OrgGo/unioffice
1
0
Fork 0
mirror of https://github.com/unidoc/unioffice.git synced 2025-04-25 13:48:53 +08:00
Code Issues Actions Packages Projects Releases Wiki Activity
504 Commits 5 Branches 62 Tags
Commit Graph

504 Commits

This Branch
This Branch
All Branches
Author SHA1 Message Date
Gunnsteinn Hall
1179840a52 Update .travis.yml 2020-06-17 21:53:23 +00:00
Gunnsteinn Hall
daa4bcb101 Create .gitattributes 2020-06-17 21:51:39 +00:00
Vyacheslav Zgordan
6cbaf67f9e
Validating examples (#404) 
* only input files remain, output deleted

* example changed to produce a new file instead of modifying the old one

* source document with incorrect characterSet is fixed; ppt path is fixed; invalid strict example is removed

* Ignorable attributes added for validating newer versions of Office

* indentation fix

* 4 byte values for rgb attr

* Validate examples in travis

* indentation

* travis files moved to subfolder

* fixed and renamed validate-examples.sh

* avoiding double building

* Update .travis.yml

* Fix indent

Co-authored-by: Gunnsteinn Hall <gunnsteinn.hall@gmail.com>
 2020-06-17 21:43:35 +00:00
Vyacheslav Zgordan
2052cbb728
PPT relationships, image fix (#395) 
* PPT relationships, image fix

* filenames fix

* Custom properties fix

* schema update

* Table styles fix

* Scale fix

* path fix

* New schema: cycle imports fix

* xsdAny namespace duplicate fix

* Images names fix

* Images extensions fix

* duplicate chart fix

* chart empty attrs fix

* Choice if fixed, scale is rolled back

* comments

* Rollback license info in schema files

* import path fix

* import path fix 2

* error with incorrect content types names fixed when deleting slides and then adding them again

* template with image example

* MustCompile replaced

* imports fixed

* slideIdx error fix
 2020-06-07 13:42:27 +00:00
Vyacheslav Zgordan
9892c32fee
SaveAsTemplate and SaveToFileAsTemplate are added for presentation (#400) 
Co-authored-by: Gunnsteinn Hall <gunnsteinn.hall@gmail.com>
 2020-06-07 13:13:15 +00:00
Vyacheslav Zgordan
1bc7809fb0
error with incorrect content types names fixed when deleting slides a… (#398) 
* error with incorrect content types names fixed when deleting slides and then adding them again

* MustCompile replaced
 2020-06-07 12:48:57 +00:00
Vyacheslav Zgordan
56b03a8aed
document.SetConformance is added with an example (#399) 
* document.SetConformance is added with an example

* SetStrict is added as shortcut

* 2020

* preserve conformance attr

* fix
 2020-06-05 16:38:29 +00:00
Gunnsteinn Hall
cd8c690655
Add nil checks to prevent crash UO-26 (#397) 2020-06-05 12:44:02 +00:00
Vyacheslav Zgordan
9f7935e5d0
paragraph and run properties (#392) v1.3.1 2020-05-12 16:07:52 +00:00
Vyacheslav Zgordan
9b547c1686
Issue #385 fix (#387) 
* Issue #385 fix

* tests for table paragraphs

* InsertTableAfter/Before inside another table

* test added for InsertTable*
 2020-05-06 20:19:39 +00:00
Vyacheslav Zgordan
f2ae75a901
numbering fix (#384) 2020-04-27 17:56:14 +00:00
Vyacheslav Zgordan
0e183a6e7b
Fixes for being able to compile with playground (#380) 2020-04-13 12:04:57 +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
Casey Kuhlman
5f9c94bf84
add the ability to utilize footnotes and endnotes in documents (#374) 
* add ability to handle footnotes and endnotes
* address review comments to make code much cleaner
* add license headers and simple example
 2020-03-13 09:53:51 +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
v1.3.0 		2020-02-11 19:47:08 +00:00
Vyacheslav Zgordan
280d692114
copying cell formats when flattening (#369) 2020-02-04 12:57:43 +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
Gunnsteinn Hall
ec23b64dee
Create greetings.yml workflow 2019-11-19 19:44:48 +00:00
Gunnsteinn Hall
cbb8a8a9a2
Update README.md 2019-11-19 18:44:09 +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
Gunnsteinn Hall
a0ab7d537f
Set threshold on testing coverage changes (#342) v1.2.1 2019-10-23 21:35:55 +00:00
Vyacheslav Zgordan
d1ac9ebe5b Optional custom.xml (#340) 
* Optional custom.xml
 2019-10-23 19:06:11 +00:00
Vyacheslav Zgordan
2bd51b004c watermarks for spreadsheets and presentations (#335) 2019-10-10 11:26:10 +00:00
Vyacheslav Zgordan
ae4e2e35b9 #315, #323, #329 (#330) 
* #315, #323, #329

* New testfile
 2019-10-01 07:11:17 +00:00
Sandro Trianni
541b6a88da Refactor header/footer reusing document.tables (#308) 
* Refactor header.go  Reuse document.tables
* Refactor footer.go  Reuse document.tables
 2019-08-05 19:14:04 +00:00
Vyacheslav Zgordan
26d9caa6f8 Support custom metadata in document properties (#309) 
* https://github.com/unidoc/unioffice/issues/302
 2019-08-04 18:52:05 +00:00
Vyacheslav Zgordan
f7abdfa23d issue with paragraph containing several form fields #305 fix (#311) 2019-08-03 12:40:05 +00:00
Vyacheslav Zgordan
73de0318a4 Licanse info fix (#314) 2019-08-02 10:49:16 +00:00
Vyacheslav Zgordan
d351975af1 Baliance replaced for FoxyUtils ehf in License information (#312) 2019-07-25 16:43:46 +00:00
Lunny Xiao
8a700b536d add hh time format support (#306) 2019-07-08 09:19:59 +00:00
Marc Coury
c6ab0e98df Add images from bytes for presentation and workbook (#295) 2019-07-02 14:54:55 +00:00
Nikita Kryuchkov
a3c3e9ba5b Add tables loop to Paragraphs funcs of Header and Footer (#303) 
* Add `Tables` func for `Header`, `Footer`
* Embed tables loop into `Header.Paragraphs`, `Footer.Paragraphs`
 2019-06-24 21:37:53 +00:00
Marc Coury
f61dcc30ae Fix runtime panic when making a presentation from a template (#291) 2019-06-21 19:37:04 +00:00
Nikita Kryuchkov
9b742a3505 Fix comment on the AddSheet (#299) 2019-06-17 18:27:10 +00:00
Alfred Hall
2e7943e809 New license based on the unidoc model (#294) 
* Style fixes.  Fixes for tests. Should not fail with version updates in the future.
v1.2.0 		2019-06-09 11:56:06 +00:00
Nikita Kryuchkov
1783b652de Functions to copy and remove sheets (#281) 
* Add funcs to remove sheet from workbook
- RemoveSheet added to remove sheet by index
- RemoveSheetByName added to remove sheet by its name
* Add `CopyRelationship` func to `Relationships`
* Add funcs `CopySheet`, `CopySheetByName`
- `CopySheet` copies sheet at the specified index
- `CopySheetByName` copies sheet with the specified name
* Make `CopyRelationship` return copied rel and bool flag
* Add func `CopyOverride` to `ContentTypes`
* Add test for `CopyRelationship`
* Add tests for sheet removing funcs
* Add test for `CopyOverride`
* Add tests for `CopySheet`, `CopySheetByName`
v1.1.0 		2019-05-12 12:12:11 +00:00
Nikita Kryuchkov
06b1c96f8f Add tables loop to document's Paragraphs func (#280) 2019-05-11 16:06:59 +00:00
Gunnsteinn Hall
c01764e24e Update README.md (#275) 2019-05-04 16:00:14 +00:00
Gunnsteinn Hall
270664ca01
Rename package name to unioffice (#274) 2019-05-04 13:54:29 +00:00