Ubuntu
openoffice.org package

wrong result of operation in calc

Asked by Vorona

Hello everybody,

I have a weird issue with Calc - first time I encounter such a thing.
When I open a particuliar document converted from xls the results of certain operations (not all of them, but it seems to be most of them) made by reference to other cells are wrong. For instance E5 = 20, E6 = 5, E7 = E6 - E5 = 0.

Any document registered from this document displays the same errors, and new operations show errors too.

No problem with other documents.

I am using OOo 3.2.0 for Ubuntu, under Kubuntu. French language.

I'd like to upload the sheet and a screenshot.

Thanks in advance
Erik

Question information

Language:
English Edit question
Status:
Solved
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Solved by:
Vorona
Solved:
Last query:
Last reply:
Revision history for this message
David Mawdsley (dm-madmod) said : 		#1

Make sure your E7 cell has "=E6-E5" without the quotes. Also make sure that all 3 cells are numbers by checking their cell formats. Also try using another 3 cells to do the same arithmetic. Then copy and paste the new cells onto E5, E6 and E7.

The possibility exists also that the particular document with the 3 problem cells is corrupt and a new worksheet needs to be made. Because the source was an Excel file, there may be a bad macro tangled up with the worksheet that's interrupting the calculations.

Best of luck.

Revision history for this message
Vorona (erikmartre) said : 		#2

Hi David.

It remains a bit strange, but anyway your answer was very helpful.

What is strange is that the data was formatted as "serial number - standard". Since the last or maybe an older update, the choice "number" does'nt exist any longer. When I choose 'all' - '-1234', the results are correct again, in spite of the fact that when I get back to the format dialog box, it is still 'serial number' but this time '-1234'. It looks like a bug : serial numbers are generally auto incremented numbers, and the choice by default should be 'number - standard', but it does'nt exist. When a file is created with OOo the default is 'serial number -1234' (seems to be, at least), but the issue occured with this file coming from Excel with most cells containing numbers formatted as "serial standard" . Even stranger is that I already imported this file (my agenda at work) without having those problems.

Thanks a lot David.