× Components and Libraries for Documents Development, discussions, problems and suggestions

Solved pl_fpspreadsheet wrong reading Libre Office Calc file

  • Leonid
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
4 years 2 months ago #9893 by Leonid
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

File Attachment:

File Name: testfps.zip
File Size:208 KB
Attachments:

Please Log in or Create an account to join the conversation.

  • Sternas Stefanos
  • Sternas Stefanos's Avatar
  • Offline
  • Moderator
  • Moderator
  • Ex Pilot, M.Sc, Ph.D
More
4 years 2 months ago #9894 by Sternas Stefanos
Replied by Sternas Stefanos on topic pl_fpspreadsheet wrong reading Libre Office Calc file
Thanks Sir
we will test and report here

PilotLogic Architect and Core Programmer

Please Log in or Create an account to join the conversation.

  • Leonid
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
4 years 1 week ago #10271 by Leonid
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

Please Log in or Create an account to join the conversation.

  • Sternas Stefanos
  • Sternas Stefanos's Avatar
  • Offline
  • Moderator
  • Moderator
  • Ex Pilot, M.Sc, Ph.D
More
4 years 1 week ago - 4 years 1 week ago #10272 by Sternas Stefanos
Replied by Sternas Stefanos on topic pl_fpspreadsheet wrong reading Libre Office Calc file
Thanks Sir
we will fix this in next Lab Release...:(

PilotLogic Architect and Core Programmer
Last edit: 4 years 1 week ago by Sternas Stefanos.

Please Log in or Create an account to join the conversation.