Skip to content

Latest commit

 

History

History
559 lines (287 loc) · 22.1 KB

CHANGELOG.md

File metadata and controls

559 lines (287 loc) · 22.1 KB
Raw

Changelog

1.8.2 (2023-05-02)

Bug Fixes:

Enhancements

  • upgrade dependencies (#60) (#61)

1.8.1 (2023-03-31)

Bug Fixes:

  • fixing a date issue about one millisecond before midnight, thanks krisanselmo (#54)

Enhancements

Default branch update:

We've migrated the default branch from master to main

1.8.0 (2022-07-21)

New Repo & Maintainer:

Huge thanks to natergj for his work on this library. Due to life circumstances he is no longer able to maintain this library and he has passed the torch over to us at Advisr to continue. We will be continuing development of this library on our fork https://github.com/advisr-io/excel4node and the original repo will be deprecated. New versions will still be released to the original NPM package https://www.npmjs.com/package/excel4node.

This release is meant to bring the package up to date with its various dependencies to address security vulnerabilities found since the last release three years ago. Additionally a few pull requests from the original repo have been merged to address a few outstanding bug/feature requests. Thanks to Arthur Blake for identifying the pull requests to transfer over from the original repo.

Bug Fixes:

Enhancements:

Breaking Changes:

  • Node versions less than v14 (current maintenance LTS) are no longer supported.
    • Please upgrade to the latest LTS release of Node (we recommend either v14 or v16).
    • When bringing the library dependencies up to date we were forced to increase the minimum node version requirement to their level

1.7.2 (2019-04-28)

Bug Fixes:

  • fix issue when comment drawing changing after save (#283)

1.7.1 (2019-03-25)

Bug Fixes:

  • fix issue where multiple complex strings could not be used (#269)
  • fix README typo (#264)
  • fix license format (#272)
  • fix TypeError: deepmerge is not a function (#258)

1.7.0 (2018-10-07)

Bug Fixes:

  • fix issue with certain emoji characters (#238)
  • fix issue with workbook validation using .Net validation library provided by Microsoft (#240)
  • fix issue where first tab will still be shown even if it is hidden (#236)

Enhancements:

  • add basic cell comment functionality (#243)

1.6.0 (2018-09-16)

Bug Fixes:

  • fix issue where emoji were not being added to worksheets (#232)

Enhancements:

  • add ability to set Print Area for worksheets (#194)
  • add ability to set Page Breaks for worksheets (#233)

1.5.1 (2018-09-09)

Bug Fixes:

  • fix issue where library crashed when null or undefined value was sent to cell string method (#218)
  • fix issue where default font would not be applied to dates when opening workbook in LibreOffice (#226)
  • fixerror when attempting to bundle application with excel4node as dependency (#225)

Enhancements:

  • reduces library size by only installed specific lodash functions (#230)

1.5.0 (2018-07-22)

Bug Fixes:

  • fix error will be thrown if no Worksheet is specified prior to attempting to write a Workbook (#156)

Enhancements:

  • merge (#211) & (#212)
    • remove default logger dependency in favor of much smaller simple logger (reduces library dependencies and size)
    • add ability specify custom logger

1.4.0 (2018-07-07)

Bug Fixes:

  • fix issue where unicode filenames could not be used with HTTP Response write handler (#196)

Enhancements:

  • add ability to hide worksheets (#201)

1.3.6 (2018-03-21)

Bug Fixes:

  • fix to allow column widths to be set as floats (#182)
  • fix to properly handle setting row autofilter with no arguments (#184)
  • fix typo in documentation (#181)

1.3.5 (2018-02-03)

Bug Fixes:

  • fix to properly handle unicode and emoji (#141)
  • fix to correct issue with row spans causing errors when opening workbooks with a large number of lines (#172)

1.3.4 (2018-01-24)

Bug Fixes:

  • resolved issue where if multiple conditional formatting rules were specified for a single sheet, only the first rule would apply
  • resolve issue adding multiple dataValidations that did not include a formula to a single worksheet (#164)

Enhancements:

  • improve performance with shared strings (#165)

1.3.2 (2017-11-30)

Bug Fixes:

  • fix issue after 1.3.0 re-introduced issue #84 (#152)

1.3.1 (2017-11-25)

Bug Fixes:

  • fix for uncatchable thrown errors (#148)
  • fix for incorrectly generated links (#106)
  • fix for missing fills in conditional formatting (#147)

1.3.0 (2017-11-12)

Enhancements:

  • add option to hide view lines (#117)
  • add code coverage checking (#109)
  • allow for image from buffer support (#138)
  • add options for workbook view (1c4a7bf)
  • fix issue where ony first data validation per sheet would take effect (ff629a2)

Bug fixes:

  • fix issue when adding 2nd image of same extension (#99)
  • fix deprecated lodash function warning (#115)
  • fix link in README (#125)
  • fix to remove babel-register runtime dependency (#119)
  • fix issue with summaryBelow and summaryRight (#132)
  • use latest version of mime module (78180e6)
  • update dependencies (b96f01a)
  • fixes date translations to match published spec (b3fcb8a)
  • fix issue where workbook would always open as smallest possible window size (1c4a7bf)

1.2.1

  • Fix Workbook#createStyle creating duplicates and slow performance [#100]

1.2.0

  • merged natergj#91 from miguelmota to expose writeToBuffer method allowing excel zip buffer to be piped to other streams
  • added documentation to README
  • fixed some errors in README

1.1.2

  • dependency cleanup
  • updated to version 3.x.x of jszip

1.1.1

  • Improved effeciency when writing Workbooks to help address Issue #83. Tested with 50 columns and 30,000 rows.

1.1.0

  • Fixed issue where defaultRowHeight set in Workbook opts was not being properly handled.

1.0.9

  • Fixed issue #90 which would result in a type error being thrown if a dataValidation errorTitle was set and errorStyle was not

1.0.8

  • Removed debug line that had been missed prior to publish

1.0.7

  • Fixed issue #89 which would result in dates showing a 1 hour offset if date was in daylight savings time

1.0.6

  • Fixed issue #87 which would result in non-logical behaviour of showDropDown="true" for dataValidations
  • Fixed issue #88 which would result in fonts set as default for workbook not having all of their attributes respected for cells that had a style assigned to them that only included a subset of the font attributes.

1.0.5

  • Fixed issue #84 which would result in Office 2013 on Windows crashing when attempting to print a workbook.

1.0.4

  • Fixed issue #82 which would result in call stack size being exceeded when workbook was being written

1.0.3

  • Fixed issue where border.outline property was not applying border only to cells on out the outside of the cell block
  • Fixed issue where an excessive number of style xfs may have been added to styles.xml file

1.0.2

  • Fixed some inaccuracies in the README.md file

1.0.1

  • Removed a missed remnant of old code that wasn't removed during the merge
  • Excluded development tests folder from npm published code

1.0.0

  • Complete rewrite of library in ES2015
  • This is a breaking change for API. Library is much more javascripty

0.5.1

0.5.0

0.4.1

  • Fixed issue causing problems when trying to bundle

0.4.0

0.3.1

0.3.0

0.2.23

0.2.22

0.2.21

  • Fixed issue where files with spaces in their names were not correctly downloading in Firefox.

0.2.20

  • Added the ability to add "Protection" to Workbooks and Worksheets
  • Fixed issue where Row.Filter() would not filter the correct row if workbook opened in LibreOffice or uploaded to GoogleSheets
  • Added the .Border() function to individual cell ranges rather than requiring borders to be defined within a Style
  • Added opts.allowInterrupt which will use an asynchronous forEach function in order not to block other operations if reports are being generated on the same thread as other operations.

0.2.19

  • Fixed issue that would cause Excel to crash when filtered columns were sorted

0.2.18

  • Fixed issue where page would not scroll vertically if row was frozen
  • Fixed issue where internal Row.cellCount() function would not return the correct number of cells if there were more than 9
  • Fixed issue where invalid workbooks would be generated on write if write was called multiple times on the same workbook.

0.2.17

  • Set string function to remove characters not compatible with XMLStringifier.
  • merged pull request natergj#38 from https://github.com/nirarazi to add support for Right to Left languages

0.2.16

0.2.15

  • fixed issue where Column functions were not returning Column objects and could not be chained
  • fixed date issues with Cell Date function when invalid date was sent.
  • fixed issue where merged cells would apply values to all cells in range rather than just top left cell. This would cause issues when summing rows and columns with merged cells.
  • fixed issue where multiple images could not be added to a workbook

0.2.14

  • Added ability to Group columns
  • Merged pull request (natergj#34) from https://github.com/kylepixel which greatly optimizes conversion of numeric to and from alpha representations of columns

0.2.13

  • Fixed issue where default style would inherit style alignement if it was delared prior to any other font declaration

0.2.12

  • Added ability to Hide a Row or Column

0.2.11

  • Merged pull request (natergj#32) from https://github.com/stefanhenze to add ability to set the fit to page on print
  • Added the abilty to rotate text in cell
  • fixed validation issue that would cause an error if a cell were written to as a formula after already being written to as a number or string

0.2.10

0.2.9

0.2.8

0.2.7

  • fixed issue that would prevent cells to be written to columns over 702 (26^2 + 26) column AAA or higher
  • Merged pull request (natergj#26) from https://github.com/RafaPolit to fixe continuing issue with merging cells

0.2.6

  • fixed to merge issues after the 52nd column

0.2.5

  • fixed the 2nd sort function needed for proper cell merging in all cases.

0.2.4

  • fixed issue with cells not merging if one of the cells is after the 26th column.
  • fixed xml validation issue if not style has been specified on the workbook.

0.2.3

  • fixed issue where groupings would cause an XML validation error when summaryBelow was set to true
  • greatly reduced memory usage when added data to worksheets
  • deprecated Workbook.Settings.outlineSummaryBelow() call. This will be removed in version 1 and a console log entry created when used.

0.2.2

  • fixed issue where incorrect string was displayed if cell had changed from a string to a number

0.2.1

  • fixed issue that would cause failure if no cells had been added to a worksheet prior to write function called

0.2.0

  • Near complete refactor. adds efficiency and speed and much more readable code.
  • Added ability to create workbook with options. jszip options are first. more to come. Issue #20
  • Added ability to create workshets with options. margins, zoom and centering on print first. more to come. Issue #19
  • Added ability to add a Date to worksheet and set type as Date
  • Fixed issue #22 where empty string would print 'undefined' in cell
  • Fixed issue #21 where foreign characters would cause issue.

0.1.7

0.1.6

  • added ability to set a row to be a Filter row
  • finished Grouping feature

0.1.5

  • fixed issue where some Excel features (sorting, grouping, etc) where not available on first sheet of workbook if more than one worksheet existed
  • continuing work on experimental Grouping features

0.1.4

  • fixed issue where sheet would not scroll properly if Freezing both a row and a column
  • allowed for usage of color definitions in multiple formats

0.1.3

  • added ability to Freeze Rows

0.1.2

  • fixed issue with Font Alignment when applied directly to a cell
  • module will no longer crash when String is passed an undefined value
  • fixed sample to properly identify if it is running from within the module or not
  • fixed issue where border would not always be applied to the correct cell range.

0.1.1

  • added ability to merge cells
  • added ability to apply styles to range of cells
  • added ability to apply formatting to cells and cell ranges without first creating a style
  • fixed issue that would cause error when applying a row height if row had populated cells

0.0.10

0.0.9

  • fixed issue where if a Worksheet was added, but then no cells added, execution would stop
  • fixed issue where workbooks would cause MS Excel for Windows to crash on print preview
  • fixed issue where if undefined or 0 value was passed to cell or row function, execution would stop
  • added changelog

0.0.8

  • fixed issue where when adding a cell in a row not in sequence would cause corrupted excel data.

0.0.7

  • added ability to add borders to cells

0.0.6

  • added ability to include images in workbooks

0.0.5

  • added ability to Freeze columns from horizontal scrolling
  • fixed bug where if a Cell had been previously set to a String and is changed to a Number, the cell would reference the shared string key of the number rather than displaying the number.

0.0.4

  • added ability to set text alignment of cells
  • added ability to set text wrapping in cells
  • fixed issue where fill were not being applied in certain circumstances

0.0.3

  • fixed bug where excel data was corrupted if write function was called twice.

0.0.1

  • initial push