Excelize 2.9.1 Launched – Open-source library for Excel (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets – Releases

Probably the most notable modifications on this launch are:

• Improve necessities Go language model is 1.23 or later, for improve of dependency package deal golang.org/x/crypto
• Change the information sort of DataValidationType, DataValidationErrorStyle, DataValidationOperator, PictureInsertType from int to byte
• SetCellInt perform required int64 knowledge sort parameter, resolve situation 2068
• When including drawing objects corresponding to footage, charts, shapes, and type controls, the offset setting will not have an effect on the scale of the drawing object, associated situation 2001

• Add new fields GapWidth and Overlap within the Chart knowledge sort
• Add new fields ShowDataTable and ShowDataTableKeys fields within the ChartPlotArea knowledge sort
• Add new area Alignment within the ChartAxis knowledge sort
• Add new area DataLabel within the ChartSeries knowledge sort
• Add new area PageOrder for PageLayoutOptions knowledge sort
• Add 2 new exported error variables: ErrPageSetupAdjustTo and ErrStreamSetColStyle
• Add 2 new exported enumerations: HeaderFooterImagePositionType and IgnoredErrorsType
• Add 2 new exported knowledge varieties: CalcPropsOptions and HeaderFooterImageOptions
• Add 2 new capabilities: SetCalcProps and GetCalcProps assist setting and getting workbook calculation properties
• Add new CultureNameJaJP, CultureNameKoKR and CultureNameZhTW enumeration values, assist apply quantity format for the Japanese calendar years, the Korean Danki calendar and the Republic of China 12 months, associated situation 1885
• Add new perform AddHeaderFooterImage to assist set graphics in a header and footer, associated situation 1395
• Add new perform AddIgnoredErrors assist to ignored error for a variety of cells, associated situation 2046
• Add new perform SetColStyle for streaming author to assist set columns model, associated situation 2075
• The AddChart and AddChartSheet perform assist set chart axis textual content path and rotation, associated situation 2025
• The AddChart and AddChartSheet perform assist set hole width and overlap for column and bar chart, associated situation 2033
• The AddChart and AddChartSheet perform assist set the format of the chart sequence knowledge label, associated situation 2052
• The AddChart and AddChartSheet perform assist set knowledge desk for chart, associated situation 2117
• The AddFormControl perform assist set cell hyperlink for test field, associated situation 2113
• The SetPageLayout perform assist set web page order of web page structure
• The DeletePicture perform assist delete one cell anchor picture, associated situation 2059
• An error will probably be return if the choice worth of the SetPageLayout perform is invalid
• Assist regulate knowledge validations cross a number of worksheets, associated situation 2072
• Assist apply quantity format with hash and nil place holder, associated situation 2058
• Assist apply quantity format with ? image
• Assist to insert one cell anchor drawing object when specified the positioning as “oneCell”, associated situation 2002

• Repair a v2.9.0 regression bug, corrupted workbook generated by open the workbook generated by stream author, resolve situation 2015
• Repair redundant none sort sample fill generated, resolve situation 2014
• Repair lacking vertical and horizontal border kinds in some case, resolve situation 2048
• Repair conditional format’s border kinds lacking in some case, resolve situation 2061
• Repair get pivot tables panic in some case, resolve points 1954 and 2051
• Repair GetStyle perform cannot get VertAlign format
• Repair CalcCellValue perform subexpressions aren’t accurately calculated in some case, resolve situation 2083
• Repair delete fallacious photographs in some case which attributable to picture reference detection situation
• Repair cell default model doesn’t override by none-zero row model when set row by stream author
• Repair redundant cols factor generated by stream author
• Repair panic on set chart title font, resolve situation 2102
• Repair panic on delete calc chain in some case
• Repair incorrect system calculation consequence attributable to shared system parse error, resolve situation 2056
• Repair corrupted workbook generated when an inside ZIP64 file measurement exceeds 4GB
• Repair sheet title error in outlined title after rename sheet, resolve situation 2126

• Use a 3 occasions sooner deepcopy library github.com/tiendc/go-deepcopy as a substitute of github.com/mohae/deepcopy, associated situation 2029
• Repair efficiency regression in v2.9.0, cut back trim cell worth reminiscence allocation for clean cells
• Enhance efficiency for calculate system when system incorporates entire column and row reference
• Rows iterator speedup about 20%, reminiscence allocation cut back about 10%

Thanks for all of the contributors to Excelize. Under is a listing of contributors which have code contributions on this model:

• wushiling50
• imirkin (Ilia Mirkin)
• Juneezee (Eng Zer Jun)
• Arpelicy
• zhuhaicity (ZhuHaiCheng)
• xxf0512 (xxf)
• gypsy1234
• mengpromax (MengZhongYuan)
• hly-717
• kurtinge (Kurt Inge Smådal)
• IvanHristov98 (Ivan Hristov)
• artur-chopikian (Artur Chopikian)
• romanshevelev (Roman Shevelev)
• LZCZ
• hm3248
• moisespsena (Moises P. Sena)
• paolobarbolini (Paolo Barbolini)
• timesince
• shcabin
• tgulacsi (Tamás Gulácsi)
• R3dByt3 (R3dByt3)
• Now-Shimmer