FiveTech Software tech support forums

... 'de' for German, 'es' for Spanish, what is it for Dutch? -> 'nl' is the iso code for Dutch and Flemish. 2) Please provide translations for: SUBTOTAL( -> SUBTOTAAL( SUM( --> ??? - > SOM( TRUE --> ??? -> WAAR FALSE --> ??? -> ONWAAR Language ID = 1043 Decimal separator ...

... also. Please help me with this information: 1) Like 'de' for German, 'es' for Spanish, what is it for Dutch? 2) Please provide translations for: SUBTOTAL( -> SUBTOTAAL( SUM( --> ??? TRUE --> ??? FALSE --> ??? Please run the small test and let us know the results: oExcel     ...

... mins 31 secs Error occurred at: 04/09/2023, 13:24:57 Error description: (DOS Error -2147352567) WINOLE/1006 (0x800A03EC): _FORMULA Args: [ 1] = C =SUBTOTAL(9,D4:D12) Stack Calls =========== Called from: => TOLEAUTO:_FORMULA( 0 ) Called from: .\source\classes\REPORT.PRG => TREPORT:TOEXCEL( ...

Excel is installed in Dutch. So '=SUBTOTAL(9,' was changed into '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 ...

Hello Mr. Rao,

Excel is installed in Dutch.

So '=SUBTOTAL(9,' was changed into 'SUBTOTAAL(9;'

Kind regards,
Bart

SUBTOTAAL or SUBTOTAL ?
What is Excel installation language?

Will you please make this correction in report.prg? Please locate the string '=SUBTOTAL(9,' and substitute it with '=SOUS.TOTAL(9;' We would be glad if you can let us know if this modification works for French installation of Excel. I changed the file report.prg ...

... data field -> precio         size 5   picture "@e 9,999,999"  font 2   column title  'Subtotal'              data field -> subto total    size 5   picture "@e 9,999,999" font ...

... Dt AS LPSTR, Hs AS LPSTR ) AS LONG PASCAL ; FROM "Bematech_FI_ReduccionZ" LIB oDp:nBemaDLL // Kleyber (Brasil) DLL32 FUNCTION BmSubTotal( SubTotal AS LPSTR ) AS LONG PASCAL ; FROM "Bematech_FI_SubTotal" LIB oDp:nBemaDLL //Ler número do caixa //DLL32 FUNCTION BmNumeroCx( ...

... "a.idcontacto as c4, " + ; ; "b.id as c5, " + ; "b.nombre as c6, " + ; "b.telefono as c7, " + ; ; "a.subtotal as c8, " + ; "a.descuento as c9, " + ; "a.total as c10 " + ; ; "FROM tbfacturados a " + ; "LEFT JOIN ...

... ;      )   RELEASE FONT oFontreturn nil  https://i.postimg.cc/N9CzdZGK/xbrow.jpg Pero quisiera llevarlo a excel y se vea subtotalizado, asi: https://i.postimg.cc/xNH3LZXD/excel.jpg No logro hacerlo, existe el parametro nGroupby del metodo toExcel pero no ...

Dear Rao Sir, I need to show subtotal in XBROWSE on the Tree Level. Could you please help me for the same. Thanks Shridhar Please try this sample function TestTree2()   local oCn   local cSql, oRs, oDlg, oFont, ...

Dear Rao Sir,

I need to show subtotal in XBROWSE on the Tree Level. Could you please help me for the same.

Thanks
Shridhar

... 296 )   Called from: test.prg => TEST( 164 )  then I wish have the get on bottom because I wish have SubTotal, Descuent, and Total the final user can insert the Descuent and the total must be refresh I made a function to calculate the subtotal and the ...

... this number indicates the column number of the exported columns. If any columns have totals, the exported sheet is grouped by nGroupBy column and subtotals displayed. For this purpose, Excel’s subtotal method is used so that the results can be used for futher computations. 3. [aCols]: By default, ...