LibreOffice

All Articles

LibreOffice

Problem with VBA compatibility in libre office calc

25 Aug 2019 by Patrice T

Hi all, I have an Excel WorkBook with VBA macros, There is no problem with it on Excel. As I try to open it on LO Calc, I got a lot of compatibility problems, I fixed them all but 1. I fixed problems like conditional compilation (#If ... #End If) incompatibility. I use Libre Office 6.1 Calc. I...

LibreOffice

VBA

Problem with VBA compatibility in libre office calc

24 Aug 2019 by OriginalGriff

At a guess, it's to do at least in part with what is being passed to that function, probably in Chaine - and we have no idea what that is. Since the problem occurs at run time, you need both the macro and the data it is associated with (the spreadsheet) working together to try and fix it - and...

LibreOffice

VBA

Problem with VBA compatibility in libre office calc

24 Aug 2019 by phil.o

There is a regular expression function in Libre Office: REGEX[^] This is for version 6.2, though; don't know if it is present in 6.1.

LibreOffice

VBA

Problem with VBA compatibility in libre office calc

25 Aug 2019 by Patrice T

Adding the type of first parameter solved the problem. Function Extract(Chaine As String, Optional Pos = 1, Optional Balise) The debugger did not helped much because it is an internal error. When Chaine is a Range, LO is unable to get the value of the cell to feed it as a string as parameter of...

LibreOffice

VBA

Alternatives to Microsoft excel for UFT automation

13 Jun 2023 by Padmapriya Elangovan

Hi, We have an automation framework developed with UFT long back and been in use to test a legacy windows application build on .Net. We use microsoft excel till now, and due to some of the constraints, we need to check for excel alternatives...

Excel-2016

LibreOffice

Apache

Alternatives to Microsoft excel for UFT automation

13 Jun 2023 by Dave Kreskowiak

Excel doesn't do the actual testing since that's not what Excel does. It can, however, be use as source data for the testing framework and storing of results. You're going to have to ask the vendor of the UFT framework you're using to see if...

Excel-2016

LibreOffice

Apache