Ask Your Question
0

Calc 6.3.x - Err:522 opening workbook

asked 2019-11-09 18:38:46 +0100

Mr_Jamie gravatar image

updated 2019-11-09 18:39:43 +0100

I am getting an Err:522 in the third row and down the rest of the sheet after upgrading to 6.3.x, This workbook works fine in all previous versions. If I recalculate, copy the formula from the cell above, or change a value the sheet is fine. The cell contents are a simple formula. =$D$5*B17 The cell doing the calculation is C17.

This only happens on 2 out of the 3 sheets in the workbook

image description

C:\fakepath\Lottery Returns_New.ods

edit retag flag offensive close merge delete

Comments

Your document uploaded doesn't show the error (also numbers differ)

522 Circular reference Formula refers directly or indirectly to itself and the Iterations option is not set under Tools - Options - LibreOffice Calc - Calculate. See https://help.libreoffice.org/latest/en-US/text/scalc/05/02140000.html.

Could it be you made a typo and wrote =$D$5*C17 into cell C17 once (at least, if I do that, I'll see the same pattern, as you do).

Opaque gravatar imageOpaque ( 2019-11-09 18:40:03 +0100 )edit

I change some of the figures on the top of the spreadsheet, but did not take another screen shoot. It does not matter what the numbers on top are still get same results.

Mr_Jamie gravatar imageMr_Jamie ( 2019-11-09 18:48:56 +0100 )edit

Again - I don't see the error in the file you've uploaded and 522 is a circular reference, which doesn't appear in the file Lottery Returns_New.ods (using LibreOffice 6.3.3.2).

Opaque gravatar imageOpaque ( 2019-11-09 18:52:48 +0100 )edit

Iterations were set I upped them to 1000 to no avail. Also if I copy down from the cell above the sheet works and when I save it and reopen I get the same results.

Mr_Jamie gravatar imageMr_Jamie ( 2019-11-09 18:54:25 +0100 )edit

Thanks for looking, I will reinstall after a reboot and try again.

Mr_Jamie gravatar imageMr_Jamie ( 2019-11-09 18:56:27 +0100 )edit

I can't see what got iterations to do with that sheet. Please consider to check user profile as well (use Safe Mode and check opening the file in Safe Mode. If that works, you might face a corrupted user profile, which won't be fixed by a reinstall).

Opaque gravatar imageOpaque ( 2019-11-09 18:59:50 +0100 )edit

It is working now. I removed Libreoffice including my profile info and reinstalled. I think you are right it was in my profile in App Data. It was curious that it worked in versions before 6.3.x. Thanks for your help.

Mr_Jamie gravatar imageMr_Jamie ( 2019-11-09 19:19:12 +0100 )edit

Really another strange side effect of a corrupt user profile.

Opaque gravatar imageOpaque ( 2019-11-09 19:28:47 +0100 )edit
1

Might be related to Tools -> Options -> Calc -> Calculate, CPU threading settings, Enable multi-threaded calculation.

erAck gravatar imageerAck ( 2019-11-09 22:36:06 +0100 )edit

Please test following the above @erAck advice, reported bugs like Err:522 on updating data from linked sheet

m.a.riosv gravatar imagem.a.riosv ( 2019-11-10 05:19:19 +0100 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2019-11-09 19:26:49 +0100

Opaque gravatar image

For the record (according to last comment of OP)

Reset user profile:

Case 1: LibreOffice can still be started

  • Start in Safe Mode using Help -> Restart in Safe Mode and confirm the restart using button: Restart
  • Archive your profile expanding Advanced (click on the word Advanced right above Help button) and click Archive User Profile button
  • Select option Reset to factory settiings
  • Activate [x] Reset entire user profile
  • Click button Apply Changes and Restart

If the answer is correct or helped you to solve your problem, please click the check mark (✔) next to the answer.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-11-09 18:38:46 +0100

Seen: 21 times

Last updated: Nov 09