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
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
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
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
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
88b48ad947
fpspreadsheet: Use category "CCR" in fpspreadsheet example projects' metadata files.
...
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@8802 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-04-24 14:17:59 +00:00
b9a6cade84
fpspreadsheet: ex-meta files for the visual demos.
...
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@8786 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2023-04-10 21:08:40 +00:00
501e848dcb
fpspreadsheet: Check (and fix) compilation of all demos. Reset debugger to "automatic".
...
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@7991 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2021-04-14 23:33:18 +00:00
8096d92b8f
fpspreadsheet: Add option to define series labels in TsWorkbookChartSource.
...
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@6564 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2018-07-22 13:58:46 +00:00
00c14b31a1
fpspreadsheet: Fix mis-named folders examples/visual/fpschart/workbookchartsource and .../worksheetchartsource to have the "deprecated" at the correct place.
...
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@6563 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2018-07-22 08:42:38 +00:00
40fabfc201
fpspreadsheet: Redo storage of formulas: formulas now are stored in a separate tree independent of the cells tree. The field FormulaValue of TCell record was removed. All unit tests passed. Demos updated (issues of speedtest due to SST in BIFF8 found - not related).
...
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@6446 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2018-05-30 22:15:07 +00:00
f85d2543ba
fpspreadsheet: Make sure that all demos are compiled with -Xg
...
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@5764 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2017-02-20 17:21:56 +00:00
5b946b751f
fpspreadsheet: Add units (mm, cm, in, pts, lines/chars) for column width and row heights. Update all demos (some issues left).
...
NOTE: This revision breaks existing code if the worksheet's DefaultRowHeight/DefaultColWidth is changed - value must be in millimeters now. Methods for accessing individual row heiths and column widths are fine, but are marked as deprecated, they use the old units. Optionally a unit parameter can be specified.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@4568 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2016-03-18 19:50:40 +00:00
f94692451c
fpspreadsheet: Fix duplicate unit issues for examples requiring installed visual package
...
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@4022 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2015-03-13 17:49:33 +00:00
380ac8247c
fpspreadsheet: Rearrange most of the demos into folders "read_write" and "visual"
...
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@4019 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2015-03-13 00:08:44 +00:00