Launchpad has imported 8 comments from the remote bug at https://bugs.freedesktop.org/show_bug.cgi?id=51918.
If you reply to an imported comment from within Launchpad, your comment will be sent to the remote bug automatically. Read more about Launchpad's inter-bugtracker facilities at https://help.launchpad.net/InterBugTracking. ------------------------------------------------------------------------ On 2012-07-09T15:22:36+00:00 Benjamin-lichtner wrote: Problem description: After reading how to export data from Base (http://help.libreoffice.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 Reply at: https://bugs.launchpad.net/df- libreoffice/+bug/1032094/comments/0 ------------------------------------------------------------------------ On 2012-07-13T14:26:11+00:00 Nv4y-robert wrote: I can't reproduce it. Have no mdb- or accdb-file. Could you please declare it with an attachment (*.odb-file and screenshot of *.odt-file)? Reply at: https://bugs.launchpad.net/df- libreoffice/+bug/1032094/comments/1 ------------------------------------------------------------------------ On 2012-07-14T00:05:27+00:00 Benjamin-lichtner wrote: Sure. Here's a link to a dropbox folder containing an .odb file, the .accdb file to which it is linked, and the .ods file into which I pasted one of the tables. https://www.dropbox.com/sh/psavwxluly5awpj/Wh_2egYE76 --Benny On Fri, Jul 13, 2012 at 11:26 PM, <[email protected]> wrote: > https://bugs.freedesktop.org/show_bug.cgi?id=51918 > > [email protected] changed: > > What |Removed |Added > > ---------------------------------------------------------------------------- > CC| | > [email protected] > > -- > Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email > ------- You are receiving this mail because: ------- > You reported the bug. > Reply at: https://bugs.launchpad.net/df- libreoffice/+bug/1032094/comments/2 ------------------------------------------------------------------------ On 2012-07-14T06:58:31+00:00 Nv4y-robert wrote: The *.odb-file is linked to a database outside the file. I couldn't see any table. I could not open an accdb-file - have no Access here and no Windows. I can not see which sorting the headers of the table had, before they are imported. When I take a table from a *.odb-file and paste it to a *.odt-file, the sorting is correct. You didn't import the Access-file in *.odb. How do you connect the *.odb-file to the accdb-file? The header of this bug is misleading. You havn't a Base-table. You have only a look on a table of another database. When you write about Base-table, we would search for the bug only in a *.odb-file, not a linked file to another database. The database of the *.odb-file is HSQLDB. The problem must be the connection between the accdb-file and LO. There is no possibility to connect to an accdb-file with a standard-LO-installation. Reply at: https://bugs.launchpad.net/df- libreoffice/+bug/1032094/comments/3 ------------------------------------------------------------------------ On 2012-07-14T07:53:38+00:00 Benjamin-lichtner wrote: Hi. To create the .odb file that I sent you, all I did was create a new Base file, select connect to an existing database, select Microsoft 2007, and select the .accdb file. However, I did need to boot into Windows--the connection is not possible on OS X. Is there a way to save a new .odb file after connecting it to another database? Or any other way to make the new .odb file independent of the .accdb file? I apologize for the misleading title. I am not familiar with databases. On Sat, Jul 14, 2012 at 8:58 AM, <[email protected]> wrote: > https://bugs.freedesktop.org/show_bug.cgi?id=51918 > > --- Comment #3 from [email protected] 2012-07-14 06:58:31 UTC --- > The *.odb-file is linked to a database outside the file. I couldn't see any > table. I could not open an accdb-file - have no Access here and no Windows. > I can not see which sorting the headers of the table had, before they are > imported. > When I take a table from a *.odb-file and paste it to a *.odt-file, the > sorting > is correct. > You didn't import the Access-file in *.odb. How do you connect the > *.odb-file > to the accdb-file? > The header of this bug is misleading. You havn't a Base-table. You have > only a > look on a table of another database. When you write about Base-table, we > would > search for the bug only in a *.odb-file, not a linked file to another > database. > The database of the *.odb-file is HSQLDB. > The problem must be the connection between the accdb-file and LO. There is > no > possibility to connect to an accdb-file with a standard-LO-installation. > > -- > Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email > ------- You are receiving this mail because: ------- > You reported the bug. > Reply at: https://bugs.launchpad.net/df- libreoffice/+bug/1032094/comments/4 ------------------------------------------------------------------------ On 2012-07-14T09:06:59+00:00 Nv4y-robert wrote: Could be the same way I can import the thunderbird-adressbook, when I want to edit the files: Open the database with the connection to the *.accdb-file. Create another new database. Click with the right button of the mouse on the table of the old database: copy. Click with the right button on the new database in the folder tables: paste. You are asked something about the types of the fiels. You can also sort the fields. Normally the fields are sorted as in the table of the old database. Try the automatic way. Could be you are asked for a primary-key. There was a key in the *.accdb-file. When you will use the new database not only for testing you must have a primary-key. If you don't know what it is you could also accept, that base creates a new key. The table would be created by this wizard. Are the fields sorted as they are sorted in the table of the old database? Now you could import the content in different ways to calc. They must be sorted like they are sorted in the new created database. After this we will see, which is the right title of this bug and we could say, this is a bug for Windows, not for Linux or Mac (because there is no easy possibility to connect to *.accdb-files). Reply at: https://bugs.launchpad.net/df- libreoffice/+bug/1032094/comments/5 ------------------------------------------------------------------------ On 2012-07-29T16:39:53+00:00 Tony Pursell wrote: I have seen a similar problem copying from Base to Calc. The table in Base contains 126 columns. 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. If correctly allocated the 126 data items take up columns A to DV. 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. I am using LO version 3.5.4.2 in Ubuntu 12.04LTS Reply at: https://bugs.launchpad.net/df- libreoffice/+bug/1032094/comments/6 ------------------------------------------------------------------------ On 2012-08-03T22:11:01+00:00 Tony Pursell wrote: @benjamin_lichtner Rather than connecting a Base (odb) file to an Access database, can you export the table to CSV (you used to be able to do do this in the days when I worked with Access mdb files) then copy that into a table in an odb file, then try copying back to Calc? If this still causes the problem that you observe, then it is not the connection to the Access database that is the problem, but the copy from Base to Calc (as I have observed. You will then have a the odb file that you can attach here as a test case. Tony Reply at: https://bugs.launchpad.net/df- libreoffice/+bug/1032094/comments/9 ** Changed in: df-libreoffice Status: Unknown => New ** Changed in: df-libreoffice Importance: Unknown => Medium -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1032094 Title: [Upstream] Data copied from Base Table to Calc spreadsheet is wrongly formatted To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1032094/+subscriptions -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
