TOPIC:

typhon64 IDE v5.8, Debian 8 (Jessie)

pl_fpspreadsheet problem with reading from
Libre Office(Version: 5.1.5.2) Calc file(.ods):

If the cell has a format 'text'(1) and it really contains a number(column B - named elem_id in my example),
method TsWorksheet.ReadAsText(iRow, iCol) returns empty string. It's wrong.
(1)(LO Calc menu Format->Format Cells: Category='Text', Format='@', FormatCode='@')

If the cell has a format 'Number'(2) and it really contains a number,
method TsWorksheet.ReadAsText(iRow, iCol) returns string contains a number. It's good.
(2)(LO Calc menu Format->Format Cells: Category='Number', Format='Standart', FormatCode='Standart')

attachment
testfps.zip -included project for demonstrate truble and
LO.Calc file 'testfps.ods'

p.s. with typhon v5.6 this problem no

Thanks Sir
we will test and report here

CT 5.9 great work! But here in CT5.9 the problem with the pl_fpspreadsheet still exists (reading from LO Calc file -
cell has a format 'text' and it really contains a number method TsWorksheet.ReadAsText(iRow, iCol) returns empty string)
www.pilotlogic.com/sitejoom/index.php/fo...ffice-calc-file#9893

Thanks Sir
we will fix this in next Lab Release...