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]
