Thanks, I'll check it out.
On Thu, Apr 7, 2022 at 12:05 PM Miklos Vajna <vmiklos@xxxxxxxxxxxxx> wrote:
Hi,
On Wed, Apr 06, 2022 at 09:18:18PM +0530, Ranganathan Seshadri <cquickcal@xxxxxxxxx> 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
