Search found 4 matches

by nagygabor679
Fri Sep 09, 2022 12:13 pm
Forum: XLSSpreadSheet
Topic: Formula problem
Replies: 0
Views: 945

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...
by nagygabor679
Fri Sep 09, 2022 10:36 am
Forum: XLSSpreadSheet
Topic: Copy to Clipboard
Replies: 2
Views: 725

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
by nagygabor679
Thu Sep 08, 2022 1:07 pm
Forum: XLSReadWritwII 6
Topic: Sort On Multiple Columns
Replies: 2
Views: 1758

Re: Sort On Multiple Columns

Hi,
How can I sort whole table by X (any) column?
Thanks,
Gábor
by nagygabor679
Wed Sep 07, 2022 8:28 am
Forum: XLSSpreadSheet
Topic: MergedCells - remove merge
Replies: 0
Views: 910

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...