Hi Arda, Arda Tunccekic wrote (07-12-10 13:27)
I think it did not work. You can try it yourself. - Open up a new spreadsheet. Choose Column A, right click on it and click on Format Cells. Make them Text. - Now type "1.22 " , "2.4 ", "3.51 " in the first 3 rows. - Go to Column B, select the first cell, click on the sum function symbol and choose the values on column A. It doesn't calculate.. Nothing changes when I use the "Convert text to number" extension.
Thanks for your fast feedback. Sorry it doesn't help now.
Maybe the extension can first trim the trailing spaces, and then change the cell formatting to number, if it can be done..
OK, I'll put it on the todo list, see if it can be changed. Maybe I have some time next weeks to work on it. Regards, Cor -- - giving openoffice.org its foundation :: The Document Foundation - -- Unsubscribe instructions: E-mail to [email protected] List archive: http://www.libreoffice.org/lists/users/ *** All posts to this list are publicly archived for eternity ***
