Search found 6 matches
- Fri Nov 22, 2013 10:55 am
- Forum: Macros and UNO API
- Topic: Detect and omit empty rows
- Replies: 6
- Views: 8619
Re: Detect and omit empty rows
Yea I see it now, thanks! So it seems to me that Excel treats those columns as hidden and therefore doesn't print them to pdf. Libreoffice doesn't seem to respect the notion of hidden cells or sheets, at least in version 3.5.
- Fri Nov 22, 2013 2:44 am
- Forum: Macros and UNO API
- Topic: Detect and omit empty rows
- Replies: 6
- Views: 8619
Re: Detect and omit empty rows
Interesting...I can't find column H in the spreadsheet. It skips from column F to I. Are you able to find this in the GUI? If so, what OS and software? Or did you find this character using the api?
- Thu Nov 21, 2013 8:11 pm
- Forum: Macros and UNO API
- Topic: Detect and omit empty rows
- Replies: 6
- Views: 8619
Re: Detect and omit empty rows
Here's an example excel sheet.
Thanks
Thanks
- Thu Nov 21, 2013 12:35 pm
- Forum: Macros and UNO API
- Topic: Detect and omit empty rows
- Replies: 6
- Views: 8619
Detect and omit empty rows
Some excel sheets for some reason end with a ton of empty rows. I would like an automated way of figuring out the used area (rows with content in them) and omitting the rest. Using cursor.gotoEndOfUsedArea(True) seems to actually count the empty rows as part of the used area, so that doesn't work. A...
- Thu Nov 21, 2013 1:51 am
- Forum: Macros and UNO API
- Topic: [Solved] Limit number of rows or columns when saving to pdf
- Replies: 2
- Views: 4180
Re: Limit number of rows or columns when saving to pdf
Awesome. This works!
I also stumbled upon this which was helpful and I think you wrote this as well:
https://wiki.openoffice.org/wiki/Python ... agesRanges
I also stumbled upon this which was helpful and I think you wrote this as well:
https://wiki.openoffice.org/wiki/Python ... agesRanges
- Wed Nov 20, 2013 7:25 am
- Forum: Macros and UNO API
- Topic: [Solved] Limit number of rows or columns when saving to pdf
- Replies: 2
- Views: 4180
[Solved] Limit number of rows or columns when saving to pdf
Hi guys, How can I limit/cut-off the number of rows or columns of a spreadsheet when saving to pdf? Effectively, I want to crop or cut-off spreadsheets that are too large, usually because there are too many empty rows. I know that you can get the bounds of the spreadsheet with something like: cursor...