Created attachment 111839 [details] Sample original spreadsheet Appleworks document .cwk A have a lot of Appleworks spreadsheet documents on MacOSX 10.9.x to convert in LibreOffice 4.3.x. If the original Appleworks .cwk spreadsheet document contains one or some empty lines and/or empty column on the first range (column A, line 1), then LibreOffice open the document with the datas but all the formulas are wrong. LibreOffice seems to open the document in column A line 1 but in fact this is column B line 2 of Appleworks document. LibreOffice 'forget' (why ?) the first empty lines/column. The result is that all the formulas and calculations are false.
Created attachment 111840 [details] screenshot original appleworks
Created attachment 111841 [details] screenshot result LibreOffice
Confirming behaviour in LO 4352 on OSX 10.10.1, but don't know whether this is intended - the filter code might well ignore blank lines
No, it was not really intended... Ie. historically, libmwaw-0.2 can not export spreadsheet, so it converts embedded spreadsheets in text document as tables ( where suppressing first empty rows and empty columns can make sense ) and when I "copy-paste" this code to create spreadsheet in libmwaw-0.3, I forgot that it did that :-~ So, I know what must be changed in the code to avoid this (but I must first check if it is also ok for embedded spreadsheets) ; I will commit a patch in libmwaw ( probably before the end of the week-end ) and will update mwawOSX in https://sourceforge.net/projects/libmwaw/files/
Must be fixed by https://sourceforge.net/p/libmwaw/libmwaw/ci/c092ac823e50083c04464565365ddd4af71f8c89 . Note: I will update mwawOSX tomorrow...
David Tardon committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=2a8f6a8a81c568d9ad73838072d287ac4927649f fdo#88098 ClarisWorks: import empty starting lines/columns It will be available in 4.5.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.
David Tardon committed a patch related to this issue. It has been pushed to "libreoffice-4-4": http://cgit.freedesktop.org/libreoffice/core/commit/?id=c475835cab890a69d3c07ddc85ce131b64affaa3&h=libreoffice-4-4 fdo#88098 ClarisWorks: import empty starting lines/columns It will be available in 4.4.0.2. 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.
hello, I have tested the new version 4.4.0.2 (64bits) on OSX mavericks 10.9.5, and now, Libreoffice open the Appleworks spreadsheet documents correctly. The first empty lines and column are no more ignored. Calculations are correct. We are hundred users and we have thousand Appleworks documents (text and spreadsheet). For this fonctionnality (import .cwk), we have migrated from OpenOffice to LibreOffice, last year. So, thank you for all. Thierry Hauth, 4murs company.
attachment 111839 [details] does not [1] list in file browser [2] open in libreoffice viewer Version: 6.0.0.0.alpha0+ Build ID: 643da8ec4e721d33dfdf8d78bedd50a915f1188d TinderBox: Android-ARM@24-Bytemark-Hosting, Branch: Master, Time: June 26, 2017 01:29:17
(In reply to krishna [:kr1shna] from comment #9) > attachment 111839 [details] does not > > [1] list in file browser > [2] open in libreoffice viewer Please don't hijack existing bugs to insert meaningless comments.