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

--- Comment #3 from Gary Kissinger <[email protected]> ---
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.

Reply via email to