Public bug reported:
Ubuntu release: 12.04.1 64 bit
package version: libreoffice-base 1:3.5.4-0ubuntu1.1
My expectation: I can right click on a table or query in LibreOffice
Base, select "Copy", then "paste" into a blank LibreOffice Calc
spreadsheet, and the data from my table or query will be copied into the
blank spreadsheet.
My reality: When I right click on a table or query in base that returns
a total of more than 65,531 elements, including column headers, and
paste into a cell in Calc, any fields after the 65,531st read are parsed
incorrectly. The remaining data elements are concatenated together and
stored in a single cell on the row where the last row of the set should
be, leaving blank rows between it and the last row with correctly loaded
fields.
For example, in a result set with two columns, the first 32,765 rows
(including header row) are pasted correctly, and the first column of the
32,766th row is pasted correctly, but all subsequent rows are not.
(32765*2)+1 = 65531
This is repeatable with different numbers of columns. 3 columns yields
21,843 correct rows, plus the first two columns of the 21,844th row
(3*21843)+2 = 65531, etc.
To illustrate, I have attached a Base database file containing a table
with 26,219 rows and 6 columns. Also in the Base file are six queries
named "one_field", "two_fields", "three_fields", "four_fields",
"five_fields", and "six_fields". Copying from any of the queries with
three or more fields and pasting to Calc results in the failed parsing
as described above.
** Affects: libreoffice (Ubuntu)
Importance: Undecided
Status: New
** Attachment added: "example Base database"
https://bugs.launchpad.net/bugs/1117935/+attachment/3518057/+files/65531_bug.odb
** Summary changed:
- Only first 65531 data elements copied from Base table to Calc sheet are
formatted correctly
+ Only first 65,531 data elements copied from Base table to Calc sheet are
formatted correctly
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1117935
Title:
Only first 65,531 data elements copied from Base table to Calc sheet
are formatted correctly
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1117935/+subscriptions
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
