Created attachment 72379 [details] .ods showing issue In 4.0.0.0B2 derived formats are not working as in 3.6.4.3 (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 3.6.4.3 and noting the differences. 1) Currency B2 has £1000 formatted as currency C2 has formula =0.015*B1 In 3.6.4.3 C2 is formatted as B1 In 4.0.0.0B2 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 3.6.4.3 B6 is formatted as B5 In 4.0.0.0B2 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
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.
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?
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 @mike.hall 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).
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 ***
Still [Reproducible] with server installation of "4.1.0.0.alpha0 (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 ***