Recent

Author Topic: TsWorksheetGrid error with ERRORVALUE = 1843722240}  (Read 1237 times)

greaseflog

  • Newbie
  • Posts: 4
TsWorksheetGrid error with ERRORVALUE = 1843722240}
« on: September 23, 2019, 02:40:10 pm »
Good godmorning !

How can i fix this   "ERRORVALUE = 1843722240}" ? 
I'm import .xlsx , but his erros just happen when the cell is   CONTENTTYPE = CCTNUMBER.

celula = pcell($067A3108) = record TCELL {
  ROW = 2,
  COL = 6,
  WORKSHEET = $1e16338,
  FLAGS = [],
  FORMATINDEX = 40,
  UTF8STRINGVALUE = $0,
  RICHTEXTPARAMS = $0,
  CONTENTTYPE = CCTNUMBER,
  NUMBERVALUE = 7899516205374,
  DATETIMEVALUE = 7899516205374,
  BOOLVALUE = false,
  ERRORVALUE = 1843722240}
var
 celula: PCell = ^TCell;

thanks for all!



wp

  • Hero Member
  • *****
  • Posts: 11910
Re: TsWorksheetGrid error with ERRORVALUE = 1843722240}
« Reply #1 on: September 23, 2019, 05:43:55 pm »
The record TCell contains data of various types. You must always check the ContentType to pick the correct one - the other fields are arbitrary. So, when ContentType is cctNumber as in your example you must read the cell value from NumberValue; the ErrorValue is meaningless here.

 

TinyPortal © 2005-2018