Skip to content

Latest commit

 

History

History
516 lines (478 loc) · 55.4 KB

RELEASE_NOTES.md

File metadata and controls

516 lines (478 loc) · 55.4 KB
Raw

6.1.3+3ba93ef (Released 2024-6-7)

  • Additions:
    • [#9c30d63] add manage-issues workflow 💚
    • [#1ab4da0] Merge pull request #89 from fslaborg/pythonWorkbookReading
    • [#7fe1c6a] bump to 6.1.2
  • Bugfixes:
    • [#3ba93ef] Fix missing fable includes #90

6.1.2+62db5ab (Released 2024-4-9)

  • Additions:
    • [#62db5ab] update project dependenices on FsSpreadsheet.Core

6.1.1+0f0535a (Released 2024-4-8)

  • Additions:
  • Bugfixes:
    • [#0f0535a] check and fix py xlsx reader rescanning rows

6.1.0+ed6795c (Released 2024-3-19)

  • Additions:
    • [#3f1fb55] start working on json writing
    • [#13dbca2] finish first version of json io functions
    • [#514c204] add json io tests
    • [#02baf70] naming adjustments and docs update
    • [#a6c882c] set ziparchivereader performance test to pending
    • [#9ceda1e] add old xlsx IO functions with deprecation attribute
    • [#5e71fb9] add try json parse functions
  • Bugfixes:
    • [#1586c5a] fix json io datetime issues

6.0.1+360ee6f (Released 2024-3-7)

  • Additions:
    • Hotfix because of erroneous namespace names
    • [#c6aa628] bump to 6.0.0
    • [#c7b4972] updated namespace names according to project name unification
    • [#360ee6f] add minimal documentation

6.0.0+b85ca85 (Released 2024-3-7)

  • Additions:
    • Added release for python
    • Renamed xlsx io packages
    • [#9572480] rename excelpy folder
    • [#491ed1e] update CI and add Python build targets
    • [#9525665] update readme with developer info
    • [#181fc70] unify test project names
    • [#b85ca85] small changes to reduce warnings

5.2.0+c6f526ad (Released 2024-2-23)

  • Additions:
    • [#bbba6d4] start setup of python package
    • [#80dd1b6] add tests for python xlsx io
    • [#992fa5a] add python xlsx io support
    • [#ddcc16d] add runtestspy target
    • [#d69288a] switch to pyxpecto for testing
    • [#2b88258] small speed improvement of reader by skipping sst include on opendocument cell
  • Bugfixes:
    • [#b35f309] finalize python xlsx io test and fixes
    • [#a55336e] fix python xlsx io for default formats

5.1.3+a260549 (Released 2024-2-13)

  • Additions:
    • [#a260549] update tests to change in empty workbook handling
    • [#4eaf806] add fail for writing empty workbook #38
    • [#6cc4d8d] Merge pull request #84 from fslaborg/speed
    • [#c9d00fb] some speed improvements to xlsx reading
    • [#bd9b64b] first draft of experimental ziparchive xlsx reader
    • [#2b88258] small speed improvement of reader by skipping sst include on opendocument cell
  • Bugfixes:
    • [#8da67c9] small fixes and adjustments to xlsx reader and tests
    • [#886dcf2] fix zipArchiveReader against default tests

5.1.2+21fd6e8 (Released 2024-1-30)

  • Additions:
    • [#21fd6e8] improve reader speed by adjusting sharedStringTable usage
  • Bugfixes:

5.1.1+e7cc638 (Released 2024-1-26)

  • Additions:
    • [#e7cc638] improve rowWithRange SkipSearch performance

5.1.0+4732d22 (Released 2024-1-24)

  • Additions:
    • Increase Parser speed
    • [#4732d22] include parse speed test in js
    • [#9aa368f] add speedtest for excel file reader
    • [#f401c96] make RescanRows speed linear

5.0.2+41eca2f (Released 2023-11-3)

  • Bugfixes:
    • [#b45db41] Fxi critical bug in fable compatibility

5.0.1+2958cd9 (Released 2023-10-28)

  • Additions:
    • [#2958cd9] update references from major 3 to major 5
    • [#dff1bf3] Update version and release npm

5.0.0+62ff8ec (Released 2023-10-26)

  • Additions:
    • [#db263ed] Start implementing logic for auto update, but push to backlog for now
    • [#c5bf348] Finish io tests ✔️
    • [#80f7632] Improve DateTime numberFormat recognition
    • [#baa88ce] update libre test file
    • [#9805811] Setup current FsSpreadsheet.Js write for defaultio tests 🚧
    • [#05e0ca4] update gitignore
    • [#2b99506] Further work on #71 change FsCell.Value to obj 💥
    • [#546e029] add stylesheet helper functions
    • [#47615d7] add preliminary stylesheet functionality for cell datetime writing (wip)
    • [#1a71e96] Update files correctly
    • [#326cbba] Make first tests pass ✔️
    • [#085418f] Add FsSpreadsheet tests and update testFile to include Time in DateTime
    • [#4d7c27f] Add boolean column to Default TestWorkbook
    • [#371808c] Make ExcelIO FableExceljs and OpenXML tests pass ✔️
    • [#759c7a0] Update files from TestWorkbook_Excel
    • [#58736f3] make ExcelIO-Excel test pass ✔️
    • [#f468fd0] Parse correct DataType from OpenXML #73
    • [#1ad6c9d] Move TestFiles and setup Utility project #71
    • [#4cc9c25] Improve HeaderRow functions #72
    • [#b8a51bf] add testFile info
    • [#88cffd2] Add io helper scripts
    • [#0811a1d] update xlsx file
    • [#cfdb888] add excel testTable
    • [#eedf32f] Merge pull request #70 from fslaborg/issue_69
    • [#858d6d8] add correct extensions to native js tests
    • [#a54d874] Set correct default for showHeaderRow = false #69
    • [#e0b42c7] Merge pull request #68 from fslaborg/ioExtension
    • [#e903e76] add additional xlsx readers variants
    • [#a4cd326] Merge branch 'main' of https://github.com/CSBiology/FsSpreadsheet
    • [#c69f787] Merge pull request #66 from fslaborg/npmRelease
    • [#63498a9] Add tasks for npm release
    • [#9c7ab69] Add test to verify correct parsing of old ClosedXml
    • [#02d92c2] Update exceljs dependency
    • [#9eb94ea] Update package.json: Mocha timeout for Exceljs JS tests
    • [#f105a75] Merge pull request #64 from CSBiology/feature-moreFsColumnFun-#63
    • [#36a72a2] Update package.json, update and rewrite Release Notes for v4.0.0
    • [#d501225] Add unit tests for newly added functions
  • Bugfixes:
    • [#56d533f] Fix ExcelIO: bool & float write. Fix exceljs: table postion write, cell value type read and write, confusing naming. Add scripts for fsspreadsheet write. ✨🤡
    • [#6fe7f89] Fix ci
    • [#17a9cf8] Fix embedded ressource path
    • [#26c574d] fix libre file parsing and update test files
    • [#47e696b] update spreadsheet file and final fixes for dotnet reader
    • [#5f6c8da] Fix DateTime format 🐛
    • [#d6e85cb] Fix DateTime and paths for build chain
    • [#3a60e29] Fix paths, but exceljs parses DateTime differently 🚧
    • [#77b722d] Fix read in for boolean type DataType 🐛
    • [#c7b88b6] try fix CI
    • [#116962e] Fix error in fsspreadsheet not writing table.name only displayname
    • [#2ea7401] fix package.json publish bug 🐛

4.0.0+5d5067f (Released 2023-8-11)

  • Additions:
    • [#19bd2a8] Add MinRowIndex and MinColIndex to FsColumn
    • [#5c2e616] Add HasCellAt to FsColumn
    • [#3e7b7d2] Add TryItem functionality to FsColumn
    • [#5d5067f] Add dense column functionality
    • [#ac14e0d] Add unit tests for column index getting and base cells in FsRow
    • [#36b2b16] Add tests for FsRow
    • [#05f19ae] Add GetRowCount functionality to FsRangeBase
    • [#aa4938c] Add GetRows functionality to FsTable
    • [#2a29cfe] Add FsRow members: TryItem, ToDenseRow, HasCellAt, MinColIndex, MaxColIndex
      • [#c228e7f] Change npm dependency to exceljs fork
    • [#5625b33] Update more tests
    • [#4378808] Update gitignore
    • [#cb35186] Update and clean up RELEASE_NOTES.md
    • [#489f6b7] Add logo to Exceljs project file
    • [#caf21db] INcrease package.json version together with fake task.
    • [#2b9c7fa] Add some tests for exceljs
    • [#1fd0e34] Add fable necessities to fsproj.
    • [#72bb41e] Write some tests #54
    • [#95c5d16] Push WIP state
    • [#58b57ae] Start refactoring to resizeArray 🔨#53
    • [#5ed3752] Specify code snippet
    • [#4a9ff2e] Initiate test setup for FsSpreadsheet.Js
    • [#d785795] Finish Api for both f# fable access and js native ✨
    • [#1456337] update gitignore
    • [#97f712c] setup msbuild
    • [#efa9815] Init FsSpreadsheet.Js and add Fable.Exceljs dependency
    • [#c4fdce6] improve testsuit
    • [#33eb847] cleanup test tasks
    • [#3116aae] Add dotnet tool femto
    • [#eb7160d] Update .gitignore
  • Deletions:
    • [#7779011] delete dist
    • [#2253fb1] Remove some js tests until fsspreadsheet syntax better fits js.
    • [#146d920] Delete .zip 🔥
    • [#6b3a27b] remove annoying warning
  • Bugfixes:
    • [#2b3b30b] Fix critical JS bug in column index getting
    • [#d14448e] Fix Async/Promises and fsspreadsheet readin 🎉
    • [#a96bcd0] fix timeout issue 🐛
    • [#a680d45] fix xlsxparser picking the wrong name fix teststrings
    • [#5293ae9] hotfix table not written correctly #49
    • [#53b109c] fix datatypes in fs->js conversion + finish tests

3.1.1+64f86ec (Released 2023-7-25)

3.1.0+0d7e699 (Released 2023-7-19)

  • Additions:
    • [#af1920a] add attachmembers attribute to FsCell
  • Bugfixes:
    • [#d6f86d2] test and fix writeAndReadSpreadsheet

3.0.0+4da5e50 (Released 2023-7-18)

  • Additions:
    • [#a9c1f29] Update test project dependencies for Fable compatability
    • [#1c9f1bd] use attachmembers for improved javascript transpilation
    • [#6085c47] improve comments
    • [#4da5e50] Merge pull request #34 from CSBiology/fable
  • Bugfixes:

2.0.3+3a1d082 (Released 2023-7-18)

  • Additions:
    • [#3a1d082] Bump project version dependencies

2.0.2+1b8d874 (Released 2023-7-17)

  • Additions:
    • latest commit #1b8d874
  • Bugfixes:
    • [#a72d301] Fix bug with read Xlsx file having no FsRows
    • [#0dfd1f0] Add unit test for bug case

2.0.1+bd195cc (Released 2023-5-11)

  • Additions:
  • Deletions:
    • [#bd195cc] remove deprecated functions and fill incomplete matches

2.0.0+2b67a3f (Released 2023-5-11)

  • Additions:
  • Deletions:
    • [#d158414] remove argument exception mapping
  • Bugfixes:
    • [#1c72afb] Fix cell getValueAs<_> for fable ✨

1.3.0-preview+549125f (Released 2023-4-24)

  • Additions:
    • [#549125f] add Columns field to FsTable
    • [#a43daef] rename members and set old counterparts as obsolete
    • [#d25b0ac] add tests and call them with runtests target
    • [#7840c1d] add IEnumerable interface to rows
    • [#768858b] add FsColumn type
    • [#bbed3ca] Add Interactive extension with tests for formatters
    • [#97ec087] Add nuget package metadata
    • [#571cab1] Comment
    • [#a3de3cb] Update ///
    • [#d5f599b] Update ///-comments & test CellValues
    • [#38864cb] Add critical error when creating FsRows
    • [#0f443f1] Replace unallowed constructor pattern
  • Bugfixes:

1.0.1+99dfa53 (Released 2023-3-23)

  • Additions:
    • [#3031151] Add tryGetById function
    • [#6be69e2] Add getCellsBySheetId function
    • [#d23ac45] Replace way to get cells from bySheetIndex to bySheetID
    • [#3fa594c] Add unit tests for edgecase XlsxFiles
  • Bugfixes:

1.0.0+6f3ddf9 (Released 2023-3-23)

  • Additions:
    • [#2c052d9] rename Missing to SheetEntity
    • [#b3225ef] allow cell, row and column builders yield optional or required operator
    • [#4a8649a] make SheetEntity type more robust
    • [#ec31b63] change target framework
    • [#fa28800] allow message type to be exception
    • [#bfd58ae] add csv writing capabilities
    • [#41ea33a] replace build script by build project
    • [#bf9b8ea] rename ok operator to some to match SheetEntity case name
    • [#fd7e783] change dsl operator names
    • [#8e4e4f6] update test project target framework to net7.
    • [#9ef1e5f] init restructuring in functional style
    • [#575f50a] rows now carry cell collection
    • [#3d7d20f] Add static methods for FsWorksheet & FsRow
    • [#4fd2d54] Add functionality & Triple Slash docu
    • [#7017802] Add static methods for FsCell
    • [#dc4fe4b] Add (static & non-static) methods for FsCellsCollection
    • [#fd6fe47] Format FsRow.fs
    • [#75d7ca4] Add ((non-)static) methods to FsWorkbook.fs
    • [#eb90e97] Add static methods and ///-docu for XLSX writer extensions
    • [#5666834] Add FsTable import functionality
    • [#0793f35] Move Table.toFsTable to FsExtensions
    • [#fe41eb2] Add more alternative constructor for FsWorksheet
    • [#e47d58c] Rename OpenXML-based methods
    • [#352833c] Comment out unfinished code to prevent building errors
    • [#0a86811] Comment out warn-inducing elements
    • [#3fdee6b] Rename FsRangeAdress.fs into correct english
    • [#a2fc967] Add playground script file for testing/developing purposes
    • [#fe288fd] Rename WorkSheet.fs to match module name
    • [#b3774e3] Renamed file again because Git does not understand
    • [#be9722d] Re-renamed file to correct name
    • [#f766dea] Reuse method instead of copypasting 95 % of the code
    • [#3485e4b] Add annotation
    • [#1189756] Add function to tranlate CellValue to DataType
    • [#76ae1cf] Format format
    • [#8710d88] Add function to get Tables in WorksheetPart
    • [#ca54bf7] Play around in playground
    • [#55b5b61] Restructure format of FsCellsCollection
    • [#e83138b] Restructure format of FsWorksheet
    • [#45c5284] Correct naming mistake
    • [#290f281] Add methods to check for FsCell presence
    • [#80ae5de] Change method name for consistency reasons
    • [#d4e2fd4] Restructure format of FsRow
    • [#2d3b618] Add static methods for retrieving FsCells
    • [#555cee5] Add exception for creation with an inappropriate FsCellsCollection
    • [#3afa531] Play around in playground
    • [#9201282] Add critical annotation to properties
    • [#0abafea] Add method to more easily add FsCells
    • [#d1b31ad] Play around in playground
    • [#ea90984] Add blueprint of method to implement later
    • [#a004ddc] Add several add methods
    • [#95a0866] Add alternate constructor (WIP)
    • [#efca757] Play around in playground
    • [#c66189a] Add Unit Test for DataType
    • [#910117a] Reformat format of FsAddress for readability/findability
    • [#28b7f54] Rename ambiguous method
    • [#65dbd74] Add methods for FsAddress
    • [#3337d57] Add unit tests for FsAddress
    • [#ea32c22] Add more unit tests for FsCell
    • [#c091bad] Let UpdateIndices method return the object
    • [#8526c91] Add ignore to not-used value
    • [#c430d2d] Play around in playground
    • [#b4ef99c] Add XML tags to member description
    • [#5ceff21] Add XML tags to member description
    • [#12a5060] Sheet Index and SheetId ambiguity
    • [#dff7243] Add IO testing data
    • [#adb5812] Add Test project for FsSpreadsheet.ExcelIO
    • [#373f774] Move data folder for Xlsx tests into FsSpreadsheet.ExcelIO folder
    • [#f354f13] Add Expecto test call
    • [#3f6e431] Format format
    • [#866dc33] Add Spreadsheet tests
    • [#24bdd61] Add Workbook tests
    • [#0d60c04] Add Sheet tests
    • [#2858ed8] Add more Spreadsheet tests
    • [#4c07ac1] Change tested property
    • [#77e15a7] Add Cell tests
    • [#f08ba18] Refactoring FsCell
    • [#79b4e85] Merge FsCell Testing
    • [#653a5af] Add FsWorksheet add FsCell
    • [#31b6789] Add FsSparseMatrix
    • [#f518d9f] Add FsCell construtcor IConvertible value
    • [#31bdfa9] Update tryItem to be 1-based like the OpenXML implementation
    • [#c1d54b2] Update testCells to have their real values instead of SST index
    • [#96f5b36] Add FsWorkbook FromXlsxStream extension
    • [#939537a] Refactor FsWorkbook
    • [#bce8df8] Play around in playground
    • [#38cec72] Add ///-XML tags
    • [#6480c95] Add static method for reader method
    • [#1a066bc] Add FsWorksheet table methods alongside respective tests
    • [#80f8aa5] Git still does not understand changes in letter case, part I
    • [#ccf81f0] Git still does not understand changes in letter case, part II
    • [#2368b70] Add .AddTables functionality (+ unit tests)
    • [#c08383b] Reformat code structure
    • [#c6c064f] Add methods to get FsWorksheet by name + unit tests
    • [#b458922] Finalize FromXlsxStream method
    • [#d641f1e] Add unit tests for FromXlsxStream method (WIP)
    • [#536a1e3] Add CellValues to DataType conversion (+ unit tests)
    • [#488b249] Specify member description
    • [#380a08d] Precise ofXlsxCell method alongside with unit tests
    • [#8e9c768] Update test Xlsx file
    • [#68f79c5] Play around in playground
    • [#3dc6434] Rename incorrectly named source file
    • [#ba5aa72] Finalize unit tests for fsWorkbookFromStream method
    • [#c531ab7] Play around in playground
    • [#393b02d] Add fromXlsxFile method
    • [#a76e289] Add method for getting FsTables from FsWorkbooks
    • [#0857107] Add unit tests for GetTables
    • [#0062c62] Add method to get the FsWorksheet of an FsTable
    • [#4999caf] Add method to add several FsWorksheets + unit tests
    • [#8ec63bc] Add some ///-description
    • [#6cf942d] Add more FsTable methods
    • [#a97d858] Add address returning methods to FsCellsCollection
    • [#212e97d] Change exception for 0,0 indices in GetFirstAddress()
    • [#e5b112c] Add FsCellsCollection tests (WIP)
    • [#3147906] Add FsTable tests (WIP)
    • [#f90b0dc] Finalize current FsCellsCollection tests
    • [#8bd24c5] Add ///-description
    • [#2a18dd3] Update FsTable tests (WIP)
    • [#c4291fb] Add table field unit tests (WIP)
    • [#ec3aca9] Add cellsColl deep copy (WIP)
    • [#440b213] Add rangeBase annotations
    • [#9b8de2e] Add commented alternative constructor
    • [#31a9cbf] Add static methods, update existing methods
    • [#0e4c2e4] Update index setter & DataCells
    • [#0764502] Finalize FsTableField unit tests
    • [#f443bfb] Update FsTable functionality (WIP)
    • [#ee6ef1b] Play around in playground
    • [#ead7004] Add method to add several fields at once to table
    • [#cfb5e4e] Add unit tests to FsTable
    • [#df5125c] Add method for creating range cols out of addresses
    • [#43aad4a] Adjust method return for FsAddress
    • [#6966580] Reformat FsCell structure
    • [#291d6c8] Setup docs, add some methods, downgrade to .NET 6, ...
    • [#772a315] Add build.sh to sln
    • [#811f491] Update build and deploy actions
    • [#cbc91db] Update Logo
    • [#af5a98b] Add FsTable unit tests (WIP)
    • [#2069ed9] Add deep copy methods to all relevant classes
  • Deletions:
    • [#89c3945] Add remove methods to FsCellsCollection
    • [#8647c3e] Add methods to remove FsCell values
    • [#153c485] Delete sample Unit Test
    • [#7269a09] Delete wrong exception
    • [#55a766a] Delete '.' from message due to it confusing YoloDev adapter
    • [#cd32696] FsCell Remove alternatve constructors
  • Bugfixes:
    • [#94211fc] Fix error (wrong member call)
    • [#810424f] Fix critical FsWorksheet error and add non-static methods for functionalities
    • [#5a8fff4] Fix naming-related error
    • [#5b857a6] Fix critical error in getter method
    • [#ef97805] Fix critical error according to the correct meaning of properties
    • [#122964b] Fix merge
    • [#5fd9bc2] Fix error when trying to get colIndex
    • [#7bf051d] Fix typo in test file
    • [#afdab8e] Fix critical XlsxCell error (+ respective unit test)
    • [#05437d7] Fix null reference error (+ unit test)
    • [#d6abf25] Fix possible error due to hard coding
    • [#1bf0ffd] Fix typo
    • [#448ccda] Add and fix table field functionality
    • [#5437128] Finalize FsTable, fix indexing error
    • [#dceac83] Update table unit tests, fix XML comment typos
    • [#6f3ddf9] Fix critical return type error

0.2.2+b86ecfd (Released 2023-2-3)

  • Additions:
    • [#b86ecfd] add additional yield method to DSL

0.2.1+927f365 (Released 2022-12-12)

  • Additions:
    • latest commit #927f365
  • Bugfixes:

0.2.0+8084a32 (Released 2022-12-12)

  • Additions:
    • [#8084a32] allow for trailing spaces to be preserved when writing strings

0.1.7+a227766 (Released 2022-6-24)

  • Additions:
    • latest commit #a227766
  • Bugfixes:

0.1.6+807ec9b (Released 2022-6-21)

  • Additions:
    • [#d097bd3] add table to dsl
    • [#cfc60cc] start working on TableBuilder for DSL
    • [#a85093f] Add basic coding examples to ReadMe.md

0.1.5+7250efd (Released 2022-5-10)

  • Additions:
    • latest commit #7250efd
  • Bugfixes:
    • [#7250efd] fix dataType of cells always being text
    • [#6d12edf] fix bug where empty rows made Excel writer crash
    • [#b70044a] fix dsl section order

0.1.4+4f2bb3b (Released 2022-5-9)

  • Additions:
    • latest commit #4f2bb3b
    • [#4f2bb3b] allow ColumnBuilder to yield Missing values

0.1.3+a18c48b (Released 2022-4-12)

  • Additions:
    • latest commit #a18c48b
    • [#5bf131f] add convenience functions for dropping dsl items
    • [#52b95e0] add cellbuilder
    • [#705edd9] rework dsl operators

0.1.2+c854ed6 (Released 2022-4-11)

  • Additions:
    • latest commit #c854ed6
  • Bugfixes:

0.1.1+aae6edd (Released 2022-3-31)

  • Additions:
    • latest commit #aae6edd
  • Bugfixes:
    • [#aae6edd] fix row functions failing when reading empty cells

0.1.0+268b900 (Released 2022-3-31)

  • Additions:
    • latest commit #268b900
    • [#268b900] add columnbuilder tp dsl
    • [#eed6806] add sheet and workbook builder to DSL
    • [#ed45200] add optional and required cells to DSL

0.0.2+2f09131 (Released 2022-1-21)

  • Additions:
    • latest commit #2f09131
    • [#2f09131] add basic dsl

0.0.1+7be5a42 (Released 2022-1-20)

  • Additions:
    • Setup basic types based on ClosedXML
    • Add Sheetbuilder based on ClosedXML.SimpleSheets
    • Copy DocumentFormat.OpenXML wrapper functions from FSharpSpreadsheetML
    • Setup excel write functionality