I copied and pasted. There isn't spaces (I have checked it) :)
steveedmonds wrote > 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: > [email protected] > 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 -- Sent from: http://nabble.documentfoundation.org/Users-f1639498.html -- To unsubscribe e-mail to: [email protected] 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
