only #NAME? - Githubissues

brjhaverkamp / Domoticz2HomeAssistant

Migrate data from Domoticz to Home Assistant

0 stars 0 forks source link

only #NAME? #1

Open Pietercorts opened 2 months ago

Pietercorts commented 2 months ago

Hello I'm trying to get temp data from Domoticz into HASS, and found your program.

However even without my data and only data in the ODS file the 3 result sheets only show #NAME? in every cell. What am I doing wrong? I tried F9 to run a Macro but there are none in the downloaded file.

Thanks for you effort

Pieter

brjhaverkamp commented 2 months ago

Hi Pieter,

Nice to hear you are trying to use the file. I hope it will be helpful, after we cross this hurdle. I just re-downloaded the file, and here all tabs contain data, no #NAME?. So let's check what the difference is between your and my setup.

What do you open it with? I use Libreoffice 24.2 at the moment.
And did you enable macros? That last is just a hunch, I didn't verify.

Regards, Bert

Pietercorts commented 2 months ago

Hi Bert, I'm using LibreOffice 24.8.03

as for macros, I've set the security to low (i.e allow all macros) I have not found a actual "enable" setting, for macros. in LibreOffice

when I open the Macros dialogue I don't see any macros under you document, just the folder Standard but it's empty. see attache pdf LibreO_Marcos.pdf

What am I missing... my previous macro experience was with Office Excel almost 10 years ago...

brjhaverkamp commented 2 months ago

Hi Pieter,

Can you share the file with me? (I know it should be the same as on here in github..) my private mail is bert at bertenselena dot net Because I am at a loss. The fact that you don't see a macro is correct. I remember now I was able to work around it.. But there are array formulas. Is it a matter of auto-calculate maybe? (Long shot, I admit)