TsWorksheetGrid  error with ERRORVALUE = 1843722240}
lazarus / 49-FPSpreadsheet

----------------------------------------------------------------------
greaseflog · 2019-09-23 12:40

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 · 2019-09-23 15:43

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.