Hi, I use password when I export my theme. I want to know if it is possible to put Spreadsheets on specific folder to give possibilty to user to edit the .csv with ATVO exported with mp ?
You can use the External Filepath property of the spreadsheet (or any other content file). The theme will look for a spreadsheet in that location first and will use it if it exists. If it does not exist, it will use the spreadsheet embedded in the theme. I believe this path must be a full (absolute) path, not relative to the theme.
Hi Nick, I want to use spreadsheet for variable text to put and edit for external commentator or specialist. My idea is to let to user to edit a spreadsheet with: name,fonction for each row.
First I think I can easily link that to a dropdown to select row number 1 and show each column in labels. But I don't know how use spreadsheet without driver ref !
Does it possible ? Can you give me a starting solution?
When you add a spreadsheet to your theme, it also becomes available as a Data Set. Just select the spreadsheet as your dataset for a Widget, and then for the labels in that widget you can select each column as a data binding. The widget will show the 1st row by default, but you can change that by using the Data Offset. Or you can make it into a ticker and it will show all rows.
I tried the External Filepath Function with absolute und relative paths but it does not work :(
Example for absolute: C:\Users\Neldrion\Documents\Appgineer.in\Theme Editor\Themes\SkippyCup\Content\Spreadsheets
The file has exactly the same nameDo I need another formatting?
Error Log says: Warning: the External Filepath property was set but the file was not found. The external file path is ignored and the embedded file was loaded. External filepath: C:\Users\Neldrion\Documents\Appgineer.in\Theme Editor\Themes\SkippyCup\Content\Spreadsheets
Just for information, I use it because I use password when I compil my ATVO. If you put a user filepath it will be difficult to your user to use it! And Without the filepath It go at this place directly ;)
Is it possible to do a little script to reload a spreadsheet (I don't want that it is always read, just if we change some parts). I hope use a button and a script to do that. But how?
If I disable Cache DATA, the system allready reading data each update as you wrote in description (and it is working nice). It is the reason why I try to do it manually to prevent some useless processor charge
Cache Data is not meant to be reading the spreadsheet every update when you are connected to iRacing. It should only do that when you are not connected to iRacing, and then it will update once per second. This is so people can use spreadsheet bindings without iRacing connection, otherwise the bindings would never work.
When connected to iRacing, the spreadsheet should be static by default unless you force it to update. You can force it to update with the above script (run Parse), or by changing any property of the spreadsheet (which I think is also only possible by a script).