Ask Your Question
0

Getting a program to use calc

asked 2019-04-13 20:51:34 +0100

BillsQ gravatar image

I use test equipment that stores information in MS Excel. Can I somehow get it to use Calc instead?

The program is UE Systems, DMS program. DMS is a SQL based program, that generates its reports to a spreadsheet.

I’ve contacted UE’s Chief Software/Tech Specialist and he is interested if I can resolve this, but has no knowledge of how to make it work.

Thank you for assistance, Bill

edit retag flag offensive close merge delete

Comments

Does your DMS program actually require that MS Excel be installed on the computer (and you want to change that to LO Calc) or does it simply generate its reports in .xls format?

ve3oat gravatar imageve3oat ( 2019-04-14 03:52:00 +0100 )edit

It appears to require it. If there’s thereks an option, I haven't found it. Currently I only have Calc installed.

BillsQ gravatar imageBillsQ ( 2019-04-15 02:30:52 +0100 )edit

This looks like an ancient program as the video shows it running on Windows XP. It's probably written in VBA or C# and directly calling Excel functions that are only available when Excel is installed on your computer. It also means that other than generating an Excel file on disk and then opening in Libre Office, you are out of luck. If the program is sucking data from the spreadsheet back into he database, you are guaranteed to be out of luck without a total rewrite targeting Libre Office.

"I’ve contacted UE’s Chief Software/Tech Specialist and he is interested if I can resolve this, but has no knowledge of how to make it work." Not a good sign!

celilo gravatar imagecelilo ( 2019-04-15 08:14:58 +0100 )edit

2 Answers

Sort by » oldest newest most voted
1

answered 2019-04-14 05:27:57 +0100

Ratslinger gravatar image

Hello,

Took a quick look at the Create a Report in Excel found here :

http://www.uesystems.com/training/onl...

Now, according to what I have seen, and don't really know what database is actually being used, you can output data in .csv format (comma separated) which is easily input into Calc.

Also, and may be incorrect here, it is basically selected data which is exported to Excel or a .csv file. The selected data is determined so as to constitute a report.

Your question is not going to generate much response as this is a specialized situation - using probes and ultrasound equipment. It is also difficult for any non-user to get their hands on the software or specific data for testing. Fortunately there is some info in the on-line videos.

edit flag offensive delete link more

Comments

Agree; Probably 3 options: - Export the file via the wizard - Try changing your file associations in windows, as I mentioned below - Pay the software vendor to modify their code to open in Libre Office.

celilo gravatar imagecelilo ( 2019-04-14 08:22:57 +0100 )edit

I will try the suggestions. If anyone is interested, the DMS program is a free download and comes with a sample test route. http://www.uesystems.com/products/sof... You do have to create an account, but that is simple.

BillsQ gravatar imageBillsQ ( 2019-04-15 00:38:30 +0100 )edit

Thanks for the info but it appears this is for Windows and I only use Linux now.

Ratslinger gravatar imageRatslinger ( 2019-04-15 03:02:46 +0100 )edit
0

answered 2019-04-14 03:19:07 +0100

celilo gravatar image

Open calc. File open spreadsheet.

To automatically have the excel file open in calc, you need to set the files association for .XLS to use Calc. You can probably right click on the file and select open with and choose always use this program for this file.

The exact method depends on your windows version. My wording is not precise because I use Linux these days and am not in a windows environment to see the exact process.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-04-13 20:51:34 +0100

Seen: 71 times

Last updated: Apr 14