forked from iliaal/php_excel
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathChangeLog
77 lines (65 loc) · 4.11 KB
/
ChangeLog
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
[2011-10-12] - Version 0.9.6
* Added new methods (requires LibXL 3.2.3+):
- ExcelSheet::isHidden() that whether sheet is hidden.
- ExcelSheet::setHidden(bool flag) that hides/unhides the sheet.
* Allow compilation against LibXL 3.2.3/3.2.2
* Added a work-around for image index bug inside LibXL 3.2.2
[2011-08-03] - Version 0.9.1
* Added new methods (requires LibXL 3.2.0+):
- ExcelSheet::setPrintFit(int wPages, int hPages) that fits sheet width and sheet height to wPages and hPages respectively
- ExcelSheet::getPrintFit() that returns whether fit to page option is enabled, and if so to what width & height
- ExcelSheet::getNamedRange(string name) that gets the named range coordianates by name, returns false if range is not found
- ExcelSheet::getIndexRange(int index) that gets the named range coordianates by index, returns false if range is not found
- ExcelSheet::namedRangeSize() that returns the number of named ranges in the sheet
- ExcelSheet::getVerPageBreak(int index) that returns column with vertical page break at position index
- ExcelSheet::getVerPageBreakSize() that returns a number of vertical page breaks in the sheet
- ExcelSheet::getHorPageBreak(int index) that eturns column with horizontal page break at position index
- ExcelSheet::getHorPageBreakSize() that returns a number of horizontal page breaks in the sheet
- ExcelSheet::getPictureInfo(int index) that returns a information about a workbook picture at position index in worksheet
- ExcelSheet::getNumPictures() that returns a number of pictures in this worksheet
- ExcelBook::biffVersion() that returns BIFF version of binary file. (Used for xls format only)
- ExcelBook::getRefR1C1() that returns whether the R1C1 reference mode is active
- ExcelBook::setRefR1C1(bool active) that sets the R1C1 reference mode
- ExcelBook::getPicture(int picture_index) that returns a picture at position index
- ExcelBook::getNumPictures() that returns a number of pictures in this workbook
- ExcelSheet ExcelBook::insertSheet(int index, string name [, ExcelSheet sh]) that inserts a new sheet to this book at position index,
returns the sheet handle. If ExcelSheet parameter is missing a new sheet will be created.
[2011-01-14] - Version 0.9.1
* Added support for LibXL 3.1.0+
* Added work-around for a bug inside xlSheetIsDate() that detects treats custom number formats as dates
* Added getSheetByName() method to retrieve sheet by name (original patch by Rob Gagnon)
* Added basic documentation
* Fixed a bug with readRow()/readCol() when end parameter is specified
[2010-08-27] - Version 0.9.0
* Added support for LibXL 3.1.0
* Added new methods
- ExcelSheet::setNamedRange(string name, int row, int col, int to_row, int to_col)
- ExcelSheet::delNamedRange(string name)
- ExcelSheet::setPrintRepeatRows(int rowFirst, int rowLast)
- ExcelSheet::setPrintRepeatCols(int colFirst, int colLast)
- ExcelSheet::getGroupSummaryBelow()
- ExcelSheet::setGroupSummaryBelow(bool direction)
- ExcelSheet::getGroupSummaryRight()
- ExcelSheet::setGroupSummaryRight(bool direction)
- ExcelSheet::clearPrintRepeats()
- ExcelSheet::clearPrintArea()
[2010-08-27] - Version 0.8.6
* Added support for LibXL 3.0.0
* Added support for generating Excel 2007/2010 (xlsx files)
- the ExcelBook() method now has a constructor parameter that can be used to toggle xlsx mode
* Added Book methods for xlsx color
- colorUnpack, colorPack, setRGBMode, rgbMode
* Added missing validation checks and fixed on-error memory leak
[2010-08-11] - Version 0.8.5
* Fixed build on 5.4 (patch from Felipe Pena)
[2010-08-01] - Version 0.8.2
* Fixed shared build
[2010-08-01] - Version 0.8.1
* Fixed build on 5.3 (patch from Felipe Pena)
* Allow compilation against LibXL 2.4.3k
* Added ExcelSheet::setProtect(), ExcelSheet::protect() to set/get sheet protection
* Added ExcelSheet::setPrintHeaders() to set printability of column/row headers
* Added ExcelSheet::setCellFormat() method (LibXL 2.4.3k+) to set a cell format
* Added ExcelBook::getAllFormats() method (LibXL 2.4.3k+) to get a list of all document formats
[2010-08-01] - Version 0.8
* Initial Release