Quatro Pro

[smithcza]

I am trying to import a quottro pro file (WB1) into Excell. I noted that there are converters for Excell 2000 but I can not find one for 2000. Where can I find a converter for Excel 2003?

Thanks

Christiaan

SmithcZA

 

[fredericofonseca]

Not sure now if 2003 includes that converter, but if it does you NEED to do a custom setup and explicitly select that one to be installed, as they are not installed by default.

I will be able to check this later though.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[smithcza]

Will try that, thanks.

SmithcZA

 

[Maximizer]

Your using one of the BEST spreadsheets available!! Why go to Excel

Couldn't resist!!



James Keep, PMP
Crystal Reports(tm) Certified Consultant 8.5 (CRCC)
Authorized Crystal Engineer (ACE)
CMRC
Crystal Decisions Business Partner
Montreal, Qc, Canada

http://www.cmrc.qc.ca

 

[yalamo]

Agree with Maximizer. Much better than Excel. Unfortunately, he and I are the only ones that use it, and eyebrows will lift when I send a spreadsheet to a customer.

 

[fredericofonseca]

Nah. I also use it (Corel office 2000 and 12).

Its just that most companies don't use it unfortunately, so people need to adapt.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[xlbo]

I would be interested to know what you can do in Quattro Pro that you can't in Excel ???

 

[smithcza]

Hi guys. Didn't mean to start a fight (LOL)

I am stuck with Excell.

The company I work for is a big international company and they have standardised on Microsoft products recently, they would not allow me to buy Perfect office. Thanks anyway. I found a trial version of Perfect Office on the net and are downloading it, I will then try to convert the sheets with that (or even analyse them and manually re-produce them in Excell).

Regards,

Smith

SmithcZA

 

[xlbo]

no fightin' - just interested

 

[yalamo]

Quattro users, unite! You have nothing to lose but your @'s.

xlbo - I still have Quattro Pro 6 from 1994. It's got about 20 mathematical functions that Excel doesn't have. For instance @linterp, a linear interpolation function. You can get most of these functions as external add-ins for Excel, or write them yourself in visual basic, but then you can't send the spreadsheet to someone else, because he or she won't have those add-ins.

Speaking of visual basic, the macro language in quattro pro is much simpler, similar to the language in the original versions of Excel. It very easy to use and does about everything you need in a spreadsheet. Of course it's not object oriented, and doesn't have other buzzwords, but that's progress.

 

[AnotherHiggins]

Isn't the Quatro Pro a razor*?

*_{(flash warning)}

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[fredericofonseca]

xlbo,

not really going to go into what one has that the other hasn't. Quattro Pro HAS a lot Excel never had/will have, but the best way for you to see this is to download a trial and to try it out.

For this I advise you to use Virtual PC or similar product to have a OS you can just trash at the end of testing.


and speaking of macros

Corel WordPerfect Office X3 supports three scripting languages—PerfectScript™, Microsoft® Visual Basic® for Applications (Available in Professional version only) and ObjectPAL (Object Paradox Application Language available in the Professional and Student and Teacher Editions only).

PerfectScript is a macro system and scripting language, developed specifically for WordPerfect Office applications, to help users create macros, recordings and scripts.

ObjectPAL is a powerful, object-based, event-driven, visual programming language tightly integrated with Paradox®.

Microsoft Visual Basic for Applications lets developers build custom business solutions by automating and integrating off-the-shelf software applications to meet specific customer needs. Scripts and macros developed in either language from earlier versions of WordPerfect Office remain fully functional.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[xlbo]

hmmmmmm......any functions that are used a lot ?? sorry but I can't see @linterp being essential usage for many people. In terms of langauge, I cannot really say anything as I have not had exposure to earlier versions of excel but VBA is (to my mind) pretty easy to understand and has the advantage of being portable to just about every other MS App.

Does Quattro pro have the ability to execute SQL statements?
Does it have anything like Pivottables?
Can you do multiple criteria sums & counts?
can you write your own functions?
Can you have dynamic named ranges that expand and contract when data is entered / deleted ?
Can it do mail merges?
Can you create custom data entry forms?
Does it have any form of 'in cell' data validation

These are all features of excel that I use pretty much all the time and I would be interested to know if they exist in QP ??

 

[Maximizer]

First reply, YES, to all the above Questions from XLBO!

Like the previous posting from Frederico Fonseca, Quattro Pro has all plus MUCH MORE. The accounting functions are superb – unlike Excel where the formulas are flawed and misrepresent financial calculations.

Since my first purchase of Quattro Pro version #1 in 1990, there’s been no spreadsheet comparable to it.

My best example is Pivot Tables – QP and Monarch Pro can calculate large dimensions and members in SECONDS. With Excel, one receives memory errors or finite limitations to the M$ software. When I used to try a Pivot table in Excel 97, there was a two and half page implementation has to why it could not perform!!

Before someone tells me try the XP version, Today, the Excel Help is reduced it to a mere page!!!

When displayed An 'insufficient memory' message appears
--Check the memory use setting
--Simplify the report
--Base multiple reports for the same data on one
--Simplify the Create the report in a separate file

And this is 2006! Who has time to simplify their ‘Excel’ spreadsheet given the client's requirements?

James Keep, PMP
Crystal Reports(tm) Certified Consultant 8.5 (CRCC)
Authorized Crystal Engineer (ACE)
CMRC
Crystal Decisions Business Partner
Montreal, Qc, Canada

http://www.cmrc.qc.ca

 

[yalamo]

I really don't want to keep this up, but interpolation is a very useful function to have - I don't know how many people need it, but then, I don't know how many people need pivot tables. I don't.

The answer to most of your other questions is yes.

 

[xlbo]

calm down guys - I didn't mean to start a riot. I've just heard a lot of XL bashing and was interested to know whether it was perception or reality. I must've cross-posted with Frederico as his advice to download a trial copy is the best way for me to find out.

Personally though, I really don't think excel is that bad at all. A lot of what you guys call limitations, I call common sense. Big pivot-tables = Database application. Sorry - but why do I want 100k rows of data in a spreadsheet ??? Lack of functions ?? I'll build my own from code or nesting......

 

[Lilliabeth]

I ran across this the other day, maybe it will be in interest to people reading this thread.

http://en.wikipedia.org/wiki/Quattro_Pro