| Summary: | VIEWING: After open xml file the cell value is NaN instead 0 | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Ruslan Fatakhov <ruslanf78> |
| Component: | Calc | Assignee: | Eike Rathke <erack> |
| Status: | RESOLVED FIXED | ||
| Severity: | minor | CC: | suokunlong |
| Priority: | medium | ||
| Version: | 4.0.1.2 release | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | BSA target:4.4.0 target:4.3.0 target:4.2.7 | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: |
Original file from bud 44969 arhive 7zip
File opened with openoffice and save like ods File opend with libreCalc 4.0.1 and save like ods Screenshot- OpenOffice left, LibreOffice right |
||
|
Description
Ruslan Fatakhov
2013-03-12 17:54:46 UTC
Created attachment 76413 [details]
File opened with openoffice and save like ods
File opened with openoffice and save like ods
Created attachment 76414 [details]
File opend with libreCalc 4.0.1 and save like ods
File opend with libreCalc 4.0.1 and save like ods
Thanks for reporting I can reproduce this behavior using Mac OSX 10.8.3 with LibreOffice Version 4.0.2.2 (Build ID: 4c82dcdd6efcd48b1d8bba66bfe1989deee49c3) TinderBox: MacOSX TDF Release, Branch:libreoffice-4-0, Time: 2013-03-26_15:52:16. A recalculation doesn't solve anything, the cells still contains "N,aN". Opening this file using OpenOffice 3.4.1 shows the cell content is "0". Therefore I mark this bug as NEW. Priority: Minor: does make it substantially harder to create high quality work medium: default priority for minor bugs. Kind regards, Joren Created attachment 77657 [details]
Screenshot- OpenOffice left, LibreOffice right
By digging into the xml file I see following line (see screenshot). This is the first line of the spreadsheet (row 5).
<Row ss:AutoFitHeight="0" ss:Height="15">
<Cell ss:StyleID="s23"><Data ss:Type="String">10</Data></Cell>
<Cell ss:StyleID="s24"><Data ss:Type="String">KZT</Data></Cell>
<Cell ss:StyleID="s24"><Data ss:Type="String">Кредитовое авизо</Data></Cell>
<Cell ss:StyleID="s24"><Data ss:Type="String">Основная деятельность</Data></Cell>
<Cell ss:StyleID="s24"><Data ss:Type="String">103946</Data></Cell>
<Cell ss:StyleID="s24"><Data ss:Type="String">103945</Data></Cell>
<Cell ss:StyleID="s24"><Data ss:Type="String">Дебиторы</Data></Cell>
<Cell ss:StyleID="s25"><Data ss:Type="String">09.09.2011</Data></Cell>
<Cell ss:StyleID="s27"><Data ss:Type="Number">925044.62</Data></Cell>
<Cell ss:StyleID="s28"><Data ss:Type="Number"></Data></Cell>
</Row>
As you can see, the last Cell tag doesn't contain data. Therefore there is nothing available (NaN). OpenOffice shows this as a zero, LibreOffice shows it how it is ... it doesn't contain data. I don't know which behavior is technically the best for this cases.
I'll ask a core developer to have a look at this.
Kind regards,
Joren
A core developer recommended me to have a look at the behavior of Excel. I openened the attached file using Excel for Mac 2011 and it shows a '0,00'. So OpenOffice has the 'good' behavior too. kind regards, Joren It's best to treat this "empty number cell" case from a file format similar to an empty cell that is used in calculations, where it is treated as zero. Having already a (even if maybe technically correct) NaN set also disallows calculations with that value, and applying number formats to a Nan may generate unexpected display strings. Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=fea6f83df8d2183b108695217bc4ff7a93e942c9 resolved fdo#62250 absent value cell values are not NaN, set to 0.0 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. Pending review for 4-3 at https://gerrit.libreoffice.org/10174 for 4-3-0 at https://gerrit.libreoffice.org/10175 for 4-2 at https://gerrit.libreoffice.org/10176 Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-4-3-0": http://cgit.freedesktop.org/libreoffice/core/commit/?id=068a7035bf679ba1b9650777cae327a18d3ee519&h=libreoffice-4-3-0 resolved fdo#62250 absent value cell values are not NaN, set to 0.0 It will be available already in LibreOffice 4.3.0. 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. Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-4-3": http://cgit.freedesktop.org/libreoffice/core/commit/?id=cd8acfacdc02dc6dbfc6a73ef64c5bec8eefebf4&h=libreoffice-4-3 resolved fdo#62250 absent value cell values are not NaN, set to 0.0 It will be available in LibreOffice 4.3.1. 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. Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-4-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=4e69127246028f72eee6279e9a810bb865ce654c&h=libreoffice-4-2 resolved fdo#62250 absent value cell values are not NaN, set to 0.0 It will be available in LibreOffice 4.2.7. 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. Is Bug 79249 related? No. |