LO Calc loses range names and references

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

LKeithJordan 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 close merge delete