Excel as a data source - editing in Open Office Calc
Posted: 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
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