<div dir="ltr">Thanks, I'll check it out. </div> <div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Apr 7, 2022 at 12:05 PM Miklos Vajna <<a href="mailto:vmiklos@collabora.com">vmiklos@collabora.com</a>> wrote: </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hi, On Wed, Apr 06, 2022 at 09:18:18PM +0530, Ranganathan Seshadri <<a href="mailto:cquickcal@gmail.com" target="_blank">cquickcal@gmail.com</a>> 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 <<a href="https://wiki.documentfoundation.org/QA/BugReport" rel="noreferrer" target="_blank">https://wiki.documentfoundation.org/QA/BugReport</a>>. Regards, Miklos </blockquote></div>