crash in export date TXBrwColumn to excel
Posted: Wed May 17, 2017 2:45 pm
Hello,
Exporting to excel a xBrowse column of type Date, the program crashes in this line:
at begin of the
It is because I have excel in Italian and the dateFormat is like dd/mm/yyyy.
I put here the same fix I see in another place in the same file:
I see that for OOCalc export there is a GetNumberFormatId that convert it for localized formats, maybe we can do it for excel too...
Exporting to excel a xBrowse column of type Date, the program crashes in this line:
Code: Select all
oSheet:Cells( nRow, nCol ):NumberFormat := Lower( Set( _SET_DATEFORMAT ) )Code: Select all
METHOD ToExcel( oSheet, nRow, nCol ) CLASS TXBrwColumnI put here the same fix I see in another place in the same file:
Code: Select all
if lxlEnglish
if ValType( ::cEditPicture ) == 'C' .and. Left( ::cEditPicture, 1 ) != '@'
oSheet:Cells( nRow,nCol ):NumberFormat := Lower( ::cEditPicture )
else
oSheet:Cells( nRow,nCol ):NumberFormat := Lower( Set( _SET_DATEFORMAT ) )
endif
endif