https://bugs.documentfoundation.org/show_bug.cgi?id=158569
Bug ID: 158569
Summary: FILEOPEN XLSX Add Calc data model structure for
sheet-level settings
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Blocks: 112752
Created attachment 191277
--> https://bugs.documentfoundation.org/attachment.cgi?id=191277&action=edit
Example file with sheet level configuration setting
There are several options on the Options - Calc - View tab, which are app level
global settings. These are on the other hand sheet level settings in Excel,
which causes interoperability issues.
The settings in Excel / Calc:
- Show row and column headers / Column/row headers
- Show formulas in cells instead of their calculated results / Formulas
- Show sheet right-to-left / MISSING feature
- Show page breaks / Page breaks
- Show a zero in cells that have zero value / Zero values
- Show outline symbols if an outline is applied / Outline symbols
- Show gridlines / Grid lines
- Gridline color / removed in bug 154446
As an example, the attached document contains the Zero values option enabled on
one sheet and disabled on the other. Another example would be bug #126541 for
the Grid lines setting (related bug 136148 shows that this is an issue in
headless mode, as the interop depends on a setting not present in headless
mode).
1. Open attached document
2. Check the C1 cell on the two sheets: on the Zero sheet, it should show 0, on
the No-zero sheet it should not show anything.
-> The zero is shown on both sheets depending on the "Zero values" setting on
Options - Calc - View tab
Version: 24.2.0.0.alpha1+ (X86_64) / LibreOffice Community
Build ID: 43967453e15e1d054972a7586cfef8f8e0866270
CPU threads: 15; OS: Windows 10.0 Build 19045; UI render: default; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: threaded
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=112752
[Bug 112752] [META] XLSX (OOXML) sheet-level bugs and enhancements
--
You are receiving this mail because:
You are the assignee for the bug.
