Recent

Author Topic: FPSpreadsheet ODS Bug  (Read 3023 times)

VTwin

  • Hero Member
  • *****
  • Posts: 1215
  • Former Turbo Pascal 3 user
FPSpreadsheet ODS Bug
« on: January 31, 2015, 07:59:33 pm »
Hello,

I greatly appreciate the work on FPSpreadsheet and use it for data file input and output (not the GUI parts at present). It is terrific! I encountered a bug in the OpenDocRead however, when the following spreadsheet (below, and see attached file) is opened in the opendocdemo:

123
112
111
122

the following output is obtained:

Code: [Select]
Row: 0 Col: 0 Value: 1
Row: 0 Col: 1 Value: 2
Row: 0 Col: 2 Value: 3
Row: 1 Col: 0 Value: 1
Row: 1 Col: 2 Value: 2
Row: 2 Col: 0 Value: 1
Row: 3 Col: 0 Value: 1
Row: 3 Col: 1 Value: 2

It is failing to find a cell if the text is repeated from the previous column.

This is FPSpreadsheet 1.4.1

Cheers,
VTwin
“Talk is cheap. Show me the code.” -Linus Torvalds

Free Pascal Compiler 3.2.2
macOS 12.1: Lazarus 2.2.6 (64 bit Cocoa M1)
Ubuntu 18.04.3: Lazarus 2.2.6 (64 bit on VBox)
Windows 7 Pro SP1: Lazarus 2.2.6 (64 bit on VBox)

VTwin

  • Hero Member
  • *****
  • Posts: 1215
  • Former Turbo Pascal 3 user
Re: FPSpreadsheet ODS Bug
« Reply #1 on: January 31, 2015, 08:53:19 pm »
Bug report filed
“Talk is cheap. Show me the code.” -Linus Torvalds

Free Pascal Compiler 3.2.2
macOS 12.1: Lazarus 2.2.6 (64 bit Cocoa M1)
Ubuntu 18.04.3: Lazarus 2.2.6 (64 bit on VBox)
Windows 7 Pro SP1: Lazarus 2.2.6 (64 bit on VBox)

wp

  • Hero Member
  • *****
  • Posts: 11923
Re: FPSpreadsheet ODS Bug
« Reply #2 on: January 31, 2015, 09:47:38 pm »
Fixed in r3919 and version 1.4.2
« Last Edit: January 31, 2015, 10:39:24 pm by wp »

VTwin

  • Hero Member
  • *****
  • Posts: 1215
  • Former Turbo Pascal 3 user
Re: FPSpreadsheet ODS Bug
« Reply #3 on: January 31, 2015, 10:25:37 pm »
Excellent!!  My sincere thanks to the developers.
“Talk is cheap. Show me the code.” -Linus Torvalds

Free Pascal Compiler 3.2.2
macOS 12.1: Lazarus 2.2.6 (64 bit Cocoa M1)
Ubuntu 18.04.3: Lazarus 2.2.6 (64 bit on VBox)
Windows 7 Pro SP1: Lazarus 2.2.6 (64 bit on VBox)

VTwin

  • Hero Member
  • *****
  • Posts: 1215
  • Former Turbo Pascal 3 user
Re: FPSpreadsheet ODS Bug
« Reply #4 on: January 31, 2015, 10:32:40 pm »
I just tried it out, works great! Thanks wp!!!

I love Free Pascal/Lazarus :D
“Talk is cheap. Show me the code.” -Linus Torvalds

Free Pascal Compiler 3.2.2
macOS 12.1: Lazarus 2.2.6 (64 bit Cocoa M1)
Ubuntu 18.04.3: Lazarus 2.2.6 (64 bit on VBox)
Windows 7 Pro SP1: Lazarus 2.2.6 (64 bit on VBox)

 

TinyPortal © 2005-2018