summaryrefslogtreecommitdiff
path: root/date_test.go
Commit message (Collapse)AuthorAge
* This closes #1219, fixes cell value reading issue, improves performance, and ↵xuri2022-05-02
| | | | | | | 1904 date system support - Fix incorrect cell data types casting results when number formatting - Support set cell value on 1904 date system enabled, ref #1212 - Improve performance for set sheet row and the merging cells, fix performance impact when resolving #1129
* Export 7 errors so users can act differently on different type of errorsxuri2021-12-07
|
* This closes #1030, fix date rounding errorxuri2021-10-12
|
* Improve security and simplify codexuri2021-08-15
| | | | | | | - Make variable name more semantic - Reduce cyclomatic complexities for the formula calculate function - Support specified unzip size limit on open file options, avoid zip bombs vulnerability attack - Typo fix for documentation and error message
* This closes #409 Remove UTC timezone requirement from date.go (#853)Alluuu2021-06-04
| | | | | | | According to issue #409 There is absolutely no reason for the timezone to be in UTC, and converting the local times to UTC while keeping values is hacky at least. Excel has no understanding of timezones, hence the user of this library should know what timezone their values are supposed to be, by following the timezone within their timeTime structs.
* This closes #652, new SetColWidth API, support set column width in stream ↵xuri2021-05-10
| | | | writing mode, and export error message
* Fix #724, standardize variable naming and update unit testsxuri2020-11-11
|
* Export ExcelDateToTime function to convert excel date to timeVaibhav Nayak2020-03-03
| | | | Signed-off-by: Vaibhav Nayak <vaibhav.nayak@gmail.com>
* add unit tests to functionsxuri2019-04-16
|
* refactor: handler error instead of panic,xuri2019-03-23
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Exported functions: SetCellStyle InsertCol RemoveCol RemoveRow InsertRow DuplicateRow DuplicateRowTo SetRowHeight GetRowHeight GetCellValue GetCellFormula GetCellHyperLink SetCellHyperLink SetCellInt SetCellBool SetCellFloat SetCellStr SetCellDefault GetCellStyle SetCellValue MergeCell SetSheetRow SetRowVisible GetRowVisible SetRowOutlineLevel GetRowOutlineLevel GetRows Columns SearchSheet AddTable GetPicture AutoFilter GetColVisible SetColVisible GetColOutlineLevel SetColOutlineLevel SetColWidth GetColWidth inner functions: adjustHelper adjustMergeCells adjustAutoFilter prepareCell setDefaultTimeStyle timeToExcelTime addDrawingChart addDrawingVML addDrawingPicture getTotalRowsCols checkRow addDrawingShape addTable
* Use bitSize for float32 type numbers conversion, relate PR #361xuri2019-03-21
|
* Huge refactorig for consistent col/row numbering (#356)Veniamin Albaev2019-03-20
| | | | | | | | | | | | | | | | | | | * Huge refactorig for consistent col/row numbering Started from simply changing ToALphaString()/TitleToNumber() logic and related fixes. But have to go deeper, do fixes, after do related fixes and again and again. Major improvements: 1. Tests made stronger again (But still be weak). 2. "Empty" returns for incorrect input replaces with panic. 3. Check for correct col/row/cell naming & addressing by default. 4. Removed huge amount of duplicated code. 5. Removed ToALphaString(), TitleToNumber() and it helpers functions at all, and replaced with SplitCellName(), JoinCellName(), ColumnNameToNumber(), ColumnNumberToName(), CellNameToCoordinates(), CoordinatesToCellName(). 6. Minor fixes for internal variable naming for code readability (ex. col, row for input params, colIdx, rowIdx for slice indexes etc). * Formatting fixes
* Tests refactoringVeniamin Albaev2018-12-27
| | | | | | | | | | | Primary motivation: Avoid statefull tests with not ignorable git file tree changes. Multiple tests reads and overwrites signle file for won needs. Multiple tests reads and overwrites file under version control. Secondary motivation: Minimal tests logic aligment, separate error expectation and not error expectation tests. Introduce sub-test over test data sets and so far. This commit is not ideal but necessary (IMHO)
* New function `AddPictureFromBytes()` has been added, this resolve #259 and ↵xuri2018-09-14
| | | | close #271.
* Ability to parse dates further in futureMārtiņš2018-06-20
Golangs time.Duration uses nanoseconds, thus it is limited to approximately 290 years.