Created attachment 75769 [details] 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
Hi Rainer, I can confirm the issue. After a hard-calculation, it is possible apply the format. I think I have seen a some issue about the need for doing hard-calculation to get spreadsheet working right. I suspect it is in relation with new option about calculate the spreadsheets at opening.
*** Bug 61691 has been marked as a duplicate of this bug. ***
Not reproducible on LO 3.6.7.2 (Ubuntu 12.04 32bit)
Just tested this with 4.2.3 and 4.2.5 and this is no longer reproducible in either version.