The enclosed sheet used to work in calc version 6.2.8 but generates many calc 522 errors in version 18.104.22.168.
Steps to Reproduce:
1.open the enclosed spreadsheet in calc 22.214.171.124
2.go to sheet "Synthese", column "Rattrapage TVA a psoteriori" (column L)
3.it shows an error 522, the error propagates throughout the spreadsheets
4.open the enclosed spreadsheet in calc 6.2.8
5.go to sheet "Synthese", column "Rattrapage TVA a psoteriori" (column L)
6.it shows the result of a processing (0), there may be some propagation problems (data processing does not get always automatically actualized on other sheets) but most often, the results are ok
In libreoffice 126.96.36.199 this column (L) in "Synthese", as some parts of the spreadsheet are not calculated : #N/A results
In libreoffice 6.2.8 the spreadsheet is usually well calculated, this column results in numbers, not error. Please note that the refresh and propagation of the data modification (between sheets) is not well done and sometimes needs some manual modification on the destination sheet to be refreshed.
In libreoffice 188.8.131.52 most parts of the spreadsheet are not calculated : error 522 results (even with iteration validated in parameters)
The L column shall be always 0 due to the parameters adopted.
This spreadsheet has worked on libreoffice 6.2.8 (with refreshing and propagation problems). This column shall result in numbers, not error. The propagation of calculations shall be done across all the right side sheets (with names not only made of uppercase characters), including "Fiscalité".
User Profile Reset: Yes
OpenGL enabled: Yes
Created attachment 155431 [details]
a calc file that exhibits the buggy behavior
For bug demonstration only.
Created attachment 155432 [details]
screenshot LO 633
i can not confirm Err:522, column L shows #N/A for me.
if enabled, can you please try again after disabling:
- Menu Tools/Options.../LibreOffice Calc/Calculate
-> [ ] Enable multi-threaded calculation
it's reproducible with:
Version: 184.108.40.206.alpha1+ (x64)
Build ID: 885ae558d34dd76955c727b90eb9ae52ce85df7f
CPU threads: 4; OS: Windows 10.0 Build 18362; UI render: default; VCL: win;
Locale: de-DE (de_DE); UI-Language: en-US
but *not* reproducible with disabled
[ ] Enable multi-threaded calculation
Looks like a duplicate, please if you are not agree reopen it.
*** This bug has been marked as a duplicate of bug 124270 ***
i don't think duplicate, and never ever of that one (#124270), but user error ... changed behaviour ...
the initial fail is cells U5:U8 on sheet Synthese not finding 2016 in '_fiscalita_an' or similar,
in older versions - i tested with 220.127.116.11 - that's somehow 'ignored' by dependent cells, in 18.104.22.168 and 22.214.171.124.a0 it's handed over to them / inherited by them, and let's them display as #NA! as well, propagating all over the sheet,
pls. retest and close with app. status