Bug 158569

Created attachment 191277 [details]
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