This website requires JavaScript.
30d3561d0e
Rename SetLegacyDrawingHF to AddHeaderFooterImage (#2023 )
master
Ilia Mirkin
2024-11-09 05:36:42 -0500
d2be5cdf8e
The SetPageLayout function support set page order of page layout (#2022 )
Ilia Mirkin
2024-11-08 03:59:07 -0500
b7375bc6d4
This closes #1395 , add new function SetLegacyDrawingHF support to set graphics in a header/footer (#2018 )
Ilia Mirkin
2024-11-03 21:39:55 -0500
0d5d1c53b2
This closes #2015 , fix a v2.9.0 regression bug introduced by commit 7715c1462a
v2
xuri
2024-10-25 08:52:59 +0800
af190c7fdc
This closes #2014 , fix redundant none type pattern fill generated
xuri
2024-10-23 21:52:32 +0800
d1937a0cde
This closes #1885 , add new CultureNameJaJP, CultureNameKoKR and CultureNameZhTW enumeration values (#1895 )
wushiling50
2024-10-21 09:36:04 +0800
f1d1a5dc2b
This closes #2004 , support apply number format for time and duration cell value
v2.9.0
xuri
2024-10-10 22:44:38 +0800
b23e5a26df
This closes #1076 , add new function MoveSheet to support changing sheet order in the workbook (#1996 )
Jian Yu, Chen
2024-09-30 21:00:59 +0800
bebb802069
This closes #1999 , fix error on GetCellRichText function when read cell without SST index (#2000 )
liuwangchao
2024-09-27 14:58:18 +0800
41c7dd30ce
This closes #1993 , support to set and get pivot table classic layout
xuri
2024-09-21 15:39:36 +0800
02189fb016
Ref #65 , new formula function DOLLAR (#1992 )
ArcholSevier
2024-09-12 22:07:18 +0800
ad8541790d
This closes #1989 , fix incorrect result of formula functions XIRR and XNPV
xuri
2024-09-08 12:19:58 +0800
8c0ef7f90d
This closes #1983 , support create combo chart with same types
xuri
2024-09-05 21:38:19 +0800
aca04ecf57
This closes #1987 , support absolute paths for pictures (#1988 )
Ben Smith
2024-09-04 14:47:02 +0300
0447cb22c8
This close #1985 , fix incorrect result of cell value after apply general number format (#1986 )
Zhang Zhipeng
2024-09-02 09:19:50 +0800
29366fd126
Add new fields for pivot table options and pivot field options
xuri
2024-09-01 12:10:01 +0800
8f87131608
This closes #1979 , fix decimal value round issue (#1984 )
centurion-hub
2024-08-31 10:57:26 +0800
9c460ffe6c
Add support for applying number format expression with language/location tags and ID (#1951 )
wanghaochen2024
2024-08-27 22:41:32 +0800
c805be1f6f
This related for #810 , add new functions DeleteSlicer and GetSlicers (#1943 )
zhangyimingdatiancai
2024-08-23 10:47:47 +0800
9a38657515
This related for #720 and closes #1965 , add new NumFmt field in the PivotTableField data type
xuri
2024-08-18 00:18:02 +0800
d21b598235
This closes #1968 , closes #1969
xuri
2024-07-31 09:10:05 +0800
30c4cd70e0
This close #1963 , prevent the GetStyle function panic when theme without sysClr
xuri
2024-07-23 21:48:17 +0800
d81b4c8661
This closes #1957 , fix missing shape macro missing after adjusted drawing object
xuri
2024-07-19 22:22:47 +0800
4dd34477f7
This closes #1955 , refs #119 , support to set cell value with an IEEE 754 "not-a-number" value or infinity
xuri
2024-07-18 21:05:36 +0800
68a1704900
This fix missing horizontal axis in scatter chart with negative values (#1953 )
pjh591029530
2024-07-17 08:44:16 +0800
9c278365f2
This closes #1945 , an error will be return if column header cell is empty in pivot table data range
xuri
2024-07-13 10:41:57 +0800
307e533061
This closes #1942 , fix percent sign missing in formatted result for zero numeric cell value (#1947 )
wxy
2024-07-12 08:07:19 +0800
431c31029e
This closes #1944 , add new TickLabelPosition field in the ChartAxis data type (#1946 )
Patrick Wang
2024-07-11 14:39:16 +0800
53b65150ce
This closes #1940 , SetCellHyperLink function now support remove hyperlink by None linkType
xuri
2024-07-07 17:22:13 +0800
7999a492a4
This closes #1937 , fix GetPivotTables returns incorrect data range (#1941 )
ShowerBandV
2024-07-06 09:25:09 +0800
b18b48099b
Optimize ColumnNumberToName function performance, reduce about 50% memory usage and 50% time cost (#1935 )
Aybek
2024-07-05 11:34:02 +0500
4e6457accd
This closes #1926 , fix secondary vertical axis title is not displayed (#1928 )
Vovka Morkovka
2024-06-20 20:13:12 -0400
f04aa8dd31
Add new AutoFitIgnoreAspect field in the GraphicOptions data type (#1923 )
wangsongyan
2024-06-19 20:45:25 +0800
1a99dd4a23
This closes #1921 , fix set axis format doesn't work in combo chart (#1924 )
联盟少侠
2024-06-17 21:54:15 +0800
c349313850
This closes #1910 , fix a v2.8.1 regression bug introduced by commit 866f3086cd
xuri
2024-05-29 21:05:34 +0800
08d25006f9
This fixed can not found code coverage on Windows (#1908 )
xiaokui
2024-05-27 20:45:37 +0800
0c3dfb1605
This closes #1903 , made GetCellStyle function concurrency safe
xuri
2024-05-25 14:54:59 +0800
42ad4d6959
This closes #1906 , fix a v2.8.1 regression bug introduced by commit d9a0da7b48
xuri
2024-05-24 22:05:07 +0800
5f583549f4
Add unit test for the stream writer to improved line of code coverage (#1898 )
nna
2024-05-14 12:06:10 +0800
a64efca31f
This fixes #1888 , read internal media files with absolute path
xuri
2024-05-03 10:16:00 +0000
781c38481d
This closes #1889 , refs #1732 and #1735 (#1890 )
barlevd
2024-04-30 19:05:05 +0300
7715c1462a
This closes #1886 , remove the namespace prefix for the default spreadsheet namespace
xuri
2024-04-27 20:13:43 +0800
055349d8a6
Fix a v2.8.1 regression bug, error on duplicate rows, if conditional formatting or data validation has multiple cell range reference
xuri
2024-04-26 00:23:10 +0800
f8487a68a8
This closes #1879 , compatible with the escaped quote symbol in none formula data validation rules (#1880 )
jianxinhou
2024-04-18 13:21:46 +0800
3e636ae7b2
This closes #1874 , reduces memory usage for the GetRows function (#1875 )
Nima
2024-04-11 18:42:56 +0330
5f8a5b8690
This closes #1867 , breaking changes: change the data type for the ConditionalFormatOptions structure field Format as a pointer
xuri
2024-04-03 08:44:46 +0800
5dc22e874b
Support get the cell images inserted by IMAGE formula function
xuri
2024-04-02 08:47:57 +0800
9999221450
This closes #1865 , unescape newline character in stream writer
xuri
2024-04-01 08:49:21 +0800
ffad7aecb5
Support get rich data value rels index from rich value part (#1866 )
yunkeweb
2024-03-28 16:37:35 +0800
5e500f5e5d
Introduce new exported PictureInsertType enumeration (#1864 )
yangyile-yyle88
2024-03-27 14:50:51 +0700
838232fd27
Add support for get the Microsoft 365 cell images (#1857 )
Matthew Sackman
2024-03-26 15:19:23 +0000
703b73779c
This closes #1861 , fix missing parentheses in the adjusted formula
xuri
2024-03-25 08:33:29 +0800
5975d87f7e
This closes #1851 , and closes #1856 fix formula calculation result round issue (#1860 )
realzuojianxiang
2024-03-22 16:09:45 +0800
9e884c798b
This closes #1847 , support apply number format with alignment (#1852 )
vic
2024-03-19 08:58:52 +0800
4eb088cf73
This fix performance impact introduced in #1692 (#1849 )
hu5ky
2024-03-15 11:36:34 +0800
585ebff5b7
Typo fix for the comment of the extractStyleCondFuncs variable (#1846 )
yeahyear
2024-03-13 14:39:22 +0800
4ed493819a
This closes #1835 , support get data validations which storage in the extension lists (#1834 )
Evan lu
2024-03-06 09:26:38 +0800
f20bbd1f1d
This closes #1830 , closes #1831 , and closes #1833
xuri
2024-03-04 21:40:27 +0800
963a058535
Optimize getSharedFormula to avoid runtime.duffcopy (#1837 )
Paolo Barbolini
2024-03-03 02:39:50 +0100
9d4c2e60f6
This closes #1825 , made AddDataValidation and DeleteDataValidation functions concurrency safe (#1828 )
陈王
2024-03-01 10:12:17 +0800
7b4da3906d
This closes #1819 , closes #1827 , formula function ISNUMBER, OR and FIND support matrix arguments (#1829 )
岳晨旭
2024-02-29 09:16:39 +0800
bb603b37d0
Clear slave cells value when merging cells (#1824 )
helloWorld
2024-02-27 16:43:47 +0800
688808b2b4
This closes #1819 , formula calculation engine support array formulas
v2.8.1
xuri
2024-02-26 02:22:51 +0800
02b84a906c
This closes #1820 , converted styleFillVariants from slice to func (#1821 )
Ed
2024-02-23 19:11:31 -0600
ee2ef152d9
This closes #1815 , cell value reading functions inherit the Options settings of the OpenReader (#1816 )
Vivek Kairi
2024-02-15 11:00:07 +0530
9cbe3b6bd0
This closes #1807 , calculation engine support date and formula type cell (#1810 )
zhukewen
2024-02-05 00:06:38 +0800
bba155e06d
This closes #1805 , support set chart axis font family, size and strike style (#1809 )
coolbit
2024-02-04 22:31:03 +0800
a258e3d858
Fix CalcCellValue does not return raw value when enable RawCellValue (#1803 )
funa12
2024-02-02 11:11:16 +0900
99e91e19ef
This closes #1794 , add new GetBaseColor function (#1798 )
xxxwang1983
2024-01-30 09:58:24 +0800
9a6855375e
This closes #1792 , support to update defined names reference when rename worksheet (#1797 )
cherry
2024-01-29 10:18:21 +0800
e4497c494d
ref #65 , new formula function: DBCS (#1791 )
Jerry
2024-01-25 14:39:21 +0800
9b078980df
This closes #1789 , delete VML shape on delete comment (#1790 )
L4nn15ter
2024-01-24 14:01:56 +0800
5399572353
This closes #1786 , support set fill color of the chart (#1788 )
MELF晓宇
2024-01-22 09:41:57 +0800
4eb3486682
This closes #1783 , support set conditional formatting with multiple cell ranges (#1787 )
327674413
2024-01-21 00:05:28 +0800
50e23df865
ref #65 , support _xlfn.ANCHORARRAY formula function (#1784 )
3zmx
2024-01-18 15:31:43 +0800
792656552b
This closes #1777 , fix the GetStyle or GetConditionalStyle function to returns incorrect DecimalPlaces field value
xuri
2024-01-09 20:56:20 +0800
f4e395137d
This closes #1770 , fix incorrect multiple conditional formats rules priorities
xuri
2023-12-30 14:41:16 +0800
bb8e5dacd2
This closes #1769 and closes #1770 , support multiple conditional formats rules
xuri
2023-12-28 16:38:13 +0800
8831afc558
This recover the Sizes field in the ChartSeries data type removed in commit dfaf418f34
xuri
2023-12-25 21:51:09 +0800
e998c374ac
This closes #1767 , change struct field tabRatio date type to float64
xuri
2023-12-22 20:49:14 +0800
37e2d946be
Breaking changes: Go 1.18 and later required
xuri
2023-12-19 23:39:45 +0800
00d62590f4
This closes #664 , support get embedded cell images (#1759 )
li
2023-12-15 13:09:42 +0800
dfaf418f34
This closes # 1704, support set the data labels position for the chart (#1755 )
yuegu520
2023-12-14 00:03:53 +0800
284345e471
This closes #1749 , fix incorrect adjust merged cells on remove rows (#1753 )
Xuesong
2023-12-13 09:22:41 +0800
7b3dd03947
Remove unused exported struct ShapeColor (#1746 )
cui fliter
2023-12-09 12:08:29 +0800
866f3086cd
This closes #1745 , prevent panic on get conditional format without above average rules
xuri
2023-12-08 00:09:06 +0800
77ece87e32
This fix some function names in comment (#1747 )
cui fliter
2023-12-07 15:22:26 +0800
18a160c5be
Support unset custom row height if height value is -1 (#1736 )
天爱有情
2023-12-02 12:03:09 +0800
a16182e004
This closes #1732 , saving workbook with sorted internal part path (#1735 )
user65536
2023-12-01 00:31:41 +0800
866e7fd9e1
This closes #1729 , support copy conditional format and data validation on duplicate row (#1733 )
Bram Vanbilsen
2023-11-28 10:13:39 -0600
bce2789c11
This support set column style with default width in sheet props settings (#1728 )
zcgly
2023-11-25 02:03:33 +0800
41259b474f
Recalculate and use the same shared string count and unique count to overwrite incorrect existing values
xuri
2023-11-23 00:03:10 +0800
6251d493b3
Fixed invalid shared string table index on set cell value (#1725 )
ZX
2023-11-21 11:23:54 +0800
55e4d4b2c3
The GetCellRichText function support to return inline rich text (#1724 )
Tian
2023-11-20 23:57:45 +0800
6220a798fd
This closes #1723 , fix panic on read workbook in some cases (#1692 )
lujin
2023-11-18 16:44:45 +0800
57faaf253a
Fix panic on GetPictureCells without drawing relationships parts (#1721 )
Tajang
2023-11-16 09:34:37 +0800
3bdc2c5fc7
This add new exported function GetHeaderFooter (#1720 )
15535382838
2023-11-14 22:49:18 -0600
5e247de805
Support set time period type conditional formatting (#1718 )
Yang Li
2023-11-14 09:47:57 +0800
2499bf6b5b
Support 5 new kinds of conditional formatting types
xuri
2023-11-13 00:16:29 +0800
c7acf4fafe
Support update data validations on inserting/deleting columns/rows
xuri
2023-11-11 00:04:05 +0800