Issue 40954

Summary: Resizing a hidden column to show it shifts cell anchored objects (formulas...)
Product: Calc Reporter: goa103 <goa>
Component: editingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 1.1.3   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
A simple spreadsheet document with 3 columns
none
Spreadsheet document screenshot
none
Spreadsheet document screenshot once the Description column is hidden
none
Spreadsheet document screenshot with the formula object shifted to the left because the hidden column was resized none

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".