On Tuesday April 18 2006 01:38 pm, Karl Monroe wrote:
> I have a number of files and Quattro Pro 12 that I would like to try to
> convert to OpenOffice Calc. The only process that kind of work so far
> is:
>
> open the file and Quattro Pro 12
> save the file has a Microsoft Excel 97/2000/2002/2003 file
> open the file in Microsoft Excel
> close the file in Microsoft Excel
> now the file will open in OpenOffice Calc
>
> any suggestions with fewer steps would be appreciated.
An observation first. It seems that Quattro Pro 12 has the same
problem of trying to figure out Excel's formatting as OOo does. Neither
one have been able to get it exactly right. That is why opening the file
in Excel and then closing it allows OOo Calc to open it. Excel make some
minor adjustments.
In this case, perhaps using another file format other than Excel might
work better. *.cvs for example. At least I think the CVS format is rather
well known which would make the conversion probably more accurate. Macros
(if any) and cell formulas would have to be rewritten anyway. Just a
thought.
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
