https://bugs.documentfoundation.org/show_bug.cgi?id=163865
Eike Rathke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #4 from Eike Rathke <[email protected]> --- Sheet 'Bilateral Assistance, MAIN DATA' has many calculations that massively rely on Excel internal error types (formula expressions using the TYPE() function), for example in columns K to S, which for example in row 686 instead of some expected calculated values produce #VALUE! errors because the Calc error classification may be different from Excel so a TYPE(J686)=2 condition may not match expectations. This will probably be never fixed for all cases as Calc has a finer granularity of error values. When loaded in 7.3.7 the document is not recalculated hence displays stored values, recalculating hard with Shift+Ctrl+F9 similarly takes a very long time, and afterwards displays equally #VALUE! results. The only difference is that in newer versions recalculation may be forced on more conditions than in earlier versions. For this, classifying this bug as regression is wrong. -- You are receiving this mail because: You are the assignee for the bug.
