Issue 53223 - WW8: brackets lost when exporting Equation formulas
Summary: WW8: brackets lost when exporting Equation formulas
Alias: None
Product: Writer
Classification: Application
Component: save-export (show other issues)
Version: OOo 2.0 Beta
Hardware: PC Windows XP
: P4 Trivial with 13 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: ms_interoperability, regression
: 57390 57670 57911 59085 59416 63072 63087 66888 67490 69643 75456 85069 85129 (view as issue list)
Depends on: 105084
  Show dependency tree
Reported: 2005-08-11 16:57 UTC by heldmar
Modified: 2013-08-07 14:44 UTC (History)
5 users (show)

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

My original (spanish) document, if you open it in OO it seems perfectly BUT open it with MS-Office and formulas are a complete dissaster! (241.00 KB, application/vnd.sun.xml.writer)
2005-08-11 16:59 UTC, heldmar
no flags Details
Screenshot of view in MS Word (127.39 KB, image/jpeg)
2005-08-12 10:26 UTC, michael.ruess
no flags Details
Screenshot of the doc opened by MS-Word 2003 (356.65 KB, image/jpeg)
2005-08-13 05:13 UTC, heldmar
no flags Details
Not so good conversion after all (386.90 KB, application/pdf)
2005-08-19 15:27 UTC, heldmar
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description heldmar 2005-08-11 16:57:27 UTC
I found that when you export a document that contains formulas written with
OO-Writer to MS-Word. I think it's because MS-Word 2003 uses Microsoft Equation
3.0 which formats the equations completely different than OO equation writer, in
fact it works efficiently than OO in that aspect (I have to declare myself a
pro-Open Source and pro-OO but....I cannot migrate until EVERYTHING works fine)
Comment 1 heldmar 2005-08-11 16:59:04 UTC
Created attachment 28670 [details]
My original (spanish) document, if you open it in OO it seems perfectly BUT open it with MS-Office and formulas are a complete dissaster!
Comment 2 eric.savary 2005-08-11 17:25:25 UTC
ES->MRU: of course, not a P1. Evaluate if it may be a P2 are else.
Comment 3 michael.ruess 2005-08-12 10:08:32 UTC
I cannot reproduce the problm with the newest build 680m122.
See my attached screenshot.
Comment 4 michael.ruess 2005-08-12 10:26:32 UTC
Created attachment 28684 [details]
Screenshot of view in MS Word
Comment 5 michael.ruess 2005-08-12 10:27:43 UTC
Comment 6 heldmar 2005-08-13 05:10:47 UTC
Oddly my MS-Word keeps displaying the document badly, so, what could it be? What
version of MS-Word did you tried to see it? I'm using MS-Word 2003, could it be
the difference?
Comment 7 heldmar 2005-08-13 05:13:42 UTC
Created attachment 28717 [details]
Screenshot of the doc opened by MS-Word 2003
Comment 8 michael.ruess 2005-08-15 12:00:24 UTC
MRU->SJ: The problem occurs when when only the OpenSymbol font (no StarSymbol
installed) is availablöe on the system. Then MS Word will fail to display the
objects correctly. Activating the objects shows correct contents.
Comment 9 heldmar 2005-08-16 18:59:16 UTC
So, what you suggest is that I have to install StarSymbol beside my normal OO
installation so my formulas can be viewed by any Word Processor?

Can you help me with any suggestion or link where it's explained how to install
StarSymbol? How to mantain my OO up to date and full compatible with MS so I can
migrate completely and no depend?
Comment 10 heldmar 2005-08-18 11:44:51 UTC
I can't understand what could happen, because I have used Times New Roman in my
equations to avoid special fonts that can't be recognized in other systems but
still I'm getting bad symbols on documents opened with MS-Word when they contain
Comment 11 heldmar 2005-08-19 15:27:10 UTC
Created attachment 28931 [details]
Not so good conversion after all
Comment 12 heldmar 2005-08-19 15:32:56 UTC
Please note this document I sent. I demonstrate that there's still a little
problem with conversion between OO formulas and MS-Word. In another issue
(53463) user UFI helped me configuring my OO to export and import correctly from
MS. Anyway, when anyone exports a document .DOC that contains a formula it is
NOT recognized in the first moment by MS-Word as it should so, you have to make
a double click over the formula to MS-Word recognize ALL the characters and
reformat it (after this reformat everything looks fine!). This is why I'm
deciding to repost reopening this issue. Thanks.
Comment 13 michael.ruess 2005-11-10 11:03:40 UTC
*** Issue 57390 has been marked as a duplicate of this issue. ***
Comment 14 quetschke 2005-11-10 12:49:22 UTC
Setting keywords regression and ms_interoperability.

This worked in OOo 1.1.x and according to comments in issue 57390 in m113.

This renders OOo useless for the scientific community as OOo *is* the way
to exchange documents with collegues that are forced to use MSO.

Targeting this issue to later leaves a bad aftertaste, even more as it allegedly
works with Staroffice.
Comment 15 michael.ruess 2005-11-11 15:46:16 UTC
As long as this is broken functionality and it has been reported from different
sources until  now I will retarget this to OO 2.0.2.
Comment 16 michael.ruess 2005-11-11 15:47:12 UTC
*** Issue 57670 has been marked as a duplicate of this issue. ***
Comment 17 michael.ruess 2005-11-15 12:24:04 UTC
*** Issue 57911 has been marked as a duplicate of this issue. ***
Comment 18 dridgway 2005-12-15 23:56:20 UTC
*** Issue 59416 has been marked as a duplicate of this issue. ***
Comment 19 sven.jacobi 2006-01-12 15:31:00 UTC
sj->tl: Private area characters (StarSymbol) are used when creating the
metafile, this is not good because StarSymbol is mostly not available. My first
impression I received is that the characters we use can also be found in
specified Unicode areas.
Comment 20 michael.ruess 2006-01-13 09:04:34 UTC
Retargeted to 2.0.3.
Comment 21 thomas.lange 2006-01-13 09:26:48 UTC
*** Issue 59085 has been marked as a duplicate of this issue. ***
Comment 22 brendel 2006-01-13 10:40:17 UTC

I have been discussing this problem already in two other issues, which have now
been marked duplicates. 
So here I go again : I can only stress, as this has already been done in another
post, that for the scientific community this problem is of major importance :
when I suggest to a colleague using OOo, one of the first questions will be :
are the equations compatible ? 
It is also not an option to install the starsymbol font , as the whole point in
saving as word document is, that I can send this document to a person who does
not have installed OO, and does not know anything about StarOffice.
Actually the whole effort that has been made by OO programmers to make writing
equations in OO compatible with (or exportable to ) Microsoft equation is
rendered useless if the greek letter problem is not resolved.
I also find it still difficult to conceive how on the one hand greek letters in
the equations are dependent on one not available font and ont he other hand
inserting greek letters into the text using Insert/SpecialCharacter is no
problem at all and exports correctly to Word.
Could not be one option, that when exporting to .doc format, that the special
characters from the starsymbol font are replaced by the correct codes for th
symbol font, available on all systems that will open .doc with word ? 
Thanks for listening to my rambling

Comment 23 thomas.lange 2006-02-08 09:17:44 UTC
Also the problem itself is globally for all applications and not Math specific
it looks like a possible and planned global solution for this cannot be applied
to MS-Word documents.

Thus the way to solve the problem for Math seems to be to change the code points
from the private use area to ones existing in the Unicode specification upon
import/export to non-native file formats.
Comment 24 thomas.lange 2006-02-08 09:26:30 UTC
More specifically: this code-point conversion needs to be done when importing
from or exporting to MathType.

Need to ask about RTF though.
Comment 25 thomas.lange 2006-02-27 09:56:01 UTC
Comment 26 lars 2006-03-12 14:57:25 UTC
*** Issue 63072 has been marked as a duplicate of this issue. ***
Comment 27 michael.ruess 2006-03-13 11:26:29 UTC
*** Issue 63087 has been marked as a duplicate of this issue. ***
Comment 28 thomas.lange 2006-04-24 10:50:10 UTC
Setting target to OOo2.0.4 since there is not much time anymore and QA resources
are also quite limited due to the number of CWS's.
Comment 29 thomas.lange 2006-06-30 13:40:34 UTC
TL: Setting target to OOo 2.x since font issues are involved as well.
It is yet to be determined if changing the font for OOo 3.0 will take place or not.
If so that problem could be largely solved by introducing the required
characters at the correct unicode points.
Thus the level of the required code changes is not yet clear.
Comment 30 michael.ruess 2006-07-14 13:32:54 UTC
*** Issue 66888 has been marked as a duplicate of this issue. ***
Comment 31 michael.ruess 2006-07-24 13:23:59 UTC
*** Issue 67490 has been marked as a duplicate of this issue. ***
Comment 32 michael.ruess 2006-09-19 06:53:05 UTC
*** Issue 69643 has been marked as a duplicate of this issue. ***
Comment 33 michael.ruess 2006-09-19 06:54:43 UTC
Made summary more significant.
Comment 34 michael.ruess 2007-03-22 10:32:45 UTC
*** Issue 75456 has been marked as a duplicate of this issue. ***
Comment 35 brendel 2007-04-19 12:56:27 UTC
Do we really have to wait until OO3.0 before this issue is solved. Looking at
all the duplicates there are many people reporting this problem.
I have OO installed on a windows XP system on which MS Office never has been
installed. I can insert in the text any greek characters I want using the
available "Symbol" font. Why can this font not be used to insert the greek
letters into the equations ?
Comment 36 thomas.lange 2007-12-03 16:06:44 UTC
Seems to be related to problems like the ones in issue 50126 and issue 69108.
Since fixing those ones depends upon the decision for the font to use with OOo
3.0 this can't be solved properly before.
Setting target to OOo 3.x
Comment 37 michael.ruess 2008-01-08 10:01:25 UTC
*** Issue 85069 has been marked as a duplicate of this issue. ***
Comment 38 michael.ruess 2008-01-10 10:49:54 UTC
*** Issue 85129 has been marked as a duplicate of this issue. ***
Comment 39 ignatus 2009-11-18 15:29:21 UTC
I've written a duplicate of Math.xcu file (found in
your_oo_install_dir\Basis\share\registry\data\org\openoffice\Office\) where most
symbolic references are replaced on TimesNewRoman Unicode characters. It doesn't
solve the whole problem but improves performance. Edit was done manually and
with appended script.

Download from my site and replace your file if want:
Comment 40 ignatus 2009-11-20 14:23:24 UTC
Yess! All formulae in word documents now look well on my PC! [Tested on
WindowsVista on WordViewer2003, no other MS Office components installed].

There was a trouble in finding in Internet StarSymbol font. In fact, this font
is proscribed in standard Math.xcu file (see above) for most symbols, but while
display in OOo Math, they come out in OpenSymbol. So I decided just to install
copy of OpenSymbol font under name "StarSymbol". Renaming was done just by
filtering opens___.ttf file (C:\Windows\Fonts\) through a simple Perl script
containing re

    s/(O\W?p\W?e\W?n\W?)(?=S\W?y\W?m\W?b\W?o\W?l)/my $x=$1;$x=~tr*Open*Star*;$x/eg

(don't attemt to edit this file in Notepad which kills binaries!). Then the
result file was installed on the system in usual way; then, all the formulae
converted to Word before appeared in good symbols.
Ready-made pseudo-StarSymbol file here:
Comment 41 elfunesto 2010-04-12 15:54:48 UTC
Since this bug depends on issue 105084 which is now solved and will be
integrated in version 3.3, will the present issue will be solved too in OOo 3.3?