Philip Walsh wrote:
I am using version 2.4 of OpenOffice.org. My problem is when using Calc
it will not open QuatroPro files. I spent 8 hours searching your guides
and blogs with no finds on QPW.
All atempts to add a new extensions lead to a dead end.
******************
I'm facing a similar problem. I still use QPW but I'm working on a
conversion procedure. It's not ready for "prime-time" but I've had
reasonable success on one fairly complicated file, and I'm next going to
try it on another one to see if I've covered most of the issues.
I assume you've already tried saving it in QPW as an Excel file (*.xls)
and importing that into Calc. My spreadsheet was fairly complicated and
Calc didn't like it.
My approach involves a multi-step process involving a Quattro macro,
several NoteTab Pro macros (Clips as they are known in that program),
and one in OOo Calc.
1. My QPW macro disguises all functions as text before exporting as an
Excel v5/v7 xls file, which Calc has no problem with.
2. In Calc I then save the xls file as html which can be edited in
NoteTabPro -- a powerful, inexpensive text editor you may be familiar with.
3. Using NoteTabPro I then run two "Clips." The first cleans up a lot
of garbage inserted in the process of disguising the QuattroPro
functions as text, converts from QPW functions to Calc functions, and
re-saves, on a Page-by-page basis, in html form. The second launches
Calc, and "types" commands into Calc causing it to import the individual
page files in the proper order.
4. A Calc macro then restores original page names.
5. Finally one global find and replace Calc operation undisguises the
functions.
If you're interested in the details let me know.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
