Issue 40954 - Resizing a hidden column to show it shifts cell anchored objects (formulas...)
Summary: Resizing a hidden column to show it shifts cell anchored objects (formulas...)
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 1.1.3
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-01-19 11:00 UTC by goa103
Modified: 2017-05-20 11:11 UTC (History)
1 user (show)

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

Attachments
A simple spreadsheet document with 3 columns (7.24 KB, application/vnd.sun.xml.calc)
2005-01-19 11:02 UTC, goa103 		no flags Details
Spreadsheet document screenshot (2.36 KB, image/png)
2005-01-19 11:03 UTC, goa103 		no flags Details
Spreadsheet document screenshot once the Description column is hidden (1.74 KB, image/png)
2005-01-19 11:04 UTC, goa103 		no flags Details
Spreadsheet document screenshot with the formula object shifted to the left because the hidden column was resized (2.71 KB, image/png)
2005-01-19 11:05 UTC, goa103 		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 goa103 2005-01-19 11:00:20 UTC 
You can show or hide a column by right clicking its name. Once hidden you can
decide to resize it to show it. By resizing the column shifts the cell anchored
objects from the other cells. Showing « back » the hidden column doesn't shift
the objects. As these objects, formulas for example, are anchored to their
cells, they shouldn't being shifted when the hidden column is resized.

It means the objects are not really anchored to their cells. They're just
floating objects like the ones you can get in Writer text documents. I also
mentionned an other anchoring issue in issue 36529.

I will attach some screenshots of what I wrote, what you get when a column is
hidden and what you get the hidden column is resized : the formula object is
shifted to the left.
Comment 1 goa103 2005-01-19 11:02:59 UTC 
Created attachment 21672 [details]
A simple spreadsheet document with 3 columns
Comment 2 goa103 2005-01-19 11:03:49 UTC 
Created attachment 21673 [details]
Spreadsheet document screenshot
Comment 3 goa103 2005-01-19 11:04:25 UTC 
Created attachment 21674 [details]
Spreadsheet document screenshot once the Description column is hidden
Comment 4 goa103 2005-01-19 11:05:20 UTC 
Created attachment 21675 [details]
Spreadsheet document screenshot with the formula object shifted to the left because the hidden column was resized
Comment 5 goa103 2005-01-19 14:07:52 UTC 
Tip of the day : Instead of hiding columns, you can split the current sheet view
from the Window > Split menu. See issue 19291, issue 19292 and topic
http://www.oooforum.org/forum/viewtopic.php?t=1704
Comment 6 frank 2005-01-26 16:52:03 UTC 
Hi Niklas,

may be a seldom problem but should not occur I think.

Frank
Comment 7 Marcus 2017-05-20 11:11:20 UTC 
Reset assigne to the default "issues@openoffice.apache.org".