Ask Your Question
0

Problem with formulas

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

przemek gravatar image

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

Alex Kemp gravatar image

Hi,

I've got a problem with formulas in Polish version of LibreOffice Calc version 4.4.4.3 (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
0

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

Question Tools

1 follower

Stats

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

Seen: 91 times

Last updated: Jul 30 '15