https://bugs.freedesktop.org/show_bug.cgi?id=58943
Priority: medium
Bug ID: 58943
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: FORMATTING: Default derived formatting not working
Severity: normal
Classification: Unclassified
OS: All
Reporter: mike.h...@onepoyle.net
Hardware: Other
Status: UNCONFIRMED
Version: 4.0.0.0.beta2
Component: Spreadsheet
Product: LibreOffice
Created attachment 72379
--> https://bugs.freedesktop.org/attachment.cgi?id=72379&action=edit
.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
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
