Issue 90928

Summary: Transpose table incorrectly changes external refs.
Product: Calc Reporter: tzp <zoltan.peter.toth>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 2.4.1   
Target Milestone: ---   
Hardware: PC   
OS: Linux, all   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Transpose error demo none

Description tzp 2008-06-20 14:39:54 UTC 
When transposing a table area (via copy & paste special+transpose), I get a lot
of #REF errors in the transposed table. The reason is that the references in the
original table that point outside the area of the table are transposed as well.

This is incorrect, as the cells referred from the original table remain in
place, so the reference in the transposed table should point to those cells.

I try to attach a spreadsheet to demonstrate this.
Comment 1 tzp 2008-06-20 14:41:16 UTC 
Created attachment 54635 [details]
Transpose error demo
Comment 2 discoleo 2008-06-21 14:13:50 UTC 
Can confirm this with OOo 2.4.0 and OOo-dev3.0-m19 on Win2k SP4.

However, when using:
= {TRANSPOSE() }
everything works as expected.

Only the COPY - > PASTE SPECIAL -> TRANSPOSE is affected.
Comment 3 chl207 2008-07-01 11:05:56 UTC 
This happens again in OOo-dev300-m21_en.
Moreover,after that ,when sava-close,and open the document again ,the error 
codes are #NAME?
,instead of  #REF!.
I personally think this is also an issue.(my OS is Windows Xp)
Frankly.
Comment 4 clytie 2008-07-02 09:16:26 UTC 
Since this has been confirmed in DEV300_m21 on WinXP, I'm confirming this issue.

Optimally, we need the extra-table references to be maintained. Until we can do this, maybe we need a 
warning about transposing table-sections with external references. :(