OSDN Git Service
barlevd [Tue, 30 Apr 2024 16:05:05 +0000 (19:05 +0300)]
This closes #1889, refs #1732 and #1735 (#1890)
Saving workbook with reverse sorted internal part path to keep same hash of identical files and fix incorrect MIME type
xuri [Sat, 27 Apr 2024 12:13:43 +0000 (20:13 +0800)]
This closes #1886, remove the namespace prefix for the default spreadsheet namespace
- Improvement compatibility for the workbook internal part with a spreadsheet namespace prefix
- Update GitHub Action configuration, using the macOS 13 in the unit test pipeline to temporarily resolve test failed in macos-14-arm64
xuri [Thu, 25 Apr 2024 16:23:10 +0000 (00:23 +0800)]
Fix a v2.8.1 regression bug, error on duplicate rows, if conditional formatting or data validation has multiple cell range reference
- Update unit tests
jianxinhou [Thu, 18 Apr 2024 05:21:46 +0000 (13:21 +0800)]
This closes #1879, compatible with the escaped quote symbol in none formula data validation rules (#1880)
- Update dependencies module to fix vulnerabilities
- Update unit tests
Co-authored-by: houjianxin.rupert <houjianxin.rupert@bytedance.com>
Nima [Thu, 11 Apr 2024 15:12:56 +0000 (18:42 +0330)]
This closes #1874, reduces memory usage for the GetRows function (#1875)
- Avoid allocate memory for reading continuously empty rows on the tail of the worksheet
xuri [Wed, 3 Apr 2024 00:44:46 +0000 (08:44 +0800)]
This closes #1867, breaking changes: change the data type for the ConditionalFormatOptions structure field Format as a pointer
xuri [Tue, 2 Apr 2024 00:47:57 +0000 (08:47 +0800)]
Support get the cell images inserted by IMAGE formula function
xuri [Mon, 1 Apr 2024 00:49:21 +0000 (08:49 +0800)]
This closes #1865, unescape newline character in stream writer
- Update dependencies module
yunkeweb [Thu, 28 Mar 2024 08:37:35 +0000 (16:37 +0800)]
Support get rich data value rels index from rich value part (#1866)
yangyile-yyle88 [Wed, 27 Mar 2024 07:50:51 +0000 (14:50 +0700)]
Introduce new exported PictureInsertType enumeration (#1864)
Matthew Sackman [Tue, 26 Mar 2024 15:19:23 +0000 (15:19 +0000)]
Add support for get the Microsoft 365 cell images (#1857)
- Update unit tests
xuri [Mon, 25 Mar 2024 00:33:29 +0000 (08:33 +0800)]
This closes #1861, fix missing parentheses in the adjusted formula
- Allow adjust cell reference with max rows/columns
- Fix incorrect data validation escape result
- Update out date reference link in the documentation
- Update unit tests
realzuojianxiang [Fri, 22 Mar 2024 08:09:45 +0000 (16:09 +0800)]
This closes #1851, and closes #1856 fix formula calculation result round issue (#1860)
- The SetSheetName function now support case sensitivity
- Update unit tests
vic [Tue, 19 Mar 2024 00:58:52 +0000 (08:58 +0800)]
This closes #1847, support apply number format with alignment (#1852)
- Update dependencies module
- Update unit tests
hu5ky [Fri, 15 Mar 2024 03:36:34 +0000 (11:36 +0800)]
This fix performance impact introduced in #1692 (#1849)
Co-authored-by: chun.zhang2 <chun.zhang2@geely.com>
- This fix speed slowdown and memory usage increase base on the reverts commit
6220a798fd79231bf4b3d7ef587bb2b79d276710
- Fix panic on read workbook with internal row element without r attribute
- Update the unit tests
yeahyear [Wed, 13 Mar 2024 06:39:22 +0000 (14:39 +0800)]
Typo fix for the comment of the extractStyleCondFuncs variable (#1846)
Signed-off-by: yetyear <flite@outlook.com>
Evan lu [Wed, 6 Mar 2024 01:26:38 +0000 (09:26 +0800)]
This closes #1835, support get data validations which storage in the extension lists (#1834)
xuri [Mon, 4 Mar 2024 13:40:27 +0000 (21:40 +0800)]
This closes #1830, closes #1831, and closes #1833
- Fix a v2.8.1 regression bug, auto filter does not work in the LibreOffice
- Fix a v2.8.1 regression bug, support to adjust data validation with multiple cell range
- Fix incorrect result data type of the DATE formula function
- Update the unit tests
Paolo Barbolini [Sun, 3 Mar 2024 01:39:50 +0000 (02:39 +0100)]
Optimize getSharedFormula to avoid runtime.duffcopy (#1837)
陈王 [Fri, 1 Mar 2024 02:12:17 +0000 (10:12 +0800)]
This closes #1825, made AddDataValidation and DeleteDataValidation functions concurrency safe (#1828)
- Remove the receiver of internal coordinatesToRangeRef, squashSqref and flatSqref functions
- Update unit tests
Co-authored-by: chenwang <chenwang@shinsson.com>
岳晨旭 [Thu, 29 Feb 2024 01:16:39 +0000 (09:16 +0800)]
This closes #1819, closes #1827, formula function ISNUMBER, OR and FIND support matrix arguments (#1829)
- Keep minimum column and row number in formula operand when deleting columns and rows
- Update unit tests
helloWorld [Tue, 27 Feb 2024 08:43:47 +0000 (16:43 +0800)]
Clear slave cells value when merging cells (#1824)
xuri [Sun, 25 Feb 2024 18:22:51 +0000 (02:22 +0800)]
This closes #1819, formula calculation engine support array formulas
- Improve the defined name and table name validation rules
- Rename internal variable names to avoid the same with Go 1.21's built-in min and max functions
- Simplify data type conversion in internal code
- Update GitHub Actions workflow configuration, test on Go 1.22.x, and disable Go module cache
- Update dependencies module
Ed [Sat, 24 Feb 2024 01:11:31 +0000 (19:11 -0600)]
This closes #1820, converted styleFillVariants from slice to func (#1821)
Vivek Kairi [Thu, 15 Feb 2024 05:30:07 +0000 (11:00 +0530)]
This closes #1815, cell value reading functions inherit the Options settings of the OpenReader (#1816)
Co-authored-by: Vivek Kairi <vivek@zerodhafundhouse.com>
zhukewen [Sun, 4 Feb 2024 16:06:38 +0000 (00:06 +0800)]
This closes #1807, calculation engine support date and formula type cell (#1810)
Co-authored-by: zhualong <274131322@qq.com>
coolbit [Sun, 4 Feb 2024 14:31:03 +0000 (22:31 +0800)]
This closes #1805, support set chart axis font family, size and strike style (#1809)
- Update unit test workflow dependencies package version
funa12 [Fri, 2 Feb 2024 02:11:16 +0000 (11:11 +0900)]
Fix CalcCellValue does not return raw value when enable RawCellValue (#1803)
xxxwang1983 [Tue, 30 Jan 2024 01:58:24 +0000 (09:58 +0800)]
This closes #1794, add new GetBaseColor function (#1798)
Co-authored-by: wangjingwei <wang.jingwei@joyratel.com>
cherry [Mon, 29 Jan 2024 02:18:21 +0000 (10:18 +0800)]
This closes #1792, support to update defined names reference when rename worksheet (#1797)
Jerry [Thu, 25 Jan 2024 06:39:21 +0000 (14:39 +0800)]
ref #65, new formula function: DBCS (#1791)
Co-authored-by: wujierui <wujierui@jimabrand.com>
L4nn15ter [Wed, 24 Jan 2024 06:01:56 +0000 (14:01 +0800)]
This closes #1789, delete VML shape on delete comment (#1790)
- Improve delete cell comment shape compatibility with KingSoft WPS
- Update unit test
MELF晓宇 [Mon, 22 Jan 2024 01:41:57 +0000 (09:41 +0800)]
This closes #1786, support set fill color of the chart (#1788)
- Add a new field Fill in Chart, ChartPlotArea, and ChartMarker struct
- Support set solid color or transparent fill for chart area, plot area, and maker
327674413 [Sat, 20 Jan 2024 16:05:28 +0000 (00:05 +0800)]
This closes #1783, support set conditional formatting with multiple cell ranges (#1787)
3zmx [Thu, 18 Jan 2024 07:31:43 +0000 (15:31 +0800)]
ref #65, support _xlfn.ANCHORARRAY formula function (#1784)
- Initial formula array calculation support
- Update unit test and documentation
xuri [Tue, 9 Jan 2024 12:56:20 +0000 (20:56 +0800)]
This closes #1777, fix the GetStyle or GetConditionalStyle function to returns incorrect DecimalPlaces field value
- Update documentation for the NewStyle function
- Update unit tests
- Update dependencies Go module
- Update GitHub workflow dependencies package version
- Update copyright agreement statement
xuri [Sat, 30 Dec 2023 06:41:16 +0000 (14:41 +0800)]
This closes #1770, fix incorrect multiple conditional formats rules priorities
- Rename variable name hCell to topLeftCell, and rename vCell to bottomRightCell
- Update the unit tests
xuri [Thu, 28 Dec 2023 08:38:13 +0000 (16:38 +0800)]
This closes #1769 and closes #1770, support multiple conditional formats rules
- Update the unit tests
xuri [Mon, 25 Dec 2023 13:51:09 +0000 (21:51 +0800)]
This recover the Sizes field in the ChartSeries data type removed in commit
dfaf418f340f260c5005e8343135cd6af60b8e58
- Update unit tests and documentation of the internal uintPtr function
xuri [Fri, 22 Dec 2023 12:49:14 +0000 (20:49 +0800)]
This closes #1767, change struct field tabRatio date type to float64
xuri [Tue, 19 Dec 2023 15:39:45 +0000 (23:39 +0800)]
Breaking changes: Go 1.18 and later required
- This made the GetPictureCell function support get embedded cell images
- Update dependencies module
- Update GitHub workflow
- Update documentation for the AddChart function
li [Fri, 15 Dec 2023 05:09:42 +0000 (13:09 +0800)]
This closes #664, support get embedded cell images (#1759)
Co-authored-by: liying05 <liying05@zhidemai.com>
yuegu520 [Wed, 13 Dec 2023 16:03:53 +0000 (00:03 +0800)]
This closes # 1704, support set the data labels position for the chart (#1755)
- Breaking change: remove the Sizes field in the ChartSeries data type
- Add new field DataLabelPosition in the ChartSeries data type, support to sets the position of the chart series data label
- Add new field BubbleSize in the Chart data type, support set the bubble size in all data series for the bubble chart or 3D bubble chart
- Add new exported ChartDataLabelPositionType data type
- Update docs and unit test for the AddChart function
- Fix a v2.7.1 regression bug, the bubble is hidden in the bubble or 3D bubble chart, commit ID:
c2d6707a850bdc7dbb32f68481b4b266b9cf7367
Xuesong [Wed, 13 Dec 2023 01:22:41 +0000 (09:22 +0800)]
This closes #1749, fix incorrect adjust merged cells on remove rows (#1753)
cui fliter [Sat, 9 Dec 2023 04:08:29 +0000 (12:08 +0800)]
Remove unused exported struct ShapeColor (#1746)
Signed-off-by: cui fliter <imcusg@gmail.com>
xuri [Thu, 7 Dec 2023 16:09:06 +0000 (00:09 +0800)]
This closes #1745, prevent panic on get conditional format without above average rules
- Define internal map variable globally instead of inside of functions
cui fliter [Thu, 7 Dec 2023 07:22:26 +0000 (15:22 +0800)]
This fix some function names in comment (#1747)
Signed-off-by: cui fliter <imcusg@gmail.com>
天爱有情 [Sat, 2 Dec 2023 04:03:09 +0000 (12:03 +0800)]
Support unset custom row height if height value is -1 (#1736)
- Return error if get an invalid row height value
- Update unit tests and update documentation of the SetRowHeigth function
user65536 [Thu, 30 Nov 2023 16:31:41 +0000 (00:31 +0800)]
This closes #1732, saving workbook with sorted internal part path (#1735)
Bram Vanbilsen [Tue, 28 Nov 2023 16:13:39 +0000 (10:13 -0600)]
This closes #1729, support copy conditional format and data validation on duplicate row (#1733)
zcgly [Fri, 24 Nov 2023 18:03:33 +0000 (02:03 +0800)]
This support set column style with default width in sheet props settings (#1728)
xuri [Wed, 22 Nov 2023 16:03:10 +0000 (00:03 +0800)]
Recalculate and use the same shared string count and unique count to overwrite incorrect existing values
ZX [Tue, 21 Nov 2023 03:23:54 +0000 (11:23 +0800)]
Fixed invalid shared string table index on set cell value (#1725)
Tian [Mon, 20 Nov 2023 15:57:45 +0000 (23:57 +0800)]
The GetCellRichText function support to return inline rich text (#1724)
Co-authored-by: jintian.wang <jintian.wang@mihoyo.com>
lujin [Sat, 18 Nov 2023 08:44:45 +0000 (16:44 +0800)]
This closes #1723, fix panic on read workbook in some cases (#1692)
- Fix panic on read workbook with internal row element without r attribute
- Check worksheet XML before get all cell value by column or row
- Update the unit tests
Tajang [Thu, 16 Nov 2023 01:34:37 +0000 (09:34 +0800)]
Fix panic on GetPictureCells without drawing relationships parts (#1721)
15535382838 [Wed, 15 Nov 2023 04:49:18 +0000 (22:49 -0600)]
This add new exported function GetHeaderFooter (#1720)
Yang Li [Tue, 14 Nov 2023 01:47:57 +0000 (09:47 +0800)]
Support set time period type conditional formatting (#1718)
xuri [Sun, 12 Nov 2023 16:16:29 +0000 (00:16 +0800)]
Support 5 new kinds of conditional formatting types
- New conditional formatting types: text, blanks, no blanks, errors, and no errors
- Support calculate formula with multiple dash arithmetic symbol
- Fix empty calculate result with numeric arguments in LEN, LOWER, PROPER, REPT, UPPER, and IF formula functions
- Uniform double quote in calculation unit tests
- Update unit tests
xuri [Fri, 10 Nov 2023 16:04:05 +0000 (00:04 +0800)]
Support update data validations on inserting/deleting columns/rows
ByteFlyCoding [Fri, 10 Nov 2023 01:25:59 +0000 (09:25 +0800)]
Support update conditional formatting on inserting/deleting columns/rows (#1717)
Return error for unsupported conditional formatting rule types
Nick [Wed, 8 Nov 2023 16:15:10 +0000 (00:15 +0800)]
Update data validation type and operator's enumerations (#1714)
xuri [Tue, 7 Nov 2023 16:01:35 +0000 (00:01 +0800)]
Support update defined names on inserting/deleting columns/rows
Marko Krstic [Tue, 7 Nov 2023 00:46:01 +0000 (01:46 +0100)]
This closes #1712, reduce memory consumption (#1713)
Anton Petrov [Mon, 6 Nov 2023 01:51:19 +0000 (04:51 +0300)]
This closes #1125, support update drawing objects on inserting/deleting columns/rows (#1127)
magicrabbit [Sat, 4 Nov 2023 00:02:09 +0000 (08:02 +0800)]
Fix number format scientific notation zero fill issues (#1710)
xuri [Thu, 2 Nov 2023 16:12:43 +0000 (00:12 +0800)]
This closes #1706 and closes #1708
- Add export ChartLineType enumeration to specify the chart line type
- Add new Border field in the Chart type to set the chart area border
- Add new Type field in the ChartLine type to set the line type
- Fix some format missing on get style definition
- Update the unit tests
xuri [Wed, 1 Nov 2023 16:15:41 +0000 (00:15 +0800)]
Support update volatile dependencies on inserting/deleting columns/rows
rjtee [Tue, 31 Oct 2023 16:52:18 +0000 (00:52 +0800)]
Support to adjust formula cross worksheet on inserting/deleting columns/rows (#1705)
xuri [Mon, 30 Oct 2023 16:01:57 +0000 (00:01 +0800)]
This improves compatibility for adjusting tables and formula references on inserting/deleting columns or rows
rjtee [Sun, 29 Oct 2023 05:40:21 +0000 (13:40 +0800)]
Support adjust formula for entire cols/rows reference (#1702)
- Update the unit tests
rjtee [Mon, 23 Oct 2023 16:05:52 +0000 (00:05 +0800)]
This closes #1306 and closes #1615 (#1698)
- Support adjust formula on inserting/deleting columns/rows
xuri [Thu, 19 Oct 2023 16:04:31 +0000 (00:04 +0800)]
This closes #1694, using namespace prefix in workbook theme XML
- Improve compatibility with the viewer which doesn't support default theme part namespace
- ref #1690, support read background color style, and conditional format with default pattern type
- Update the unit tests
xuri [Tue, 17 Oct 2023 00:52:34 +0000 (08:52 +0800)]
This closes #1690, new exported function `GetConditionalStyle`
- Support get the conditional format style definition
- Update the unit test
壹次心 [Thu, 12 Oct 2023 16:06:07 +0000 (00:06 +0800)]
This closes #1218 and closes #1689 (#1634)
- Introduce new exported function GetPictureCells
- Upgrade dependencies module golang.org/x/net from 0.16.0 to 0.17.0
- Update unit tests
Eng Zer Jun [Thu, 12 Oct 2023 01:23:31 +0000 (09:23 +0800)]
Remove redundant `len` check in `GroupSheets` and `UngroupSheets` (#1685)
xuri [Tue, 10 Oct 2023 16:04:38 +0000 (00:04 +0800)]
This closes #1687 and closes #1688
- Using sync map internally to get cell value concurrency safe
- Support set the height and width for the comment box
- Update the unit test
xuri [Mon, 9 Oct 2023 16:04:10 +0000 (00:04 +0800)]
Support format cell value with fraction number format code
- Fix delete incorrect image files when picture deleting pictures
- Update the unit test and dependencies modules
xuri [Sun, 8 Oct 2023 16:14:56 +0000 (00:14 +0800)]
This closed #1680, fixing a potential issue that stream reader temporary files can not be clear
- Delete image files from the workbook internally when deleting pictures to reduce generated workbook size and resolve potential security issues
xuri [Sat, 7 Oct 2023 16:06:11 +0000 (00:06 +0800)]
This closes #1681, closes #1683
- Fix incorrect formula calculation result
- Introduce new exported function `SetCellUint`
- Updates unit test
- Typo fixed
Abdelaziz-Ouhammou [Fri, 6 Oct 2023 16:05:50 +0000 (19:05 +0300)]
Keep all cells value in the table range when deleting table (#1684)
xuri [Thu, 5 Oct 2023 16:04:38 +0000 (00:04 +0800)]
This fix #1682, removes table and content type parts when deleting the table
- Move worksheet-related functions in one place
xuri [Wed, 4 Oct 2023 16:08:31 +0000 (00:08 +0800)]
This improves performance for adding and removing pivot table
dependabot[bot] [Tue, 3 Oct 2023 16:11:50 +0000 (00:11 +0800)]
Update actions/checkout from 3 to 4 (#1676)
xuri [Mon, 2 Oct 2023 16:59:31 +0000 (00:59 +0800)]
Add new exported function `DeletePivotTable`
- Support adding pivot table by specific table name
- Update unit tests
xuri [Sun, 1 Oct 2023 16:06:38 +0000 (00:06 +0800)]
This closes #1677, fix the incorrect custom number format ID allocated
- Improve compatibility with empty custom number format code
xuri [Sun, 1 Oct 2023 05:37:47 +0000 (13:37 +0800)]
ref #65, formula functions TEXTAFTER and TEXTBEFORE (array formula not support yet)
xuri [Thu, 28 Sep 2023 00:53:54 +0000 (08:53 +0800)]
This sorted exported error constants by name and listed them in one place
xuri [Tue, 26 Sep 2023 16:05:59 +0000 (00:05 +0800)]
The `AddSlicer` function now support create pivot table slicer
xuri [Wed, 20 Sep 2023 16:06:31 +0000 (00:06 +0800)]
This fix #1665, supports getting formula string cell value
- Improve compatibility for absolute path drawing part
- Fix incorrect table ID generated in the workbook which contains single table cells
- Fix missing relationship parts in the content types in some cases
- Upgrade number format parser to fix missing literal tokens in some cases
- Update built-in zh-cn and zh-tw language number format
- Ref #65, init new formula function: TEXT
- Remove duplicate style-related variables
- Update the unit tests
xuri [Sun, 17 Sep 2023 10:30:58 +0000 (18:30 +0800)]
This closes #1661, fix incorrect time number format result
xuri [Sat, 16 Sep 2023 04:21:11 +0000 (12:21 +0800)]
Introduce the new exported function `AddSlicer` for adding table slicer
- Fix a v2.8.0 regression bug, generate workbook corruption caused by incorrect MRU colors style parts
- Fix corrupted workbooks generated when adding tables in some cases
- Added several exported extension list child element URI constants
- Move part of the internal constant and variables definition to the template source code file
- Updated unit tests
xuri [Thu, 14 Sep 2023 14:56:28 +0000 (22:56 +0800)]
This fixes #1658
- Fix a v2.8.0 regression bug, number format code apply result was empty
- Fix calculate formula functions CHITEST and MMULT panic in some cases
- Updated unit tests
xuri [Sat, 9 Sep 2023 05:51:00 +0000 (13:51 +0800)]
This fixes #1645 and fixes #1655
- Breaking changes, change the data type for the `HeaderFooterOptions` structure fields `AlignWithMargins` and `ScaleWithDoc` as a pointer
- Fixed panic on `AutoFilter` by adding nil pointer guard for local sheet ID
- Allow dot character in the defined name, table name, or pivot table name
- Update the unit tests
Matthias Endler [Tue, 5 Sep 2023 11:43:22 +0000 (13:43 +0200)]
Fix bug in checkDefinedNames
xuri [Thu, 7 Sep 2023 16:09:41 +0000 (00:09 +0800)]
This fixes #1643, fixes #1647 and fixes #1653
- Correction cell type when formatting date type cell value
- Add check for MID and MIDB formula functions num_chars arguments, prevent panic on specifying a negative number
- Ref #65, add support for 2 formula functions: SEARCH and SEARCHB
- Fix a v2.8.0 regression bug, error on set print area and print titles with built-in special defined name
- Add new exported function `GetPivotTables` for get pivot tables
- Add a new `Name` field in the `PivotTableOptions` to support specify pivot table name
- Using relative cell reference in the pivot table docs and unit tests
- Support adding slicer content type part internally
- Add new exported source relationship and namespace `NameSpaceSpreadSheetXR10`, `ContentTypeSlicer`, `ContentTypeSlicerCache`, and `SourceRelationshipSlicer`
- Add new exported extended URI `ExtURIPivotCacheDefinition`
- Fix formula argument wildcard match issues
- Update GitHub Actions configuration, test on Go 1.21.x with 1.21.1 and later
- Avoid corrupted workbooks generated by improving compatibility with internally indexed color styles
Francis Nickels III [Sun, 3 Sep 2023 16:11:35 +0000 (09:11 -0700)]
add Footer & Header clarification to docs (#1644)
xuri [Sun, 27 Aug 2023 16:02:25 +0000 (00:02 +0800)]
Update the README and documentation for the data validation functions
fsfsx [Sat, 26 Aug 2023 05:14:03 +0000 (13:14 +0800)]
ref #65, add support for 10 formula functions
- Add support for 10 formula functions: ARRAYTOTEXT, FORECAST, FORECAST.LINEAR, FREQUENCY, INTERCEPT, ODDFYIELD, ODDLPRICE, ODDLYIELD, PROB and VALUETOTEXT
- Update unit tests
xuri [Thu, 24 Aug 2023 17:06:41 +0000 (01:06 +0800)]
This closes #1628, fix the GetPictures function returns pictures doesn't correct in some cases