geckon01/PhpSpreadsheet
1
0
Fork 0
mirror of https://github.com/PHPOffice/PhpSpreadsheet.git synced 2026-08-19 17:40:41 +00:00
Code Issues Packages Projects Releases Wiki Activity
Files
master
PhpSpreadsheet/samples/templates
T
History
oleibman 6a0d4ff527 No lumOff for Radar Charts 
Fix #661 (marked stale in 2018, but now reopened). That issue was already mostly resolved by many changes to Xlsx Chart Writer logic some time ago. However, a new problem popped up. PR #2950 added `brightness` logic to Xlsx Reader and Writer. That was done primarily for the benefit of scatter charts. Xlsx Writer writes two brightness properties `lumMod` and `lumOff`. These values are complete complementary (if you know one, you know the other), so I am not sure why both are needed, but my scatter chart testing indicated that they were. It turns out that Radar charts can also set brightness, but, if the writer specifies both `lumMod` and `lumOff`, the resulting chart is slightly off. There may be more to this, but that's all I can deal with for now - I suppress writing `lumOff` if we're writing a radar chart. If there are other problems in this area, I will wait for them to be reported. None of the existing radar chart samples used the brightness properties; however, the example attached to 661 did. It is added as a new Sample, and tests are added.
2026-06-09 12:26:11 -07:00
..
21d_FitToHeightPdf.xlsx
Attempt To Honor Fit to 1-Page Height for Html/Pdf (#3279)
2023-01-11 12:02:21 -08:00
26template.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
27template.xls
Writer Xls Handle Characters Outside Unicode BMP
2023-08-31 09:46:02 +08:00
27template.xlsx
Image Transparency/Opacity Including Html Reader Changes
2024-08-15 18:34:15 -07:00
28iterators.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
30template.xls
Stacked Alignment - Use Class Constant Rather than Literal (#1716)
2021-02-03 23:53:04 +01:00
30templatebiff5.xls
Stacked Alignment - Use Class Constant Rather than Literal (#1716)
2021-02-03 23:53:04 +01:00
31docproperties.xls
Reorganize code samples
2016-09-01 01:17:13 +09:00
31docproperties.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32chartreadwrite.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32complexChartreadwrite.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteAreaChart1.xlsx
Charts Support for Rounded Corners and Trendlines (#2976)
2022-08-06 18:06:36 -07:00
32readwriteAreaChart2.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteAreaChart3.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteAreaChart3D1.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteAreaChart4.xlsx
Expand Chart Support for schemeClr and prstClr (#2879)
2022-06-14 08:45:12 -07:00
32readwriteAreaPercentageChart1.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteAreaPercentageChart2.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteAreaPercentageChart3D1.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteAreaStackedChart1.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteAreaStackedChart2.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteAreaStackedChart3D1.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteBarChart1.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteBarChart2.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteBarChart3.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteBarChart3D1.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteBarChart4.xlsx
Charts Additional Support for Layout and DataSeriesValues (#2922)
2022-07-04 08:43:54 -07:00
32readwriteBarPercentageChart1.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteBarPercentageChart2.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteBarPercentageChart3D1.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteBarStackedChart1.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteBarStackedChart2.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteBarStackedChart3D1.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteBubbleChart1.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteBubbleChart2.xlsx
More Bubble Chart Fixes (#2856)
2022-05-28 18:45:47 -07:00
32readwriteBubbleChart3D1.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteChartWithImages1.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteColumnChart1.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteColumnChart2.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteColumnChart3.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteColumnChart3D1.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteColumnChart4.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteColumnPercentageChart1.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteColumnPercentageChart2.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteColumnPercentageChart3D1.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteColumnStackedChart1.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteColumnStackedChart2.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteColumnStackedChart3D1.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteComboChart1.xlsx
Xlsx Reader/Writer Composite Charts (#3265)
2023-01-01 15:08:14 -08:00
32readwriteDonutChart1.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteDonutChart2.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteDonutChart3.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteDonutChart4.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteDonutChartExploded1.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteDonutChartMultiseries1.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteLineChart1.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteLineChart2.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteLineChart3.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteLineChart3D1.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteLineChart4.xlsx
Move Gridlines from Chart to Axis (#2923)
2022-07-07 21:48:12 -07:00
32readwriteLineChart5.xlsx
Fix Chart Problems and Memory Leak in Xlsx Writer (#2930)
2022-07-14 08:30:36 -07:00
32readwriteLineChart6.xlsx
Font/Effects/Theme Support for Chart Data Labels and Axis (#3476)
2023-03-26 03:19:34 -07:00
32readwriteLineChartNoPointMarkers1.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteLineDateAxisChart1.xlsx
Charts - Add Support for Date Axis (#3018)
2022-08-24 19:31:55 -07:00
32readwriteLinePercentageChart1.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteLinePercentageChart2.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteLineStackedChart1.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteLineStackedChart2.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwritePieChart1.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwritePieChart2.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwritePieChart3.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwritePieChart3D1.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwritePieChart4.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwritePieChartExploded1.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwritePieChartExploded3D1.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteRadarChart1.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteRadarChart2.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteRadarChart3.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteRadarChart4.xlsx
No lumOff for Radar Charts
2026-06-09 12:26:11 -07:00
32readwriteScatterChart1.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteScatterChart2.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteScatterChart3.xlsx
Final Tweak (I Think)
2025-09-15 21:29:46 -07:00
32readwriteScatterChart4.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteScatterChart5.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteScatterChart6.xlsx
Some Fixes for Scatter Charts (#2828)
2022-05-17 07:48:24 -07:00
32readwriteScatterChart7.xlsx
More Chart Fixes (#2841)
2022-05-21 07:01:18 -07:00
32readwriteScatterChart8.xlsx
Add Chart Axis Option textRotation (#2940)
2022-07-17 06:46:22 -07:00
32readwriteScatterChart9.xlsx
Charts - Gradients, Transparency, Hidden Axes (#2950)
2022-07-23 08:06:13 -07:00
32readwriteScatterChart10.xlsx
Charts - Gradients, Transparency, Hidden Axes (#2950)
2022-07-23 08:06:13 -07:00
32readwriteScatterChartTrendlines1.xlsx
Additional Properties for Trendlines (#3028)
2022-08-27 22:59:35 -07:00
32readwriteStockChart1.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteStockChart2.xlsx
Stock Chart Improvements - Minor Break (#3515)
2023-04-15 07:17:44 -07:00
32readwriteStockChart3.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteStockChart4.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteStockChart5.xlsx
More Chart Fixes (#2841)
2022-05-21 07:01:18 -07:00
32readwriteSurfaceChart1.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteSurfaceChart2.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteSurfaceChart3.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
32readwriteSurfaceChart4.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
36writeLineChart1.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
36writeMultiple1.xlsx
Two Problems with Html Chart Rendering - Minor Break (#3787)
2023-11-13 06:53:03 -08:00
37dynamictitle.xlsx
Chart Dynamic Title and Special Font Properties (#3800)
2023-11-30 08:01:56 -08:00
43mergeBook1.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
43mergeBook2.xlsx
Reorganize code samples
2016-09-01 01:17:13 +09:00
46readHtml.html
HTML reader supports text and background color from inline CSS, for td and th element
2017-06-23 11:28:17 +02:00
47_xlsfill.xls
Problems Formatting Very Small and Very Large Numbers (#3152)
2022-11-07 06:36:04 -08:00
47_xlsxfill.xlsx
Fill Pattern Start and End Colors (#2444)
2021-12-18 08:53:23 -08:00
50_xlsverticalbreak.xls
Xls Reader Vertical Break and Writer Page Order (#3306)
2023-01-20 17:33:19 -08:00
56_MixedDateFormats.ods
Ods Writer Support Some Number Formats
2026-02-10 23:48:49 -08:00
BasicConditionalFormatting.xlsx
Conditional and table formatting support for html writer
2025-03-26 15:30:33 +02:00
chart-with-and-without-overlays.xlsx
Support for configuring a Chart Title's overlay (#3325)
2023-01-30 18:37:18 -08:00
chartSpreadsheet.php
Phpstan and Samples
2025-04-05 13:54:20 -07:00
ColourScale.xlsx
Conditional and table formatting support for html writer
2025-03-26 15:30:33 +02:00
ConditionalFormattingConditions.xlsx
Conditional and table formatting support for html writer
2025-03-26 15:30:33 +02:00
excel2003.short.bad.xml
Improving Coverage for Excel2003 XML Reader (#1557)
2020-10-11 13:26:56 +02:00
excel2003.xml
Reader XML Properties - Eliminate strtotime (#2134)
2021-05-31 11:04:07 +02:00
Excel2003XMLTest.xml
Prefer https:// URLs when available in docs & comments
2018-10-28 13:55:00 +11:00
GnumericTest.gnumeric
Improve Coverage for Gnumeric (#1517)
2020-06-19 20:34:02 +02:00
largeSpreadsheet.php
Phpstan and Samples
2025-04-05 13:54:20 -07:00
Mpdf2.php
Minor Modifications to Sample Names and Locations
2025-12-08 08:53:59 -08:00
old.gnumeric
Improve Coverage for Gnumeric (#1517)
2020-06-19 20:34:02 +02:00
OOCalcTest.ods
Ods Reader Style Support Part 3 - Borders
2026-02-19 17:54:39 -08:00
sampleSpreadsheet2.php
Hyperlink Styles
2025-05-20 22:54:08 -07:00
sampleSpreadsheet.php
Hyperlink Styles
2025-05-20 22:54:08 -07:00
ShadowsIntoLight-Regular.ttf
Minor Modifications to Sample Names and Locations
2025-12-08 08:53:59 -08:00
ShadowsIntoLight.OFL.txt
Minor Modifications to Sample Names and Locations
2025-12-08 08:53:59 -08:00
SortExcel.php
Update Samples
2026-05-31 01:15:04 -07:00
SylkTest.slk
Improve Coverage for Sylk (#1514)
2020-06-19 20:35:44 +02:00
TableFormat.xlsx
Conditional and table formatting support for html writer
2025-03-26 15:30:33 +02:00