Description: Hello, I'm trying to do an simple IF sentence on a cell. For Example: On C2, I put this formula =IF(B2;1;0) Normally, if B2 has some value, will return 1, on the other cases (FALSE,0,empty cell) will return 0. Now, if B2 is the result from a formula, lets say =MID(A2;1;10), and A2 is empty, B2 will be empty, BUT, C2 will not give me any result from the if (not 1, not 0) Steps to Reproduce: 1.Make A2 empty 2.Put on B2 =MID(A2;1;10) 3.Put on C2 =IF(B2;1;0) Actual Results: Not 1 or 0 result on C2 Expected Results: It should be 0 Reproducible: Always User Profile Reset: No Additional Info: Versión: 6.3.3.2.0+ Id. de compilación: 30(Build:2) Subprocs. CPU: 4; SO: Linux 4.12; Repres. IU: predet.; VCL: kde5; Configuración regional: es-ES (es_ES.UTF-8); Idioma de IU: es-ES Calc: threaded
I can't reproduce it. 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? If the problem still persists, please attach a sample document, as this makes it easier for us to verify the bug. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.) I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the issue is still present
Please test it the option in Menu/Tools/Options/LibreOffice calc/Formula - Detailed calculation settings - Treat empty string as zero, solve your issue.
Dear moyanocasco.franciscom, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping
(In reply to m.a.riosv from comment #2) > Please test it the option in Menu/Tools/Options/LibreOffice calc/Formula - > Detailed calculation settings - Treat empty string as zero, solve your issue. issue and solution confirmed, without this option an empty result of a string operation in B2 produces #VALUE! in B3, with the option checked the result is '0', as well in 6.1.6.3 (winx64) as in actual 7.1.0.0 dev (winx64), thus 'notabug' the option is in [tools - options - libreoffice calc - formula - detailed calculation settings - **custom (conversion of text to numbers and more): details** - treat empty string as zero]