Ask Your Question
0

Err:510 Calc - Importing from Excel [closed]

asked 2013-09-06 20:14:51 +0200

Jonesypeter gravatar image

updated 2015-09-01 23:02:35 +0200

Alex Kemp gravatar image

Hello,

If I format a cell in Excel (Windows any version) as text, then enter in the cell any number of equal signs for example

=====

Then save an Excel file 2003/2007/2010 formats then open in it up Calc the cell just says Err:510. I thought Libre Office was supposed to open Excel files?

If I try and save the file I get 'This document my contain formatting which cannot be saved in Excel Format.

I am on Windows Libre Office 4.1.1.2 and Excel 2007 for Windows. The sample file is on Dropbox

https://www.dropbox.com/s/gyejl09n0aavn68/EqualSigns.xlsx

I'm trying to move from Windows to Linux but need a good office suite that I can rely on. A spreadsheet came from my accountant with this formatting I made the changes n LibreOffice then could not send the file back to him, so had to do it all again in Excel.

Thanks

Peter Jones

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-07 23:27:42.222342

Comments

Please can you share a sample file?

m.a.riosv gravatar imagem.a.riosv ( 2013-09-06 22:10:53 +0200 )edit

Please provide file, most of the users of LibreOffice do not use Excel anymore, so they can't reproduce the problem without sample file. Please also write what is your Excel, Windows and LibreOffice version. Also what is your Linux name and version. Provide more info (you can update your question using Edit).

L-user gravatar imageL-user ( 2013-09-07 09:36:37 +0200 )edit

2 Answers

Sort by » oldest newest most voted
1

answered 2013-09-07 20:00:14 +0200

L-user gravatar image

updated 2013-09-07 20:08:25 +0200

I can perfectly fine open this two files:
https://www.dropbox.com/s/gyejl09n0aavn68/EqualSigns.xlsx
https://www.dropbox.com/s/r0yixrw4emppryl/EqualSigns.xls
in LibreOffice 4.0.5 on Windows XP. See attachment of both files opened: excel.png

LibreOffice 4.0.x should be currently used by most of the users! LibreOffice 4.1.x should be used only with users that are willing to test and report bugs or really really need new features only available in latest version.

I suggest the following:
1. Document carefully how can you reproduce the problem and what error messages you get.
2. Uninstall LibreOffice 4.1.x
3. Install LibreOffice 4.0.x
4. Retest the files. Does it works fine for you? If yes, then it is possible there is some kind of bug in LibreOffice 4.1.x and in this case PLEASE report a bug at bugtracker: https://www.libreoffice.org/get-help/bug/ and write how the bug can be reproduced (see step 1). In title bar of bug report write: "[REGRESSION] then the title bar".

edit flag offensive delete link more

Comments

Hi,

Thanks for the reply. Just so you are aware I downloaded the new version of OpenOffice 4 and the file opened perfectly. I will download LibreOffice 4.0.x and feedback.

Peter

Jonesypeter gravatar imageJonesypeter ( 2013-09-08 16:50:07 +0200 )edit
0

answered 2013-09-07 12:03:07 +0200

m.a.riosv gravatar image

Hi Jonesypeter,

sorry but this is not an excel file, it is a HTML file with excel extension.

image description

edit flag offensive delete link more

Comments

That is the standard format that Excel 2007 saves a file in XML format.

Jonesypeter gravatar imageJonesypeter ( 2013-09-07 12:51:13 +0200 )edit

XLSX files are created using the Open XML standard, which was introduced in Microsoft Office 2007. They are stored as a compressed Zip archive, which contains a collection of individual files. The archive includes the file [Content_Types].xml, which describes the spreadsheet, and an XML file for each worksheet within the spreadsheet.

That is an Excel file.

Jonesypeter gravatar imageJonesypeter ( 2013-09-07 12:54:58 +0200 )edit

Then the share file it is not the file what you are talking about (EqualSigns.xlsx). When I change their extension to HTML the windows explorer shows the file contents.

m.a.riosv gravatar imagem.a.riosv ( 2013-09-07 14:51:08 +0200 )edit

Sorry, All I know is I saved the file from Excel 2007 in the standard format like I have hundreds of files. I think you must have the wrong end of the stick. Apologies.

Jonesypeter gravatar imageJonesypeter ( 2013-09-07 14:56:54 +0200 )edit

I have also saved it in old Office 2003 format.

https://www.dropbox.com/s/r0yixrw4emppryl/EqualSigns.xls

Jonesypeter gravatar imageJonesypeter ( 2013-09-07 14:58:34 +0200 )edit

I think I need help from someone who uses Excel and LibreOffice? Thanks

Jonesypeter gravatar imageJonesypeter ( 2013-09-07 14:59:44 +0200 )edit

Hi Jonesypeter, I have not any end of the stick. If you do not want understand what is happening, why should I do? Good luck with the issue.

m.a.riosv gravatar imagem.a.riosv ( 2013-09-07 15:10:44 +0200 )edit

@mariosv, you have most probably right clicked on link and selected Save Link As. In this case I also get a HTML file. But if I click on the link and then on opened web page click on Download link to download file, file is downloaded without a problem. Don't know why, probably some Dropbox hack...

L-user gravatar imageL-user ( 2013-09-07 20:02:55 +0200 )edit

Hi L-user, thanks for your information, now I can open the file and see the issue. All needed information is in your answer.

m.a.riosv gravatar imagem.a.riosv ( 2013-09-07 22:13:16 +0200 )edit

Many thanks L-user, and Mariosv,

I'm glad you managed to get the file and replicate my issue.

Hopefully we can get this sorted?

Best wishes

jonesypeter

Jonesypeter gravatar imageJonesypeter ( 2013-09-08 16:15:55 +0200 )edit

Question Tools

2 followers

Stats

Asked: 2013-09-06 20:14:51 +0200

Seen: 2,700 times

Last updated: Sep 07 '13