Issue 34625 - Export spreadsheet as javascript
Summary: Export spreadsheet as javascript
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: OOo 1.1.3
Hardware: All All
: P3 Trivial with 4 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2004-09-25 21:47 UTC by tange
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description tange 2004-09-25 21:47:06 UTC
Today it is possible to have Calc export the spreadsheet as an 
HTML-file. However, the HTML-file is just a static file, whereas the 
spreadsheet is dynamic and changes if you change some of the input 
It would be nice if it was possible to export the spreadsheet as 
javascript so it was possible to change the non-formula fields in a 
browser and have the result presented after a javascript calculation. 
It would be useful even if a lot of functionality could not be 
exported (e.g. graphs).
Comment 1 frank 2004-10-13 10:35:38 UTC
Hi Bettina,

sounds interesting but may be very difficult to implement.

Comment 2 tange 2004-10-13 17:07:05 UTC
I have have a few ideas concerning implementation. 
We will need a javascript function for each of the functions in Calc. Some will 
probably not be easy to write in javascript and those can be left out - the 
javascript export is usable even if some functions are not exportable. 
The recalculation order should be determined in advance. So it will not be 
needed to make a topological sorting in javascript or checks for 
self-referencing formulas (eg: A1=B2+A1). 
A lot of other functionality can probably be determined in advance: Instead of 
a general sum function you could generate specific functions that return the 
value (e.g. sum_from_b12_to_b17() { return b12()+b13()+b14()+b15()+b16()+b17
() } 
An input validation mechanism can be copied from Jwig's PowerForms 
Comment 3 bettina.haberer 2010-05-21 15:03:09 UTC
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements". 
Comment 4 gacb 2010-09-12 20:53:53 UTC
There's a commercial plugin to Excel that does this. Someone with extensive
JavaScript experience should be able to handle what would largely be formulas
tied to a form.

My JavaScript is confined to understanding what another person has written and
can modify it to suit my needs.