https://bugs.freedesktop.org/show_bug.cgi?id=75840
--- Comment #2 from Pierre CARRET <[email protected]> --- Hello Joren, Sorry for the late anwser, i was pretty busy at work. My build id is d7dbbd7842e6a58b0f521599204e827654e1fb8b. > * 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 ok. > * 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 "€" ok, but exactly i have # ##0,00 "€";[RED]-# ##0,00 "€". At this moment the display is fine for the original cell. If I apply this format in a new cell with a values of 123,45 as a custom format, it displays 1,23€. For information in Right click > Format Cell > Number, the last one with the description # ##0,00 "€";[RED]-# ##0,00 "€", the example displayed here is 1,23€. Maybe something wrong with the french version ? > * Resaved as .xlsx > * Open .xlsx in Excel Or LibreOffice, the result is the same for me. > * Shown content in cell A1 is 123,45€ which is correct. Not for me, it displays 1,23€. * Right click > Format Cell shows : # ##0,00 €;[RED]-# ##0,00 € The " are gone. I don't know if it's the same for every versions but in the french version the format # ##0,00 €;[RED]-# ##0,00 € doesn't display the result excpected. And this is the case for both LibreOffice and Excel 2010. This is because of the space I think, # ##0,00\ €;[RED]-# ##0,00\ € works as excepted. Kind regards. -- 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
