Issue 4387 - Bullets exported to Word displayed as incorrect symbols in word.
Summary: Bullets exported to Word displayed as incorrect symbols in word.
Status: CLOSED DUPLICATE of issue 2192
Alias: None
Product: Writer
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.0
Hardware: PC Linux, all
: P2 Trivial (vote)
Target Milestone: ---
Assignee: caolanm
QA Contact: issues@sw
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2002-05-02 20:22 UTC by Unknown
Modified: 2003-09-08 16:56 UTC (History)
2 users (show)

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


Attachments
Original BulletTest.sxw document, created in OOo 1.0.0 (5.54 KB, application/octet-stream)
2002-05-02 20:23 UTC, Unknown
no flags Details
BulletTest.doc, exported from OOo 1.0.0 to Word 97/2000/XP format (9.00 KB, application/octet-stream)
2002-05-02 20:25 UTC, Unknown
no flags Details
Screen shot of BulletTest.doc from Win98SE/Word 2000 (9.0.2720) showing bullets as "Outline Numbered" instead of "Bulleted" (21.81 KB, image/png)
2002-05-02 20:28 UTC, Unknown
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Unknown 2002-05-02 20:22:04 UTC
This problem has been reported for previous builds, and persists in OOo 1.0.0.

My Linux environment:
Linux/x86 2.4.17
RedHat 7.1 + Ximian Gnome
XFree86 4.0.3
OpenOffice.org 1.0.0

My Windows environment:
Windows 98 SE
Microsoft Office 2000
Microsoft Word 2000 - 9.0.2720

Install Procedure:
1) All previous versions of OOo and SO were completely removed, including
settings/preferences
2) OOo 1.0.0 was installed by root with "setup /net"
3) OOo 1.0.0 was installed by user with "/path/to/OOo/setup"
4) All components were selected for install
5) Java was not configured (I use the IBM JRE)

Procedure to reproduce:
1) Start Writer or select "File->New->Text Document" from the OOo menu
2) Type a line of text and press Enter
3) Click the "Bullets On/Off" toolbar button
4) Type a few short lines of bulleted info, pressing Enter after each
5) Click the "Bullets On/Off" toolbar button
6) Type a line of text and press Enter
7) Select "File->Save As..." from the OOo menu
8) Enter a name in the "File name" field
9) Select "Microsoft Word 97/2000/XP" and click "Save"
10) Open document in Word 2000 running on Win98SE
11) Note that "lottery balls" (bullets containing the number 10) have replaced
the standard bullets
12) Highlight the bulleted lines, right click, and select "Bullets and Numbering"
13) Note that what should be "Bulleted" is now a custom variant of "Outline
Numbered" (screenshot attached)

This is a major issue for me, as my resume contains bulleted lists, and I have
to reboot into Windows/Word to correct them before emailing it to prospective
employers. This is rather a pain, as I do everything else in Linux. I seem to
remember this working correctly in SO 5.2.

Please feel free to contact me if there's any additional information I can
supply. I'll be attaching the original .sxw file, the exported .doc file, and a
screenshot showing the results in Word 2000.

Thanks!
Comment 1 Unknown 2002-05-02 20:23:38 UTC
Created attachment 1523 [details]
Original BulletTest.sxw document, created in OOo 1.0.0
Comment 2 Unknown 2002-05-02 20:25:10 UTC
Created attachment 1524 [details]
BulletTest.doc, exported from OOo 1.0.0 to Word 97/2000/XP format
Comment 3 Unknown 2002-05-02 20:28:21 UTC
Created attachment 1525 [details]
Screen shot of BulletTest.doc from Win98SE/Word 2000 (9.0.2720) showing bullets as "Outline Numbered" instead of "Bulleted"
Comment 4 Joost Andrae 2002-05-03 14:35:46 UTC
JA->MRU: reassigned to you...
Comment 5 michael.ruess 2002-05-07 14:36:02 UTC
Hi Caolan,
didn't you work on a similar problem a few days ago? 
I could't find the double Issue/Bug? Do you remember what went on?
Comment 6 caolanm 2002-05-10 12:16:48 UTC
I guess that the problem here is something along the lines that the
starsymbol font is missing on the windows machine and that a
substitute has been found by word that has different symbols :-(. (The
starsymbol font is difficult, private code points cause nothing but
trouble)

cmc->cbell: Please can you check to see if that is the case. In word 
open your example document and go to...
tools->options->compatability-> and click Font substitution

Does it say "no font substitution is necessary" or does it say that
some other font has been substituted for starsymbol ?

If I'm right then, then what you should be able to do as a user to
work around this problem is in writer for the numbered paragaphs use
numbering/bullets and go to options and there select character and
change the font away from starsymbol to a font that will exist on any
windows machine, i.e. symbol. That should avoid the problem. 

If this is the problem then the correct long term solution for us is
to accept that other machines will not have starsymbol installed and
to try and bundle starsymbol in the exported word documents i.e.
implement cunning idea in issue 2192. Or to try and convert the
starsymbol characters to symbol/wingdings characters. Of course your
document works fine for me (and probably the testers) because everyone
has word installed on machines that also have writer installed, so
we've all got starsymbol installed :-(
Comment 7 caolanm 2002-05-10 12:21:35 UTC
For what its worth the bulleting being exported as outline numbering
is meant to happen, in writer you will see that that pbullet style has
10 levels and each level has more indent that the last level, so it
has to be exported as an outline numbered list to export the
differences between levels.
Comment 8 caolanm 2002-05-10 12:26:12 UTC
retitled
Comment 9 caolanm 2002-05-13 15:50:14 UTC
I'll assume that my analysis is correct pending any new evidence to
invalidate that view, and so contend that for a full solution we need
to be able to make our exported word documents contain the starsymbol
font to allow word to find a font which has the correct symbols at the
unicode private code points that starsymbol (ab)uses.

*** This issue has been marked as a duplicate of 2192 ***
Comment 10 Unknown 2002-05-13 17:45:22 UTC
I checked Tools->Options->Compatability->Font substitution 
and "WingDings" is being substituted for "StarSymbol". I looked 
in /OOo_install_dir/share/fonts/truetype, and the only font is 
opens___.ttf, aka "OpenSymbol", which seems not to have the required 
glyphs.

Is StarSymbol just hidden somewhere, or is it built into the binary 
or something?

I'll try your suggested workaround and let you know.

Thanks!
Comment 11 Unknown 2002-05-13 18:16:08 UTC
The workaround seems to work, however it seems like the bullet font
selection needs to be done for each bulleted list. I can change it for
one list, and the next bulleted list created reverts to the original
font. I've also played with font substitution on the OOo side, but it
doesn't seem to make any difference.

Is there an easier way to do this, or could it be scripted somehow?

Thanks!
Comment 12 javajeff 2002-05-14 00:01:11 UTC
I have the same problem.
Comment 13 caolanm 2002-05-14 09:22:42 UTC
Its just a bad habit of mine to call it StarSymbol, its OpenSymbol
when the application is OOo. 

Sadly the problem with font substitution is that it only makes sense
when there is a substitute font with the same glyph in the same
location. This is the case for fonts that have a true encoding. But
the OpenSymbol font, while a unicode font, makes use of private area
glyphs, i.e. locations which are up to the whims of any given font to
contain random glyphs, or normally none at all. So there is no font
which can be substituted for OpenSymbol correctly when the private
area characters are used. The issue this is duped with might resolve this.

Anyhow, for the workaround to be more pleasant to live with, try
creating a numbering style and do the manual change to symbol
workaround for each list level in it, and use that style from then
onwards. i.e. F11, click the fifth icon that look like number. Right
click a style, e.g. numbering 1 and either create a new style based on
that, or change it. Apply the starsymbol->symbol changes. (note that
what should happen on importing an word document that has lists, is
that a pile of WW list styles are created, the bulleted varients of
which should all be viewable correctly when reexported to word, as
they will have their fonts set to a commonly available windows font,
it can be possible for the reverse problem to exist under linux if
wingdings is not available for example)

Leave the handy stylelist open, when you want numbering to be added to
a paragraph, put the cursor in the paragraph and double click in the
stylelist on your new list style. 

You can fiddle with templates and so on to make the new or modified
styles part of your default template, but that's well outside the
scope of this bug.
Comment 14 javajeff 2002-05-15 23:45:50 UTC
I have experimented with styles and various fonts in bullet options,
but I still have the problem with it transforming into outline
numbering in Word.  Furthermore, there is no indent in Word where the
bullet is against the first letter.  If the line manages to wrap, the
second line has text that goes under the bullet rather than flush with
an indent.  The Word filter did a good job with columns and tables,
but bullets are another story.
Comment 15 caolanm 2002-05-16 10:13:46 UTC
1) Please, there is nothing inherently wrong with lists being exported
as outline numbering, read back through the bug for my previous
comment on that.

2) There *are* differences in the indentation which are the bane of my
life, especially first line indent models between word and writer.
Generally a one line list should import reasonably well, and export
not so great. There are a number of different sub issues with the list
model, i.e. 

2.1 word seperates numbering from text generally with a tab this is
addressed in issue 3232, and is suprisingly complicated. We do it with
width and spacing attributes, word does it with a great big ugly tab
character and tab atributes attached to the paragraph that is being
indented, very tricky to map them together, for import I need to be
able to have fields contain tabs at the end. Read issue 3232 for all
the fun details.

2.2 There is also as you have discovered a fundamental different of
opinion as to what properties and layout options exist for controlling
what happens when the paragraph properties flow over onto a second
line. The good news is that it's not too common to run into the snag,
the bad news is that some thought needs to go into what should happen.

There is a bit of a mess in word with lists and tabs and indentation
which makes them an ungodly affair to import/export.

But these are independant problems from each other, and not related to
this bulleting issue. Do feel free to discuss these more general
issues in the users@sw or dev@sw mailing lists. Or to submit seperate
issues for seperate parts of the list puzzle that you run into. For
instance some comprehensive word test documents that demonstrate all
possibilites of combinations of list indent vs para indent, with
positive and negative hanging indent and different tab stops would
help flush out the right thing to do for 2.2

For this issue, does changing the font for the bullets and numbering
in writer to wingdings/symbol mean that the bullet itself looks
correct when viewed in word ?
Comment 16 Unknown 2002-05-16 19:13:25 UTC
I'm going to look into the comments here and see if I can get it
working. Just some things I noticed.

When composing on linux and exporting to Word, then opening with word,
the bullets appear as a number 10 in a black circle, which would be
explained by the list level thing. 

When I composed on OO for windows (using 2000), I noticed that the
bullet displayed immediately as the 10, before I even exported it. 

I'll give the font substitution a try.
Comment 17 Unknown 2002-05-16 19:40:36 UTC
The workaround seems to work....however a more permanent solution is
better.....even if it was just allowing the change in the font used
for bullets to be saved in a configuration file.

I don't particularly like solution to adding a new numbering style
that has the bullets...it seems a little complicated to have to run
for any number of users that will need this change.

Thanks for the workaround though.
Comment 18 caolanm 2002-06-14 11:49:43 UTC
Splitting from font embedding proposal.
Comment 19 caolanm 2002-06-14 11:53:06 UTC
Going to solve this without using font embedding.

*** This issue has been marked as a duplicate of 3839 ***
Comment 20 caolanm 2002-07-15 18:13:19 UTC
Closing, works in SRX643 for me. Track issue 3839 for QA