Description: I wanted to display a cell as blank and found <https://ask.libreoffice.org/t/how-to-return-empty-cell-from-function-in-calc/8435/5>. So I used the formula =IF(A1=0;{};A1). This worked fine when I entered it in the text bar and clicked the green tick-mark. A1 was 1 and B1 displayed 1. Change A1 to 0 - B1 display stays unchanged (??). Click on B1 - goes blank, change A1 back to 1, click on B1 *stays blank*. Looking at the text bar I see the formula displayed with semicolons changed to commas. LibreOffice Online Help says to use semicolons in formulas but the tool tip says to use commas The formula with commas always makes the cell blank, regardless of the tested value. Calc should either make commas work in formaulas or leave semicolons alone. Steps to Reproduce: 1.Enter 1 in A1 and =IF(A1=0;{};A1) in B1 2.Enter 0 in A1. Observe B1 does not change 3.Click on B1. Observe it goes blank. Observe formula in text bar now has commas where it had semicolons. 4.Enter 1 in A1. Observe B1 unchanged. 5.Click on B1. Observe it stays blank 6. Change commas back to semicolons in text bar 7. Click green tick. Observe B1 displays 1 Actual Results: As above Expected Results: Changing A1 to 0 should make B1 go blank straight away and changing A1 back to 1 should make B1 display 1 Reproducible: Always User Profile Reset: No Additional Info: Version: 25.2.3.2 (X86_64) / LibreOffice Community Build: https://gerrit.libreoffice.org/gitweb?p=core.git;a=log;h=bbb074479178df812d175f709636b368952c2ce3 Environment: CPU threads 16; OS: Linux 6.13 User Interface: UI render: default; VCL: gtk3 Locale: en-GB (en_US.UTF-8); UI: en-US Misc: Calc: threaded I had to transcribe the above by hand except the URL
If I'm not wrong, you are using an supposed inline blank array, that is not allowed. =IF(A1=0;"";A1) works as expected. There is no option to generate a blank cell with a formula, at most you can generate a cell with an empty string, but it is not a blank cell.
Many thanks for that info. I posted it in <https://ask.libreoffice.org/t/how-to-return-empty-cell-from-function-in-calc/8435/25>.