https://bugs.documentfoundation.org/show_bug.cgi?id=75650
Aron Budea <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |[email protected]
--- Comment #5 from Aron Budea <[email protected]> ---
Created attachment 125583
--> https://bugs.documentfoundation.org/attachment.cgi?id=125583&action=edit
Boolean formula to numeric, cell format not updated
The reason why it could not be reproduced is the "Now delete A3 value (DEL key)
and enter formula" step. If the text is copied from a neutral source, like this
bug report, you will see the formatting updated to number.
The formula in A3 either has to be changed for the issue to show:
1. via Input line,
2. by deleting A3, and pasting "=MAX(A1:A2)*1000" that was copied from Calc
itself (another field),
3. by deleting A3, and writing "=MAX(A1:A2)*1000" manually.
Attaching a screenshot where:
-A3 has "=IF(A1>A2)", B3 has "=MAX(A1:A2)*1000"
-A4-A7 had "=IF(A1>A2)" initially
-A4 is updated by copying B3's Input line over its Input line
-A5 is updated by pressing Delete, and pasting B3's Input line
-A6 is updated by pressing Delete, and entering the formula manually
-A7 is updated by pressing Delete, and pasting the formula copied from this bug
report
Result: A4-A6 shows TRUE, A7 shows 2000.
Expected: A4-A7 should show 2000.
Confirmed in 4.1.0.4 and 5.2.0.0.beta2.
Not confirmed in 4.0.0.3 => regression
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
