Ask Your Question

How to use .xml spreadsheet in LibreOffice

asked 2019-05-08 21:10:07 +0200

El Fundidor gravatar image

updated 2019-05-12 21:59:15 +0200

My granddaughter has a college class and they use xml spreadsheets with formulas. How does she convert these files to a format that libre office can work with?

Update 2019-05-09T18:55+02:00 (erAck: moved the following section from Answer to this Question)

The spreadsheet was created with Exxel. My granddaughter uses Libre Office Calc. When she opens the .xml spreadsheet, she gets errors in the cells that have formulas. In the formula composition line above, the formulas have an =of in front of the normal formula. If I go to each individual cell that contains a formula and delete that prefix, it works for multiplication functions. But for formulas that output an average of the numbers in three cells, it still does not work.Here is one of her text

edit retag flag offensive close merge delete


What do you mean by xml spreadsheet exactly? MS Excel can produce XML Spreadsheets, LibreOffice can produce Flat XML ODF Spreadsheets (.fods), so your usage is a bit unspecific to provide an answer. Which application produced these .xml spreadsheets you are talking about ?

Opaque gravatar imageOpaque ( 2019-05-08 22:18:05 +0200 )edit

According to your answer, I think the only way to give a useful answer requires to have an anonymized version of your Excel xml. Please consider to upload a testfile (use the clip icon when editing your original question)

But from my point of view, it sounds a bit strange that you try a way which requires the use of 2 format conversions from Excel to xml and from xml into LibreOffice, while LibreOffice is capable to use Excel's native format .xlsx. Every conversion is prone to leak information, since no support of a foreign format is hardly ever 100%, and a single conversion (from xls/xlsx into LibreOffice) probably is less prone than a double conversion.

Opaque gravatar imageOpaque ( 2019-05-09 09:35:59 +0200 )edit

The =of appears to be the OpenFormula namespace used in ODF spreadsheet documents; however, if that shows up as content there's something wrong. Which Excel version and what filter / file format was used to create the file? Without seeing the file there's not much we can do other than guessing. Please attach the sample file if it doesn't have sensitive content. Otherwise you'd want to replace sensitive content with XXX or such and save again (in that Excel version!) before uploading.

erAck gravatar imageerAck ( 2019-05-09 19:07:02 +0200 )edit

I have the file to attach to my question, but the forum software will not allow for an .xml attachment. Should I post it as text in a comment?

El Fundidor gravatar imageEl Fundidor ( 2019-05-12 13:13:45 +0200 )edit

Rename the file to an allowed extension (e.g. <name>.odt) and make a comment, that it is an xml file and needs to be renamed to .xml before using/investigating.

Opaque gravatar imageOpaque ( 2019-05-12 13:50:02 +0200 )edit

I have changed the file extension to .xls, and made note that it is an .xml file.

El Fundidor gravatar imageEl Fundidor ( 2019-05-12 15:25:34 +0200 )edit

@El Fundidor

Upload the original file in a cloud and post the link here at ask.

The xls formula is gone.

Schiavinatto gravatar imageSchiavinatto ( 2019-05-12 16:11:19 +0200 )edit

The link to the .xml file is:

link text

El Fundidor gravatar imageEl Fundidor ( 2019-05-12 18:37:18 +0200 )edit

My Excel 2007 does not open?

Opened just like LibreOffice, without the formulas.

Schiavinatto gravatar imageSchiavinatto ( 2019-05-12 22:19:38 +0200 )edit

That is the problem. She is working with formulas in her class.

El Fundidor gravatar imageEl Fundidor ( 2019-05-12 22:39:40 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-05-14 19:46:31 +0200

erAck gravatar image

That linked file is a mix of OpenFormula syntax (ss:Formula="of:=...") stored in the old interim MS-Excel 2003 XML file format. That's not going to fly. Didn't even know that Excel allows such combination (if it was Excel that wrote the file?). In Excel 2013 (or newer) either save as OOXML .xlsx or as ODF .ods, in older Excel versions only save as OOXML .xlsx; best bet when saving in Excel is always OOXML .xlsx

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-05-08 21:10:07 +0200

Seen: 718 times

Last updated: May 14 '19