Date: prev next · Thread: first prev next last
2017 Archives by date, by thread · List index


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

On 28/09/17 04:02, cfranz wrote:
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



--
Sent from: http://nabble.documentfoundation.org/Users-f1639498.html



--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.