[Upstream] Data copied from Base Table to Calc spreadsheet is wrongly formatted
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
LibreOffice |
Invalid
|
Medium
|
|||
libreoffice (Ubuntu) |
Invalid
|
Undecided
|
Unassigned |
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:/
ProblemType: Bug
DistroRelease: Ubuntu 12.04
Package: libreoffice 1:3.5.4-0ubuntu1
ProcVersionSign
Uname: Linux 3.2.0-29-
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)
summary: |
- Data copied from Base Table to Calc spreadsheet is wrongly formatted + [Upstream] Data copied from Base Table to Calc spreadsheet is wrongly + formatted |
Changed in df-libreoffice: | |
importance: | Unknown → Medium |
status: | Unknown → New |
Changed in df-libreoffice: | |
status: | New → Incomplete |
Changed in df-libreoffice: | |
status: | Incomplete → Confirmed |
Changed in df-libreoffice: | |
status: | Confirmed → Invalid |
Problem description:
After reading how to export data from Base (http:// help.libreoffic e.org/Common/ Importing_ and_Exporting_ Data_in_ Base), I attempted to follow the steps to export a csv. I copied the data from a table in my database and pasted it into a new spreadsheet, but the header row was completely alphabetized (and thus misaligned), and each header name occupied more than a single column.
Steps to reproduce:
1. Import an mdb or accdb file into Base
2. Open a table
3. Copy the table
4. Open a new spreadsheet
5. Paste into the spreadsheet
Current behavior:
Elements of the header row are alphabetized and occupy more than one column. Thus they are not properly aligned with each column of data.
Expected behavior:
Each element of the header row is properly aligned with the corresponding data column.
Platform (if different from the browser):
Windows 7