https://bugs.freedesktop.org/show_bug.cgi?id=61677
Priority: medium
Bug ID: 61677
Assignee: [email protected]
Summary: FORMATTING change of cells calculated from calculated
cells needs Complete Recalculation
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.0.1.2 rc
Component: Spreadsheet
Product: LibreOffice
Created attachment 75769
--> https://bugs.freedesktop.org/attachment.cgi?id=75769&action=edit
Sample Document
Steps how to reproduce [Reproducible] with "LibO 4.0.1.2 rc - German UI /
German Locale [Build ID: 84102822e3d61eb989ddd325abf1ac077904985)]"
{tinderbox: @6, pull time 2013-02-28 08:53(?)} on German WIN7 Home Premium
(64bit):
1. open attached "0_sample.ods"
2. Select A17:B26
3. Click 'Currency' icon in Formatting Toolbar
Expected: all selected range changes to currency view
Actual: Only valuse in column A become currency.
More info:
----------
Values A17:A26 are directly calculated from values A2:A11
Values B17:B26 are calculated from values B2B11m what are calculated from
values A2:A11
The relation is tricky, and the Summary only is correct for the sample
document. I found a how to create a very simple sample:
11. Open new blank spreadsheet fom LibO start Center
12. Type "1" to A1
13. "=A1" to B1
14. "=A1" to A2
15. Save as "sample.ods"
16. Select A1:B2
17. Click "Currency
> all become currency
18. Quit without saving
19. reopen "sample.ods"
20. Select A1:B2
21. Click "Currency
bug: only A1 becomes currency
22. Undo
> back to default number formatting
23. also try for only B1 or A1, selected or only in cell cursor
Bug: never 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
