OrgGo/unioffice
1
0
Fork 0
mirror of https://github.com/unidoc/unioffice.git synced 2025-05-12 19:29:34 +08:00
Code Issues Actions Packages Projects Releases Wiki Activity
455 Commits 5 Branches 62 Tags
Commit Graph

58 Commits

Author SHA1 Message Date
UniDoc Build
563dd7e106 prepare release 2022-02-05 13:05:36 +00:00
UniDoc Build
3de0947c35 prepare release 2022-01-15 21:17:38 +00:00
UniDoc Build
39270215e8 prepare release 2021-11-10 11:45:21 +00:00
UniDoc Build
fa02d825de prepare release 2021-09-22 16:41:01 +00:00
UniDoc Build
27dedcd877 prepare release 2021-08-23 20:44:48 +00:00
UniDoc Build
a63348d637 prepare release 2021-07-30 17:03:26 +00:00
UniDoc Build
af0572acdd prepare release 2021-06-16 07:10:52 +00:00
UniDoc Build
d1a30428b9 prepare release 2021-05-31 16:22:30 +00:00
UniDoc Build
ad0b34b299 prepare release 2021-04-23 20:00:00 +00:00
UniDoc Build
088849b757 prepare release 2021-03-16 20:51:18 +00:00
UniDoc Build
e3d76c4061 prepare release 2021-01-04 16:11:39 +00:00
UniDoc Build
570c747147 prepare release 2020-12-17 22:07:08 +00:00
UniDoc Build
ff1d40472f prepare release 2020-11-09 01:00:18 +00:00
UniDoc Build
c68234383a prepare release 2020-10-12 13:59:12 +00:00
UniDoc Build
b8160fa447 prepare release 2020-08-31 22:58:25 +00:00
UniDoc Build
25f34f3f92 prepare release 2020-08-23 14:15:53 +00:00
Gunnsteinn Hall
1f8785cc75 fixes 2020-08-08 01:11:24 +00:00
Gunnsteinn Hall
5335bf249b
License update (#426) 
* update license and terms

* Fixes

* Create ACKNOWLEDGEMENTS.md

* Update ACKNOWLEDGEMENTS.md

* Revert go.mod changes and remove go1.11 tests
 2020-08-08 01:01:05 +00:00
Vyacheslav Zgordan
72ad869a28
Get all cells in a row with empty ones (#377) 
* Get all cells in a row with empty ones
* sheet.MaxColumnIdx() changed
* goimports for all
 2020-03-25 13:40:25 +00:00
Vyacheslav Zgordan
ddafaca850
Spreadsheet: Remove columns feature (Issue #367) (#371) 
* Issue #376 fix - RemoveColumn
* Removing of columns is forbidden when there are formula arrays in the area of removing, except 1-column wide arrays
* Modifying named ranges, column ranges when deleting a column
* Updating formulas when deleting a column
* UpdateAction
 2020-02-11 19:47:08 +00:00
Vyacheslav Zgordan
215a2d27f1
Flatten fixes (#368) 
* Cells in a row fix
* adopted for older Go versions; fixed another error case of Cells
 2020-01-31 13:28:47 +00:00
Vyacheslav Zgordan
a5ef37c0bc
Spreadsheet formulas: Flattening files (#366) 
* evaluation errors fixed
* allow underscores in sheet names
* allow wildcard in *LOOKUP functions
* horizontal and vertical ranges
* horizontal and vertical ranges for sheet references
* remove redundant recalculate
* caching
* fixed named ranges, made Evaluator more generic
* Memory usage shown in flatten example
* temporary file deleted
* ParseCellReference duplicate removed
* ISREF is fixed
 2020-01-29 10:43:43 +00:00
Vyacheslav Zgordan
2cfb3539c7 Test cases for functions for https://github.com/unidoc/unioffice/issues/336 (#363) 
* SUBSTITUTE
* ACCRINTM fix
* tests
* MID
 2020-01-08 08:32:38 +00:00
Vyacheslav Zgordan
fbcea8d7d6 Financial functions: part 4 (#362) 
* YIELDDISC
* XIRR
* XNPV
* YIELD
* YIELDMAT
 2020-01-04 11:31:20 +00:00
Vyacheslav Zgordan
f4e59e2275 Financial functions: part 3 (#361) 
* PMT, PPMT
* PRICEDISC, fixed YEARFRAC
* PV and handling empty arguments
* RATE
* RECEIVED
* RRI
* ODDLPRICE, ODDLYIELD
* PRICE, PRICEMAT
* SLN
* SYD
* TBILLEQ, TBILLPRICE, TBILLYIELD
* VDB
 2019-12-27 12:24:38 +00:00
Vyacheslav Zgordan
dc34147325 Financial functions: part 2 (#360) 
* DB, DDB
* DISC, DOLLARDE, DOLLARFR
* EFFECT
* FV
* FVSCHEDULE, INTRATE, IPMT
* IRR, ISPMT
* MIRR, NOMINAL, NPER, NPV
 2019-12-21 10:54:57 +00:00
Vyacheslav Zgordan
64edd6c139 Financial functions - part 1 (#359) 
* ACCRINTM, COUPNUM, COUPPCD, AMORDEGRC, AMORLINC
* COUPDAYBS
* COUPNCD, COUPDAYS, COUPDAYSNC
* CUMIPMT, CUMPRINC
 2019-12-14 15:08:04 +00:00
Vyacheslav Zgordan
e17f3d3164 Test cases for SUM and IF (#357) 2019-12-09 12:08:47 +00:00
Vyacheslav Zgordan
50980fe02e TEXT (#354) 2019-12-05 15:16:38 +00:00
Vyacheslav Zgordan
8fadaaeecf Excel functions part 4 (#353) 
* DURATION, MDURATION
* PDURATION
* ROW, ROWS
* tests for LOOKUP and VLOOKUP
* LARGE, SMALL
* LOWER
* REPLACE
* TEXTJOIN
* INDEX
 2019-12-05 13:03:20 +00:00
Vyacheslav Zgordan
055ebf0f4c Excel spreadsheet functions, part 3 (#351) 
* fixed IF and statistical functions
* Issue #347
* DATETIME
* DAY, DAYS, Cells() fix
* MONTH
* MINUTE
* EDATE
* EOMONTH
 2019-12-02 16:25:18 +00:00
Vyacheslav Zgordan
dd7713e1e3 Functions2 (#348) 
* MATCH, IFS, MAXA, MINA
* OFFSET fixed
* ISBLANK, ISERR, ISERROR, ISEVEN ,ISFORMULA, ISNONTEXT, ISNUMBER, ISODD, ISTEXT
* ISLEAPYEAR, ISLOGICAL, ISNA, ISREF
* FIND, FINDB
* SEARCH, SEARCHB
* CONCAT, CONCATENATE
* YEAR, YEARFRAC
* CONCAT is fixed, now TRUE and FALSE are concatenated instead of 1 and 0 in case of boolean results
* NOW, TODAY, TIME, TIMEVALUE
* DATE
* DATEDIF
 2019-11-20 23:21:00 +00:00
Vyacheslav Zgordan
415c045839 Spreadsheed Formula Functions (#345) 
* CELL function
* CELL moved to fninformation.go
* CHOOSE function
* CHOOSE function add one test
* COLUMN function
* COLUMNS function
* COUNTIF function
* COUNTIF, COUNTIFS, MINIFS, MAXIFS, SUMIF, SUMIFS, some style fixes
* SUMIF and SUMIFS moved to the right location
* VALUE function
* wildcard is added
* CELL format fix
 2019-11-05 16:36:09 +00:00
Vyacheslav Zgordan
d351975af1 Baliance replaced for FoxyUtils ehf in License information (#312) 2019-07-25 16:43:46 +00:00
Gunnsteinn Hall
270664ca01
Rename package name to unioffice (#274) 2019-05-04 13:54:29 +00:00
Nikita Kryuchkov
e8bf6a3bb9 Move repository https://github.com/baliance/gooxml to https://github.com/unidoc/unioffice (#273) 2019-05-04 08:18:06 +00:00
Todd
99ed4875e1 spreadsheet: support evaluation of shared formulas 
This seems to be very uncommon.
 2017-10-01 19:29:13 -05:00
Todd
988f2e3290 spreadsheet: move ColumnToIndex/IndexToColumn 
Create a spreadsheet/reference package and put these functions
there. This prevents both duplication across the formula &
spreadsheet packages and a cyclic reference.
 2017-10-01 19:29:13 -05:00
Todd
801388a119 gooxml: clean up some old TODOs 2017-09-30 07:09:26 -05:00
Todd
5bfa034ef9 gooxml: add and use a Log function 
This allows redirecting or discarding any
logs produced by the library.
 2017-09-30 07:09:26 -05:00
Todd
00be1d037c formula: support evaluating array formulas 
Array formulas are entered in Excel by pressing
Ctrl+Shift+Enter to finish the formula.  The resulting
formula is entirely in one cell, but its computed results
expand into cells the size of the array result.
 2017-09-21 20:20:06 -04:00
Todd
c4c9138da2 formula: add more index functions 
- HLOOKUP
- LOOKUP
- TRANSPOSE
- VLOOKUP
 2017-09-21 19:31:28 -04:00
Todd
f915bf1a9b formula: support for more statistical functions 
- AVERAGE
- AVERAGEA
- COUNT
- COUNTA
- COUNTBLANK
- MEDIAN
 2017-09-20 20:47:03 -04:00
Todd
0e09e64818 formula: compatibility & bug fixes 
- Make UNICODE with no arguments behave like Excel
- Fix OFFSET/INDEX for named ranges
 2017-09-20 20:47:03 -04:00
Todd
20e8ecd685 format: add package doc 2017-09-19 19:45:41 -04:00
Todd
b54a2efd19 formula: add method to determine the supported functions 2017-09-17 14:56:58 -05:00
Todd
422484af83 formula: add more complex function support 
- INDEX
- INDIRECT
- OFFSET
 2017-09-17 14:56:58 -05:00
Todd
92c902e6bd formula: support for using named ranges/tables from formulas 2017-09-17 14:56:58 -05:00
Todd
5ed34695bd formula: add support for text functions 
- CHAR
- CLEAN
- CODE
- CONCATENATE
- EXACT
- LEFT
- LEN
- LOWER
- PROPER
- REPT
- RIGHT
- T
- TRIM
- UNICHAR
- UNICODE
- UPPER
 2017-09-17 09:23:37 -05:00
Todd
09419b822f formula: trig functions 
- ACOT
- ACOTH
- CEILING (legacy version)
- COT
- COTH
- CSC
- CSCH
- FLOOR (legacy version)
- SEC
- SECH
 2017-09-16 21:12:41 -05:00