Microsoft Excel to LibreOffice Calc and Back
Ranganathan Seshadri
cquickcal at gmail.com
Wed Apr 6 15:48:18 UTC 2022
Dear Developers,
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.
Thanks and Best Regards,
Nathan SR
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice/attachments/20220406/ea7a763b/attachment.htm>
-------------- next part --------------
Name Profile Download Toll Free Number Toll Free Number Linked Web Address Web Address Linked Photo / Image Photo / Image Embed Photo / Image Embed and Linked Email Email Linked
Paul Job <a href='./images/Paul Job.pdf' target='_blank' rel='noopener noreferrer'>Profile Download</a> 8888888888 <a href='tel:8888888888' target='_blank' rel='noopener noreferrer'>8888888888</a> rediff.com <a href='http://rediff.com' target='_blank' rel='noopener noreferrer'>Home Page</a> team1.jpg <img src='./images/team1.jpg' alt='./images/team1.jpg' width='50' height='50' style='border:5px solid black'> <a href='./images/team1.jpg' alt='./images/team1.jpg' target='_blank'> <img src='./images/team1.jpg' alt='./images/team1.jpg' width='50' height='50' style='border:5px solid black'></a> tram at tram.com <a href='mailto:tram at tram.com' target='_blank' rel='noopener noreferrer'>Send email</a>
Michelle Erpenbach <a href='./images/Michelle Erpenbach.pdf' target='_blank' rel='noopener noreferrer'>Profile Download</a> 4444444444 <a href='tel:4444444444' target='_blank' rel='noopener noreferrer'>4444444444</a> marioninstitute.org <a href='http://marioninstitute.org' target='_blank' rel='noopener noreferrer'>Home Page</a> team2.jpg <img src='./images/team2.jpg' alt='./images/team2.jpg' width='50' height='50' style='border:5px solid black'> <a href='./images/team2.jpg' alt='./images/team2.jpg' target='_blank'> <img src='./images/team2.jpg' alt='./images/team2.jpg' width='50' height='50' style='border:5px solid black'></a> test at test.com <a href='mailto:test at test.com' target='_blank' rel='noopener noreferrer'>Send email</a>
Lucas Ribeiro <a href='./images/Lucas Ribeiro.pdf' target='_blank' rel='noopener noreferrer'>Profile Download</a> 8003486258 <a href='tel:8003486258' target='_blank' rel='noopener noreferrer'>8003486258</a> icmorris.org <a href='http://icmorris.org' target='_blank' rel='noopener noreferrer'>Home Page</a> team3.jpg <img src='./images/team3.jpg' alt='./images/team3.jpg' width='50' height='50' style='border:5px solid black'> <a href='./images/team3.jpg' alt='./images/team3.jpg' target='_blank'> <img src='./images/team3.jpg' alt='./images/team3.jpg' width='50' height='50' style='border:5px solid black'></a> test at test.com <a href='mailto:test at test.com' target='_blank' rel='noopener noreferrer'>Send email</a>
Yona Willis <a href='./images/Yona Willis.pdf' target='_blank' rel='noopener noreferrer'>Profile Download</a> 8002428721 <a href='tel:8002428721' target='_blank' rel='noopener noreferrer'>8002428721</a> vaumc.org <a href='http://vaumc.org' target='_blank' rel='noopener noreferrer'>Home Page</a> team4.jpg <img src='./images/team4.jpg' alt='./images/team4.jpg' width='50' height='50' style='border:5px solid black'> <a href='./images/team4.jpg' alt='./images/team4.jpg' target='_blank'> <img src='./images/team4.jpg' alt='./images/team4.jpg' width='50' height='50' style='border:5px solid black'></a> test at test.com <a href='mailto:test at test.com' target='_blank' rel='noopener noreferrer'>Send email</a>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 1. Excel Original Nonprofit Lists Database Sample.xlsx
Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Size: 29794 bytes
Desc: not available
URL: <https://lists.freedesktop.org/archives/libreoffice/attachments/20220406/ea7a763b/attachment.xlsx>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 2. Excel to CSV - Nonprofit Lists Database Sample.csv
Type: text/csv
Size: 23349 bytes
Desc: not available
URL: <https://lists.freedesktop.org/archives/libreoffice/attachments/20220406/ea7a763b/attachment.csv>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 3. LibreOffice Sheet Formulas Added and Columns Deleted.xlsx
Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Size: 12820 bytes
Desc: not available
URL: <https://lists.freedesktop.org/archives/libreoffice/attachments/20220406/ea7a763b/attachment-0001.xlsx>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 4. LibreOffice Sheet Converted to CSV By Excel.csv
Type: text/csv
Size: 8101 bytes
Desc: not available
URL: <https://lists.freedesktop.org/archives/libreoffice/attachments/20220406/ea7a763b/attachment-0001.csv>
More information about the LibreOffice
mailing list