Editing document leaves formulas stale.

zdavatz / spreadsheet

The Ruby Spreadsheet by ywesee GmbH

http://spreadsheet.ch

GNU General Public License v3.0

1.13k stars 240 forks source link

Editing document leaves formulas stale. #241

Closed westonstewarttennes closed 5 years ago

westonstewarttennes commented 5 years ago

It seems like there's no way to edit a document's cells that are used in formulas elsewhere in the same document. When I try to open the document after editing I get a 'File error: data may have been lost.' error and I have to manually refresh all formulas. Is there any way around this currently?

zdavatz commented 5 years ago

Can you please post more specifics about what you are exactly doing? Code sample, OS Version, Ruby Version, LibreOffice/MSOffice Version, etc.

westonstewarttennes commented 5 years ago

Figured it out -- sheet had formulas set to update manually instead of automatically, in case anyone else stumbles on the same issue.

zdavatz commented 5 years ago

Thank you for documenting this.