Err:510 Calc - Importing from Excel [closed]

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

Jonesypeter
31 ●2 ●3 ●7

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

Alex Kemp

flag of United Kingdom of Great Britain and Northern Ireland

10534 ●14 ●42 ●43 http://etmg.altervista...

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 ( 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 ( 2013-09-07 09:36:37 +0200 )edit

add a comment

2 Answers

Sort by » oldest newest most voted

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

L-user
2897 ●33 ●45 ●65

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

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 ( 2013-09-08 16:50:07 +0200 )edit

add a comment

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

m.a.riosv

21196 ●7 ●50 ●130

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

Comments

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

Jonesypeter ( 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 ( 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 ( 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 ( 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 ( 2013-09-07 14:58:34 +0200 )edit

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

Jonesypeter ( 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 ( 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 ( 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 ( 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 ( 2013-09-08 16:15:55 +0200 )edit

see more comments

Err:510 Calc - Importing from Excel [closed]

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

Comments

2 Answers

Comments

Comments

Question Tools

Stats

Related questions

Err:510 Calc - Importing from Excel [closed] edit

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

Comments

2 Answers

Comments

Comments

Question Tools

Stats

Related questions

Err:510 Calc - Importing from Excel [closed]

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