LO Calc loses range names and references [closed]

asked 2016-04-16 21:44:57 +0200

LKeithJordan gravatar image

updated 2020-08-02 14:15:01 +0200

Alex Kemp gravatar image

I've run into a couple of problems with LO Calc and range names. I hope someone here can help.

BACKGROUND
I'm running LO Calc Version: 5.1.2.2 on a Windows 7 machine. I have an Excel workbook with a VBA macro I wrote using Excel-specific code. Range names are assigned to certain "parameter" cells to ensure the code responds if these specific cells are moved (for instance, if someone inserts or deletes a row or column surrounding the parameter cells). The Excel workbook has an xlsm file extension.

I am NOT running JRE in LO. I am trying to see if the VBA code will execute (with modifications if necessary) in LO Basic. (I'm still a bit new to LO -- would this be Basic2VBA?)

FIRST PROBLEM
I have determined that merely opening the Excel workbook in LO Calc results in all range names and references being removed.

SECOND PROBLEM
Once I add the missing range names and references, I can get LO to execute the code -- except that it results in a series of Err:508 cells. I have isolated the error to a particular range name reference in the code.

If I replace the range name reference (literally overwriting the reference with the same reference) in the range name manager, the errors are replaced by the amounts that should be there -- except I can tell that this is somehow outside the macro since the rounding adjustment automated in the macro does not occur.

If I run the code again, the errors reappear -- for the same reason and with the same fix.

I hope I have made sense. Anyone have any ideas?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-02 14:15:22.793044