Summary: | Incorrectly export number 0 form calc to PDF | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Jaroslaw <j.fliski> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | UNCONFIRMED --- | ||
Severity: | normal | CC: | heiko.tietze, kira.tubo, miguelangelrv |
Priority: | medium | Keywords: | needsDevAdvice |
Version: | 7.4.4.2 release | ||
Hardware: | x86-64 (AMD64) | ||
OS: | Windows (All) | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Attachments: | One of file witch wrong export to PDF |
Description
Jaroslaw
2023-12-05 08:13:07 UTC
Please attach a sample file. Created attachment 191243 [details]
One of file witch wrong export to PDF
Part of field of every sheet was protect to edit. All sheet protect to edit.
Sumarize each column on single sheet and conditional format this results to show posiible wrong write data.
Export do PDF with option:
- PDF/A ISO 19005: version PDF/A-3b
- PDF/UA
I think i see what is wrong. One of options from "Print preview" => "Page formating" used to export PDF: page "sheet" => "zero values" In my humble opinion when we export sheet to PDF value "0" must be exported as "0" not empty field, aspecialy when generated PDF/A (archive). I search for some options to PDF in: - "Tools" => "Options" => "LibreOffice" - "Tools" => "Options" => "Calc" I guess the question is whether or not we want the exported PDF to display "0" values using the "Zero values" settings from "Print preview" or "Tools" section. I can understand from the user's perspective that it would be pretty easy to assume that the "Zero values" setting from "Print preview" should only controls documents that are physically printed. Maybe something for the UX team to review? Weird option, probably there for compatibility. Feels wrong to ignore this settings on export to PDF (or anything else). And, by default the option is checked. (In reply to Heiko Tietze from comment #5) > Weird option, probably there for compatibility. Feels wrong to ignore this > settings on export to PDF (or anything else). And, by default the option is > checked. If we are keeping things as is, then probably the next best thing is to update the documentation to clarify how the settings affect the exported PDFs. Add info that settings under Format - Page Style - Sheet affects exported PDF: https://help.libreoffice.org/latest/en-US/text/scalc/guide/print_details.html?DbPAR=CALC#bm_id3154346 Clarify that settings under Tools - Options - LibreOffice Calc - View has NO effect on exported PDF: https://help.libreoffice.org/latest/en-US/text/shared/optionen/01060100.html?DbPAR=SHARED#bm_id3147242 We discussed the topic in the design meeting. The default is to export zeros and if a user deliberately switches the option off we should respect this. Excel behaves exactly the same. Whether some PDF formats should be treated more carefully is a question to the experts. Removing keyword needsDevEval, which is used for potential easy hacks: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Keywords#needsDevEval |