Link to home
Start Free TrialLog in
Avatar of Glen Gibb
Glen GibbFlag for Canada

asked on

LibreOffice macro error -- #Value

Experts,

I'm trying to create macros to handle a number of spreadsheet routines in LibreOffice Calc.

The output of every single function has suddenly become #VALUE in the spreadsheet.

And as a corollary, the numeric output when they did work had four decimal places -- no amount of formatting would convert them to currency.

Can you help?

Capt Alberta
ASKER CERTIFIED SOLUTION
Avatar of ltlbearand3
ltlbearand3
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Glen Gibb

ASKER

Thanks for getting back to me, Bear.

I'll post the resolution for anyone who runs into the same issue.  I surely did do a lot of fruitless searching, so I hope someone can profit from my experience.

The issue was to search Google for "StarBasic," which took me awhile to figure out.

The search will lead you to a number of good sites.  The following link was most useful:   OOMacros

The gist of my errors was the Error Handling in StarBasic:  I am used to the VBA syntax (Err.Number, Err.Source, Err.Description, etc.)  StarBasic returns the errorNumber in "Err", the error message in Error$ and the line number in Erl.  

Once I replaced the offending code, everything smoothed out.

I'm awarding you the points.   Tnx.
Happy New Year!
Oh, and the strange number formatting is what StarBasic does with currency:  $2.00 looks like this -- 2.0000.    To handle the number formatting, I changed the currency datatype to "single."

Cheers,

Capt