Bug 58943 - FILEOPEN .ods from LibO 3.6: Number FORMATTING not inherited in formula like "=A1"
Summary: FILEOPEN .ods from LibO 3.6: Number FORMATTING not inherited in formula like ...
Status: RESOLVED DUPLICATE of bug 59724
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) Master
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
Keywords: regression
Depends on:
Reported: 2013-01-02 12:03 UTC by mike.hall
Modified: 2013-01-22 18:39 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

.ods showing issue (9.72 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-01-02 12:03 UTC, mike.hall
Additional Sample (10.79 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-01-02 13:13 UTC, Rainer Bielefeld Retired

Note You need to log in before you can comment on or make changes to this bug.
Description mike.hall 2013-01-02 12:03:12 UTC
Created attachment 72379 [details]
.ods showing issue

In derived formats are not working as in (regression). There are also some oddities about when derived formats should follow a format change in the original cell.

It's easiest to see the effects by opening the attachment in and noting the differences.

1) Currency
B2 has £1000 formatted as currency
C2 has formula =0.015*B1
In C2 is formatted as B1
In C2 is unformatted (ie no £ sign) Regression, corrected if a row above the cells is deleted

2) Dates
B5 has =now() formatted as date
B6 has formula =B5+365.25
In B6 is formatted as B5
In B6 is unformatted (ie shows a long number) Regression, corrected if a row width is changed

Similar example in attachment at B9/B10

3) Derived formats are uncorrected until screen layout is changed (not a regression)
Dates: Change original cell format from date/time to date only. Derived formats do not adjust until eg a row width is altered.
Currency: Change original cell currency format to show decimal places. Derived formats do not adjust until eg a row above the cells is deleted
Comment 1 Rainer Bielefeld Retired 2013-01-02 13:04:12 UTC
I see the effect, and I think this one is a DUP of an other bug I saw few days before. The effect only appears for old spreadsheets opened with 4.0, not if you create the relation in 4.0.

The problem can be healed by 'find & replace' all "=" by "=", and the formatting will appear.
Comment 2 Rainer Bielefeld Retired 2013-01-02 13:13:34 UTC
Created attachment 72381 [details]
Additional Sample

Hm, the other bug I remembered is "Bug 58863 - FILEOPEN .xlsx: "IF" condition not calculated", what looks rather different. But nevertheless, might have similar roots.
The additional sample document shows the problem, Column B should show currencies, not numbers.
Columns C and following show LibO 3.6 effects I do not understand.  Why will negative value in C1 not be shown as currency, but D1 is shown as currency?
Comment 3 Rainer Bielefeld Retired 2013-01-02 13:20:33 UTC
Already [Reproducible] with Server-installation of Master "3.7.0.alpha0+  – ENGLISH UI [Build ID: f2e622]" {tinderbox: Win-x86@16, pull time 2012-10-06 09:31:39} on German WIN7 Home Premium (64bit) UserInstallation=$SYSUSERCONFIG/LOdev/3.

Bug 58863 still woks fine with that version, so I believe my suspect concerning similar roots was wrong

Please switch OS back to "All" if your OS was not WIN

@Spreadsheet Team
Please set Status to ASSIGNED and add yourself to "Assigned To" if you accept this Bug or forward the Bug if it's not your turf (and remove others in team from CC).
Comment 4 Markus Mohrhard 2013-01-04 19:08:12 UTC
While not being obvious this is just a duplicate and my fix for Bug 58863 will also fix this issue.

Please test the cached value import a bit more. There might be more hidden problems that we did not find yet.

*** This bug has been marked as a duplicate of bug 58863 ***
Comment 5 Rainer Bielefeld Retired 2013-01-22 18:39:42 UTC
Still [Reproducible] with server installation of  " (Build ID: 0ff470cff6ecc436e723af6a60986c8eefaba7b) TinderBox: Win-x86@6, Branch:master, Time: 2013-01-19 22:38:36  - ENGLISH UI / German Locale  on German WIN7 Home Premium (64bit) with LO41 Masters User Profile

So not a DUP of Bug 58863, but a special case of "Bug 59724 - FILEOPEN: Inherited currency format not retained through close and open".

*** This bug has been marked as a duplicate of bug 59724 ***