Search found 38 matches: nformat

Return to advanced search

Re: DBF to Excel Sheet, without Excel, using ADO ?

A few suggestions: 1) Instead of your CopyToClipBoard() fuction, we recommend using FW_CopyToClipboard( data, [nFormat] ) --> lSuccess nFormat can be omitted and is mostly guessed correctly by the function. 2) Sec2HMS: There are built-in functions in (x)Harbour ...
by nageswaragunupudi
Tue Aug 15, 2023 7:21 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF to Excel Sheet, without Excel, using ADO ?
Replies: 50
Views: 2567

Re: New FTDN April/Abril 2023 (FWH 23.04)

... cSql ) mejorado a QueryResult( cSql, [aParams] ) * Nueva función JsonView( cJsonText/File, [cTitle] ) * La función FW_CopyToClipBoard( uValue, [nFormat] ) --> lSucess Ahora también soporta texto UTF8. * Corrección: la función GetProfString() causaba un GPF en Windows 7 si se compilaba con ...
by Antonio Linares
Thu May 04, 2023 6:37 am
 
Forum: WhatsNew / Novedades
Topic: New FTDN April/Abril 2023 (FWH 23.04)
Replies: 4
Views: 1750

New FTDN April/Abril 2023 (FWH 23.04)

... cSql ) enhanced to QueryResult( cSql, [aParams] ) * New Function JsonView( cJsonText/File, [cTitle] ) * function FW_CopyToClipBoard( uValue, [nFormat] ) --> lSucess now supports UTF8 text also. * Fix: function GetProfString() was causing a GPF in Windows 7 if compiled using Visual C 2022. ...
by Antonio Linares
Tue May 02, 2023 7:08 am
 
Forum: WhatsNew / Novedades
Topic: New FTDN April/Abril 2023 (FWH 23.04)
Replies: 4
Views: 1750

Re: Pasar facturas a Excel

... Date() ) OF oXls Para un texto: @ nFila, nCol XLS SAY OemToAnsi( cText ) OF oXls Para un número, antes tengo que dar formato: DEFINE XLS FORMAT nFormat PICTURE '#,##0.00' Y no he visto otras formas de hacerlo
by JoseLuis
Wed Dec 21, 2022 8:30 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: Pasar facturas a Excel
Replies: 5
Views: 560

Re: New FTDN June/Junio (FWH 21.06)

... * Nueva función FW_CopyToClipBoard( uValue, [nFormat] ) --> lSuccess Función simple para copiar al portapapeles, sin tener que crear un objeto TClipboard. El segundo parámetro no es necesario ...
by Antonio Linares
Wed Jul 28, 2021 2:07 pm
 
Forum: WhatsNew / Novedades
Topic: New FTDN June/Junio (FWH 21.06)
Replies: 7
Views: 2111

New FTDN June/Junio (FWH 21.06)

... * New function FW_CopyToClipBoard( uValue, [nFormat] ) --> lSuccess Simple function to copy to clipboard, without having to create TClipboard object. Second parameter is not necessary of the ...
by Antonio Linares
Tue Jul 27, 2021 4:47 pm
 
Forum: WhatsNew / Novedades
Topic: New FTDN June/Junio (FWH 21.06)
Replies: 7
Views: 2111

New FTDN June/Jnio (FWH 21.06)

... * New function FW_CopyToClipBoard( uValue, [nFormat] ) --> lSuccess Simple function to copy to clipboard, without having to create TClipboard object. Second parameter is not necessary of the ...
by Antonio Linares
Tue Jul 27, 2021 4:46 pm
 
Forum: WhatsNew / Novedades
Topic: New FTDN June/Jnio (FWH 21.06)
Replies: 0
Views: 467

Excel 2016

... "XLSError.ch" #define BORDER_UP nOr( BORDER_TOP ) #define BORDER_DOWN nOr( BORDER_BOTTOM ) #DEFINE TRUE .T. #DEFINE FALSE .L. LOCAL nFormat,nFormat2,nFormat3,nFont1,nFont2,nFont3,oXLS local f local i DEFINE XLS FORMAT nFormat PICTURE '#,##0.00_);[Red](#,##0.00)' DEFINE XLS FORMAT ...
by acwoo1
Wed Jul 31, 2019 8:19 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Excel 2016
Replies: 0
Views: 477

xls color

... "XLSError.ch" #define BORDER_UP nOr( BORDER_TOP ) #define BORDER_DOWN nOr( BORDER_BOTTOM ) #DEFINE TRUE .T. #DEFINE FALSE .L. LOCAL nFormat,nFormat2,nFormat3,nFont1,nFont2,nFont3,oXLS local f local i DEFINE XLS FORMAT nFormat PICTURE '#,##0.00_);[Red](#,##0.00)' DEFINE XLS FORMAT ...
by acwoo1
Sun Apr 15, 2018 8:08 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: xls color
Replies: 4
Views: 1369

New FTDN May/Mayo 2017 (FWH 17.05)

... AddHelp( cAbout, cCopyRight, aColors, cFile, cRes ) METHOD AddMdi( aColors, cFile, cRes ) * New function GetClipContentFormat( [aFormats] ) --> nFormat This function can be used to find if clipboard is empty and if not the format of the clipboard contents, eg. CF_TEXT (1), CF_BITMAP(2) Optional ...
by Antonio Linares
Sat May 20, 2017 10:15 am
 
Forum: WhatsNew / Novedades
Topic: New FTDN May/Mayo 2017 (FWH 17.05)
Replies: 1
Views: 2431

Re: DBF editors

Hello, function copy to delimited errors out. I think the parameter nMode == 1 should be logical parameter and TRUE. Best regards, Otto ELSEIF nFormat == 3 // Delimited ? cFileName //__dbDelim( nMode == 1 , cFileName , cDelim , aFld , ; // bFor , bWhile , nNext , nRec , lRest) __dbDelim( .T. ...
by Otto
Mon Sep 12, 2016 8:07 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF editors
Replies: 16
Views: 4431

Re: question for trichedit

... cFileName ) CLASS TRichEdit  Cristobal before pls see the methods METHOD InsertRTF( cRTF ) CLASS TRichEdit and METHOD CanPaste( nFormat ) before there was a new data nFormat ? I thinked to add a data into trichedit Data nformat add nformat on New method and redefine and on some ...
by Silvio.Falconi
Sun Apr 24, 2016 9:52 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: question for trichedit
Replies: 10
Views: 2455

Re: Save all the Screen to BMP

Romeo,

You could try:

FIConvertImageFile( cDestinationFileName, cSourceFileName, nFormat, nQuality )
by Antonio Linares
Tue Oct 13, 2015 9:24 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Save all the Screen to BMP
Replies: 13
Views: 1848

Error al grabar formulas con FileXLS con + de 16000 lineas

... METHOD Formula( nRow, nCol, nNumber, lRecalc, cFormula, ; lHidden, lLocked, nFont, nFormat, lShaded, ; nBorder, nAlignament ) CLASS TFileXLS local cExpression := GetExpression( cFormula ) local nLen := Len( cExpression ) DEFAULT nNumber ...
by Enrrique Vertiz
Mon May 25, 2015 3:49 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: Error al grabar formulas con FileXLS con + de 16000 lineas
Replies: 2
Views: 598
Next

Return to advanced search