On further experimentation I found that restricting the print area does
NOT remove the error message.

However, in the document used for testing, a template file prepared as
follows gives the error, tested with Libreoffice 3.5.4_2 from PPA and
3.5.3:

- new document
- fill column A with data using fill/increment for a hundred or so rows.
- Select column header and give all cells borders (which extend the to the rows 
limit), or perform other formatting to the entire column, such as background 
fill
- save as .xls format

Result: unsupported rows

If the cell formatting is restricted to the active area, the error
message does not show.

It appears that the range of formatted cells is not truncated by the
Excel export filter, giving rise to an error for the formatting over 64k
rows.

Unfortunately this technique of cell formatting is in common use by
spreadsheet users to avoid selecting a specific area in their document.

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1011564

Title:
  [upstream] "the document contains more rows than supported in the
  selected format."

To manage notifications about this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug/1011564/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to