Looks really promising, "NoOp" -- don't have time to try it out right now,
but I'll let you know what happens when I do.
Lindsay Graham
--------------------------------------------------
From: "NoOp" <[EMAIL PROTECTED]>
Sent: Saturday, April 05, 2008 4:29 AM
To: <[email protected]>
Subject: [users] Re: FORMAT PROBLEMS BETWEEN OOo AND MS OFFICE
On 04/04/2008 01:54 AM, Lindsay Graham wrote:
I have been trying out OOo for some months and am persevering with
it, although I have several issues which prevent me from switching
over completely.
But I have one thing that's bugging me, and I hope someone can help.
I'm using OOo 2.3 and Microsoft Office 2000. I need to switch
frequently between the 2 programs when using both Writer/Word and
Calc/Excel. Files that have been formatted in OOo (eg, highlighting
text in Writer, highlighting cells in Calc or applying special date
formats to cells in Calc) cannot be formatted differently in Word or
Excel.
You might find this helpful:
<http://wiki.services.openoffice.org/wiki/Documentation/OOoAuthors_User_Manual/Migration_Guide>
<http://wiki.services.openoffice.org/wiki/Documentation/OOoAuthors_User_Manual/Migration_Guide/Writer_and_Word>
<http://wiki.services.openoffice.org/wiki/Documentation/OOoAuthors_User_Manual/Migration_Guide/Calc_and_Excel>
For example, text highlighting applied in Writer cannot be removed in
Word -- I have to retype it!
In Word:
- Select the highlighted text, then:
Format|Borders and Shading|Shading tab|Fill - None
Similarly, cell highlighting applied in
Calc cannot be removed in Excel.
Works for me using the Highlight button in Excel. But if the button
doesn't work, then: Format|Cells|Patterns tab|Color -No Color.
And new rows inserted in an Excel
file take on the format (eg, a custom date format) applied in Calc to
adjacent cells and that format cannot be modified in Excel by using
Format > Cell or the Format Painter.
From the referenced doc above:
Default number format
Calc and Excel use different default number formats.
* With Excel, the cells are set to the “General” category number
format., so if you entered 25.12345 in a cell it would display “25.12345”.
* In Calc a default formatted cell is set to the “Number” category in
the “General” format. Thus, if 25.12345 is entered, 25.12 will be
displayed.
Perhaps you need to adjust the defaults first?
Can anyone suggest an reason or, better still, a solution?
Lindsay Graham Canberra, Australia
--------------------------------------------- Please reply only to
the list so that all may benefit.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
