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