Ask Your Question

Problem with formulas

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

przemek gravatar image

updated 2015-09-27 19:27:55 +0200

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 close merge delete

1 Answer

Sort by » oldest newest most voted

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

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
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 132 times

Last updated: Jul 30 '15