https://bugs.freedesktop.org/show_bug.cgi?id=60778
Priority: medium
Bug ID: 60778
Assignee: [email protected]
Summary: EDITING (some?) changes of currency format should
trigger a recompute/reformat/...
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: All
Status: UNCONFIRMED
Version: 4.0.0.3 release
Component: Spreadsheet
Product: LibreOffice
1) Open a blank LibreOffice Calc document.
2) Enter 5 in A1, 3 in B1 and =A1-B1 in C1.
3) C1 displays 2: good
4) Right-click on A1, choose "Format Cells...". In tab "Numbers", take Category
"Currency" and click "OK" (accepting the default currency format and locale).
5) Do the same on B1.
6) Now, A1 and B1 show currency values, but C1 shows a scalar (no currency)
7) Now, set the currency format on A2 and B2. Enter 5 and 3, respectively. In
C2, enter =A2-B2. C2 displays a currency value.
The result is different in C1 and C2. It should be the same.
F9 and/or 'Menu Tools / Cell Contents / Recalculate' does not make a
difference.
Go to C1. Enter =A1-B1, that is the *same* formula that is already in it. *Now*
it displays as a currency.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
