Hi Jochen I am not the original reporter (benjamin_licht...@brown.edu). I have added myself to this bug as my problems are the same or similar. Please let me know if you would prefer me to create a separate bug report.
This bug was originally reported at https://bugs.launchpad.net/df- libreoffice/+bug/1032094 See that for further details. I have uploaded three files i) A database file LS.odb containing a table Test2 ii) A Calc file copyout2.ods which shows the formatting problems iii) A screen shot ScreenshotOfFormatCells.png The file copyout2.ods was created by:- 1) Opening a new Calc document 2) Opening the file LS.odb 3) Selecting Tables 4) Right clicking on Test2 and selecting Copy 5) Switching to the Calc document 6) Copying data with Ctrl-V (cell A1 should be selected) 7) Saving the Calc document as copyout2.ods Please let me know if you need any more information Tony -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/1032094 Title: [Upstream] Data copied from Base Table to Calc spreadsheet is wrongly formatted Status in LibreOffice Productivity Suite: Incomplete Status in “libreoffice” package in Ubuntu: New Bug description: What I expected to happen: The table in Base contains 126 columns. If correctly formatted the 126 data items take up one column each, i.e. columns A to DV. Each cell should have Default formatting. What happened instead: When copied and pasted into a Calc spreadsheet, the first 35 data items span 3 columns each, taking up the first 105 spreadsheet columns from A to DA. Then from columns DB to DU there are a further 10 data items spanning 2 columns each. The other 81 data items are correctly allocated 1 column each, taking columns DV to GX. This problem seems to relate to the number of columns copied and pasted. A table with only a few columns has data items correctly allocated 1 column each. There is also other mis-formatting with strikethrough and underline formatting being applied to the data items. (This can be corrected using Format > Cells and setting '(Without)' for Strikethrough and Underlining on the Font Effects in place of the blank entries found.) This mis-formatting occurs with any size table. This has been added to a similar upstream bug https://bugs.freedesktop.org/show_bug.cgi?id=51918 ProblemType: Bug DistroRelease: Ubuntu 12.04 Package: libreoffice 1:3.5.4-0ubuntu1 ProcVersionSignature: Ubuntu 3.2.0-29.46-generic-pae 3.2.24 Uname: Linux 3.2.0-29-generic-pae i686 ApportVersion: 2.0.1-0ubuntu12 Architecture: i386 Date: Thu Aug 2 09:32:28 2012 InstallationMedia: Ubuntu 10.04 LTS "Lucid Lynx" - Release i386 (20100429) SourcePackage: libreoffice UpgradeStatus: Upgraded to precise on 2012-04-29 (94 days ago) To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1032094/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp