Chuck wrote:
"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".
From your examples, it seems that Pocket Excel, which does not support
"merge and center" also "cannot be safely used in a 'mixed' environment
with regular Excel", which should make Pocket Excel also, by your logic,
a show stopper for corporate acceptance.
It is *somewhat* dangerous to rely completely on *any* two spreadsheet
products exactly translating data and formatting from one to the other,
including different version of the same spreadsheet product, especially
if the spreadsheet uses macros.
The OOo2.0 Migration Guide available at
http://documentation.openoffice.org/manuals/index.html provides various
examples of incompatibilities and necessary workarounds between
OpenOffice.org and comparable products produced by Microsoft and others.
But I don't think "corporate" acceptance is an issue especially. The
same problems occurs for individuals. And the corporation I work for
uses both MS Excel and OOo Calc depending on department, with no
difficulties that I am aware of, because there is little or no passing
of *complex* spreadsheets back *and forth* between Excel and Calc.
You are quite right that the level of compatibility needed is an
important issue that corporations and departments within corporations
need to consider very carefully.
Jallan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
