Commit Graph

468 Commits

Author SHA1 Message Date
Mark Baker
83b8e9dad3 Bugfix: (wolf5x) Work item 18492 - load file failed if the file has no extensionType 2012-08-19 23:57:16 +01:00
Mark Baker
b00f6d4c4c AutoFilter unit tests 2012-08-19 23:17:12 +01:00
Mark Baker
61bc7c8e98 Autofilter show/hide for all dynamic types now complete (still with
debugs)
2012-08-19 11:14:34 +01:00
Mark Baker
f9a1267697 Dynamic autofilter show/hide rows for this/next/last
week/month/quarter/year etc
2012-08-18 23:41:16 +01:00
Mark Baker
960f5a32a2 Range argument tests with default value in cell range methods, and further
AutoFilter expression evaluation for dynamic filters
2012-08-16 22:53:13 +01:00
Mark Baker
bb0d413a67 Fix to dynamic autofilter expression in writer, preventing writing
blanks="1"
2012-08-16 00:29:07 +01:00
Mark Baker
83afa87bf3 Fixed broken build after recent autofilter changes 2012-08-15 13:20:34 +01:00
Mark Baker
18920d60c7 Merge pull request #25 from alexgann/patch-2
Add cell indent to html rendering
2012-08-13 05:09:42 -07:00
Mark Baker
db1f8c98f0 The bulk of the autofilter expressions work for Excel2007, including
documentation
2012-08-13 00:14:51 +01:00
alexgann
dae529615e Add cell indent to html rendering
Quick one-liner to render cell indents in html as padding. 9px seems to be what Excel uses internally
2012-08-10 21:34:39 -03:00
unknown
303a6443ed Initial Writer code for autofilter selections 2012-08-09 21:26:33 +01:00
unknown
1bd83a115e Merge branch 'develop' into autofilter 2012-08-09 12:41:46 +01:00
unknown
2251839f66 Support for AutoFilter active filters in the Excel2007 Reader 2012-08-09 12:38:11 +01:00
unknown
14686dbb42 Feature: (k1LoW) Support SheetView view attribute (Excel2007)
modified to add reader support, and refactored validation
2012-08-09 12:35:04 +01:00
k1LoW
d24e640801 Support SheetView view param 2012-08-09 10:13:05 +09:00
unknown
c9daa12245 Initial work on AutoFilter selections reading from Excel2007 (with
diagnostics, remember to remove before any merging to develop)
2012-08-08 22:11:26 +01:00
Mark Baker
c770117193 Validation fix to mathematical matrix functions 2012-08-07 23:44:35 +01:00
Mark Baker
b694241de6 Merge branch 'develop' of https://github.com/PHPOffice/PHPExcel into autofilter 2012-08-07 10:16:03 +01:00
Mark Baker
938ce8d51f Bugfix: Work item 18325 - v-type texts for series labels now recognised and parsed correctly 2012-08-06 22:40:24 +01:00
Mark Baker
6c9a907027 Bugfix: Work item 18145 - Autoshape being identified in twoCellAnchor when includeCharts is TRUE triggering load error 2012-08-06 11:41:05 +01:00
Mark Baker
8ba160ed28 Modify Test examples to echo nicely from both CLI and in a web browser 2012-08-05 18:54:20 +01:00
Mark Baker
b2b66ecfd4 Merge branch 'charts' into develop 2012-08-04 16:11:25 +01:00
Mark Baker
7d13b6de2e Bugfix: Work item 18377 - Chart Title compatibility on Excel 2007 2012-08-04 16:08:28 +01:00
Mark Baker
cdf9dfdcbe Unit tests, plus a couple of minor validation bugfixes 2012-08-03 21:21:32 +01:00
Mark Baker
7fae37247b General: Magic __toString() method added to Cell object to return raw data value as a string 2012-08-01 21:41:00 +01:00
Mark Baker
0b60b61104 Bugfix: takaakik) Work Item 15455 - getNestingLevel() Error on Excel5 Read
Bugfix: ix to Excel5 Reader when cell annotations are defined before their referenced text objects
2012-08-01 17:25:10 +01:00
Mark Baker
83c083392a GH18 - Modify extractAllCellReferencesInRange() behaviour for , and space
range separators
2012-07-31 13:00:09 +01:00
Mark Baker
6a14bdce4c Unit tests for Cell static methods and creation of PHPExcel_Exception
rather than use of standard Exception
2012-07-29 20:56:35 +01:00
Mark Baker
8f3dc270a6 Bugfix: Work Item 18415- mb_stripos empty delimiter 2012-07-27 22:06:28 +01:00
Mark Baker
8ab0200584 Further chart bugfixes, plus an example of changing chart data for use in
templates
2012-07-27 12:22:47 +01:00
Mark Baker
b871674f18 Ensure that chart worksheet is correctly set when adding chart to a
worksheet
2012-07-26 20:04:52 +01:00
Mark Baker
8e41c70d41 General: Work item 18404 - setCellValueExplicitByColumnAndRow() do not return PHPExcel_Worksheet 2012-07-25 23:54:53 +01:00
Mark Baker
013c18b859 General - merged (with some localisation mods) from a pull request by alexgann - Add Currency detection to the Advanced Value Binder 2012-07-25 13:15:27 +01:00
Mark Baker
dbe12c73a2 Formatting constant GENERAL should be FORMAT_GENERAL 2012-07-24 07:39:36 +01:00
Mark Baker
317f00b259 Bugfix to ensure that General format is not treated as a date format
despite containg e for epoch
OOCalc Reader modified to process number-rows-repeated
Modify OOCalc Reader to only read cells that containing data, or merged cells
(depending on setReadDataOnly setting)
2012-07-23 21:52:14 +01:00
Mark Baker
868d14a84d Fix to OOCalc Reader for percentage and currency datatypes 2012-07-23 12:29:15 +01:00
Mark Baker
19dfbfe418 Remove chart diagnostics from echoes 2012-07-21 11:57:02 +01:00
Mark Baker
679f95773e Chart Writing bugfix to refresh values 2012-07-21 11:52:20 +01:00
Mark Baker
8bcf795e16 Chart writing bugfixes 2012-07-20 23:53:16 +01:00
Mark Baker
dd69a5a134 More chart bugfixing 2012-07-20 23:13:16 +01:00
Mark Baker
946ea73ddb Bugfixes to Chart Reader and Writer 2012-07-20 22:35:53 +01:00
Mark Baker
5e44fa2517 Issue #5 - Refactor autoFilter range into an autofilter class in
preparation for adding support for autofilter expressions
2012-07-18 21:12:02 +01:00
Mark Baker
59932b0cac Bugfix: Work item 18370 - Error loading xlsx file with column breaks
Deprecated the getCalculatedValue(), setCalculatedValue(), setFormulaAttributes() and getFormulaAttributes() methods in PHPExcel_Cell.
Documentation changes and unit tests.
2012-07-18 12:29:33 +01:00
Mark Baker
1535b4d9e7 Feature: Modified ERF and ERFC Engineering functions to accept Excel 2010's modified acceptance of negative arguments 2012-07-14 14:20:17 +01:00
Mark Baker
5925bc8a65 Extended IOFactory list of file extensions matched to Readers 2012-07-14 12:33:03 +01:00
Mark Baker
15ccc845da Improved canRead test for OOCalc files 2012-07-14 11:45:32 +01:00
Mark Baker
78b7019247 Set temporary directory for PCLZip wrapper 2012-07-14 10:32:36 +01:00
Mark Baker
e2a2fdb335 Bugfix: (seltzlab) Fix to excel2007 Chart Writer when a $plotSeriesValues is empty 2012-07-14 01:26:53 +01:00
Mark Baker
c20c5f6ac8 Bugfix: (wackonline) OOCalc Reader fix for NULL cells 2012-07-14 00:40:55 +01:00
Progi1984
e1104f1862 ADDED : Implement support for AutoFilter in PHPExcel_Writer_Excel5 2012-07-13 18:20:06 +02:00
Mark Baker
b7acf2bbe4 Bugfix: Work items 15905 and 18183
Allow "no impact" to formats on Conditional Formatting
2012-07-02 22:38:24 +01:00
Mark Baker
6710c8a136 Bugfix: Work items 15799 and 18278
Background color cell is always black when editing cell
2012-06-26 21:08:11 +01:00
Mark Baker
57464cbf1a Bugfix: Support for "e" (epoch) date format mask
Rendered as a 4-digit CE year in non-Excel outputs
2012-06-26 20:55:27 +01:00
Mark Baker
6285555c52 Minor tweaks to charts, unit testing for charts, and pdf examples 2012-06-24 13:34:57 +01:00
Mark Baker
d700807ed0 Convert string text to rich text for chart title and axis labels 2012-06-18 23:43:53 +01:00
Mark Baker
ccc562dea8 Setter methods for Title, Legend, X and y axis labels 2012-06-18 22:26:22 +01:00
Mark Baker
5193c6c35d Envelope case validation and fix return values
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@91574 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-06-10 22:06:14 +00:00
Mark Baker
92461ae067 Set htmlspecialcharacters for text fields
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@91573 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-06-10 22:05:40 +00:00
Mark Baker
1b642d4e7d Validate existence of PDF Renderer library before instantiating renderer class
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@91572 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-06-10 22:05:00 +00:00
Mark Baker
3783c7e099 Feature: Initial version of HTML Reader
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@91447 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-06-07 19:43:19 +00:00
Mark Baker
ec9256a12e Bugfix: Patch 12318 - OOCalc cells containing <text:span> inside the <text:p> tag
Bugfix: Fix to listWorksheetInfo() method for OOCalc Reader

git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@91446 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-06-07 19:42:45 +00:00
Mark Baker
2cd4c7e044 Validate Graph and PDF Renderer library directories
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@91353 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-06-05 14:18:55 +00:00
Mark Baker
4fa6c2ceaf Removed spurious final blank page from PDF Writer output
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@91328 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-06-04 21:34:16 +00:00
Mark Baker
6dc94c6e04 Refactor individual library PDF writers to use a common core class for all shared methods
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@91320 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-06-04 16:20:43 +00:00
Mark Baker
2329e178aa Gridlines fix for tcPDF renderer
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@91319 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-06-04 15:48:05 +00:00
Mark Baker
b9ca129e74 Case-sensitivity for PDF renderer library options
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@91297 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-06-03 21:45:33 +00:00
Mark Baker
dccaf0b676 Remove embedded tcPDF from repository - this is now an optional choice of PDF renderer, and must be installed separately if required
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@91295 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-06-03 21:23:56 +00:00
Mark Baker
686f35e182 Initial refactoring of PDF Writer to work with user-selection of 3rd party PDF libraries
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@91294 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-06-03 21:20:05 +00:00
Mark Baker
5f301a72c1 Additional validation on Worksheet name when adding/creating a new worksheet
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@90941 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-05-25 06:45:01 +00:00
Mark Baker
762f12624b Bugfix: Work item 17471 - OOCalc cells contain same data bug?
Plus a couple of charting bugs


git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@90420 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-05-13 18:15:09 +00:00
Mark Baker
540aebe68b Fix to use of $updateFormulaCellReferences flag in setTitle() method for worksheets
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@89095 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-04-11 19:46:29 +00:00
Mark Baker
2093d9274f Additional argument validation
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@89018 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-04-09 11:25:27 +00:00
Mark Baker
c284eef55e Additional argument validation
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@88996 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-04-08 20:39:24 +00:00
Mark Baker
193a766ab3 Fix to UOM Conversion where input UoM is the same as output UoM
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@88979 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-04-08 14:52:27 +00:00
Mark Baker
64cc573a1e Fixed missing {
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@88966 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-04-07 23:28:55 +00:00
Mark Baker
2917b44fe3 Fixed missing {
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@88965 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-04-07 23:15:41 +00:00
Mark Baker
e321a1666d Fixed missing }
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@88964 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-04-07 23:12:47 +00:00
Mark Baker
9785cbea82 Minor fix to Financial RATE() function
Refresh method for charts

git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@88962 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-04-07 20:54:55 +00:00
Mark Baker
63c411791e New Reader Feature: listWorksheetInfo() method added to Readers... courtesy of Christopher Mullins (schir1964)
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@88720 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-03-31 19:17:24 +00:00
Mark Baker
f65dfa951e Fix when format is not defined for data series values, thanks to pnomolos
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@88558 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-03-28 12:02:24 +00:00
Mark Baker
8309a14df5 Remove comment about Euro, correct currency is Zloty - thanks for confirming dkrysiak
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@88557 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-03-28 11:59:44 +00:00
Mark Baker
4347e0635a Doc Block changes
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@88405 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-03-25 23:58:02 +00:00
Mark Baker
6fcec48233 Enable DAVERAGE() Excel function
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@88401 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-03-25 22:23:30 +00:00
Mark Baker
0735f2c61e Doc Block changes
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@88400 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-03-25 22:22:20 +00:00
Mark Baker
fe91406bfc Doc Block changes, plus improvements to financial month start and month end test methods
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@88322 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-03-24 23:14:35 +00:00
Mark Baker
699467cd0f Doc Block changes
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@88243 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-03-23 18:03:25 +00:00
Mark Baker
3d7153c7f4 Doc Block changes
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@88175 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-03-21 23:55:54 +00:00
Mark Baker
ffdb1966b1 Doc Block changes
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@88003 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-03-19 00:25:29 +00:00
Mark Baker
8ade1b8a69 Doc Block changes
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@87976 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-03-18 16:26:03 +00:00
Mark Baker
4f76dfad97 Bugfix: (bnr) Work item 17501 - =sumproduct(A,B) <> =sumproduct(B,A) in xlsx
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@87695 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-03-12 23:42:12 +00:00
Mark Baker
4bb4f5ebc8 Doc Block changes
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@87642 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-03-11 19:24:20 +00:00
Mark Baker
891981928d Doc Block changes
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@87638 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-03-11 17:58:38 +00:00
Mark Baker
953b1e82fb Doc Block changes
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@87578 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-03-10 23:29:09 +00:00
Mark Baker
15391c2074 Doc Block changes
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@87576 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-03-10 22:43:00 +00:00
Mark Baker
0de1f6324d Doc Block changes
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@87554 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-03-10 11:38:35 +00:00
Mark Baker
19403c43d8 Doc Block changes
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@87550 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-03-10 11:15:37 +00:00
Mark Baker
eeac8e3b7f Doc Block changes
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@87549 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-03-10 11:14:05 +00:00
Mark Baker
b3cb86ccff Doc Block changes
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@87532 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-03-09 23:55:17 +00:00
Mark Baker
4562c83ec8 Minor fix to varyColor
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@87267 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-03-04 11:30:33 +00:00
Mark Baker
1600961140 Minor fix to chart dataseries for charts with only one series
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@87266 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-03-04 11:15:46 +00:00
Mark Baker
c275bf7a8d Change copyright 2011 -> 2012
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@87249 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-03-03 21:29:01 +00:00
Mark Baker
2526492ca5 Change copyright 2011 -> 2012
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@87248 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-03-03 21:16:09 +00:00
Mark Baker
b3fc8424f3 Change copyright 2011 -> 2012
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@87247 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-03-03 21:09:50 +00:00
Mark Baker
7bda2c3f3b Change copyright 2011 -> 2012
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@87246 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-03-03 21:08:29 +00:00
Mark Baker
22404188a0 Work Item 17516 - Issue #1 fix bad cut-and-paste
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@87244 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-03-03 20:22:13 +00:00
Mark Baker
69671d2dc7 Additional work on stock charts
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@87128 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-02-29 22:01:45 +00:00
Progi1984
41199626d8 FIXED : Work item 8916 - Support for Rich-Text in PHPExcel_Writer_Excel5
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@87070 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-02-27 22:05:21 +00:00
Mark Baker
e0751201b8 Radar fills
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@87008 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-02-26 16:27:05 +00:00
Mark Baker
b95a61b6d5 Scatter chart basics, prevent problems with other chart types
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@87002 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-02-26 13:42:36 +00:00
Mark Baker
ed6d71cb92 Scatter chart basics
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@87000 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-02-26 12:31:03 +00:00
Mark Baker
938dcd9d5f Minor refactoring
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@86972 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-02-25 18:46:39 +00:00
Mark Baker
e60920e7f7 Minor refactoring
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@86968 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-02-25 18:22:39 +00:00
Mark Baker
8bbb468122 Radars and some fixes to bubbles
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@86922 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-02-24 23:58:02 +00:00
Mark Baker
49e485e010 Can't give you exploding penguins.... so here's the next best thing: exploding pies and donuts
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@86908 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-02-24 17:08:13 +00:00
Mark Baker
778ec9e7af Fix for stacked and percentage grouping son bar and column charts
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@86904 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-02-24 13:30:22 +00:00
Mark Baker
fdd1b20830 Tweak to varyColors element
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@86902 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-02-24 13:13:38 +00:00
Mark Baker
e624bb7c9e Holes in doughnuts
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@86882 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-02-24 07:45:08 +00:00
Mark Baker
2a8dc8f7f5 Fixes to Pie and Donut charts
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@86871 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-02-23 23:49:45 +00:00
Mark Baker
fac2858b1d Fixes to rich text in charts
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@86842 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-02-23 17:20:25 +00:00
Mark Baker
3392f46985 Minor tweak to fix colours from the pallette index
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@86741 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-02-21 17:28:37 +00:00
Mark Baker
9b462e941d Reset Theme.php charset to UTF-8 without BOM as fix for far-eastern fonts
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@86736 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-02-21 14:17:35 +00:00
Mark Baker
3543ea45ef Bugfix: Work item 17186 - setSelectedCellByColumnAndRow is not working
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@86732 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-02-21 10:44:10 +00:00
Mark Baker
4e6807578e Initial chart writer code (still annoyingly buggy)
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@86726 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-02-20 22:47:06 +00:00
Mark Baker
6ba19b8241 Initial chart writer code (still annoyingly buggy)
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@86721 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-02-20 20:49:25 +00:00
Mark Baker
29fcbd0c97 Fix point count in multi-level dataseries
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@86522 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-02-15 23:28:46 +00:00
Mark Baker
3b47bd0852 Rich text should be inline rather than string... still needs testing for readers/writers of all file formats
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@86490 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-02-14 23:30:00 +00:00
Mark Baker
18a5e7d2a4 Initial merge of Chart reader code
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@86489 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-02-14 23:28:41 +00:00
Mark Baker
337af28233 Prevent stack overflow problem when formula in a cell contains a named range without a worksheet reference... this doesn't fix the formula, but does avoid the exception and allows the workbook to be written with the problematic cell as a blank
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@86488 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-02-14 23:27:50 +00:00
Mark Baker
b18939b29d Minor fixes for strict standards
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@86471 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-02-14 13:48:09 +00:00
Mark Baker
ffb8ccc362 Bugfix: Work item 15459 - Invalid cell coordinate in Autofilter for Excel2007 Writer
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@86455 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-02-14 01:03:40 +00:00
Mark Baker
6f91dd9f59 Bugfix: Work item 17403 - duplicateStyle() method doesn't duplicate conditional formats
Added an equivalent duplicateConditionalStyle() method for duplicating conditional styles

git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@86383 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-02-12 18:04:22 +00:00
Mark Baker
df29d7d985 Chart reader code, still detached from the workbook reader until I'm ready to commit that
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@86206 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-02-08 22:44:00 +00:00
Mark Baker
b41407743e Whoopsee... managed to introduce a bug when changing is_null() to === NULL for performance reasons, and reversed the logic of the test..... this is the fix
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@86204 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-02-08 22:33:31 +00:00
Mark Baker
73f013c68f Initial addition of chart classes, though not yet including the reader/writer code for loading the classes
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@86197 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-02-08 21:17:39 +00:00
Mark Baker
0285c3e428 Inline documentation changes
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@85955 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-02-02 10:27:14 +00:00
Progi1984
44b3fa2c94 ADDED : Documents Properties Writing in Excel5Writer
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@85916 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-01-31 23:53:21 +00:00
Mark Baker
42fa6f10a1 Minor tweaks to Excel functions to handle envelope cases
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@85866 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-01-30 00:41:52 +00:00
Mark Baker
695edbf677 Minor tweaks to Excel functions to handle envelope cases
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@85852 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-01-29 14:25:25 +00:00
Mark Baker
9f2addc893 Minor tweaks to Excel functions to handle envelope cases
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@85793 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-01-26 22:39:21 +00:00
Mark Baker
f0959c9ef3 Minor tweaks to Excel functions to handle envelope cases
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@85783 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-01-26 20:06:35 +00:00
Mark Baker
d5ce069cfc minor performance tweak
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@85749 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-01-26 00:53:20 +00:00
Mark Baker
bed8ef21b4 Removal of redundant code: break after return in case statements
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@85747 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-01-26 00:49:34 +00:00
Mark Baker
9c2ceed08d Minor performance tweaks
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@85743 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-01-25 23:07:22 +00:00
Mark Baker
2cce9b754d Minor performance tweaks and adjustments to Excel functions to handle a few envelope test cases
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@85742 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-01-25 22:07:35 +00:00
Mark Baker
f9e719dc52 Minor tweaks to Excel functions to handle envelope cases
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@85631 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-01-22 19:00:42 +00:00
Mark Baker
508be392e7 Minor performance tweaks
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@85527 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-01-19 22:36:22 +00:00
Mark Baker
9bec4af001 Fix to inappropriate replacement of count() with empty().... there may be others I've not spotted yet.
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@85438 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-01-18 17:55:51 +00:00
Mark Baker
414209c03d Fix to inappropriate replacement of count() with empty().... there may be others I've not spotted yet.
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@85437 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-01-18 17:51:53 +00:00
Mark Baker
21cce674c8 Fix to inappropriate replacement of count() with empty().... there may be others I've not spotted yet.
Improved debuglog in calculation engine.

git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@85403 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-01-17 21:57:06 +00:00
Mark Baker
24a9eb285c Use of empty() rather than count() to test if arrays are empty or not - simple performance tweak... empty() is over twice as fast as count()
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@85344 2327b42d-5241-43d6-9e2a-de5ac946f064
2012-01-16 12:34:22 +00:00