Search found 4 matches
- Fri Sep 09, 2022 12:13 pm
- Forum: XLSSpreadSheet
- Topic: Formula problem
- Replies: 0
- Views: 3401
Formula problem
Hi, I would like set formulas by my program. When the btn3Click procedure is executed, I see a zero number at cell B2, but "2" is expected. (If I export the table into XLSX file, and I load into Excel, then I see "2" in the cell.) Question 1: how can I update, recalculate or do a...
- Fri Sep 09, 2022 10:36 am
- Forum: XLSSpreadSheet
- Topic: Copy to Clipboard
- Replies: 2
- Views: 2412
Copy to Clipboard
Hi,
How can I copy the selected area to Windows clipboard?
(In XLSClipboard5.pas I didn't see any copy function)
Thanks,
Gábor
How can I copy the selected area to Windows clipboard?
(In XLSClipboard5.pas I didn't see any copy function)
Thanks,
Gábor
- Thu Sep 08, 2022 1:07 pm
- Forum: XLSReadWritwII 6
- Topic: Sort On Multiple Columns
- Replies: 2
- Views: 3386
Re: Sort On Multiple Columns
Hi,
How can I sort whole table by X (any) column?
Thanks,
Gábor
How can I sort whole table by X (any) column?
Thanks,
Gábor
- Wed Sep 07, 2022 8:28 am
- Forum: XLSSpreadSheet
- Topic: MergedCells - remove merge
- Replies: 0
- Views: 3428
MergedCells - remove merge
Hi, I would like to merge cells and remove merge. I wrote this little test program: procedure TForm1.btn1Click(Sender: TObject); begin with xs do begin XLS[0].SelectedAreas[0].Col1 := 1; XLS[0].SelectedAreas[0].Row1 := 1; XLS[0].SelectedAreas[0].Col2 := 2; XLS[0].SelectedAreas[0].Row2 := 2; XLS[0].M...