Chuck wrote:
Dan Lewis wrote:
If it is a title that you want centered at the top, what is wrong with
using a header and centering the title in it?
Dan
I wanted it centered over two columns. Something like this.
+-------------------+
| Breakfast |
+--------+----------+
+Insulin | BG level +
+--------+----------+
| | |
+--------+----------+
| | |
"Merge and center" would seem to be the obvious choice, except for the
fact that I am syncing this spreadsheet with Pocket Excel which does not
support "merge and center". Instead it uses "center across selection"
which is *not* the same thing though visually they appear similar. CAS
is supported by the full version of Excel and is different from merging
cells. If I were to remove OOo from the mix and just used Excel,
everything would work perfectly.
What this thread is pointing out is that OOo 2.02 is not completely
compatible with Excel and cannot be safely used in a "mixed" environment
which IMO is a show stopper for corporate acceptance. The formatting of
a spreadsheet created in Excel will be silently changed by OOo 2.02 if
that spreadsheet uses "center across selection".
Firstly, one other possible solution to your problem is to use
indentation in a left justified cell. If the columns are fixed width and
the fonts are the same then it may be ok. Again, it may not be exactly
centred, but it may be close enough and hopefully compatible.
Secondly, are there any drop-in replacement applications for any MS
products that are so compatible that they can be used perfectly freely
in mixed environments? Are there any two applications from different
major vendors that are? Except for those that claim to use only standard
protocols or formats (and rarely even then), I can't think of any off
the top.
The documented cases of major corporate migrations suggests that
providing a more acceptable product (however a corporation chooses to
define that) with a sufficiently painless migration path is more
important than 100 percent compatibility.
Ross
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
