summaryrefslogtreecommitdiffhomepage
diff options
context:
space:
mode:
authorWeston Ganger <[email protected]>2019-10-28 15:49:45 -0700
committerStefan Daschek <[email protected]>2019-10-29 00:24:50 +0100
commit2224dbc942c15122d2c66f3371a42b502aa2aeab (patch)
tree5463dc2d353a648c37a69a3a664247d5343d73ff
parentfff65a95da4d2ca9b115781a65d1164823e06636 (diff)
downloadcaxlsx-2224dbc942c15122d2c66f3371a42b502aa2aeab.tar.gz
caxlsx-2224dbc942c15122d2c66f3371a42b502aa2aeab.zip
Use CHANGELOG.md instead of README for changelog
-rw-r--r--CHANGELOG.md133
-rw-r--r--README.md60
2 files changed, 103 insertions, 90 deletions
diff --git a/CHANGELOG.md b/CHANGELOG.md
index 83d88069..4ef11371 100644
--- a/CHANGELOG.md
+++ b/CHANGELOG.md
@@ -1,13 +1,77 @@
CHANGELOG
---------
-- **November.25.12**:1.3.4
+
+- **October.4.19**: 3.0.1
+ - Support for ruby versions limited to officially supported version (Ruby v2.3+)
+ - Updates to dependency gems, especially nokogiri and ruby-zip
+ - Fix Relationship.instances cache
+ - Autoload fix for Rails
+
+- **September.17.19**: 3.0.0
+ - First release of caxlsx, fork of axlsx
+
+- **April.1.17**: 3.0.0-pre
+ - Support for ruby versions limited to officially supported version
+ - Updates to dependency gems, especially nokogiri and ruby-zip
+ - Patch options parsing for two cell anchor
+ - Remove support for depreciated worksheet members
+ - Added Cell#name so you you can quickly create a defined name for a single cell in your workbook.
+ - Added full book view and sheet state management. This means you can specify how the workbook renders as well as manage sheet visibility.
+ - Added smoothing management for line charts series
+
+- **September.12.13**: 2.0.1
+ - Unpinned rubyzip version
+
+- **September.12.13**: 2.0.0
+ - DROPPED support for ruby 1.8.7
+ - Altered readme to link to contributors
+ - Lots of improvements to make charts and relations more stable.
+ - Patched color param mutation.
+ - Data sourced for pivot tables can now come from other sheets.
+ - Altered image file extension comparisons to be case insensitive.
+ - Added control character sanitization to shared strings.
+ - Added page breaks. see examples/example.rb for an example.
+ - Bugfix: single to dual cell anchors for images now swap properly so you can set the end_at position during instantiation, in a block or directly on the image.
+ - Improved how we convert date/time to include the UTC offset when provided.
+ - Pinned rubyzip to 0.9.9 for those who are not ready to go up. Please note that release 2.0.1 and on will be using the 1.n.n series of rubyzip
+ - Bugfix: transposition of cells for Worksheet#cols now supports
+ incongruent column counts.counts
+ - Added space preservation for cell text. This will allow whitespace
+ in cell text both when using shared strings and when serializing
+ directly to the cell.
+
+- **April.24.13**: 1.3.6
+ - Fixed LibreOffice/OpenOffice issue to properly apply colors to lines
+ in charts.
+ - Added support for specifying between/notBetween formula in an array.
+ *thanks* straydogstudio!
+ - Added standard line chart support. *thanks* scambra
+ - Fixed straydogstudio's link in the README. *thanks* nogara!
+
+- **February.4.13**: 1.3.5
+ - converted vary_colors for chart data to instance variable with appropriate defulats for the various charts.
+ - Added trust_input method on Axlsx to instruct the serializer to skip HTML escaping. This will give you a tremendous performance boost,
+ Please be sure that you will never have <, >, etc in your content or the XML will be invalid.
+ - Rewrote cell serialization to improve performance
+ - Added iso_8601 type to support text based date and time management.
+ - Bug fix for relationahip management in drawings when you add images
+ and charts to the same worksheet drawing.
+ - Added outline_level_rows and outline_level_columns to worksheet to simplify setting up outlining in the worksheet.
+ - Added support for pivot tables
+ - Added support for descrete border edge styles
+ - Improved validation of sheet names
+ - Added support for formula value caching so that iOS and OSX preview can show the proper values. See Cell.add_row and the formula_values option.
+
+- **November.25.12**: 1.3.4
- Support for headers and footers for worksheets
- bug fix: Properly escape hyperlink urls
- Improvements in color_scale generation for conditional formatting
- Improvements in autowidth calculation.
-- **November.8.12**:1.3.3
+
+- **November.8.12**: 1.3.3
- Patched cell run styles for u and validation for family
-- **November.5.12**:1.3.2
+
+- **November.5.12**: 1.3.2
- MASSIVE REFACTORING
- Patch for apostrophes in worksheet names
- added sheet_by_name for workbook so you can now find your worksheets
@@ -15,6 +79,7 @@ CHANGELOG
- added insert_worksheet so you can now add a worksheet to an
arbitrary position in the worksheets list.
- reduced memory consumption for package parts post serialization
+
- **September.30.12**: 1.3.1
- Improved control character handling
- Added stored auto filter values and date grouping items
@@ -23,29 +88,35 @@ CHANGELOG
all the predefined table styles.
- Improved style management for fonts so they merge undefined values
from the initial master.
+
- **September.8.12**: 1.2.3
- enhance exponential float/bigdecimal values rendering as strings intead
of 'numbers' in excel.
- added support for :none option on chart axis labels
- added support for paper_size option on worksheet.page_setup
+
- **August.27.12**: 1.2.2
- minor patch for auto-filters
- minor documentation improvements.
+
- **August.12.12**: 1.2.1
- Add support for hyperlinks in worksheets
- Fix example that was using old style cell merging with concact.
- Fix bug that occurs when calculating the font_size for cells that use a user specified style which does not define sz
+
- **August.5.12**: 1.2.0
- rebuilt worksheet serialization to clean up the code base a bit.
- added data labels for charts
- added table header printing for each sheet via defined_name. This
means that when you print your worksheet, the header rows show for every page
-- **July.??.12**: 1.1.9 release
+
+- **July.??.12**: 1.1.9
- lots of code clean up for worksheet
- added in data labels for pie charts, line charts and bar charts.
- bugfix chard with data in a sheet that has a space in the name are
now auto updating formula based values
-- **July.14.12**: 1.1.8 release
+
+- **July.14.12**: 1.1.8
- added html entity encoding for sheet names. This allows you to use
characters like '<' and '&' in your sheet names.
- new - first round google docs interoperability
@@ -54,7 +125,8 @@ CHANGELOG
to PDF from Libra Office
- various readability improvements and work standardizing attribute
names to snake_case. Aliases are provided for backward compatiblity
-- **June.11.12**: 1.1.7 release
+
+- **June.11.12**: 1.1.7
- fix chart rendering issue when label offset is specified as a
percentage in serialization and ensure that formula are not stored
in value caches
@@ -62,7 +134,8 @@ in value caches
- Add title property to axis so you can lable the x/y/series axis for
charts.
- Add sheet views with panes
-- **May.30.12**: 1.1.6 release
+
+- **May.30.12**: 1.1.6
- data protection with passwords for sheets
- cell level input validators
- added support for two cell anchors for images
@@ -72,14 +145,15 @@ in value caches
- added ph (phonetics) and s (style) attributes for row.
- resolved all warnings generating from this gem.
- improved comment relationship management for multiple comments
-- **May.13.12**: 1.1.5 release
+
+- **May.13.12**: 1.1.5
- MOAR print options! You can now specify paper size, orientation,
fit to width, page margings and gridlines for printing.
- Support for adding comments to your worksheets
- bugfix for applying style to empty cells
- bugfix for parsing formula with multiple '='
-- **May.3.12:**: 1.1.4 release
+- **May.3.12:**: 1.1.4
- MOAR examples
- added outline level for rows and columns
- rebuild of numeric and axis data sources for charts
@@ -91,23 +165,23 @@ in value caches
- Added support for specifying the color of data series in charts.
- bugfix using add_cell on row mismanaged calls to update_column_info.
-- ** April.25.12:**: 1.1.3 release
+- ** April.25.12:**: 1.1.3
- Primarily because I am stupid.....Updates to readme to properly report version, add in missing docs and restructure example directory.
-- ** April.25.12:**: 1.1.2 release
+- ** April.25.12:**: 1.1.2
- Conditional Formatting completely implemented.
- refactoring / documentation for Style#add_style
- added in label rotation for chart axis labels
- bugfix to properly assign style and type info to cells when only partial information is provided in the types/style option
-- ** April.18.12**: 1.1.1 release
+- ** April.18.12**: 1.1.1
- bugfix for autowidth calculations across multiple rows
- bugfix for dimension calculations with nil cells.
- REMOVED RMAGICK dependency WOOT!
- Update readme to show screenshot of gem output.
- Cleanup benchmark and add benchmark rake task
-- ** April.3.12**: 1.1.0 release
+- ** April.3.12**: 1.1.0
- bugfix patch name_to_indecies to properly handle extended ranges.
- bugfix properly serialize chart title.
- lower rake minimum requirement for 1.8.7 apps that don't want to move on to 0.9 NOTE this will be reverted for 2.0.0 with workbook parsing!
@@ -122,7 +196,7 @@ in value caches
- Major (like 7x faster!) performance updates.
- Gem now supports for JRuby 1.6.7, as well as experimental support for Rubinius
-- ** March.5.12**: 1.0.18 release
+- ** March.5.12**: 1.0.18
https://github.com/randym/axlsx/compare/1.0.17...1.0.18
- bugfix custom borders are not properly applied when using styles.add_style
- interop worksheet names must be 31 characters or less or some versions of office complain about repairs
@@ -132,14 +206,14 @@ in value caches
- added << alias for add_row
- removed presetting of date1904 based on authoring platform. Now defaults to use 1900 epoch (date1904 = false)
-- ** February.14.12**: 1.0.17 release
+- ** February.14.12**: 1.0.17
https://github.com/randym/axlsx/compare/1.0.16...1.0.17
- Added in support for serializing to StringIO
- Added in support for using shared strings table. This makes most of the features in axlsx interoperable with iWorks Numbers
- Added in support for fixed column_widths
- Removed unneeded dependencies on active-support and i18n
-- ** February.2.12**: 1.0.16 release
+- ** February.2.12**: 1.0.16
https://github.com/randym/axlsx/compare/1.0.15...1.0.16
- Bug fix for schema file locations when validating in rails
- Added hyperlink to images
@@ -147,14 +221,14 @@ in value caches
- removed whitespace/indentation from xml outputs
- col_style now skips rows that do not contain cells at the column index
-- **January.6.12**: 1.0.15 release
+- **January.6.12**: 1.0.15
https://github.com/randym/axlsx/compare/1.0.14...1.0.15
- Bug fix add_style specified number formats must be explicity applied for libraOffice
- performance improvements from ochko when creating cells with options.
- Bug fix setting types=>[:n] when adding a row incorrectly determines the cell type to be string as the value is null during creation.
- Release in preparation for password protection merge
-- **December.14.11**: 1.0.14 release
+- **December.14.11**: 1.0.14
- Added support for merging cells
- Added support for auto filters
- Improved auto width calculations
@@ -163,14 +237,14 @@ in value caches
- Added access to app and core package objects so you can set the creator and other properties of the package
- The beginning of password protected xlsx files - roadmapped for January release.
-- **December.8.11**: 1.0.13 release
+- **December.8.11**: 1.0.13
- Fixing .gemspec errors that caused gem to miss the lib directory. Sorry about that.
-- **December.7.11**: 1.0.12 release
+- **December.7.11**: 1.0.12
DO NOT USE THIS VERSION = THE GEM IS BROKEN
- changed dependency from 'zip' gem to 'rubyzip' and added conditional code to force binary encoding to resolve issue with excel 2011
- Patched bug in app.xml that would ignore user specified properties.
-- **December.5.11**: 1.0.11 release
+- **December.5.11**: 1.0.11
- Added [] methods to worksheet and workbook to provide name based access to cells.
- Added support for functions as cell values
- Updated color creation so that two character shorthand values can be used like 'FF' for 'FFFFFFFF' or 'D8' for 'FFD8D8D8'
@@ -178,7 +252,7 @@ in value caches
- Clean up and support for 1.9.2 and travis integration
- Added support for string based cell referencing to chart start_at and end_at. That means you can now use :start_at=>"A1" when using worksheet.add_chart, or chart.start_at ="A1" in addition to passing a cell or the x, y coordinates.
-- **October.30.11**: 1.0.10 release
+- **October.30.11**: 1.0.10
- Updating gemspec to lower gem version requirements.
- Added row.style assignation for updating the cell style for an entire row
- Added col_style method to worksheet upate a the style for a column of cells
@@ -188,11 +262,11 @@ in value caches
- fixed out of range bug in time calculations for 32bit time.
- added i18n for active support
-- **October.26.11**: 1.0.9 release
+- **October.26.11**: 1.0.9
- Updated to support ruby 1.9.3
- Updated to eliminate all warnings originating in this gem
-- **October.23.11**: 1.0.8 release
+- **October.23.11**: 1.0.8
- Added support for images (jpg, gif, png) in worksheets.
- **October.23.11**: 1.0.7 released
@@ -206,10 +280,10 @@ in value caches
- rebuild of anchor positioning to remove some spagetti code. Chart now supports a start_at and end_at method that accept an arrar for col/row positioning. See example6 for an example. You can still pass :start_at and :end_at options to worksheet.add_chart.
- Refactored cat and val axis data to keep series serialization a bit more DRY
-##October.22.11: 1.0.6 release
+- **October.22.11**: 1.0.6
- Bumping version to include docs. Bug in gemspec pointing to incorrect directory.
-##October.22.11: 1.05
+- **October.22.11**: 1.05
- Added support for line charts
- Updated examples and readme
- Updated series title to be a real title ** NOTE ** If you are accessing titles directly you will need to update text assignation.
@@ -225,14 +299,13 @@ in value caches
- Added style property to charts
- Removed serialization write test as it most commonly fails when run from the gem's intalled directory
-##October.21.11: 1.0.4
+- **October.21.11**: 1.0.4
- altered package to accept a filename string for serialization instead of a File object.
- Updated specs to conform
- More examples for readme
-##October.21.11: 1.0.3 release
+- **October.21.11**: 1.0.3
- Updated documentation
-##October.20.11: 0.1.0 release
-
+- **October.20.11**: 0.1.0
diff --git a/README.md b/README.md
index ff076fde..7cc45c44 100644
--- a/README.md
+++ b/README.md
@@ -168,66 +168,6 @@ Specs
This gem has 100% test coverage using test/unit. To execute tests for this gem, simply run rake in the gem directory.
-Change log
----------
-- **October.4.19**:3.0.1
- - Support for ruby versions limited to officially supported version
- - Updates to dependency gems, especially nokogiri and ruby-zip
- - Fix Relationship.instances cache
- - Autoload fix for Rails
-- **September.17.19**:3.0.0
- - First release of caxlsx, fork of axlsx
-- **April.1.17**:3.0.0-pre
- - Support for ruby versions limited to officially supported version
- - Updates to dependency gems, especially nokogiri and ruby-zip
- - Patch options parsing for two cell anchor
- - Remove support for depreciated worksheet members
-- **
- - Added Cell#name so you you can quickly create a defined name for a single cell in your workbook.
- - Added full book view and sheet state management. This means you can specify how the workbook renders as well as manage sheet visibility.
- - Added smoothing management for line charts series
-- **September.12.13**:2.0.1
- - Unpinned rubyzip version
-- **September.12.13**:2.0.0
- - DROPPED support for ruby 1.8.7
- - Altered readme to link to contributors
- - Lots of improvements to make charts and relations more stable.
- - Patched color param mutation.
- - Data sourced for pivot tables can now come from other sheets.
- - Altered image file extension comparisons to be case insensitive.
- - Added control character sanitization to shared strings.
- - Added page breaks. see examples/example.rb for an example.
- - Bugfix: single to dual cell anchors for images now swap properly so you can set the end_at position during instantiation, in a block or directly on the image.
- - Improved how we convert date/time to include the UTC offset when provided.
- - Pinned rubyzip to 0.9.9 for those who are not ready to go up. Please note that release 2.0.1 and on will be using the 1.n.n series of rubyzip
- - Bugfix: transposition of cells for Worksheet#cols now supports
- incongruent column counts.counts
- - Added space preservation for cell text. This will allow whitespace
- in cell text both when using shared strings and when serializing
- directly to the cell.
-- **April.24.13**:1.3.6
- - Fixed LibreOffice/OpenOffice issue to properly apply colors to lines
- in charts.
- - Added support for specifying between/notBetween formula in an array.
- *thanks* straydogstudio!
- - Added standard line chart support. *thanks* scambra
- - Fixed straydogstudio's link in the README. *thanks* nogara!
-- **February.4.13**:1.3.5
- - converted vary_colors for chart data to instance variable with appropriate defulats for the various charts.
- - Added trust_input method on Axlsx to instruct the serializer to skip HTML escaping. This will give you a tremendous performance boost,
- Please be sure that you will never have <, >, etc in your content or the XML will be invalid.
- - Rewrote cell serialization to improve performance
- - Added iso_8601 type to support text based date and time management.
- - Bug fix for relationahip management in drawings when you add images
- and charts to the same worksheet drawing.
- - Added outline_level_rows and outline_level_columns to worksheet to simplify setting up outlining in the worksheet.
- - Added support for pivot tables
- - Added support for descrete border edge styles
- - Improved validation of sheet names
- - Added support for formula value caching so that iOS and OSX preview can show the proper values. See Cell.add_row and the formula_values option.
-
-Please see the {file:CHANGELOG.md} document for past release information.
-
# Known interoperability issues.
As axslx implements the Office Open XML (ECMA-376 spec) much of the
functionality is interoperable with other spreadsheet software. Below is