FiveTech Software tech support forums

... local nRuote:= 1 local nColpiGioco:= 10 // the number of iteration local nColpiRecupero:= 0 //iterations for recovery We have found the right formulas to calculate the expense, the winnings, the profit and the profit in percentage as you can see on the picture we need to know how to change ...

... y aparezcan el peso del lote. Con ese dato calcularán las cantidades de detergentes, blanqueadores, suavizantes etc a aplicar al mismo, según formulas preestablecidas. Me dicen que necesitan hacerlo con este tipo de dispositivos https://articulo.mercadolibre.com.ve/MLV-741142643-1-celda-de-carga-10kg-1-hx711-modulo-sensor-arduino-esp32-_JM ...

ExcelRange Vs ADO Use ExceRange for reasonable sized ranges. The data need not be organized like a table, can contain formulas and can be or ragged size. Planned improvements in future: Will soon provide editing excel formulas in xbrowse itself. Use ADO for organized larger tables. ...

Entiendo que las formulas de combinatorias nos dicen cuantas combinaciones tenemos.
Pero yo necesito saber cuales son esas combinaciones.

Buenas Jose Alvarez

A mi me funcionan las operaciones de suma, resta, etc.... , incluso si pongo formulas o funciones. Y al vuelo, como tu dices.
Bien es cierto que siempre utilizo arrays.
Te pongo un video de ejemplo

... 2019..) y solo puedo con .XLS antiguos, o crear formatos con celdas combinados, rejillas o colores especficos , con graficos, inclusiones de formulas, nombres de tablas ; inclusive poder crear archi¿vos excel aunque no tenga instalado el Office en la maquina. Muchas veces esto no es posible ...

... of more cells with text beginning with "=". This was created for purpose of debugging while developing the feature of using Excel like formulas in Arrays and we forgot the remove this. We will remove this in the next version. You can remove this by commenting out or removing this line ...

Gracias hmpaquito y Joao

Me voy a revisar los links, necesito una de esas clases pues permiten definir celdas, hacer formulas, quiebres, Etc. son reportes, grandes pero con formato, revisare

Gracias nuevamente

Thanks Jimmy but ADO is good for exporting but it doesn't allow me to define cells with colors, widths, borders, make breaks and embed formulas, I need to generate large reports in Excel, so I need some help with LibXL or failing that with xlsxwriter
Thanks again

... (nTotalrow * nTax) / 100 Tip : Consider using that header name in your functions for better reading and sure when you add a column, all formulas will go wrong. With the names you have no problems. oBrw:NET:VarPut( value ) instead of oBrw:acols[9]:varput(value) you're right (nTotalRow*ntax)/100 ...

... (nTotalrow * nTax) / 100 Tip : Consider using that header name in your functions for better reading and sure when you add a column, all formulas will go wrong. With the names you have no problems. oBrw:NET:VarPut( value ) instead of oBrw:acols[9]:varput(value)

... 0xFF00 ) ? hb_NumToHex( hb_bitAnd( 6736896, 0x00 FF 00 ) / 0x00FF ) ? hb_NumToHex( hb_bitAnd( 6736896, 0x0000 FF ) ) I must disagree, the correct formulas are: ? hb_NumToHex( hb_bitAnd( 6736896, 0x FF 0000 ) / 0x10000 ) ? hb_NumToHex( hb_bitAnd( 6736896, 0x00 FF 00 ) / 0x100 ) ? hb_NumToHex( hb_bitAnd( ...

...  DEFINE DIALOG oDlg SIZE 600,250 PIXEL TRUEPIXEL FONT oFont ;      TITLE FWVERSION + " XBROWSE : COLMERGE AND INLINE FORMULAS"   @ 20,20 XBROWSE oBrw SIZE -20,-20 PIXEL OF oDlg ;      DATASOURCE aData COLUMNS 2,3,4,5 ;      ...

So, following my Idea, I copied the text directly to my PRG file, to test the conversion Formulas, and I got this MOISES.prg(22) Error E0030 Syntax error "syntax error at 'ô'" That means that other characters are in fact being copied in my computer, together ...

... III+, Clipper 5.0, Clipper 5.2, Fivewin (siempre que he podido), etc...) Realmente el propósito de mi respuesta era responder a la pregunta que tu formulas. Que el ComboBox no se actualiza. Como puedes comprobar en el ejemplo simple que te he copiado, SI se actualiza. Por lo tanto, no falla el ...