[Libreoffice-bugs] [Bug 107518] New: changes to Detailed Calculation Settings need recalculation / not saved to document

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 107518
           Summary: changes to Detailed Calculation Settings need
                    recalculation / not saved to document
           Product: LibreOffice
           Version: 5.3.2.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: oliver.brinzing at gmx.de

Created attachment 132952
  --> https://bugs.documentfoundation.org/attachment.cgi?id=132952&action=edit
compatibility setting in calc demo

there is a problem with the compatibility setting in calc.

steps to reproduce:
- open attached calc document
- cell D5 shows #VALUE! (AOO 4.1.2 shows 0)
- Set "Tools/Options.../LibreOffice Calc/Formula/Detailed Calculation Settings"
  -> Custom -> [Details...]
     -> Conversion from text to number [Treat as Zero]
     -> [x] Apply those settings to current document only

notice:
-> document needs a full recalc (strg+shift+F9) to apply settings

-> settings are not saved, after save & reload #VALUE is displayed again
   this is maybe related to:
   FILESAVE Detailed Calculation Settings won't trigger file change
   https://bugs.documentfoundation.org/show_bug.cgi?id=96498

-- 
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/20170429/777cc5f0/attachment.html>