https://bugs.freedesktop.org/show_bug.cgi?id=87773
--- Comment #5 from raal <[email protected]> --- LO: 4.3.3.2, Linux python /usr/local/bin/runxlrd.py 3rows /tmp/upc_number_sample.xls === File: /tmp/upc_number_sample.xls === Open took 0.01 seconds BIFF version: 8; datemode: 0 codepage: 1200 (encoding: utf_16_le); countries: (1, 1) Last saved by: u'Calc' Number of data sheets: 1 Use mmap: 1; Formatting: 0; On demand: 0 Ragged rows: 0 Load time: 0.00 seconds (stage 1) 0.01 seconds (stage 2) sheet 0: name = u'Sheet1'; nrows = 161; ncols = 1 cell A1: type=1, data: u'UPC#' cell A2: type=1, data: u'744835962453' cell A161: type=1, data: u'744835400016' command took 0.00 seconds after deleting # from UPC# /tmp/xlrd-0.9.3$ python /usr/local/bin/runxlrd.py 3rows /tmp/upc_number_sample.xls === File: /tmp/upc_number_sample.xls === Open took 0.00 seconds BIFF version: 8; datemode: 0 codepage: 1200 (encoding: utf_16_le); countries: (420, 420) Last saved by: u'Calc' Number of data sheets: 1 Use mmap: 1; Formatting: 0; On demand: 0 Ragged rows: 0 Load time: 0.00 seconds (stage 1) 0.00 seconds (stage 2) sheet 0: name = u'Sheet1'; nrows = 161; ncols = 1 cell A1: type=1, data: u'UPC' cell A2: type=2, data: 0.0 cell A161: type=2, data: 0.0 command took 0.00 seconds I changed first number (A2 cell) from ="744835962453" to numeric value: python /usr/local/bin/runxlrd.py 3rows /tmp/upc_number_sample.xls === File: /tmp/upc_number_sample.xls === Open took 0.00 seconds BIFF version: 8; datemode: 0 codepage: 1200 (encoding: utf_16_le); countries: (420, 420) Last saved by: u'Calc' Number of data sheets: 1 Use mmap: 1; Formatting: 0; On demand: 0 Ragged rows: 0 Load time: 0.00 seconds (stage 1) 0.00 seconds (stage 2) sheet 0: name = u'Sheet1'; nrows = 161; ncols = 1 cell A1: type=1, data: u'UPC' cell A2: type=2, data: 744835962453.0 cell A161: type=2, data: 0.0 command took 0.00 seconds Open file, save as .ods, then save as .xls python /usr/local/bin/runxlrd.py 3rows /tmp/upc_number_sample2.xls === File: /tmp/upc_number_sample2.xls === Open took 0.00 seconds BIFF version: 8; datemode: 0 codepage: 1200 (encoding: utf_16_le); countries: (420, 420) Last saved by: u'Calc' Number of data sheets: 1 Use mmap: 1; Formatting: 0; On demand: 0 Ragged rows: 0 Load time: 0.00 seconds (stage 1) 0.00 seconds (stage 2) sheet 0: name = u'Sheet1'; nrows = 161; ncols = 1 cell A1: type=1, data: u'UPC' cell A2: type=2, data: 0.0 cell A161: type=2, data: 0.0 command took 0.00 seconds xlrd read values as numeric values but these values are strings. I don't know if it is bug in LO or in xlrd. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
