Recalculate doesn't work

users
#1

Hallo.
I have a problem with recalculate in a file.
I have imported some data from Börse Frankfurt and I have made a spreadsheet
with some formulas.
The calculate from row 5 to row 10 are correct, but from row 11 to row 13
not. I tried to recalculate but without success.
I have noticed that the format of columns of "bind" and "Ask" (columns M and
N) was text, not numbers. After I have changed these (with regular
expressions), the spreadsheet has become correct.
But I don't understand why before,despite the format of columns M and N was
in incorrect format, only half of rows was correct.
The file is:
https://mega.nz/#!nZBn2CLa!WJTJgahHFAMFg5oTN3LeCyVNjqijJhRodUNEale4PQk

Can somebody help me to understand why?
Thanks

Cri

#2

Hi CFranz:

Would you please tell us what version of LibreOffice use you ?, it is because some issues are correlations with specific versions. I don't know in this case but usually is necessary to know the version if it is a cause of a bug.

Regards,

Jorge Rodríguez

#3

I did find that there were trailing spaces on the contents of some cells.
How did you import the information. All at once or certain columns at a time.
steve

#4

Is not version correlate because I tired with 5.4.1, 5.3.4.2, 5.2.2.
I tried with different OS (linux, Mac..).

#5

I copied and pasted.
There isn't spaces (I have checked it) :slight_smile:

steveedmonds wrote

#6

I have a problem with recalculate in a file.

Er, no: you don't!

I have imported some data from Börse Frankfurt and I have made a spreadsheet with some formulas. The calculate from row 5 to row 10 are correct, but from row 11 to row 13 not.

That's simply untrue. In your example file, *all* those rows show #VALUE! for some results, as you are trying to calculate with values expressed as text.

I tried to recalculate but without success.

If you have set up a calculation that doesn't work, why on earth would you expect a recalculation to behave differently? If the M40 doesn't get you to Cambridge, would you try that way again and hope for different results?

I have noticed that the format of columns of "bind" and "Ask" (columns M and N) was text, not numbers. After I have changed these (with regular expressions), the spreadsheet has become correct.

Good-oh! Problem solved. (The better solution is to select appropriate cell formats for columns in the Text Import window.)

I copied and pasted. There isn't spaces (I have checked it) :slight_smile:

It makes no sense to attempt to deny the facts! Those text values *do* have trailing spaces. But that's irrelevant, as it is not the problem.

I trust this helps.

Brian Barker