Microsoft Excel to LibreOffice Calc and Back
vmiklos at collabora.com
Thu Apr 7 06:35:19 UTC 2022
On Wed, Apr 06, 2022 at 09:18:18PM +0530, Ranganathan Seshadri <cquickcal at gmail.com> wrote:
> Libreoffice is a great software that I work with regularly.
> Following is the version that I am working with currently.
> Version: 18.104.22.168 / LibreOffice Community
> Build ID: 49f2b1bff42cfccbd8f788c8dc32c1c309559be0
> CPU threads: 8; OS: Mac OS X 12.2.1; UI render: default; VCL: osx
> Locale: en-IN (en_IN.UTF-8); UI: en-US
> Calc: threaded
> When I work on my spreadsheets in this order:
> Microsoft Excel First, then take the .xlsx file to LibreOffice Calc and
> Back to MS Excel for some more work ( then Save it as CSV or TSV finally ) ,
> I notice that in the output CSV file, lots of commas get added, at the end
> of the records, to indicate that they are NULL columns.
> I enclose these sheets hereby with numbering from 1 to 5, so that you can
> spot out the source of the error.
If you want to improve the Calc CSV import/export, look at the TSV cases
in ScImportExport::ImportStream() / ScImportExport::ExportStream().
Or in case you just wanted to report this as a bug, please see
More information about the LibreOffice