Welcome, Guest
Username: Password: Remember me
Components and Libraries for Documents Development, discussions, problems and suggestions
  • Page:
  • 1

TOPIC:

pl_fpspreadsheet wrong reading Libre Office Calc file 7 years 6 months ago #9893

  • Leonid
  • Leonid's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 36
  • Thank you received: 3
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.

pl_fpspreadsheet wrong reading Libre Office Calc file 7 years 6 months ago #9894

  • Sternas Stefanos
  • Sternas Stefanos's Avatar
  • Offline
  • Moderator
  • Moderator
  • Ex Pilot, M.Sc, Ph.D
  • Posts: 4506
  • Thank you received: 1100
Thanks Sir
we will test and report here
PilotLogic Architect and Core Programmer

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

pl_fpspreadsheet wrong reading Libre Office Calc file 7 years 4 months ago #10271

  • Leonid
  • Leonid's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 36
  • Thank you received: 3
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.

pl_fpspreadsheet wrong reading Libre Office Calc file 7 years 4 months ago #10272

  • Sternas Stefanos
  • Sternas Stefanos's Avatar
  • Offline
  • Moderator
  • Moderator
  • Ex Pilot, M.Sc, Ph.D
  • Posts: 4506
  • Thank you received: 1100
Thanks Sir
we will fix this in next Lab Release...:(
PilotLogic Architect and Core Programmer

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

Last edit: by Sternas Stefanos.
  • Page:
  • 1