Ask Your Question

I have an MS excel file. When opening it with calc there is a lot of err:520

asked 2018-02-02 14:37:02 +0200

calc gravatar image

updated 2018-02-02 14:38:08 +0200

Hopeles case?

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted

answered 2018-02-02 20:53:22 +0200

erAck gravatar image

Err:520 means an unknown formula token and can have various reasons. Without inspecting the actual document in question there's nothing we could do. Which LibreOffice version btw?

edit flag offensive delete link more


Version is 6. Maybe I send it to you. There is nothing sensitive in it.

calc gravatar imagecalc ( 2018-02-04 14:27:22 +0200 )edit

Probably best to submit a bug report for this case and attach the document in question.

erAck gravatar imageerAck ( 2018-02-05 12:39:59 +0200 )edit

answered 2018-02-03 10:50:56 +0200

calc gravatar image

Can't get any help of those. Version is this new 6. Maybe I send part of that file so that errors are there, you willing to check? But very simple commands like =#NAME? give the error.

edit flag offensive delete link more


Please don't use the answer field to comment on your case (because it is not an answer to the question), instead either edit your question or add a comment there. Thanks.

erAck gravatar imageerAck ( 2018-02-05 12:41:33 +0200 )edit

answered 2018-02-02 15:46:01 +0200

Try Tools/detective/trace error. when done Tools/detective/remove all traces. Also, if I recall rightly, Tools/Options/LibreOffice Calc/Calculate, Enable regular expressions in formulas. This box is to be unchecked for Excel files. In mine I have another unchecked, No wildcards or regular expressions in formulas. All others are checked. Hope that helps.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-02-02 14:37:02 +0200

Seen: 70 times

Last updated: Feb 03 '18