Issue 119728 - Text anchor properties changes in shape can not be saved when saving the attached xls file to another xls file.
Summary: Text anchor properties changes in shape can not be saved when saving the atta...
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 3.4.0
Hardware: PC All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2012-06-04 09:53 UTC by Li Lin Yi
Modified: 2012-08-02 08:24 UTC (History)
1 user (show)

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

text anchor in shape can not be saved (13.50 KB, application/
2012-06-04 09:53 UTC, Li Lin Yi
no flags Details
patch for this issue (7.11 KB, patch)
2012-08-02 06:57 UTC, Tan Li
litan.test: review?
Details | Diff

Note You need to log in before you can comment on or make changes to this issue.
Description Li Lin Yi 2012-06-04 09:53:06 UTC
Created attachment 77939 [details]
text anchor in shape can not be saved

Steps to Reproduce:
1. Open the attached xls file. Text's anchor in shape is: Right Center.
2. Change the properties to Left Center.
3. Save it to another xls file and reopen the saved file.

Expected Results:
Text's anchor in shape should be: Left Center.

Actual Results: 
Text's anchor in shape was still: Right Center.
Save the changed to ods, it can be saved.

Build Date & Platform:
Build revision is Rev. 1327774. First found on windows vista.

Symphony build SymGAD_R1_20120530.2055 has the same problem.
Comment 1 Tan Li 2012-07-20 10:08:54 UTC
   I have investigate this issue. Text anchor properties for shapes is AOO's feature which Excel don't has. Similar properties in Excel is text alignment for shapes, and it correspond AOO's text alignment, which could use by click menu "Format"->"Alignment" or from toolbar. It could be distinguished from apperance that text anchor and text alignment is different on horizontal direction.
   When import Excel file, horizontal text alignment is mapped to AOO's text alignment, but text alignment in AOO don't enable "top", "bottom", so it map Excel text alignment "top", "bottom" to text anchor in AOO, for vertical appearance is same between two software. By above methods, Excel's alignment could be mapped to AOO.
   In this issue, we want to set horizontal text anchor "left", "right" for xls file, but it could not mapped to properties in Excel, because horizontal text anchor appears differently from alignment and Excel don't has text anchor properties. AOO has more properties than Excel's text alignment in shapes, so AOO text alignment and text anchor properties could not be mapped to Excel completely.
    So I think it is not AOO's bug or if we could simplify AOO UI to keep same with Excel?
Comment 2 Tan Li 2012-08-02 06:56:05 UTC
For horizontal alignment and anchor appears similar, I have a patch for this issue, and it will map horizontal left/right anchor to left/right alignment to enhance MSO user experience.
Comment 3 Tan Li 2012-08-02 06:57:27 UTC
Created attachment 78818 [details]
patch for this issue