Todd
99ed4875e1
spreadsheet: support evaluation of shared formulas
...
This seems to be very uncommon.
2017-10-01 19:29:13 -05:00
Todd
d7515808d8
spreadsheet: initial shared formula support
2017-10-01 19:29:13 -05:00
Todd
c5be4536a9
spreadsheet: support sorting a sheet
...
The file format doesn't support sorting, so we
need to sort the sheet rows and renumber after sorting.
2017-09-27 18:27:53 -05:00
Todd
5c7852d21e
schema: rename spreadsheetml to sml
2017-09-23 10:01:17 -04:00
Todd
09825ac816
schema: rework schema namespaces to work around Windows issues
...
The go command on Windows doesn't like long path name. To
work around this, this is the first in a series of changes to
shorten the schema disk path structure in a few places.
Fixes #89
2017-09-23 10:01:17 -04:00
Todd
39028bcd7a
spreadsheet: add ability to recalculate formulas
...
If the formula executes without errors, it stores the
result as a cached value in the sheet.
2017-09-17 14:56:58 -05:00
Todd
b54a2efd19
formula: add method to determine the supported functions
2017-09-17 14:56:58 -05:00
Todd
fe93d10dca
meta: add performance numbers
2017-09-15 17:44:25 -05:00
Todd
382c157c11
formula: add more math formulas
...
- ABS
- ACOS
- ACOSH
- ARABIC
- ASIN
- ASINH
- ATAN
- ATANH
- ATAN2
- BASE
- CEILING.MATH
- CEILING.PRECISE
- COMBIN
- COMBINA
- COS
- COSH
- DECIMAL
- DEGREES
- PI
2017-09-15 17:43:40 -05:00
Todd
17a365ee93
spreadsheet: start adding support for formula evaluation
...
We can take advantage of cached formula results that Excel/LibreOffice
insert to ensure that our formula results match the expected results.
2017-09-14 22:17:42 -05:00
Todd
58b6c0700e
spreadsheet: allow multiple anchor types for charts
2017-09-11 20:17:06 -05:00
Todd
558e5ee274
spreadsheet: add image support and example
2017-09-11 20:17:06 -05:00
Todd
90e6416440
spreadsheet: add more fine control over anchoring
2017-09-11 20:17:06 -05:00
Todd
0791b4688b
spreadsheet: add freeze rows/columns support and example
2017-09-10 19:11:53 -05:00
Todd
f3eca9e68e
spreadsheet: add support for data validation rules
2017-09-10 17:13:40 -05:00
Todd
db7145dcbb
spreadsheet: add helper function for applying a border to multiple cells
2017-09-10 16:13:11 -05:00
Todd
2312e6cdc8
spreadsheet: add initial cell border example
2017-09-10 16:13:11 -05:00
Todd
3bc4675cf6
spreadsheet: add comment support
...
This adds comment support for sheets. Excel requires a VML drawing with
the comment box shape for each comment to display the comment.
LibreOffice displays comments fine with or without the shape, and
creates the shape for its own comments. For the sake of compatibility,
we create comment shapes as well.
I know of no other use for the legacy VML support other than comment
boxes...
2017-09-10 11:25:29 -05:00
Todd
cba2eae60f
meta: update and fix examples
...
Fixes #54
2017-09-10 10:33:53 -05:00
Todd
50c3c2c990
document/spreadsheet: updates for new schema
2017-09-10 10:33:53 -05:00
Todd
3d6b12368b
spreadsheet: add complex example
...
This has some conditional formatting, charts and auto filters.
2017-09-09 11:02:39 -05:00
Todd
cdb3f64c4a
spreadsheet: more fill cleanup
2017-09-09 11:02:39 -05:00
Todd
3b50df7eb7
spreadsheet: add support for conditional formatting
2017-09-09 09:34:57 -05:00
Todd
924140c87d
spreadsheet: add support for merged cells
2017-09-07 19:12:30 -04:00
Todd
f70810321d
spreadsheet: support adding/removing an auto filter
2017-09-07 16:39:40 -04:00
Todd
6f25f76689
spreadsheet: support numbers on the category axis
...
Rename SetReference to SetLabelReference and add a new SetNumberReference
2017-09-07 12:44:31 -04:00
Todd
0de975d3dd
spreadsheet: add support for bubble chart
2017-09-07 12:44:31 -04:00
Todd
4d6533f4a7
spreadsheet: support exploded pie chart
2017-09-07 10:53:53 -04:00
Todd
744babf1bd
spreadsheet: add support for scatter charts
2017-09-07 10:53:53 -04:00
Todd
059cbd9e85
spreadsheet: add support for the surface chart
2017-09-07 09:39:51 -04:00
Todd
03540b8c38
spreadsheet: add support for defined names
2017-09-07 07:34:52 -04:00
Todd
878e759954
meta: add missing bar-chart sample
2017-09-07 06:55:20 -04:00
Todd
144a590088
spreadsheet: add pie chart support
2017-09-06 17:58:56 -04:00
Todd
38db3f5311
spreadsheet: add radar chart support
2017-09-06 17:58:56 -04:00
Todd
ee6ad24531
spreadsheet: add convenience methods
...
- add a Cell method to the sheet that gets/creates a cell
- chance Row.Cell to not require the row number
- rename EnsureRow to Row
- add examples/tests
2017-09-06 17:41:05 -04:00
Todd
7e0d2edaab
spreadsheet: add support for named cells/rows
2017-09-06 15:20:51 -04:00
Todd
80fc93a1a7
spreadsheet: add support for rich text within a cell
2017-09-06 15:20:51 -04:00
Todd
04f24736db
spreadsheet: add a no cell data example
2017-09-05 20:17:10 -05:00
Todd
11a2e9db58
spreadsheet: add line 3d chart example
2017-09-05 19:33:25 -05:00
Todd
10498401d6
spreadsheet: add helpers and example for number/date/time formatting
2017-09-05 17:55:22 -05:00
Todd
bf452b0a64
meta: update preview images
2017-09-05 08:07:28 -05:00
Todd
5ee1459321
spreadsheet: add a multi chart example
2017-09-05 08:07:28 -05:00
Todd
03fa89c7ee
spreadsheet: add bar chart support
2017-09-04 16:16:03 -05:00
Todd
a59b472c98
meta: add screenshots of a few examples
2017-09-04 15:11:54 -05:00
Todd
bb72680e01
spreadsheet: fix drawing for Mac Excel
2017-09-04 15:01:14 -05:00
Todd
35a2b8026e
spreadsheet: add a line chart example and supporting code
2017-09-04 11:08:29 -05:00
Todd
d186678dbb
spreadsheet: merge spreadsheet/style package into spreadsheet
2017-09-02 17:50:38 -05:00
Todd
3e1bcdd646
examples: add simple spreadsheet example
2017-09-02 17:50:38 -05:00
Todd
1896e7fd06
spreadsheet: allow setting/retrieving sheet name
2017-09-02 17:50:38 -05:00
Todd
d1012cdbc4
meta: remove unused files
2017-08-31 22:16:05 -05:00
