Ask Your Question

Problem with formulas [closed]

asked 2015-07-30 13:41:42 +0100

przemek gravatar image

updated 2020-10-28 13:11:37 +0100

Alex Kemp gravatar image


I've got a problem with formulas in Polish version of LibreOffice Calc version (Windows 7 Professional, SP1, 64-bit). In one of my sheets I created formulas which include references to the other sheet, then I saved the file and closed it. When I opened the file again, all formulas (which had references to the other sheets) were broken. It's interesting that formulas work correct when they include references to the same sheet where they were created. I hope that I made myself clear. Sorry for my poor grammar.

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 2020-08-23 09:57:03.183702

1 Answer

Sort by » oldest newest most voted

answered 2015-07-30 19:19:53 +0100

Kunjomachen gravatar image

Check the function for any change in symbols after reopening.The problem may be connected with localized argument separators. LibreOffice uses different argument separators for different languages. Check the setting under Tools →Options → LibreOffice Calc → Formula.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2015-07-30 13:41:42 +0100

Seen: 155 times

Last updated: Jul 30 '15