Hello Ventuzians!
THE FORUMS ARE CLOSED!

Please join our discord server HERE!! << click me :D

We are shutting our Ventuz Forum, but don't worry, it will all be archived for you to search in if you have a query. From now on, please add all your comments, questions or observations into our Discord Server

Thanks for the great time - see you on discord!!
Dee, Karol, Daniel and the whoooole Product and Support team!

Excel as a data source - editing in Open Office Calc

All other topics about Ventuz 5 here.

Moderator: Support

Post Reply
User avatar
craig
Posts: 34
Joined: 18 Jan 2012, 11:42
Location: Wales, UK
Contact:

Excel as a data source - editing in Open Office Calc

Post by craig » 08 Aug 2017, 20:39

Hi Ventuz community. We use Excel as a data source to the Excel workbook node for a lot of settings in our projects - pretty typical usage. I've noticed a behaviour that I don't understand. When I open an Excel workbook using Microsoft Excel and edit a cell that is bound into a Ventuz node and save the workbook, the change reflects instantly in Ventuz. This is great, and makes managing configuration really easy.

But - I can open the same workbook in Open Office/Libre Office Calc, edit the same cell and save the workbook - but Ventuz does not see the change. Closing the workbook doesn't cause Ventuz to change either. I have to restart the scene.

I'd like to try and understand why - I'm sure the Ventuz programmers must have an insight? If it's possible to recreate the same behaviour in Open Office Calc, I could completely eliminate the need for Excel or Microsoft Office licences completely within my business - saving me a significant amount of money each year!

It'd be great to hear from the Ventuz team on this one - even if it's just to help understand how and why this behaviour works.

Craig
Craig Hann
Kinetic Pixel

http://www.kineticpixel.tv

User avatar
Karol
Posts: 640
Joined: 10 Jan 2012, 12:07

Re: Excel as a data source - editing in Open Office Calc

Post by Karol » 09 Aug 2017, 09:24

Hi Craig!

We do not use any MS Office specific functionality to get informed about the file update.
We only rely on the notifications of the NTFS file system. It's the same for all resource loader nodes with the Auto-Update flag.
I guess that Open Office has a special way of serialization which does not trigger the events on which Ventuz is listening.

Best Regards
Karol

User avatar
craig
Posts: 34
Joined: 18 Jan 2012, 11:42
Location: Wales, UK
Contact:

Re: Excel as a data source - editing in Open Office Calc

Post by craig » 09 Aug 2017, 09:57

Hey Karol, thanks for the quick reply!

That's good to know - I couldn't understand why editing files in Open Office caused different behaviour, but that makes sense. At least now I know where my investigation leads me next. If I find something in the Open Office/Libre Office Calc configuration that forces Calc to emulate Excel more closely when it serialises to file, I'll report back on this thread.

Thanks for your help.
Craig
Craig Hann
Kinetic Pixel

http://www.kineticpixel.tv

Olivier
Posts: 23
Joined: 19 Jun 2012, 13:28

Re: Excel as a data source - editing in Open Office Calc

Post by Olivier » 11 Sep 2017, 11:02

Hi there,

I had some issue using .xlsx files saved via open office... It did not worked in Ventuz, I had to re-open the file with Microsoft Excell and resave it... And Tadam! ;)

Post Reply