https://bugs.documentfoundation.org/show_bug.cgi?id=60718
Timur <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
CC| |[email protected]
See Also|https://bugs.freedesktop.or |
|g/show_bug.cgi?id=63608 |
Resolution|--- |NOTABUG
--- Comment #25 from Timur <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
