[Libreoffice-bugs] [Bug 60718] FILEOPEN: protected workbook

[bugzilla-daemon at bugs.documentfoundation.org]

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

Timur <gtimur at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
                 CC|                            |gtimur at gmail.com
           See Also|https://bugs.freedesktop.or |
                   |g/show_bug.cgi?id=63608     |
         Resolution|---                         |NOTABUG

--- Comment #25 from Timur <gtimur at gmail.com> ---
This bug needed a minimal test case and a simple explanation. 

If I understood it well: open attachment 79401 and see sheet: "Acqua condotta
sintesi", cell: B5 which is in MSO:
=VLOOKUP("CodicePerito";_RiservatoAxa_!A1:B210;2;FALSE) with value 20445.
LO opens it as: 
=VLOOKUP("CodicePerito";$_RiservatoAxa_.A1:B210;2;0) with value 0 BUT
recalculation also shows 20445.

Recalculation is F9 on that cell or Shift+Ctrl+F9 to recalculate all formulas
in the document.
And from LO 4.0 that we get with: "Menu/Tools/Options/LibreOffice calc/Formula
- Recalculation on file load" setting Excel 2007 and newer to always
recalculate or better prompt user.
Default option is to "Never recalculate". Previously LO 3.6 and earlier it was
"Always" so that's why this bug is repro from 4.0.

So it's not about "Fileopen: protected workbook", it's about "Fileopen: XLSX
needs hard recalculation". 
I close this as NotABug with the intention to open a new one with a general
problem about recalculations which are not transparent to the user. Even help
page https://help.libreoffice.org/Calc/Recalculate is wrong.

-- 
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/20170518/2036a358/attachment-0001.html>