https://bugs.freedesktop.org/show_bug.cgi?id=75840
Priority: medium
Bug ID: 75840
Assignee: [email protected]
Summary: Currency format after FILESAVE for a xlsx made from
excel is wrong
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.2.2.1 rc
Component: Spreadsheet
Product: LibreOffice
Create a new xlsx file from Excel (2010 in my case).
Put an amount in a cell and format it with a standard monetary format (in my
case # ##0,00 €, for exemple 123,45 €).
Save it.
Open it with Spreadsheet, the display is fine (exact format is # ##0,00 "€").
Save the file with a new name or modify it and save.
Open it again with Spreadsheet, the display is divide by 1000 for example 0,12
€. The format saved was # ##0,00 \€.
This is weird because both of this formats give 0,12 € in Excel and
Spreadsheet, one working is # ##0,00\ €. This may depend of the regional
settings, mines are French.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
