https://bugs.documentfoundation.org/show_bug.cgi?id=166557
Bug ID: 166557
Summary: calc changes semicolons in a formula to commas.
Formula then stops working
Product: LibreOffice
Version: 25.2.3.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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
--
You are receiving this mail because:
You are the assignee for the bug.
