Description: The enclosed sheet used to work in calc version 6.2.8 but generates many calc 522 errors in version 6.3.2.2. Steps to Reproduce: 1.open the enclosed spreadsheet in calc 6.3.2.2 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 Actual Results: In libreoffice 6.0.7.3 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 6.3.2.2 most parts of the spreadsheet are not calculated : error 522 results (even with iteration validated in parameters) Expected Results: 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é". Reproducible: Always User Profile Reset: Yes OpenGL enabled: Yes Additional Info:
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: 6.4.0.0.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 Calc: threaded 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 5.0.0.1 - that's somehow 'ignored' by dependent cells, in 6.4.0.1 and 6.5.0.0.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 reg. b.
source of error?: might be that someone changed a date in the project. having year of PRODUITS.D6 earlier than year of ENTERPRISE.B12 is questionable from the point of view of IT (referencing in a daterange not available) and probably also of business administration, setting theese dates to other order or identical year 'heals' the sheet, <<< bug killed? >>> never ever a dup of 124270, removing that, spotted one more problem: in ver. 5.0.0.1 on one occasion cells J5:J27 were - erroneously - calculated to '0', that error was 'stable' when it occurred, replacing the term '*(1-$H5)' with '*(1)' gave correct result in J5, re-typing it with '*(1-$H5)' had error again, function wizard calculated correct (5425) while cell value was wrong (0), but on retries after restart 5.0.0.1 calculated results for those cells, might have been dependent on whatever special condition, cannot reproduce, have seen before that sometimes function wizard analysis tool works different to cell value calculation ... for the moment i'd say #N/A in Synthese.L is correct while year of PRODUITS.D6 being smaller than year of ENTERPRISE.B12 feel free to change or reopen if i'm wrong