Bug 61677 - FORMATTING change of cells calculated from calculated cells needs Complete Recalculation
Summary: FORMATTING change of cells calculated from calculated cells needs Complete Re...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.0.0.3 release
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: target:4.2.3
Keywords: regression
: 61691 (view as bug list)
Depends on:
Blocks:
 
Reported: 2013-03-02 08:31 UTC by Rainer Bielefeld Retired
Modified: 2014-05-17 14:14 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Attachments
Sample Document (12.40 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-03-02 08:31 UTC, Rainer Bielefeld Retired 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Rainer Bielefeld Retired 2013-03-02 08:31:07 UTC 
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
Comment 1 m_a_riosv 2013-03-02 21:24:54 UTC 
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.
Comment 2 m_a_riosv 2013-03-03 14:12:29 UTC 
*** Bug 61691 has been marked as a duplicate of this bug. ***
Comment 3 ign_christian 2013-10-09 13:18:55 UTC 
Not reproducible on LO 3.6.7.2 (Ubuntu 12.04 32bit)
Comment 4 Kohei Yoshida 2014-05-17 14:14:30 UTC 
Just tested this with 4.2.3 and 4.2.5 and this is no longer reproducible in either version.