FiveTech Software tech support forums

... valores datetime con fracciones de segundo. También se ha aumentado el tamaño de las columnas para ajustar el contenido. * FWMariaRowSet: - Método ToExcel(): (1) Adjuntado: Paneles congelados en el bloque TRY/CATCH para evitar errores de tiempo de ejecución en algunas instalaciones.. (2) Los valores ...

... fixed format while exporting datetime values with fraction of seconds. Also increased column size to fit the contents. * FWMariaRowSet: - Method ToExcel(): (1) Enclosed :FreezePanes in TRY/CATCH block to avoid runtime errors in some installtions. (2) Date and DateTime values are exported as character ...

In the next version to be released.

1. :lFreezePanes does not raise runtime error.
2. Dates and TimeStamps earlier than the year 1900 are exported as text to avoid loss of data and export errors.

... LABEL "CONSULTA" ; COLORS CLR_BLACK, CLR_HRED ; TOOLTIP { "Enviar Consulta a Excel", "Consultas" } ; ACTION oBrw:ToExcel() DEFINE BUTTON OF oBar ; FILE op:png+"appchart.png" TOP ; PROMPT "Cuadro Resumen" ; TOOLTIP { "Elaborar cuadro resumen ...

It appears you are using

Code: Select all  Expand view

oRowSet:ToExcel()

of FWMaria lib.
We will now include this code in TRY/CATCH block for future.

But we advise you to use oBrw:ToExcel() which is safer.

https://fivetechsupport.com/forums/viewtopic.php?f=3&t=3950

Regards, saludos.

... [ 1] = L .T. Stack Calls =========== Called from: => TOLEAUTO:_FREEZEPANES( 0 ) Called from: .\source\internal\FWMARIA.PRG => FWMARIAROWSET:TOEXCEL( 5640 ) Luego de revisar las consultas de porque genera bien el excel en unos y no en otros me percate que el usuario habia digitado columnas ...

We get this error with some versions of Excel.

We need to modify xbrowse.prg
Please locate this line of code in the method ToExcel()

Code: Select all  Expand view

oWin:FreezePanes := .t.

Replace with:

Code: Select all  Expand view

  TRY
      oWin:FreezePanes := .t.
   CATCH
   END

Hi, My app run on 15 pcs but I get error only on 2 pcs when I call function oBrw:ToExcel() I get this error: Application =========== Path and name: myexe.exe (32 bits) Size: 7,345,664 bytes Compiler version: xHarbour 1.2.3 Intl. (SimpLex) (Build 20161218) FiveWin ...

If you set

Code: Select all  Expand view

UseXLSXLIB(  .T.  )

All toExcel methods will use this lib instead of Using Excel

Can you please make these changes in fwh\source\function\olefuncs.prg and test with toexcel() methods of Report and XBrowse please? Please replace these three functions function ExcelLangID()function ExcelLang()function ExcelTranslate( cFunc )  ...

... = C =SUBTOTAL(9,D4:D12) Stack Calls =========== Called from: => TOLEAUTO:_FORMULA( 0 ) Called from: .\source\classes\REPORT.PRG => TREPORT:TOEXCEL( 0 ) Called from: .\source\classes\RPREVIEW.PRG => (b)TPREVIEW( 0 ) Called from: .\source\classes\RPREVIEW.PRG => TPREVIEW:EXPORTTOMSEXCEL( ...

... version of FWH to be released, will come with an interface to DrXlsx lib. Conversion of AnsiToUtf8 is automatic. Using FWH methods/functions like :ToExcel() or DbfToExcel() do not require the user to convert data into utf8. What all the work a programmer needs to do is to set oBrw:lOemAnsi := .t. ...

... 'SUBTOTAAL(9;' I see. So will you be kind enough to let us know what is working correctly with Dutch installation of Excel? Also please try oBrw:ToExcel() from XBrowse, Both have the same language issues for SUBTOTAL. Please help us to support Dutch installation by advising us the correct keyword ...