Issue 90360 - use OOo "no perspective" for Excel "perspective 0.1°"
Summary: use OOo "no perspective" for Excel "perspective 0.1°"
Status: CLOSED FIXED
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@graphics
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-06-04 14:02 UTC by Regina Henschel
Modified: 2017-05-20 11:42 UTC (History)
1 user (show)

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

Attachments
testcases for perspective setting (94.50 KB, application/vnd.ms-excel)
2008-06-04 14:04 UTC, Regina Henschel 		no flags Details
same in Excel 2007 file format (82.32 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2008-06-04 14:05 UTC, Regina Henschel 		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 Regina Henschel 2008-06-04 14:02:45 UTC 
This is a follow up to issue 72994.

I'll attach an Excel file which contains two charts and beneath them pictures
of the charts that show how they look in Excel 2007. Open the file in OOo2.4.1.
Besides gaps in the grid, you can notice that the vertical lines have stairs,
which makes the columns and grids ugly. Open 3d View and disable perspective.
Now the vertical lines are OK.

Excel has no setting for "no perspective" and you cannot set the perspective to
0° but the smallest value is 0.1°. Although this settings are missing, the
vertical lines in Excel have no stairs. It seems that Excel uses 0.1° as synonym
for "no perspective".

Because the setting "no perspective" gives better charts in OOo than setting
"0.1°" is should be used in import for such charts.

 I haven't got an OOo3.0m15, therefore cannot test it there.
Comment 1 Regina Henschel 2008-06-04 14:04:16 UTC 
Created attachment 54236 [details]
testcases for perspective setting
Comment 2 Regina Henschel 2008-06-04 14:05:39 UTC 
Created attachment 54237 [details]
same in Excel 2007 file format
Comment 3 kla 2008-06-04 14:19:57 UTC 
@DR: I think its your turn.
Comment 4 daniel.rentz 2008-06-04 14:34:29 UTC 
started

note that Excel mesaures perspective in percent, not degrees, this is an UI bug
in Excel :-)
Comment 5 daniel.rentz 2008-11-21 17:16:17 UTC 
fixed in CWS DEV300/dr67

both filters fixed: XLSX and XLS
Comment 6 daniel.rentz 2009-03-12 12:56:28 UTC 
back to QA
Comment 7 oc 2009-04-09 09:43:53 UTC 
verified in internal build cws_dr67
Comment 8 thorsten.ziehm 2009-07-20 14:53:19 UTC 
This issue is closed automatically and wasn't rechecked in a current version of
OOo. The fixed issue should be integrated in OOo since more than half a year. If
you think this issue isn't fixed in a current version (OOo 3.1), please reopen
it and change the field 'Target Milestone' accordingly.

If you want to download a current version of OOo =>
http://download.openoffice.org/index.html
If you want to know more about the handling of fixed/verified issues =>
http://wiki.services.openoffice.org/wiki/Handle_fixed_verified_issues
Comment 9 thorsten.ziehm 2009-07-20 15:35:45 UTC 
Sorry this issue was wrongly closed. This issue will be reopened automatically.
And will be set after that back to fixed/verified.
Comment 10 thorsten.ziehm 2009-07-20 15:40:08 UTC 
Set to state 'fixed'.
Comment 11 thorsten.ziehm 2009-07-20 15:44:21 UTC 
Set back to state 'verified/fixed'.

Again. Sorry for the mass of mails.