[Solved] Open CSV and save to XLSX in OO 3.4

Keyboard macros or custom scripts

Re: [Solved] Open CSV and save to XLSX in OO 3.4

Postby Villeroy » Sat Oct 11, 2014 10:01 pm

As a matter of fact, software that is able to write OOXML does exist. Nothing forces you to use OpenOffice which (for very good reasons) does not write OOXML for now. If you have nothing to say and nothing to contribute to this project, piss off and leave us alone.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26874
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: [Solved] Open CSV and save to XLSX in OO 3.4

Postby pitonyak » Wed Jan 21, 2015 7:55 am

rhersom wrote:I'm not able to save a 106,000 row spreadsheet in XSLX format using )) 3.4. I open a CSV successfully but the "Calc MS Excel 2007 XML" option is not available and I get a Write Error trying to save to "MS Excel 2003 XML". The end goal is saving to the XSLX under program control, but I don't expect to get there if I can't do it through the menu. Is there an installable add-on that adds the "Calc MS Excel 2007 XML" opion to OO 3.4?


LibreOffice is able to read and write this format. Note that these are very similar products (they used to be the same product)

If you have overly complicated formatting, some things will not be read or written correctly, but, for your uses, it would likely be fine. If you want to use the full scope of the format, you are safer with MS products. When I create a very complicated document, I usually use the product that best supports the target format unless I know that the formatting will be in a format that is well supported in the product that I prefer to use.
Andrew Pitonyak
http://www.pitonyak.org/oo.php
LO and AOO on Fedora
pitonyak
Volunteer
 
Posts: 186
Joined: Sun Oct 07, 2007 9:13 pm
Location: Columbus, Ohio, USA

Re: [Solved] Open CSV and save to XLSX in OO 3.4

Postby Villeroy » Wed Jan 21, 2015 2:27 pm

The latest version of MS Excel can read ODF.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26874
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: [Solved] Open CSV and save to XLSX in OO 3.4

Postby anyname » Mon Aug 08, 2016 9:41 pm

I just uninstalled OpenOffice and installed LibreOffice. I then proceeded to save an XLSX file with ease.

Thank you LibreOffice.
OpenOffice 3.none on OS X 10.11
anyname
 
Posts: 1
Joined: Mon Aug 08, 2016 9:38 pm

Re: [Solved] Open CSV and save to XLSX in OO 3.4

Postby Bonsai » Wed Aug 24, 2016 12:57 pm

Guys ..... I registered to forum to tell you my opinion on this particular topic .....

I found this post, becasue right now I have the problem, that I need to send a spreadsheet to one or our wholesaler in xmlx, as their mailserver just DELETES all xls.

So I MUST send xlsx!!!! There's absolutely no way to get the data to this company in any other format!

So stop shouting, please! The requirement is not an optional thing to get this excellent software more popular, it is a MUST HAVE. To reject this requirement is ignorant!

I already would have killed all MS Office installation in my company, but becasue such incompatibilites it is not possible.

BTW: Becasue the lot of shouting if have now to read a lot of uninterresting waste to find out why this topic is marked "solved". As english is not my mother language it wastes my time ....
ApacheOpenoffice 4.1.0 on Windows 7
Bonsai
 
Posts: 1
Joined: Wed Aug 24, 2016 12:46 pm

Re: [Solved] Open CSV and save to XLSX in OO 3.4

Postby RoryOF » Wed Aug 24, 2016 1:02 pm

OpenOffice does not, repeat _NOT_ , support xlsx format. If you must have that, try LibreOffice, but be aware that there may be problems in compatibility. If I were sending spreadsheets, which might contain sensitive financial information, I'd use a program for which the format was a native format.

When it comes to "wasting time" (your phrase) there is a lot of it about!
Apache OpenOffice 4.1.6 on Xubuntu 18.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29102
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: [Solved] Open CSV and save to XLSX in OO 3.4

Postby Villeroy » Wed Aug 24, 2016 11:40 pm

Bonsai wrote:So I MUST send xlsx!!!! There's absolutely no way to get the data to this company in any other format!

Nothing stops you from sending xlsx. Just use some appropriate software other than Apache OpenOffice which does not write this file format for very good reasons.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26874
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Previous

Return to OpenOffice Basic, Python, BeanShell, JavaScript

Who is online

Users browsing this forum: No registered users and 4 guests