Quality Center Cal Add-in Like For Excel

Discuss the spreadsheet application

Quality Center Add-in for Calc like Excel

Postby johnscarpino » Wed May 01, 2013 1:36 am

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/applications/qualitycenter/qc100/msoffice/msexcel/index.html

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

Thank you.
John Scarpino, D.Sc.
John Scarpino, D.Sc.
OpenOffice 3.4.1
johnscarpino
 
Posts: 4
Joined: Wed May 01, 2013 1:27 am

Quality Center Cal Add-in Like For Excel

Postby johnscarpino » Wed May 01, 2013 1:42 am

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.
John Scarpino, D.Sc.
OpenOffice 3.4.1
johnscarpino
 
Posts: 4
Joined: Wed May 01, 2013 1:27 am

Re: Quality Center Cal Add-in Like For Excel

Postby acknak » Wed May 01, 2013 4:33 am

I've merged your two posts into one topic; you can delete one or the other if you like.
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Quality Center Cal Add-in Like For Excel

Postby FJCC » Wed May 01, 2013 4:49 am

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.
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7744
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Quality Center Cal Add-in Like For Excel

Postby johnscarpino » Tue Jun 25, 2013 6:10 am

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/
Attachments
Calc_Addin.zip
(28.85 KiB) Downloaded 154 times
Last edited by acknak on Tue Jun 25, 2013 6:15 am, edited 1 time in total.
Reason: removed live links
John Scarpino, D.Sc.
OpenOffice 3.4.1
johnscarpino
 
Posts: 4
Joined: Wed May 01, 2013 1:27 am

Re: Quality Center Cal Add-in Like For Excel

Postby acknak » Tue Jun 25, 2013 6:16 am

No live links, please (forum policy).
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Quality Center Cal Add-in Like For Excel

Postby Villeroy » Tue Jun 25, 2013 9:40 am

johnscarpino wrote:... OpenOffice Cal is free ...

... and your Visual Basic is not.
Apart from that, your .zip is password protected.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28537
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Quality Center Cal Add-in Like For Excel

Postby motuetu » Tue Jun 25, 2013 12:14 pm

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.
OpenOffice 3.0 on Windows 7
motuetu
 
Posts: 2
Joined: Tue Jun 25, 2013 11:32 am

Re: Quality Center Cal Add-in Like For Excel

Postby Villeroy » Tue Jun 25, 2013 1:31 pm

How can I run this on a free system?
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28537
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Quality Center Cal Add-in Like For Excel

Postby Villeroy » Tue Jun 25, 2013 1:48 pm

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?
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28537
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Quality Center Cal Add-in Like For Excel

Postby johnscarpino » Tue Jun 25, 2013 2:35 pm

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.
John Scarpino, D.Sc.
OpenOffice 3.4.1
johnscarpino
 
Posts: 4
Joined: Wed May 01, 2013 1:27 am

Re: Quality Center Cal Add-in Like For Excel

Postby eremmel » Wed Jun 26, 2013 12:16 am

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?
It's Microsoft marketing that tells you computers are qualified for non-technicians
eremmel
 
Posts: 1041
Joined: Tue Dec 30, 2008 1:15 am

Re: Quality Center Cal Add-in Like For Excel

Postby keme » Wed Jun 26, 2013 11:16 am

Villeroy wrote: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 wrote: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 wrote:[ ... ]
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.
Apache OO 3.4.1/4.1.2/4.1.3, on Ms Windows 7/10 and Mac OS-X 10.8.5 and 10.11.
LibreOffice 4.3.3.2 on Mepis Antix MX 14
User avatar
keme
Volunteer
 
Posts: 3367
Joined: Wed Nov 28, 2007 10:27 am
Location: Egersund, Norway


Return to Calc

Who is online

Users browsing this forum: No registered users and 9 guests