The single most irritating aspect of the LP feature in Calc is its inability to save the model that I built. Specifically, data on the cells used as the objective function, constraints and variables is lost when the spreadsheet is reloaded.
I’ve known this problem for a while now, and know that there won’t be any straightforward way of saving the model, either through the extension options or Calc’s save function. All I want to know is if there’s any sane way to store the model in any sort of persistent data such that, upon restart, opening the model will result in the cells previously input to still be there. My first guess is through macros, but I’m both clueless on the basics of macro building as well as dubious that its functionality can extend to extensions.
If anyone could give me not only a simple yes/no answer, but also a step-by-step procedure for saving and restoring model data in a spreadsheet, I’d be incredibly grateful. (And I’d label you as the answer and +1 you.)