Issue 95572 - wrong encoding opening xls file
Summary: wrong encoding opening xls file
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: viewing (show other issues)
Version: OOo 3.0
Hardware: Unknown All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL: https://bugs.launchpad.net/bugs/262777
Keywords:
Depends on:
Blocks:
 
Reported: 2008-10-29 04:48 UTC by ccheney
Modified: 2014-12-23 00:30 UTC (History)
5 users (show)

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

Attachments
proposed bundle (7.96 KB, application/x-gzip)
2008-10-29 12:15 UTC, rail_ooo 		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 ccheney 2008-10-29 04:48:26 UTC 
The following file is not opened correctly in OpenOffice.org 3.0.0 (or previous
versions). It opens fine in MS Office 2007.

http://launchpadlibrarian.net/17161669/lessons.xls
Comment 1 rail_ooo 2008-10-29 05:56:57 UTC 
add CC
Comment 2 Regina Henschel 2008-10-29 09:28:04 UTC 
It is an Excel 95 file. But the encoding remains wrong, if you explicitly choose
this filter. If you save the file in a newer format in Excel 2007, the encoding
is correct when opening in Calc.

In addition font effects "outline" and "shadow" are set, which should not be.

Has this file been generated by Excel (which version?) or by some other application?
Comment 3 rail_ooo 2008-10-29 12:14:23 UTC 
Attached is a bundle of patches to enforce character encoding of old xls, doc
and some rtf files produced by MSO < 97 and other third party applications.
Enforced character set is based on OOo's locale settings in Tool-Options-Languages.

IMO, the better way is have another settings for character encoding of old MSO docs.

Currently there are 2 languages (ru, uk) with non 1252 charset enforced. Other
languages can be added on request.

Changing type to PATCH
Comment 4 rail_ooo 2008-10-29 12:15:48 UTC 
Created attachment 57538 [details]
proposed bundle
Comment 5 ooo 2008-11-06 13:57:18 UTC 
@dr: Please investigate whether the attached patch offers a viable solution.
Comment 6 Rob Weir 2013-03-11 15:00:51 UTC 
I'm adding this comment to all open issues with Issue Type == PATCH.  We have 220 such issues, many of them quite old.  I apologize for that.  

We need your help in prioritizing which patches should be integrated into our next release, Apache OpenOffice 4.0.

If you have submitted a patch and think it is applicable for AOO 4.0, please respond with a comment to let us know.

On the other hand, if the patch is no longer relevant, please let us know that as well.

If you have any general questions or want to discuss this further, please send a note to our dev mailing list:  dev@openoffice.apache.org

Thanks!

-Rob