Ask Your Question
0

Lose sheet referance in calc formulas and border formatting when I save and reopen spread sheets. Libre office 4.2.1.1, English , calc. Windows 8.1, English [closed]

asked 2014-03-09 04:31:17 +0200

1947130 gravatar image

updated 2015-09-11 12:35:11 +0200

Alex Kemp gravatar image

In the formulas that gather or calculate data from a sheet other than the sheet that the formula is written on the reference to the sheet is lost on save. Eg. - =SUM('sheet 2.C3:C6) after saving and opening again will appear as =SUM(#REF!!C3:C6) I have saved sheets in XLS, Xlsx, open office ods. ,!! I just saved sheets in xls and the formulas remained intact ??? The border formatting is still lost in certain parts of the sheets.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-20 06:49:02.991888

2 Answers

Sort by » oldest newest most voted
0

answered 2014-03-09 16:00:53 +0200

m.a.riosv gravatar image

Verified the issue about broken formulas in xlsx format, reported a bug: Saving as xlsx breaks formulas with sheet name in the references

Last version working fine: Version: 4.2.0.4 Build ID: 05dceb5d363845f2cf968344d7adab8dcfb2ba71

In relation with lost borders, there is a resolved bug for next releases: Cell Borders not exported properly to XLS

I think if you don't need the new features of 4.2.x, better stay with the more stable version of 4.1.x series, you can find it in download page or you can find all releases to download in :All LibreOffice releases

edit flag offensive delete link more
0

answered 2014-03-09 15:03:17 +0200

Tinkerer gravatar image

Do not include spaces in sheet names. Rename Sheet 2 as Sheet2, Sheet_2.

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2014-03-09 04:31:17 +0200

Seen: 1,557 times

Last updated: Mar 09 '14