Microsoft Excel to LibreOffice Calc and Back

[Miklos Vajna]

Hi,

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: 7.3.2.2 / 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
<https://wiki.documentfoundation.org/QA/BugReport>.

Regards,

Miklos