Created attachment 70707 [details] test document Problem description: Wile opening a xlsx file, LibreOffice Calc modifies cell formatting for text cells. Steps to reproduce: 1. Take an example sheet Item,PartNum,Price Thing1,0001,1.10 Thing 2,0002,1.20 2. Save as xlsx useing Microsoft Office or LibreOffice 2. Open with LibreOffice Calc 3. PartNums are changed to 1 and 2 instead of 0001 and 0002 4. Examining the cell format, it is still set as text. Current behavior: Changes values of cells Expected behavior: Don't change values of cells Other: If you save to xlsx form LibreOffice and open with Microsoft office the formatting is correct. Tested on Mac and a Ubuntu system. Also this is not a problem in OpenOffice 3.2.1 Operating System: All
reproducible with LO 3.6.3.2 (Win7 Home, 64 Bit) but I have to format the cells as TEXT in advance
I close this bug report as WORKSFORME because it is no longer reproducible. Tested on: - Libreoffice 4.1.4.2 Build ID: 0a0440ccc0227ad9829de5f46be37cfb6edcf72 - Libreoffice 4.2.0.4 Build ID: 05dceb5d363845f2cf968344d7adab8dcfb2ba71 - Libreoffice 4.3.0.0.alpha0+ Build ID: e076b5290e706b8a69abd397a9f255eba6a0cd1a Feel free to open this bug report again if you find that the bug is still reproducible under some special circumstances, etc.