Quality Center Cal Add-in Like For Excel

[johnscarpino]

Hello,

Attached is a link to a Excel Add-in for Quality Center Guide, Readme and download. How can I get this to work with Calc?
ftp://us-ffs.external.hp.com/applicatio ... index.html

I tried several ways but was not able to get it as an Calc Add-in?

Thank you.
John Scarpino, D.Sc.

[johnscarpino]

Hello,

How can I get Cal add-in to work like Excel? I have tried multiple different ways with no luck. Below is the link for the Add-in Guide, Readme and download.

ftp://us-ffs.external.hp.com/applicatio ... index.html

Thank you.
John Scarpino, D.Sc.

[acknak]

I've merged your two posts into one topic; you can delete one or the other if you like.

[FJCC]

An Excel add-in will not work with Calc. Excel and Calc are entirely different in their programming, though their appearance is similar. I guess you could ask HP to write a Calc version, but I wouldn't hold my breath waiting for it.

[johnscarpino]

Try this out...

Quality Center Open Calc Add-in

After several attempts to create a solution for using OpenOffice.org’s Calc with Quality Center, the attached .zip file contains three .vbs scripts to connect Cal Open Office with Quality Center Requirements, Test Plan, and Test Steps. The Batch.ods file is a spreadsheet file format used by OpenOffice/StarOffice to help make this connection possible.

So, why use this OpenOffice Calc add-in with Quality Center? The answer is simple: unlike the current add-in for Excel (which requires you to have a license for Excel to be used with QualityCenter), OpenOffice Cal is free.

We are interested to learn your feedback about this add-in.

John Scarpino, D.Sc.www.johnscarpino.com | www.softwarequalityanalyst.com
and
Massimo www.motu4qc.it/

[acknak]

No live links, please (forum policy).

[Villeroy]

... OpenOffice Cal is free ...

... and your Visual Basic is not.
Apart from that, your .zip is password protected.

[motuetu]

Hi,

the password is "CalcAddin"

the .vbs must be save under c:\temp folder. If you'd like to save them under other path you need to change the relative Constants inside the Basic code.

You can find how it works inside the Basic Code but If you need more information please don't hesitate to contact us.

Best Regards,
Massimo & John.

[Villeroy]

How can I run this on a free system?

[Villeroy]

And how is that code related to OpenOffice, Calc or any kind of spreadsheets?
What is TDApiOle80 and how about the database connection it tries to establish?
Why does johnscarpino.com look like the web-site of some phony idiot?

[johnscarpino]

Villeroy - please keep your judgments out of this forum unless it relates to the actual fix. We are trying to resolve and assist the testing community with using Cal instead of Excel.

[eremmel]

So, why use this OpenOffice Calc add-in with Quality Center? The answer is simple: unlike the current add-in for Excel (which requires you to have a license for Excel to be used with QualityCenter), OpenOffice Cal is free.

What is the price ratio between "Quality Center" and an excel license?
Are there not any legal issues involved in 'porting' an plugin from HP?

[keme]

And how is that code related to OpenOffice, Calc or any kind of spreadsheets?
What is TDApiOle80 and how about the database connection it tries to establish?
Why does johnscarpino.com look like the web-site of some phony idiot?

Villeroy - please keep your judgments out of this forum unless it relates to the actual fix. We are trying to resolve and assist the testing community with using Cal instead of Excel.

[ ... ]
What is the price ratio between "Quality Center" and an excel license?
Are there not any legal issues involved in 'porting' an plugin from HP?

Mr. Scarpino:

• You have posted a question which represents a complex problem. The solution would involve converting from the Microsoft Office API to the OpenOffice.org API. To do this, a knowledge of both APIs is required. This looks to be a fairly big task, with considerable know-how required.
• Furthermore, you have a HP supplied file which looks to be something that plugs into the Excel API directly. Interfacing that to Calc is probably not feasible. The documentation for that file states "Confidential computer software" and indicates that posession, use or copying is not allowed without a valid license from HP.
• Also, you expect your VBS files, documented in Italian, to be read and interpreted by the helpers in an English speaking forum.

You are asking the forum for help on a full project, with components labeled as "Confidential computer software" and no licensing info provided, no info about how your particular application is supposed to relate to HP Quality Center, and little info about what you have tried to do and the outcome of that. You should not be surprised that this ticks off some of the helpers here.

If you really want help, there are a few possible approaches that may bring you better results (or at least a more positive feedback):

• Ask HP to provide support for open solutions. Perhaps you already did that...
• Ask in the forum what you already have asked above. Your above postings ask for more than simple advice, so post in the "Paid support" section.
  Also, make sure that you have valid license for anyone you hire to do the job. (You may need a special developer license. Check the conditions in your current license document.)
• Make yourself familiar with the OOo API, and start hacking. Ask for specific help whenever you run into obstacles.