xuri
ca6b1577a7
add ten formula functions: ENCODEURL, EXACT, FALSE, IFERROR, ISTEXT, LENB, NOT, REPT, SHEET, TRUE
4 years ago
xuri
ec45d67e59
binary search in range lookup and new formula function: LOOKUP
4 years ago
xuri
3648335d7f
This improves compatibility for worksheet relative XML path and multi rules auto filter
4 years ago
xuri
3783d1d01b
This closes #782 , fix unmerge all cells cause corrupted file
4 years ago
xuri
23c73ab527
init new formula function: HLOOKUP
4 years ago
xuri
30549c5e90
fix custom row height check issue
4 years ago
xuri
2fb135bc94
handle end element event in the worksheet row/column iterator XML SAX parser
4 years ago
xuri
66d85dae13
init new formula function: VLOOKUP
4 years ago
xuri
1f329e8f96
This closes #774 , closes #775 and closes #776
...
- correct adjust calculation chain in duplicate rows
- correct adjust defined name in the workbook when delete worksheet
- use absolute reference in the auto filters defined name to make it compatible with OpenOffice
- API `CoordinatesToCellName` have a new optional param to specify if using an absolute reference format
- Fix cyclomatic complexity issue of internal function `newFills` and `parseToken`
4 years ago
xuri
db7b4ee362
update formula functions test
4 years ago
xuri
4ac32278ff
Fix hyperbolic cotangent calculation incorrect and unit test
4 years ago
xuri
76c72e0a30
Nested formula function support cell references as arguments
4 years ago
xuri
dd77cfe44c
refactor formula calculation framework, add new function CHOOSE, and update dependencies module
4 years ago
Eagle Xiang
219add2f0e
value fields xlsxPatternFill.FgColor & xlsxPatternFill.BgColor cause … ( #770 )
...
* value fields xlsxPatternFill.FgColor & xlsxPatternFill.BgColor cause ineffective omitempty tags
* remove useless omitempty tag on xlsxPatternFill.FgColor and xlsxPatternFill.BgColor
4 years ago
xuri
b84bd1abc0
new formula fn: IF, LEN; not equal operator support and faster numeric precision process
4 years ago
xuri
e568319bbc
Fixed #766 , change order, and added fields of workbook fields
4 years ago
Ray
58ecf81630
Update excelize.go ( #765 )
...
miss a char as 'l' in the excel.
4 years ago
xuri
1bc5302007
Fixed #764 , add a condition for round precision
4 years ago
xuri
b260485f29
support to set print black and white and specified the first printed page number
4 years ago
xuri
054bb9f061
Support to adjust print scaling of the worksheet
4 years ago
xuri
a26675517e
This closes #756 , not set the empty string for the cell when SetCellValue with nil
4 years ago
龚尚
22dc6ff33c
Update the tips message for Go modules user
4 years ago
xuri
71829c5202
AddChart support disable legend of the chart
4 years ago
xuri
576bfffbe6
This closes #752 , fix incorrectly merged cells on duplicate row, and new formula function: LOWER, PROPER, UPPER
4 years ago
xuri
77978ac68d
This closes #657 and closes #748 , AddChart support custom marker symbol and symbol size, fix AddPicture auto fit failure with multi merged cells
4 years ago
Zhang Zhipeng
ad79505173
new formula func CLEAN and TRIM, change import path to v2 ( #747 )
4 years ago
Artem Kustikov
61057c58d3
Number format read fix ( #741 )
...
* fix UT-generated file names to be ignored
* fix cell value load with invalid number format ID
* fix PR issues
4 years ago
jacentsao
95d8920c8e
support range validation for decimal ( #739 )
...
Co-authored-by: jacen_cao <jacentsao@kingdee.com>
4 years ago
xuri
13e0ed2a69
Fixed #735 , refresh active tab after delete sheet
4 years ago
xuri
599a8cb0bc
Fixed #727 , rounding numeric with precision for formula calculation
4 years ago
xuri
92c8626f81
Fixed #732 , support single line with repeated row element in the sheet data
4 years ago
Eugene Androsov
2be4bfd410
Fix row duplicate mechanism ( #729 )
4 years ago
xuri
2514bb16c6
Fix #724 , standardize variable naming and update unit tests
4 years ago
xuri
5dd0b4aec2
using POSIX directory separator in zip path with Windows
4 years ago
xuri
cdc57db3b3
Fix race conditions
4 years ago
xuri
c82a185af8
Compatibility improvement: parse document core part (workbook) dynamically
4 years ago
Ted
fcca8a3838
optimize memory allocation ( #722 )
...
* optimize marshal
* optimize mem alloc
* add benchmark testing
* add NewSheetWithRowNum testing
* sync struct fields order
* add BenchmarkNewSheetWithStreamWriter
* delete NewSheetWithRowNum and benchmark test
4 years ago
xuri
9d470bb38f
Update conversion between integer types and unit tests
4 years ago
xuri
b812e9a1a8
New formula function AND ( #701 ) and update doc for the NewSheet ( #714 )
4 years ago
xuri
4834a058aa
This closes #714 and closes #715 , fix wrong worksheet index returned by NewSheet in some case, fix panic on formatted value with no built-in number format ID
4 years ago
xuri
520aa679f3
Fix #706 , #713 improve AddPicture performance, fix missing worksheet when rename with same names
4 years ago
xuri
02530e8c8a
Fix #701 , init new formula function AND and OR, prevent formula lexer panic on retrieving the top token type
4 years ago
xuri
ac3dce0bea
- Resolve #711 , update docs for the GetSheetIndex
...
- Update unit test
4 years ago
xuri
d1926675f8
- Resolve #627 , improve multi-series line chart compatibility with KingSoft WPS
...
- Avoid to create duplicate style
- Update unit test for the auto filter
- Init code scanning alerts
4 years ago
Lijingfeng
93160287bb
Optimize memory usage when stream flush and save ( #659 )
...
* use io.Copy from stream temp file to zip Writer
* fix nil
* log
* build
* delete log
* fix compatibility for office
* Update go module
Co-authored-by: lijingfeng <lijingfeng@laiye.com>
Co-authored-by: xuri <xuri.me@gmail.com>
4 years ago
Artem Kustikov
f2b8798a34
extend cell value load to support custom datetime format ( #703 )
...
* extend cell value load to support custom datetime format
* cleanup incorrect imports
* fix numeric values conversion as done in legacy Excel
* fix tests coverage
* revert temporary package name fix
* remove personal info from test XLSX files
* remove unused dependencies
* update format conversion in parseTime
* new UT to increase code coverage
* Resolve code review issue for PR #703
* Rename broken file name generated by unit test
Co-authored-by: xuri <xuri.me@gmail.com>
4 years ago
xuri
9055a835a8
Merge pull request #710 from lbraconnier2/Pivot-failed-in-case-of-multi-columns-and-multi-data
...
fix pivot fails in case of multi columns and multi data
4 years ago
Ludovic Braconnier
2bd359bd01
fix pivot fails in case of multi columns and multi data
4 years ago
jinhyuk-kim-ca
c492220237
Pivot table generation fails when no Columns and multiple Data are provided. ( #708 )
...
fix to create pivot table in case there is no input from Columns
Co-authored-by: Jin Kim <jinhyuk.kim@cerence.com>
Co-authored-by: xuri <xuri.me@gmail.com>
4 years ago
xuri
89465f41b5
Update dependency package version and docs for the OpenFile
4 years ago