Created attachment 149769 [details] Spreadsheet with this =NA() problem. Did not occur in 6.0.7.3 release. When I look at below spreadsheet in 6.0.7.3 cells are properly calculated as #N/A. But in 6.1.5 there are cells with formulas where #N/A cells are treated as 0.
"There are cells" - which where?
See "Measured+" Column "G". The graph displays points that should be #N/A. The formula for "Measured+" is "Morning Measured" column + "Fake Loss" column. Rows in the "Future" are "=NA()"
I was working and suddenly I visits your site frequently and recommended it to me to read also. The writing style is superior and the content is relevant. Thanks for the insight you provide the readers! https://kissmanga.biz
(In reply to Eike Rathke from comment #1) > "There are cells" - which where? Cell G95 (and following) contains formula =D95+F95 with D95 equals #N/A.
Created attachment 150195 [details] how it looks in master
Not reproducible in Version: 6.3.0.0.alpha0+ Build ID: f8ca6e0a59bff51fcb09af4fa6d9cd458b32f223 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US Calc: threaded nor in Versió: 6.1.4.2 ID de la construcció: 1:6.1.4-0ubuntu0.16.04.1~lo2 Fils de CPU: 4; SO: Linux 4.15; Renderitzador de la IU: per defecte; VCL: gtk3; Configuració local: ca-ES (ca_ES.UTF-8); Calc: group threaded nor in Versión: 6.2.2.2 Id. de compilación: 2b840030fec2aae0fd2658d8d4f9548af4e3518d Subprocs. CPU: 1; SO: Windows 6.1; Repres. IU: predet.; VCL: win; Configuración regional: es-ES (es_ES); Idioma de IU: es-ES Calc: threaded To be certain the reported issue is not related to corruption in the user profile, could you please reset your Libreoffice profile ( https://wiki.documentfoundation.org/UserProfile ) and re-test? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the issue is still present
Confirm works correctly 6.2.2.2(x64) Windows 7 Doesn't work correctly 6.1.5.2(x64) in safe-mode. So for me it has been fixed.
(In reply to sponge_bob_128 from comment #7) > Confirm works correctly 6.2.2.2(x64) Windows 7 > Doesn't work correctly 6.1.5.2(x64) in safe-mode. > So for me it has been fixed. Thanks for retesting with the latest version. Setting to RESOLVED WORKSFORME as the commit fixing this issue hasn't been identified.