670 Commits

Author SHA1 Message Date
4029403012 fpspreadsheet: Support error bar ranges in chart link (only for single-valued charts, though - limitation of TAChart).
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9106 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-12-28 18:15:59 +00:00
03417e642f fpspreadsheet: ods writer supports error bars.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9102 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-12-24 23:23:34 +00:00
8b8a73d887 fpspreadsheet: Add demo for stacked & rotated bar series.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9095 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-12-19 13:24:39 +00:00
41fda1fbfb fpspreadsheet: Chart link supports rotated axes.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9094 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-12-19 12:30:16 +00:00
e10ac1b73e fpspreadsheet: Fix labels of rotated axes in chart link.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9087 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-12-16 18:45:36 +00:00
689b43288e fpspreadsheet: Some progress with rotated axis labels in chart link.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9086 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-12-15 23:38:58 +00:00
c085882894 fpspreadsheet: Better display of pointer symbols in chart legend.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9085 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-12-15 15:31:40 +00:00
af15ca0540 fpspreadsheet: Beginning with rotated axes in chart link. Simplify generation of sample ods files.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9084 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-12-14 22:50:59 +00:00
c7f8430eb8 fpspreadsheet: Fix ods writer to create stock+volume charts. Add demo for it.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9080 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-12-13 21:51:57 +00:00
12849441cd fpspreadsheet: ods writer supports stockseries
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9079 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-12-13 21:22:33 +00:00
dc777e99cf fpspreadsheet: Fix compilation back to Laz v2.0.12
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9076 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-12-08 16:54:08 +00:00
9914514709 fpspreadsheet: Add the ohlcseries of Laz/main as TStockseries in unit fpsstockseries for supporting the HLC series of Excel and Calc.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9075 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-12-07 22:53:48 +00:00
e8a24a0cf0 fpspreadsheet: More on date/time formats for axis labels.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9074 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-12-06 14:11:04 +00:00
6f9b697780 fpspreadsheet: Add demos writing data for linear and logarithmic charts.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9069 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-12-04 21:14:22 +00:00
634319d562 fpspreadsheet: Complete primary and secondary axis support
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9068 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-12-04 18:53:04 +00:00
91474f2d49 fpspreadsheet: Initial commit to support secondary y axis in ods reader/writer and chart link.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9065 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-12-04 00:29:43 +00:00
faaed4b25b fpspreadsheet: Improved user interface for adding datapoint styles in workbook charts.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9064 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-12-02 21:13:09 +00:00
8919da735c fpspreadsheet: Chart link as well as ods reader/writer support individual data point colors
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9063 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-12-01 23:54:16 +00:00
fb4abdab4d fpspreadsheet: Adjust chart link to new percentage-sized bubble series radii. No longer ignore font of series labels.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9062 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-11-30 23:20:34 +00:00
5926c10883 fpspreadsheet: Fix border when drawing data point marks.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9060 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-11-29 16:47:46 +00:00
7394833a30 fpspreadsheet: Show regression formula in chart with number format specified in file.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9059 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-11-29 12:33:37 +00:00
f14558000b fpspreadsheet: Remove requirement to call chart.AddSeries.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9056 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-11-29 00:09:59 +00:00
22e45acc19 fpspreadsheet: Reset TChart.Proportional to false when a new chart is created (distorts axes after drawing a radar series).
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9054 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-11-28 23:29:59 +00:00
e041a4109e fpspreadsheet: Extended chart display demo. Rework TsWorkbookSource's ListenerNotification to avoid crash when chart destroy a listening chartsource. Chart link can display pie series now.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9053 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-11-28 23:04:27 +00:00
8b51f30e14 fpspreadsheet: Add ods writer demo for TsBubbleSeries. Chart link supports reading TsBubbleSeries (but: size issues to be fixed in TAChart).
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9052 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-11-28 21:22:46 +00:00
2df3e382a2 fpspreadsheet: Chart link supports 100%-stacking for bar, area and line series.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9050 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-11-27 22:41:30 +00:00
bdd483000f fpspreadsheet: Chart link supports stacked area and line series.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9049 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-11-27 21:37:13 +00:00
2c6fbd54c5 fpspreadsheet: Fix cooperation of changed TsWorkbookChartSource with TsWorkbookChartLink.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9047 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-11-27 18:17:22 +00:00
baf8abdc40 fpspreadsheet: Update workbookchartsource demo to show multiple-y-values feature.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9046 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-11-26 23:04:52 +00:00
d83922c334 fpspreadsheet: Chart links supports a very basic radar series.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9044 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-11-26 00:30:18 +00:00
c86abab97c fpspreadsheet: Fix memory leaks
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9041 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-11-23 22:13:52 +00:00
cb2cb5ef60 fpspreadsheet: ods reader and chart link support bitmap fill patterns.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9040 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-11-23 18:49:41 +00:00
49b6486be7 fpspreadsheet: Chart link supports regression curve in scatter plot.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9039 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-11-23 00:08:33 +00:00
6946f27d34 fpspreadsheet: Chart link supports series marks, and pie series. Add related missing properties to ods reader/writer.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9038 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-11-22 22:08:47 +00:00
71f5985598 fpspreadsheet: Chart link supports bar, line and area series.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9037 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-11-22 14:23:55 +00:00
7ea57aae2b fpspreadsheet: Add chart link demo
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9036 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-11-21 22:03:20 +00:00
9ced830ecc fpspreadsheet: Remove deprecated TsWorksheetChartSource.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9033 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-11-21 11:16:16 +00:00
3d9619fe06 fpspreadsheet: ods reader supports number formats in charts.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9023 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-11-12 18:12:12 +00:00
9b0e01149c fpspreadsheet: ods reader support regression in scatter series.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9022 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-11-12 00:04:38 +00:00
927d08783d fpspreadsheet: ods reader supports chart series.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9021 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-11-10 23:31:27 +00:00
0a956f3056 fpspreadsheet: No longer ignore worksheets in chart cell ranges.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9020 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-11-10 16:19:22 +00:00
d4f01977aa fpspreadsheet: ods reader support chart axes.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9019 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-11-09 23:15:33 +00:00
78fe3945ba fpspreadsheet: ods reader supports chart title and subtitle.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9018 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-11-08 21:54:29 +00:00
f82f76457d fpspreadsheet: ods reader supports chart legend.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9017 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-11-08 18:33:29 +00:00
97d23a09e0 fpspreadsheet: ods reader supports chart background and border
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9015 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-11-07 22:37:30 +00:00
b28852a155 fpspreadsheet: ods chart reader supports gradient styles.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9014 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-11-07 19:17:23 +00:00
818083dd9f fpspreadsheet: Initial commit of ods chart reader (not complete).
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9013 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-11-07 17:25:03 +00:00
2053c444cb fpspreadsheet: Support hatched fills in charts and writing to ods.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9010 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-11-05 19:05:11 +00:00
077717d3f0 fpspreadsheet: Support gradients in charts and writing to ods.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9009 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-11-05 00:26:04 +00:00
b66f052dc4 fpspreadsheet: Support number formatting in charts.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9008 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-11-03 22:36:00 +00:00