https://bugs.freedesktop.org/show_bug.cgi?id=75840

Jorendc <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[email protected]

--- Comment #1 from Jorendc <[email protected]> ---
Mmh, strange. I think I can't reproduce it completely

What I did using Mac OSX 10.9, LibreOffice Version: 4.2.2.1
Build ID: 3be8cda0bddd8e430d8cda1ebfd581265cca5a0f and Excel for Mac 2011:
* Open Excel
* In cell A1 I enter 123,45
* Right click > Format Cell
* Choose 'currency' format with 2 decimals
* OK; cell now shows 123,45€
* Save as .xlsx

* Opened saved .xlsx using LibreOffice
* Content in cell A1 shows 123,45€ as expected
* Right click > Format Cell
* Format is 'Number' with format code: #.##0,00 "€";[RED]-#.##0,00 "€"

Not sure this is 'bad' behavior (should be imported as currency, not?)

* Resaved as .xlsx
* Open .xlsx in Excel
* Shown content in cell A1 is 123,45€  which is correct.
* (in Excel) Right click > Format Cells
* Format is 'Custom' with format code: #.##0,00 "€";[RED]-#.##0,00 "€"

So, looks like the number format isn't roundtripped correctly.

Kind regards,
Joren

-- 
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

Reply via email to