Bug 49979 - EDITING : Paste Special with Transpose & Link doesn't work in some situations
Summary: EDITING : Paste Special with Transpose & Link doesn't work in some situations
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.3 release
Hardware: x86 (IA32) Windows (All)
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-05-15 16:03 UTC by Janusz
Modified: 2012-09-05 09:18 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
Example of bug discovered (15.27 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-05-15 16:03 UTC, Janusz
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Janusz 2012-05-15 16:03:01 UTC
Created attachment 61702 [details]
Example of bug discovered

Hi,
attached is a file which, I hope, illustrates the problem:
1) create new Calc document,
2) fill rectangular range with values(numbers) thus creating a matrix M by N
3) highlight and copy
4) choose cell nearby upper boundary of the spreadsheet,
5) Paste special (Ctrl+Shift+V), choose All, Link, Transpose
6) in attached file transposing failed in two cases: into C10 cell
   and K20 cell, but
7) astonishingly pasting the same data but from range K13 (origin 2nd) into K20
   succeeded!

Provisional conclusion:

Copying and pasting special with transpose 
from some first (7?) rows is always incorrect.
Beginning from 8th row the same makes good result.

LO, 3.5.3, XP & Win7. Ubuntu not tested.

Greetings,
Janusz
Comment 1 Noel Grandin 2012-09-05 09:18:19 UTC
Tested in 3.6.1.2 (Windows)