FiveTech Software tech support forums

... Delete( lMsg ): Deletes the currently selected record.

SaveData( lRefresh ): Saves changes made during editing back to the data source.

ArrCellSet(), ArrCell(): Methods for direct manipulation of array data source cells.

Lock(), UnLock(): Methods for controlling data modification by locking ...

... row 2 and only retrieve about 80 columns of data so I can upload to SQL. Is there a way to read data row by row like below?

cValue01 := oSheet:Cells( nCurrentXlsRow, 2 ):Value
cValue02 := oSheet:Cells( nCurrentXlsRow, 8 ):Value
cValue03 := oSheet:Cells( nCurrentXlsRow, 18 ):Value
cValue04 ...

... aStruct
DATA aData
ACCESS oData // aData in the form of TArrayData

METHODS:
METHOD ReadData()
METHOD ShowData()
METHOD Range( cRange )
METHOD Cells( nRow, [anCol] )
METHOD SaveAs( cSave )
METHOD Close()/End()


Notes:
1. Reads only values and data types of the cells but does not read other ...

... row 2 and only retrieve about 80 columns of data so I can upload to SQL. Is there a way to read data row by row like below?

cValue01 := oSheet:Cells( nCurrentXlsRow, 2 ):Value
cValue02 := oSheet:Cells( nCurrentXlsRow, 8 ):Value
cValue03 := oSheet:Cells( nCurrentXlsRow, 18 ):Value
cValue04 ...

... give the cell focus and then past. Don't enter the cell and try to paste.

I noticed that when you give focus to the top/left cell and paste, all cells and rows are pasted.

The array don't need all the rows, but the columns it does. Xbrowse appends automaticaly the folowing rows (Smart xBrowse Mr ...

insert numbers using the tab key,

TAB key is never used to insert (write) data.
If you mean navigating cells....
Arrow keys move the cursor to right or left.
If you want to use TAB key to move to next right cell for editing, the same way as in Excel, then use
oBrw:lTabLikeExcel := .t.

If you set ...

I have this xbrowse




I need to insert numbers using the tab key, but I saw that it doesn't work and I have to change cells with the mouse spending a lot of time

How can I use the tab key for quick data entry?

in VB net there is a grid with which one can select all the cells and then by doing ctrl+C one can copy the content and transfer it to a notepad file, in Xbrowse this is not yet possible I hope that in the future we will have this very useful possibility

Dear Riaz,

> On key press {Enter].. fuction called ..To edit columns...

What function do you use to edit the cells ?

It could be modified to allow horizontal scrolling

The question is very simply
I want to colorize the cells interior using a color present in theme colors dialog.
In this way the user can manipulate an excel workshet using the same color i an easiste way

oAs:Range( "A1:K1" ):Interior:Color:= RGB( 244, 176 , 132 )

in my opinion an expression like ...

A mi me ha funcionado poniendo así:

vconcepto:=strtran(alltrim(oHoja:Cells( nrow, 5 ):Value),chr(10),CRLF)

Espero que le sirva a quien lo necesite.

Un saludo

... y al pasarlo de la siguiente mamera a un campo memo en el fichero dbf lo hace obviando el intro (ALT+INTRO)
vconcepto:=alltrim(oHoja:Cells( nrow, 5 ):Value)
y queda así:
"RETIRADA DE PAVIMENTO. Demolición del pavimento, capa de nivelación e impermeabilización existentes. Incluye ...

... I could use it like this :

https://www.maveco.be/fivewin/overlay.png

A selected small image that position as a layover in a cell in the top right or top left position in order to show that these cells need extra care.

This can be done with colors, but the png could also be like (DISCOUNT) image

Dear Mark,

well done!

Another way is updating after editing a xbrowse cell. If you let me know what cells will keep the values then we can do it also.

I am emailing you an updated webview DLLs that fix the resolution change. Please try them, thank you

... on page
FONTNUMBER 1 ; // Use font #2 for the body rows
FONTSIZE 10 ; // Use 9 Pt. font for the body rows
CELLAPPEAR BOLD_OFF ; // Normal cells unbolded
CELLHALIGN LEFT ; // Text in normal cells aligned left
COLUMNS 9 ; // Table has n Columns
CELLWIDTHS {0.4,0.5,0.5,0.8,0.9,0.9,0.9,0.5,0 ...