https://bugs.documentfoundation.org/show_bug.cgi?id=167636
Bug ID: 167636
Summary: Formulas in some cells are not recalculated on
document load when multi-threaded calculation is
enabled.
Product: LibreOffice
Version: 24.8.0.0 alpha1+
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 201938
--> https://bugs.documentfoundation.org/attachment.cgi?id=201938&action=edit
A spreadsheet document with examples of problematic formulas.
* What happens:
On document load some formulas return the error '#N/A' in some cells when
multi-threaded calculation is enabled, while the same formula in another cell
return a correct result.
'Data > Calculate > Recalculate' doesn't solve the problem but the formulas are
recalculated and display the correct result on 'Data > Calculate > Recalculate
Hard'.
If the document is saved and reloaded, the formulas return '#N/A' again.
When the option 'Libreoffice Calc > Calculate > Enable multi-threaded
calculating' is disabled, the result is correct in any case.
The problem seems to only concern formulas with specific functions like the
vlookup one.
* What should happen :
On document load formulas the result of the formulas should be the same whether
multi-threaded calculating is enabled or not.
* How to reproduce :
- Enable the 'Libreoffice Calc > Calculate > Enable multi-threaded calculating'
option
- Open the document provided as attachment
=> formula in cells "$Formulas.D2", "$Formulas.D4" and "$Formulas.D6" returns
the '#N/A' error.
- Disable the 'Libreoffice Calc > Calculate > Enable multi-threaded
calculating' option
- Reload the document with 'File > Reload' (or close and reopen the document)
=> formula in cells "$Formulas.D2", "$Formulas.D4" and "$Formulas.D6" returns
the correct result.
* Reproducible: Always
* User Profile Reset: Yes
* Libreoffice informations :
Version: 25.2.5.2 (X86_64) / LibreOffice Community
Build ID: 03d19516eb2e1dd5d4ccd751a0d6f35f35e08022
CPU threads: 8; OS: Linux 6.12; UI render: default; VCL: gtk3
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
