Formula/ spreadsheets in fgu?

[adzling]

I've been having a lot fun building nested tables for various random stuff and it got me thinking, is there any way to embed a complete spreadsheet (with formula) in FGU?

We use various google sheets for tracking things like ship chases and finances, would be neat if we could just toss that all into FGU.

Example: Starship Chase Calculator (https://docs.google.com/spreadsheets/d/1guoSay35nVl-dA-O--xIWK57kLe6oi1C8c2RUGbjVzc/edit#gid=0)

cheers!

[MrWigggles]

Are you any good with Lua and XML?

[adzling]

har no, sadly.

[GregRex]

adzling you got me thinking but haven't tried it yet. Check out this video quick: https://www.youtube.com/watch?v=gua_wNY4wc0&ab_channel=PhilipGreig

What I think may work is saving your spreadsheet to CSV, open in Notepad, then copy and past to FG using the table import in the video but select Delimited at the bottom of the Import Table window.

[adzling]

thanks GregRex, yeah I noticed you can import comma/tab/etc delimited tables which is great.

I'm trying to figure out if it's possible to have a working spreadsheet with formula/ functions in FGU.

It doesn't seem it's possible without custom coding.

[GregRex]

Ah gotcha, more of a live link to an open/saved spreadsheet? That would be over my head.