Variable names inside LET function are prefixed with _xlpm

callous · January 13, 2025, 3:59am

So this file was a .xlsx file before I changed it to .ods after migrating to Linux.

I tried using variables inside a Let function on a clean file. For some reason, this is the only file that keeps prefixing the variable names with _xlpm upon re-opening it. What could be the reason, and how can I resolve this?

mikekaganski · January 13, 2025, 5:47am

Open the file.
Delete everything from it.
Create a LET formula in it.
Save and reload.
Check if it still fails.
If it doesn’t, try to find out, deleting what heals it.
If it does, attach it here for inspection.

callous · January 13, 2025, 6:14am

I deleted all of the sheets in the file, but the problem still persists. Maybe there’s still a VBA macro but I don’t know how I can remove it. I don’t see anything in Tools > Macros > Organize Macros (Basic, BeanShell, Javascript, Python).

I saved it as .ods already

mikekaganski · January 13, 2025, 6:40am

Do you mean, that you missed the point 7 in my advice?

callous · January 13, 2025, 6:42am

I was only at point 6.

Is “a” a reserved word or some sort?

mikekaganski · January 13, 2025, 6:47am

A is the name of the first column.

callous · January 13, 2025, 6:57am

I just changed the variable from a to b and it doesn’t prefix the variable with _xlpm anymore. Probably a variable is being used somewhere is the file. Same with the data variable

mikekaganski · January 13, 2025, 11:15am

Unfortunately, you ignored the point 7, and thus this topic can’t help anyone, because we couldn’t analyze the problem, diagnose it, and maybe suggest other solutions or fix. We couldn’t even improve wording for this still-unknown problem, to help people find it.

callous · January 16, 2025, 4:11am

Probably there’s still fragments from Excel left. I just created another file and redo it.

mikekaganski · January 16, 2025, 4:32am

Sigh. You found a workaround, and solved your local problem. But you decided to not help us improve. If we had that file, we could try to fix Calc, so that it doesn’t create problems with “fragments from Excel left” - not being able to see the problem means others will continue to suffer.