Issue 83332 - xls import filter fails to handle the anchored-to-page property (but works for export)
Summary: xls import filter fails to handle the anchored-to-page property (but works fo...
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.3
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-11-05 15:49 UTC by norbert2
Modified: 2013-02-07 21:52 UTC (History)
1 user (show)

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

Attachments
files to reproduce the bug (479.16 KB, application/x-compressed)
2007-11-05 15:51 UTC, norbert2 		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 norbert2 2007-11-05 15:49:59 UTC 
Hi,

please ...

1.
Open the attached issue1.ods:
Notice that the tux-picture is anchored to page.

2.
Save the document as "Microsoft Excel 97/2000/XP", with the name "issue2.xls"
and close it.

3.
Open the the file "issue2.xls" in MS Excel:
Notice that the propertie "Von Zellposition und -größe UNabhängig" for the
tux-picture is selected (like in the attached screenshot "issue2.png")

4.
Open the file "issue2.xls" in OOo Calc again:
Notice that tux-picture is acnhored to cell!

5.
Save the file as "Microsoft Excel 97/2000/XP", with the name "issue3.xls" and
close it.

6.
Open the the file "issue3.xls" in MS Excel:
Notice that the propertie "Von Zellposition und -größe ABhängig" for the
tux-picture is selected (like in the attached screenshot "issue3.png")

The conclusion is that OOs xls-export-filter correctly sets the property
anchored-to-page, while the xls-import-filter ignores this property.
Charts are affected by this bug, too.

Found on OOo 2.3.0 Windows.
Used Excel version: 2003 SP3
Comment 1 norbert2 2007-11-05 15:51:00 UTC 
Created attachment 49430 [details]
files to reproduce the bug
Comment 2 amy2008 2008-10-09 05:01:19 UTC 
Can reproduce it in OOo300m9 on WinXP. 
Li Meiying
Comment 3 amy2008 2008-10-09 05:02:10 UTC 
confirmed