[Libreoffice-bugs] [Bug 138702] FILESAVE XLSX Changes to Plot Options not being saved

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=138702

--- Comment #11 from NISZ LibreOffice Team <libreoffice at nisz.hu> ---
Created attachment 174853
  --> https://bugs.documentfoundation.org/attachment.cgi?id=174853&action=edit
Original file exported to xlsx with 6.2 seen in Excel an current Calc

In:
Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: c7b5e6566d9b24a0a996c739a945004d9aadee2f
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: default; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: CL

The display of the exported xlsx is the same as in Excel ("Közökkel" in this
shot means "Leave gap"). The export of this c:dispBlanksAs val="gap"/> setting
was correct even in 5.0.

What is different the understanding of "Empty cells" by Excel and "missing
values" by Calc.

In this file these plotted cells are the result of a formula calculation in the
B3:L27 range:
=IF($Weight.B3="";"";($Weight.B3-$Weight.B$2)/$Weight.B$2)

Calc considers these cells "empty" when the IF formula gives the empty string
and plots them as gaps.
Excel however does NOT consider them empty and plots them "with zero values"
even if you have selected "with gaps" on it's UI.
If you delete the formulae from the seemingly empty cells, then it really does
not plot anything, just like Calc.

The bibisected commit solved the visual difference by detecting whether there
are "not really empty" calculated cells and changed the plotting option from
"Leave gap" to "Assume zero", so when Excel cheats, Calc cheats as well.

The downside of cheating is this bug: Leave gap option is not usable anymore
when you load XLSX format.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210907/923eafe2/attachment.htm>