[Bug 121906] New: Problem Importing CALC spreadsheet data to define and populate a new table

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=121906

            Bug ID: 121906
        Issue Type: DEFECT
           Summary: Problem Importing CALC spreadsheet data to define and
                    populate a new table
    Classification: Application
           Product: Base
           Version: AOO 3.4.1
          Hardware: PC
                OS: Windows 7
            Status: UNCONFIRMED
          Severity: normal
          Priority: P3
         Component: code
          Assignee: issues@openoffice.apache.org
          Reporter: gkissinger@cox.net
                CC: issues@openoffice.apache.org

When Importing CALC spreadsheet data to define and populate a new table after a
few iterations of (EDIT->COPY in CALC then EDIT->PASTE in BASE) the dialog
retains the table highlighted, rather than accepting a new tablename and
displaying the data just pasted.  

E.g. I (EDIT->COPY in CALC then EDIT->PASTE in BASE) data for a "Patients"
table.  Everything OK, then I repeat the process for another table.  After a
few iterations of this, the create table dialog displays the previous data that
was (EDIT->COPY in CALC then EDIT->PASTE in BASE), not the latest.  I confirmed
the new data was in fact copied.  At this point I can open any spreadsheet and
still get the last table's data displayed in the dialog box.  I have to exit
BASE and OpenOffice , restart, then everything works again.  So it seems that
something is not getting updated in BASE when the new (EDIT->COPY in CALC then
EDIT->PASTE in BASE) operation is performed.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.

[Bug 121906] Problem Importing CALC spreadsheet data to define and populate a new table

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=121906

Gary Kissinger <gk...@cox.net> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |FIXED

--- Comment #4 from Gary Kissinger <gk...@cox.net> ---
This is NOT a bug.  I was incorrectly selecting the same table while
cutting/pasting from CALC.  Sorry for my inexperience in using BASE!

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.

[Bug 121906] Problem Importing CALC spreadsheet data to define and populate a new table

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=121906

--- Comment #3 from Gary Kissinger <gk...@cox.net> ---
Created attachment 80435
  --> https://issues.apache.org/ooo/attachment.cgi?id=80435&action=edit
PNG of my screen

To setup a test case, I made 10 Excel (.xlsx) files. Filenames "tbl<0-9>"  Each
had 2 columns and 4 rows.  The 2nd column was named "tbl<n>" so I could see
when the incorrect data was displayed. I spent about 2 hours trying to condense
the problem into repeatable steps.  I failed - although I encountered the
problem twice.  But, I think now that the problem is in CALC, not BASE.  While
trying to reproduce the problem, I encountered a second issue I had in the
original session. i.e., when I did EDIT->COPY on my selected cells in CALC,
then went to OOf window to do EDIT->PASTE the PASTE was grayed out, meaning
nothing was available to be COPIED from CALC. I went back to CALC and re-COPIED
with the same result.  I had to close/launch CALC to make it work properly. 
So, my theory is that CALC is sometimes NOT copying the selected cells -
sometimes this looks to BASE like nothing is available to PASTE or in some
cases the previous COPY is available to BASE to PASTE.  I attached a .png of my
desktop when the issue was encountered.  Observe that the "Existing Columns" on
APPLY COLUMNS dialog is displaying tbl 8 columns (the previous PASTE) - the
COPIED columns should be from tbl 3 ( as can be seen in the CALC window).  So,
while I don't have discrete steps to reproduce the problem, my best advice is
to generate these 10 Excel files and then repeatedly EDIT->COPY from CALC and
EDIT->PASTE in BASE, you will encounter the problem after 5-10 cycles.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.

[Bug 121906] Problem Importing CALC spreadsheet data to define and populate a new table

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=121906

--- Comment #1 from Gary Kissinger <gk...@cox.net> ---
I found that if I EDIT->PASTE SPECIAL the dialog shows a previous filename -
not the one I am copying from - and the incorrect fields displayed in the table
dialog DO match the incorrect filename.  Problem seems to be that the
EDIT->PASTE from CALC is not overriding the previous EDIT->PASTE, even though I
CLOSED the previous file.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.

[Bug 121906] Problem Importing CALC spreadsheet data to define and populate a new table

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=121906

Rob Weir <ro...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Keywords|                            |needmoreinfo

--- Comment #2 from Rob Weir <ro...@apache.org> ---
What would be the simplest way to reproduce this bug?  Do you have a set of
specific steps that reliably cause this bug to show up?

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.