Search found 6 matches

by bhh1988
Fri Nov 22, 2013 10:55 am
Forum: Macros and UNO API
Topic: Detect and omit empty rows
Replies: 6
Views: 8444

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.
by bhh1988
Fri Nov 22, 2013 2:44 am
Forum: Macros and UNO API
Topic: Detect and omit empty rows
Replies: 6
Views: 8444

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?
by bhh1988
Thu Nov 21, 2013 8:11 pm
Forum: Macros and UNO API
Topic: Detect and omit empty rows
Replies: 6
Views: 8444

Re: Detect and omit empty rows

Here's an example excel sheet.

Thanks
by bhh1988
Thu Nov 21, 2013 12:35 pm
Forum: Macros and UNO API
Topic: Detect and omit empty rows
Replies: 6
Views: 8444

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...
by bhh1988
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: 4158

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
by bhh1988
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: 4158

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