[Bug 1032094] Re: [Upstream] Data copied from Base Table to Calc spreadsheet is wrongly formatted
closing here, too ** Changed in: libreoffice (Ubuntu) Status: Confirmed = Invalid -- 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 ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1032094] Re: [Upstream] Data copied from Base Table to Calc spreadsheet is wrongly formatted
** Changed in: df-libreoffice Status: Confirmed = Invalid -- 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 ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1032094]
I have retested thus using LO version 4.2.7.2 and Ubuntu 14.04 and it seems to be OK now so I am changing the status to RESOLVED/FIXED. If any one else still has this problem using 4.2.7.2 or later, please put it back to NEW. -- 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 ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1032094]
(We reserve the FIXED resolution when we know the exact commit that fixed a bug. When a bug becomes obsolete or is not reproducible anymore, we set the WORKSFORME status.) -- 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 ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1032094]
Adding self to CC if not already on -- 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 ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1032094] Re: [Upstream] Data copied from Base Table to Calc spreadsheet is wrongly formatted
Status changed to 'Confirmed' because the bug affects multiple users. ** Changed in: libreoffice (Ubuntu) Status: New = Confirmed -- 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 ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1032094] Re: [Upstream] Data copied from Base Table to Calc spreadsheet is wrongly formatted
Upstream Base attachment https://bugs.freedesktop.org/attachment.cgi?id=66342 . ** Attachment added: LS.odb https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1032094/+attachment/3338699/+files/LS.odb -- 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 ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1032094] Re: [Upstream] Data copied from Base Table to Calc spreadsheet is wrongly formatted
Upstream attachment https://bugs.freedesktop.org/attachment.cgi?id=66343 . ** Attachment added: copyout2.ods https://bugs.launchpad.net/df-libreoffice/+bug/1032094/+attachment/3338748/+files/copyout2.ods -- 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 ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1032094] Re: [Upstream] Data copied from Base Table to Calc spreadsheet is wrongly formatted
** Changed in: df-libreoffice Status: Incomplete = Confirmed -- 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 ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1032094]
Hi reporter, it is necessary to make the bugreport reproducible. Please do following: 1) Ceck if object/title of this bugreport is correct 2) List the single steps in details to reproduce your procedure 3) attach database-file and screenshot(s) -- 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 ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1032094]
Created attachment 66342 Database (odb) file -- 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 ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1032094]
Created attachment 66343 Calc file showing formatting problems -- 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 ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1032094]
Created attachment 66344 Screen shot of the Format Cells dialogue -- 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 ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1032094]
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 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 ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1032094]
Thanks for taking this on, Tony! -- 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 ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1032094] Re: [Upstream] Data copied from Base Table to Calc spreadsheet is wrongly formatted
** Changed in: df-libreoffice Status: New = Incomplete -- 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 ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1032094] Re: [Upstream] Data copied from Base Table to Calc spreadsheet is wrongly formatted
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, bugzilla-dae...@freedesktop.org wrote: https://bugs.freedesktop.org/show_bug.cgi?id=51918 rob...@familiegrosskopf.de changed: What|Removed |Added CC|| rob...@familiegrosskopf.de -- 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, bugzilla-dae...@freedesktop.org wrote: https://bugs.freedesktop.org/show_bug.cgi?id=51918 --- Comment #3 from rob...@familiegrosskopf.de 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
[Bug 1032094] Re: Data copied from Base Table to Calc spreadsheet is wrongly formatted
-- 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: Data copied from Base Table to Calc spreadsheet is wrongly formatted To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1032094/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1032094] [NEW] Data copied from Base Table to Calc spreadsheet is wrongly formatted
Public bug reported: 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) ** Affects: libreoffice (Ubuntu) Importance: Undecided Status: New ** Tags: apport-bug i386 precise running-unity -- 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: Data copied from Base Table to Calc spreadsheet is wrongly formatted To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1032094/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1032094] Re: Data copied from Base Table to Calc spreadsheet is wrongly formatted
** Bug watch added: freedesktop.org Bugzilla #51918 https://bugs.freedesktop.org/show_bug.cgi?id=51918 ** Also affects: df-libreoffice via https://bugs.freedesktop.org/show_bug.cgi?id=51918 Importance: Unknown Status: Unknown ** Summary changed: - Data copied from Base Table to Calc spreadsheet is wrongly formatted + [Upstream] Data copied from Base Table to Calc spreadsheet is wrongly formatted -- 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 ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs