OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

How to SAVE AS xlsx using OpenOffice Calc?

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
Flow
Newbie
Newbie


Joined: 09 Jan 2009
Posts: 2

PostPosted: Sat Jan 10, 2009 12:06 am    Post subject: How to SAVE AS xlsx using OpenOffice Calc? Reply with quote

Hi,

I know OpenOffice 3.0 can open xlsx (Excel 2007) files. But after opening and editing the xlsx file, can I save the file as xlsx (i.e. without changing the file extension)?

(When I click "save", xlsx does not show up under the list of file extensions.)

Can someone tell me how I can save the file (after editing) as xlsx, so I don't have to change the file extension after editing? Thanks.
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Sat Jan 10, 2009 12:37 am    Post subject: Reply with quote

Simply save as xls. There is no extra-value in saving as xlsx. Other software developers can deal with the old obscurities better than with the new ones.
MS failed to establish their pseudo-standard "Office Open XML" which has been invented to undermine the open XML-standard created by OpenOffice.org. The similarity in naming says it all.
Next service release of MS Office is reported to support the internationally standardized and well established file format of OpenOffice.org. Meanwhile you may suggest to install an office plug-in from the original vendor of that standard: http://www.sun.com/software/star/odf_plugin/ (just in case Microsoft retries to sabotage our file formats).
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
Flow
Newbie
Newbie


Joined: 09 Jan 2009
Posts: 2

PostPosted: Sat Jan 10, 2009 1:34 am    Post subject: Reply with quote

According to the person who gave me the spreadsheet, the spreadsheet uses some formulas that may not be supported in older (pre-2007) versions of Excel. So I'm worried that saving as xls may change how the spreadsheet works.

Edit: Indeed, when I try to save as xls, I get the message that "This document may contain formatting or content that cannot be saved in the Microsoft Excel 97/2000/XP file format".
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Sat Jan 10, 2009 1:58 am    Post subject: Reply with quote

The supported functions depend on the spreadsheet application rather than file format. Which exact functions does he mean? If the functions work in Calc, they should work with Excel 2003 as well. OOXML is just another way to encode the very same contents as the binary functions did.
Add-in functions impose other problems regardless of the used application since not everyone has the same set of add-ins installed.

But this is a typical issue with Microsoft users. They always assume that everybody has the latest shit from Microsoft installed.
But today Office 2007 has a comparatively small market share due to the flop of the Vista operating system and the hardware resources required by Vista and Office 2007 for almost no extra value.
If someone uses all the features of his new toy he can not expect that others can handle the result on their computers.

EDIT: Every application gives a warning that foreign file formats may strip some of the features. You get the same warning when you save a spreadsheet as plain text, which can only store the current sheet's plain data without formulas nor formatting.
There are very few features uniquely in OpenOffice.org, but not representable in the Excel file formats, regardless of xls or xlsx.

I'm fairly shure that saving a working xlsx as xls where you just edited some values, formulas or common things will not destroy anything.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
dkerber
Newbie
Newbie


Joined: 16 Sep 2009
Posts: 3

PostPosted: Wed Sep 16, 2009 10:39 am    Post subject: Reply with quote

So is saving as .xlsx a planned enhancement? Or if not, does anybody know of a 3rd-party plugin or other way of generating .xlsx files directly from OOo? We have one customer who does not want xls's; they are requiring .xlsx format, and we're hoping not to have to buy Excel 2007 just for them.

D
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Wed Sep 16, 2009 11:07 am    Post subject: Reply with quote

This has been answered over and over again. MS wants to stay compatible with itself and meanwhile I think the rest of the world should do them this favour.

No, this brand new highly complex file format (6,000 pages of technical specs, compared to 700 pages ODF specs) is impossible to implement by any software company other than Microsoft.
StarOffice/OpenOffice.org struggle since 20 years with the binary xls/doc/ppt and still they are not implemented perfectly.

You may use an experimental branch of OpenOffice.org that has been developed mainly by Novell (MS partner): http://go-oo.org
If that filter does not work well enough there is an online converter http://zamzar.com

Just another question: Why should OOo help to spread OOXML file formats that have been "invented" to kick OpenOffice.org right in the ass (just notice the name "Office Open XML").
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
dkerber
Newbie
Newbie


Joined: 16 Sep 2009
Posts: 3

PostPosted: Wed Sep 16, 2009 11:14 am    Post subject: Reply with quote

Villeroy wrote:


...

You may use an experimental branch of OpenOffice.org that has been developed mainly by Novell (MS partner): http://go-oo.org
If that filter does not work well enough there is an online converter http://zamzar.com

Just another question: Why should OOo help to spread OOXML file formats that have been "invented" to kick OpenOffice.org right in the ass (just notice the name "Office Open XML").


To help OOo's users? To help OOo get more users? Like I said, not having this capability is forcing us to *reduce* our use of OOo. If OOo can export .xlsx files, I can get 5 people in our office to forego buying another copy of M$ Office 2007, and use OOo in its place. If not, then we'll have to spend all that money, and NOT use OOo in its place.

Thanks for the suggestion about the Novel version; I'll give that a look-see.

D
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Wed Sep 16, 2009 12:24 pm    Post subject: Reply with quote

Proprietary file formats are the main reason why users are stuck to one software. Obscure file formats and all their implications are the main source of confusion, anger and disappointment among non-techie users.
Every software that produces OOXML helps to spread this pestilence.
The widely accepted ODF standard and the PDF export option are the most important reasons to install OpenOffice.org.

MSOffice is cheap enough and for most people it's better than than the rest. If you want the same as MSO accept MS being the co-owner of your data then you should definitively install Microsoft Office and never dare to ask for anything else. The latest version or some very cheply availlable older version.
OOo supports the features that can be stored in doc/xls/ppt almost fully. OOo as a program does not support all the new features that are possible to describe in OOXML.
MS Office supports 100% doc/xls/ppt, OOo 98% (?). Therefore doc/xls/ppt is the better exchange format between OOo and MSO and a few other applications.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
dkerber
Newbie
Newbie


Joined: 16 Sep 2009
Posts: 3

PostPosted: Wed Sep 16, 2009 12:37 pm    Post subject: Reply with quote

Villeroy wrote:


...

OOo supports the features that can be stored in doc/xls/ppt almost fully. OOo as a program does not support all the new features that are possible to describe in OOXML.
MS Office supports 100% doc/xls/ppt, OOo 98% (?). Therefore doc/xls/ppt is the better exchange format between OOo and MSO and a few other applications.


Believe me, you don't have to sell me on the benefits of OOo. I'm just stuck because my customer is requiring .xlsx spreadsheets. If I could get them to use OOo instead, I'd LOVE it.

D
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Wed Sep 16, 2009 1:30 pm    Post subject: Reply with quote

Just send them xls. I can't see a technical reason not to do so. If you can wrap it in xls, they receive 100% of it.
What do they expect? Until today MSOffice 2007 has a very small market share compared to version XP or 2003.
14% of WIndows boxes have OOo installed.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
grjizewolf
Newbie
Newbie


Joined: 21 Mar 2011
Posts: 1

PostPosted: Mon Mar 21, 2011 3:29 am    Post subject: Reply with quote

Villeroy wrote:
Just send them xls. I can't see a technical reason not to do so. If you can wrap it in xls, they receive 100% of it.
What do they expect? Until today MSOffice 2007 has a very small market share compared to version XP or 2003.
14% of WIndows boxes have OOo installed.


Man u should work on your attitude. Someone's asking a genuine question and there you are rambling on about MS's evil empire.

FYI: just because *you* can't see a technical reason, that doesn't mean there isn't a technical reason. I could think of one, the number of rows allowed in a sheet.
Back to top
View user's profile Send private message
ken johnson
Super User
Super User


Joined: 23 Apr 2009
Posts: 2032
Location: Sydney, Australia

PostPosted: Mon Mar 21, 2011 3:47 am    Post subject: Reply with quote

grjizewolf wrote:
FYI: just because *you* can't see a technical reason, that doesn't mean there isn't a technical reason. I could think of one, the number of rows allowed in a sheet.

Calc in OOo 3.3.0 has 1048576 rows

Ken Johnson
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Mon Mar 21, 2011 4:48 am    Post subject: Reply with quote

ken johnson wrote:
grjizewolf wrote:
FYI: just because *you* can't see a technical reason, that doesn't mean there isn't a technical reason. I could think of one, the number of rows allowed in a sheet.

Calc in OOo 3.3.0 has 1048576 rows

Ken Johnson

But the xls file format does not support more than 65536x256.

I strongly recommend using Excel for special use cases.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group