https://bugs.documentfoundation.org/show_bug.cgi?id=96648
--- Comment #5 from [email protected] --- Updated to Libre Office 5.1.2.2. It did not make any difference. The steps that I go through. Computer 1, Windows 7, MS Office 2003 or Computer 2, MacBook Air, Os X, MS Office or Computer 3, Excel On-line Create an Excel spreadsheet Highlight column and click the toolbar format button for currency. Enter Data. Close the spreadsheet. Open the spreadsheet on my computer, Windows 10, Libre Office 5.1.2.2 (the same issue occurred running Windows 7). The problem is as described in the previous examples. I see the Print Screen from 5.1.2 submitted by raal. My screen look did not change after upgrading to 5.1.2.2 this morning. However if I highlight column D and change the formatting by clicking on the default "$" in the tool bar and get the formatting correct in Libre Office. I can move that same spreadsheet back to Excel, re-save it by giving it a new name (Sample Excel Spreadsheet-2.xls) close it and reopen on my computer the formatting stays correct. I have looked at the default settings on my computer, they are: [$$-409]#,##0.00;[RED]-[$$-409]#,##0.00. So it is the initial opening of a spreadsheet in Libre Office that was created in Excel (only on my computer ??) This problem is not such a big issue as long as there are a few columns that can be changes all at once, but it is a bigger issue when the format has to be changed in a number of non-adjacent cells. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
