Functions disappearing between xls and versions [closed]

asked 2014-04-09 18:04:19 +0100

thomjones gravatar image

updated 2015-08-24 17:27:21 +0100

Alex Kemp gravatar image

Hi!
I have an xls spreadsheet that works fine in Office 2003. It is a largish spreadsheet with quite a few formulas (although they are simple formulas). And when I open this file in Calc version 5.1.5.3 under openSuSE it works fine. And when I open it under Windows XP with version 4.0.2.2 it works great as well. But if I try to open it under Windows 7 with version 4.2.2, there are four cells where the formula disappears. Formula consists of =G53+G61+G69 and three others just adding cells together. Elsewhere in the spreadsheet, there are formulas that are almost the same both addition and subtraction and these all look okay. Just this one spot of 4 cells in one column contiguous to each other that just are blank when opened under Windows 7. Any ideas? This is baffling.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2016-02-20 19:10:20.123708

Comments

Could you please attach this document here (as an separate answer, you will get permission if one more user will upvote your question or a comment) or link to it. Or better yet write a bug report about this attaching the example document there: https://www.libreoffice.org/get-help/...

mahfiaz gravatar imagemahfiaz ( 2014-04-10 13:45:42 +0100 )edit