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:
oSheet:Cells( nRow, nCol ):NumberFormat := Lower( Set( _SET_DATEFORMAT ) )at begin of the
METHOD ToExcel( oSheet, nRow, nCol ) CLASS TXBrwColumnIt 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:
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
endifI see that for OOCalc export there is a GetNumberFormatId that convert it for localized formats, maybe we can do it for excel too...