Hello,
I do not know, how to delete rows or sort a sheet using c#.
I have access to the cells, but something is missing (maybe only in my head )
I tried this
XSpreadsheet oSheet;
XCellRange oCellRange;
oCellRange = oSheet.getCellRangeByPosition(0, i, 255, 1);
oCellRange.Delete () - this or similar is not existing !!
Thanks
frank
c# Programming, removing rows and sorting problems
c# Programming, removing rows and sorting problems
Libre Office 4.3 and Win 7 / 64
Re: c# Programming, removing rows and sorting problems
Libreoffice 7.4 on Debian 12 (Bookworm) (on RaspberryPI4)
Libreoffice 7.6 flatpak on Debian 12 (Bookworm) (on RaspberryPI4)
Re: c# Programming, removing rows and sorting problems
This topic may help
viewtopic.php?f=9&t=2562
viewtopic.php?f=9&t=2562
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Re: c# Programming, removing rows and sorting problems
If you want to actually remove the rows (and not just clear the contents), you need to obtain the Rows object from the Spreadsheet object, then Where i = The index of the first row to be removed
j = number of rows to remove
Code: Select all
oRows.removeByIndex(i,j)
j = number of rows to remove
OpenOffice 4.1.1 on Windows 10, HSQLDB 1.8 split database