With Excel 2007 (tested with 2007 but maybe 2010 too?), create a new spreadsheet doc. - select a cell and set number type as Text - Enter a long number as 1234567890123456789 - save as XLSX (not tested with XLS) - Open the file with LibreOffice - The number in the cell is now 1234567890123450000 -> The numbers after the 15th are replaced with 0... the same beavior as typing this number in a standard number cell format, and changing it after this in text cell format ... example file from Excel 2007 Vista 32bits : http://cyrille.grosdemange.free.fr/libo/test-cellules.xlsx In this file, the A2 cell shows the bug. The others are for reference. This file displays well in GoogleDocs : https://docs.google.com/open?id=0ByjMh5M85asZaWhCeHhEbnZFWHM -- My alternative method to open correctly this file in LibO is : - import in GoogleDocs (works) - export from GoogleDocs in ODS - Open the exported Google Docs ODS with LibO So ... I think the problem is in the import filter who should set the cell number type BEFORE inserting values into it (Don't know the code but seems like that) Thanks. Set this bug to blocker because long numbers are sometime serial numbers etc. and NEEDS to be correct.
On pc Debian x86-64 with master sources updated today, I reproduced the problem. I've got "54645768794543200000" which displays on A2 cell with doc from http://cyrille.grosdemange.free.fr/libo/test-cellules.xlsx Eike: one for you?
It works with LO-3.5 => regression. It is a kind of data loss => we should fix it ASAP. Well, it was already in LO-3.6.0. It was not reported immediately => it affects only some users => it should not block 3.6.3 with many other useful fixes => reducing the severity a bit
Created attachment 69058 [details] cell format dialog in LO-3.6 Please, notice the "5.46457687945432E+019" in the preview box and also in the input line. LO-3.5 shows the full number there. I wonder if it is the reason for the shrinking.
Created attachment 69059 [details] cell format dialog in LO-3.5 It shows the full 54645768794543243576 number.
"filters and storage" is a very weird component. Changing that to Spreadsheet.
I'll have a look
(In reply to comment #0) > So ... I think the problem is in the import filter who should set the cell > number type BEFORE inserting values into it (Don't know the code but seems > like that) certainly filter related, the order shouldn't matter ( or at least it didn't in 3.5 )
Noel Power committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=f39238693096fe0001f8d526f22b920fc0be185b fix for fdo#55875 numbers as text converted strangely The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Marking as fixed.
Noel Power committed a patch related to this issue. It has been pushed to "libreoffice-3-6": http://cgit.freedesktop.org/libreoffice/core/commit/?id=08ca08d2f46c6119550024ce02bc42c271a3644b&g=libreoffice-3-6 fix for fdo#55875 numbers as text converted strangely It will be available in LibreOffice 3.6.4. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
*** Bug 55091 has been marked as a duplicate of this bug. ***
Is there a way to fix this bug manually in version 3.6.0.2 ? (replace a file or something) Or does anyone know a work-around? The problem is, we work on the office with Ubuntu 12.04 LTS and the LibreOffice version from the Ubuntu Repository... This version will probably not updated (soon) to 3.6.4
bugs@eases.nl: By looking at the fix, I don't think there could be a workaround but perhaps I'm wrong (since I'm not a core dev just a simple contributor) and a core dev could give one. Just an idea, if you're not authorized to install .deb from LO website, would it be possible to try ppa Libreoffice?
"Just an idea, if you're not authorized to install .deb from LO website, would it be possible to try ppa Libreoffice?" This is certainly a possible solution. But I can't find a PPA LibreOffice for Ubuntu 12.04 LTS. There are however PPA's for 12.10 and I believe even for 13.04, but the do not work on the LTS... A .deb install I tried on one of the systems, but the integration with Unity/HUD doesn't seems right. Also the toolbar icons go black. So this is not a solution... (and I do not prefer .deb installs)
*** Bug 59470 has been marked as a duplicate of this bug. ***
As part of FDO cleanup we are checking version #'s for regressions against minor releases in 3.6. I was able to confirm this one on 3.6.0.0-alpha1 Updating version