Issue 90928 - Transpose table incorrectly changes external refs.
Summary: Transpose table incorrectly changes external refs.
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.4.1
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-06-20 14:39 UTC by tzp
Modified: 2013-01-29 21:47 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Transpose error demo (7.88 KB, application/vnd.oasis.opendocument.spreadsheet)
2008-06-20 14:41 UTC, tzp 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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. :(