63 Commits

Author SHA1 Message Date
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
5cdb8c16c7 fpspreadsheet: Add TsWorksheetIndicator as new visual control. Donated by forum user "abcthing" (https://forum.lazarus.freepascal.org/index.php/topic,49312.0.html)
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@7385 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2020-04-15 22:19:20 +00:00
21b927cc27 fpspreadsheet: Add property Worksheet.Index.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@7005 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2019-06-09 23:15:10 +00:00
2e252ce658 fpspreadsheet: Add new TsWorkbookTabControl property ShowAllSheets (to be used to hide sheets marked as hidden).
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@6555 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2018-07-10 09:25:25 +00:00
685581a8da fpspreadsheet: Fix WorksheetGrid event OnSelectCell not firing any more. Less hints.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@5905 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2017-05-27 16:43:27 +00:00
055a4eb439 fpspreadsheet: Fix reader not found error in demos fpsctrls and fpsctrls_no_install
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@5848 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2017-05-11 21:38:15 +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
3e6dd484f7 fpspreadsheet: Fix compilation issues when fpc version is changed: separate package units into different folders, incorporate code of fpsnumformatparser in unit fpsnumformat and code of fpsregfileformats in units fpsreaderwriter. Check and fix all demos.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@5282 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2016-10-22 20:59:00 +00:00
75492d48ea fpspreadsheet: Replace the demo project in fpsctrls by the one created in the wiki spreadsheet tutorial. The former version has been extended and moved to the folder "applications/spready" of ccr.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@5279 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2016-10-21 20:57:58 +00:00
301f7034db fpspreadsheet: Add "Auto row height" command to menu of fps_ctrls demo.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@5259 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2016-10-12 22:40:48 +00:00
b75e220a8d fpspreadsheet: Update docs
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@5245 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2016-10-06 21:42:16 +00:00
85187e4927 fpspreadsheet: Add zoom actions. Make worksheetgrid and spreadsheet inspector react on zoom changes. Update fpsctrls demo.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@5242 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2016-10-03 22:00:27 +00:00
1257b32614 fpspreadsheet: Scroll active grid cell back into viewport if lost by zooming process.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@5239 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2016-10-02 11:45:22 +00:00
b4851141c0 fpspreadsheet: Fix fpsctrls demo picking the correct file extension for saving.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@5237 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2016-10-01 22:19:02 +00:00
88e48c66de fpspreadsheet: Extend TsSpreadsheetInspector to show row records
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@5236 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2016-10-01 21:46:44 +00:00
863be778f9 fpspreadsheet: Add row height type to row record to distinguish custom from auto-calculated row heights. Add grid property AutoCalcRowHeights to use pre-calculated row height instead of always automatically recalculating row heights.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@5233 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2016-10-01 12:20:18 +00:00
be413db8f0 fpspreadsheet: Fix fpsctrls demo showing a thick black line when column width is changed by dragging header edge (caused by UseXORFeatures=true).
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@5231 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2016-09-28 17:39:46 +00:00
0a99b97c4b fpspreadsheet: Add zooming support to WorksheetGrid (use SHIFT+CTRL+MouseWheel in fpctrls demo).
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@5218 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2016-09-26 22:34:28 +00:00
f38a3f42de fpspreadsheet: Fix WorksheetGrid.OnValidateEntry not showing OldValue and NewValue parameters (issue #30236)
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@5214 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2016-09-25 22:23:26 +00:00
d8bf9f10b7 fpspreadsheet: Fix grid autoexpanding for navigation purposes.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@5208 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2016-09-25 08:53:01 +00:00
ff2e533d06 fpspreadsheet: Fix rewinding error of rtf memory stream when reading biff8 (see forum http://forum.lazarus.freepascal.org/index.php/topic,34150.msg223013)
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@5207 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2016-09-24 21:38:57 +00:00
2c01d20390 fpspreadsheet: Undo prev fix of compilation error because it is fixed in grids.pas now. Update title style of TsWorksheetGrid for Win10.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@4653 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2016-05-17 11:47:17 +00:00
34025326da fpspreadsheet: Workaround for ods rows and columns erroneously added by Libre/OpenOffice when importing an xlsx file (see forum http://forum.lazarus.freepascal.org/index.php/topic,32193.0.html)
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@4610 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2016-04-08 18:54:58 +00:00
7b9a56cd3e fpspreadsheet: Add method AddColors and event OnGetColorName to TsCellCombobox. Remove ComboColors.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@4607 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2016-04-06 08:37:34 +00:00
c8d5e0f95a fpspreadsheet: Add text format. Allow leading apostrophe to prevent conversion of a cell text to numbers.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@4538 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2016-03-09 21:17:53 +00:00
1504384e79 fpspreadsheet: Add reading of print ranges and repeated print cols/rows for xlsx. xlsx unit test for print ranges. Fix reading/writing of worksheets with spaces and special xml entities in the sheet name.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@4503 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2016-02-15 21:12:17 +00:00
ef7c595cf7 fpspreadsheet: Fix several painting issues of TWorksheetGrid related to merged cells. Add diagonal borders to fpsActions and demo.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@4482 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2016-01-29 09:59:37 +00:00
7679ef468c fpspreadsheet: Show message during writing when a formula is not supported by file format. Fix TsWorkbookSource ignoring its set options (i.e. ReadFormulas and AutoCalc working again).
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@4480 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2016-01-27 22:17:56 +00:00
bbe063d794 fpspreadsheet: Add property SelectionPen to WorksheetGrid
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@4449 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2016-01-21 11:39:05 +00:00
7d731629e1 fpspreadsheet: Add method LoadFromWorkbook to WorksheetGrid and WorkbookSource. Remove "deprecated" from some overloaded workbook file access methods.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@4448 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2016-01-21 10:55:55 +00:00
638b34c693 fpspreadsheet: Add support for formulas, as well as properties for cell comments, hyperlinks and number formats to TsSpreadsheetGrid
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@4431 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2016-01-18 12:09:06 +00:00
48c33e0c1c fpspreadsheet: Massive reconstruction of file format registration: it is now possible to add user-defined readers and writers without modifying the fpsspreadsheet sources (--> new unit fpsregfileformats). Add (incomplete) unit for the SYLK file format (---> new unit fpssylk) to show this in the demo project visual/fpsctrls/demo_ctrls. Update all visual demos.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@4373 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2015-10-09 13:27:04 +00:00
95704110ce fpspreadsheet: Improved cooperation of visual controls with clipboard.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@4363 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2015-09-28 20:23:28 +00:00
0dc5a6e45e fpspreadsheet: Add writer for ExcelXML files (Office XP and 2003, will be needed for clipboard operations); formulas and rich-text not functional, yet.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@4338 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2015-09-19 22:55:18 +00:00
106c5a90f6 fpspreadsheet: Add ColorRectOffset to TsCellCombobox. Fix color rect of TsCellCombobox being truncated in qt.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@4321 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2015-09-09 20:58:15 +00:00
1641355a19 fpspreadsheet: Control position of search dialog and confirmation dialog.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@4319 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2015-09-09 15:26:11 +00:00
a5cbacff27 fpspreadsheet: Add "replace" to search engine.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@4316 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2015-09-08 21:43:02 +00:00
49dea52ee1 fpspreadsheet: Redo searching (better OO code), some identifiers renamed with respect to initial commit.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@4313 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2015-09-07 15:48:43 +00:00
7c8e0a8b3d fpspreadsheet: Initial support for reading html files (data only, no formats, no nested tables).
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@4236 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2015-08-01 22:11:44 +00:00
9bf5e60e90 fpspreadsheet: Initial commit of html writer.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@4218 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2015-07-28 22:13:48 +00:00
ef69632cea fpspreadsheet: Initial version of searching in workbook/worksheet, not perfect yet.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@4214 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2015-07-27 23:01:52 +00:00
539da5c2db fpspreadsheet: Final changes before release 1.6
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@4196 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2015-06-28 12:09:12 +00:00
f8f72e3847 fpspreadsheet: Make number format parser independent of workbook. Some cleanup.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@4167 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2015-05-31 16:06:22 +00:00
dc32996691 fpspreadsheet: Collapsable/expandable items in TsSpreadsheetInspector
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@4165 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2015-05-30 14:32:09 +00:00
5b0181c297 fpspreadsheet: Improved usability of the TsSpreadsheetInspector.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@4164 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2015-05-30 14:01:10 +00:00
8adf987bf9 fpspreadsheet: Better detection of fraction format by numberformat action. Some clean-up.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@4145 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2015-05-19 16:18:01 +00:00
47db427771 fpspreadsheet: Add header/footer parser for conversion between Excel and ODS header/footer. Still some bugs.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@4121 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2015-05-09 22:40:59 +00:00
12d3dae6ed fpspreadsheet: Add font support for headers/footers from ods files
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@4116 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2015-05-05 17:38:39 +00:00
f5c1eb21cb fpspreadsheet: Add dialog for number format selection to examples folder. Fix grid forgetting current number format after editing cell content.
git-svn-id: https://svn.code.sf.net/p/lazarus-ccr/svn@4095 8e941d3f-bd1b-0410-a28a-d453659cc2b4
2015-04-26 16:24:19 +00:00