Custom Format Exception
Posted: Fri Jun 13, 2008 11:22 am
I met an exception when I attempt open an Excel created file which has user customized date format stored within the excel file by using both XLSReadWriteII 3/4.
The exception prompt is: "Can not find number format# 57."
I had tried to solve the issue by myself. I found there are only 50 formats have been pre-defined in const array named ExcelStandardNumFormats in "CellFormats4.pas". I added more format strings in the array as below.
it seems worked but I'm not sure it is right way, please advise. Thank you.
The exception prompt is: "Can not find number format# 57."
I had tried to solve the issue by myself. I found there are only 50 formats have been pre-defined in const array named ExcelStandardNumFormats in "CellFormats4.pas". I added more format strings in the array as below.
Code: Select all
......
{2F} '[h]:mm:ss',
{30} 'mm:ss.0',
{31} '# #0.0E+0',
{32} '@',
{33} '',
{34} '',
{35} '',
{36} '',
{37} '',
{38} '',
{39} '',
{3A} 'yyyy"年"m"月"'); // 3A means format 57