Microsoft Excel to LibreOffice Calc and Back

[Ranganathan Seshadri]

Thanks, I'll check it out.

On Thu, Apr 7, 2022 at 12:05 PM Miklos Vajna <vmiklos at collabora.com> wrote:

> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice/attachments/20220407/7605d893/attachment.htm>