Todd
9b89ae1f12
spreadsheet: add fast paths for appending rows/cells
2017-09-15 17:43:40 -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
111567b74e
spreadsheet: default new cells to numeric with implicit zero value
2017-09-14 22:17:42 -05:00
Todd
1ff1b074f7
spreadsheet: add support for setting the active sheet
...
This is the tab that is initially selected when opening
a spreadsheet.
2017-09-12 16:32:16 -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
9e6bfaf6e1
spreadsheet: add method to clear cached formula results
2017-09-10 17:28:36 -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
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
ceb8570558
spreadsheet: add support for column formatting
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
9433c08f42
spreadsheet: rework fills
...
Fills were a little odd before, this modifies them to
work similarly to the other type (user API didn't change).
2017-09-09 09:34:57 -05:00
Todd
d5c07a59d6
spreadsheet: add method to determine sheet extents
2017-09-09 09:34:57 -05:00
Todd
41e2d6eaec
document: add support for rewriting document filenames
...
The problem this solves is loading and re-saving a document
that uses an odd file structure (e.g. the main body is
not at word/document.xml). I've seen this occur with spreadsheets
but not with a docx in the wild, however it's fairly simple
to handle in case it occurs.
2017-09-08 18:30:40 -04:00
Todd
9b33f72f6e
spreadsheet: add spreadsheet golden test
2017-09-08 18:20:52 -04:00
Todd
924140c87d
spreadsheet: add support for merged cells
2017-09-07 19:12:30 -04:00
Todd
8957cf73e3
spreadsheet: add validation for sheet name length
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
d8554f54de
spreadsheet: fix bug when saving sheets loaded with themes
2017-09-07 12:44:31 -04:00
Todd
2d710a2e6d
spreadsheet: ensure rows stay sorted
...
This fixes an issue with Mac Excel being unable to display
unsorted rows.
2017-09-07 12:44:31 -04:00
Todd
03540b8c38
spreadsheet: add support for defined names
2017-09-07 07:34:52 -04:00
Todd
2498814f67
spreadsheet: add support for hyperlinks
2017-09-07 06:12:41 -04:00
Todd
adb206e663
spreadsheet: always set cell reference numbers
2017-09-07 06:12:41 -04:00
Todd
0aebfb3d95
spreadsheet: pass sheet/row information down to cell wrapper
2017-09-07 06:12:41 -04:00
Todd
607db91c86
spreadsheet: add more unit tests
2017-09-07 06:12:41 -04:00
Todd
982e3a4f7d
spreadsheet: add methods for getting a cell's value as date/time
2017-09-07 06:12:41 -04:00
Todd
5392829790
spreadsheet: add method for retrieving cell value as a number/bool
2017-09-07 06:12:41 -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
10498401d6
spreadsheet: add helpers and example for number/date/time formatting
2017-09-05 17:55:22 -05:00
Todd
70051ae509
spreadsheet: support setting date/time cell values
2017-09-05 17:55:22 -05:00
Todd
7562c4e7bb
spreadsheet: provide an Epoch for dealing with older spreadsheets
2017-09-05 17:55:22 -05:00
Todd
17e9b1b684
spreadsheet: add support for ECMA-376 defined number formats
2017-09-05 17:55:22 -05:00
Todd
cd10a33f30
spreadsheet: improve Excel compatibility
...
Mac Excel apparently doesn't like empty drawing
relationships file.
2017-09-05 10:01:28 -05:00
Todd
5ee1459321
spreadsheet: add a multi chart example
2017-09-05 08:07:28 -05:00
Todd
e83404616d
Revert "schema: apply more default values"
...
This caused problems with Libre.
This reverts commit 59b2711e1b87be534c9cd3d155710d13cfe7743b.
2017-09-05 06:33:38 -05:00
Todd
59b2711e1b
schema: apply more default values
...
These are implied values as they are the defaults in the XSD
for optional attributes/elements. However I've noticed that
I keep running into issues where Mac Excel/Word fail to open
a file unless an optional default is provided.
I'll just add them all to hopefully increase compatibility and
save painful file format debugging sessions later.
2017-09-04 17:14:06 -05:00
Todd
817869647c
chart: move chart related classes from spreadsheet to chart
2017-09-04 16:16:03 -05:00
Todd
bb72680e01
spreadsheet: fix drawing for Mac Excel
2017-09-04 15:01:14 -05:00
Todd
f91f68b26a
spreadsheet: rename InitializeDefault to InitializeDefaults
2017-09-04 15:01:14 -05:00
Todd
b19266aced
spreadsheet: initial fixes for Mac Excel
2017-09-04 15:01:14 -05:00
