201 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
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
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
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
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
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
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
c4d733bd08 fpspreadsheet: Add example project for writing ods with regression chart.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9007 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-11-03 18:58:20 +00:00
0fe9411ff3 fpspreadsheet: Support regression.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9006 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-11-03 18:56:15 +00:00
3fc925936c fpspreadsheet: Support filled radar series. Add radar series demo.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9004 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-10-30 22:37:44 +00:00
7335cf0733 fpspreadsheet: Support pie and ring series. Add piechart demo.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9003 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-10-30 17:41:53 +00:00
1176d41a94 fpspreadsheet: Support radar charts.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9002 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-10-30 14:56:16 +00:00
2f80394b32 fpspreadsheet: Add writing of series labels to ods.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9001 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-10-30 14:37:53 +00:00
ceec0a7159 fpspreadsheet: Support axis position and inner/outer tick lines in ods writer.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@9000 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-10-29 21:33:39 +00:00
6a183346ed fpspreadsheet: Support manual axis scaling in ods writer.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@8999 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-10-29 18:36:13 +00:00
2c8dac0888 fpspreadsheet: Fix series fills and chart titles in ods writer.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@8998 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-10-29 16:12:34 +00:00
fb8b6eef96 fpspreadsheet: Support individual fill colors of bars, bubbles, symbols. Fix dash line pattern broken after previous commit.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@8997 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-10-29 15:52:46 +00:00
b8bff13140 fpspreadsheet: Split chart writing code off of ods writer.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@8996 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-10-29 12:10:50 +00:00
0599bd5dcd fpspreadsheet: Add support for bubble series.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@8991 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-10-28 12:07:10 +00:00
43aa702f8e fpspreadsheet: different interpolation types for line and scatter plots.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@8990 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-10-27 22:28:13 +00:00
1ec2d7c28c fpspreadsheet: ods writer supports scatter charts
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@8989 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-10-27 21:24:32 +00:00
87c0d8cc73 fpspreadsheet: Add TsAreaSeries. Add stack and 100%-stack modes (not working)
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@8988 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-10-27 20:44:33 +00:00
ff3ea1135b fpspreadsheet: Improved handling of rotated axis titles for horizontal bar charts
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@8987 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-10-27 20:09:03 +00:00
4fffa53722 fpspreadsheet: Simplify creation of the chart styles by the ods writer.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@8986 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-10-27 17:45:33 +00:00
1b7bcf0ee9 fpspreadsheet: ods writer supports bar series (vertical and horizontal bars)
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@8985 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-10-26 22:00:07 +00:00
f63bc90ba7 fpspreadsheet: Support chart legend position in ods writer.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@8984 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-10-26 21:21:51 +00:00
eded936053 fpspreadsheet: ods chart writer supports legend overlapping with plot area.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@8982 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-10-26 11:30:36 +00:00