Sign in Join
Wiki copytemporary

FPSpreadsheet: history

RevisionWhenWhoWhat changed
4WikiArchiveFrom the Free Pascal wiki's archive, edited there on 2024-08-28What changed
3WikiArchiveTables mended: merged cells and line breaks in cells keptWhat changed
2WpFrom the Free Pascal wiki's dump of 2024-05-26What changed
1WpFrom the Free Pascal wiki's dump of 2024-05-26What changed
Edited on wiki.freepascal.org by 26 people, 2005–2024

From the official wiki's backup of 26 May 2024: who edited this page there, and when. Edits made there after that date were not recorded, and the earlier versions are not shown here; the main page says why.

WhenWhoWhat changed
SekelsenmatProgress of the formatting options
SekelsenmatNew page: Because of it's very simple format, it's easy to generate Excel 2.1 files from code. New Excel versions are still capable of reading those files, so this can be enough to automate the gene...
Sekelsenmat
Sekelsenmat
SekelsenmatSubversion
SekelsenmatSubversion
Sekelsenmat
GgeldenhuysLicense
Sekelsenmat
SekelsenmatCurrent Progress
SekelsenmatExcel 5 example
Sekelsenmat
Sekelsenmat
DblaszijkCurrent Progress
SekelsenmatCurrent Progress
SekelsenmatCurrent Progress
SekelsenmatChangelog
SekelsenmatCurrent Progress
SekelsenmatChangelog
SekelsenmatChangelog
SekelsenmatExternal Links
Sekelsenmat
SekelsenmatCurrent Progress
MarcovCurrent Progress
SekelsenmatCurrent Progress
JoshyCurrent Progress
SekelsenmatCurrent Progress
Sekelsenmat
SekelsenmatCurrent Progress
SekelsenmatCurrent Progress
SajgonExcel 5 example
SekelsenmatCurrent Progress
SekelsenmatCurrent Progress
SekelsenmatCurrent Progress
SekelsenmatCurrent Progress
Sekelsenmat
SekelsenmatCurrent Progress
SekelsenmatExamples
GgeldenhuysLicense: Clearer definition of the lisence. (minor)
Sekelsenmat
SekelsenmatConverting a database to a spreadsheet
SwenConverting a database to a spreadsheet (minor)
SwenConverting a database to a spreadsheet (minor)
SwenConverting a database to a spreadsheet (minor)
4yma
4yma
4yma
SekelsenmatBuilt-in routines
SekelsenmatPackages
SekelsenmatExamples
SekelsenmatConverting between two spreadsheet formats
Chronos
SekelsenmatCurrent Progress
SekelsenmatCurrent Progress
SekelsenmatProgress of the formatting options
SekelsenmatExamples
SekelsenmatUsing formatting options
SekelsenmatSettings a Border and a Background Color
SekelsenmatSetting a Background Color
SekelsenmatProgress of the formatting options
SekelsenmatSetting a Background Color
SekelsenmatProgress of the formatting options
SekelsenmatRPN Formulas
SekelsenmatCurrent Progress
SekelsenmatFormulas
SekelsenmatUsing ranges of cells and the unary SUM operator
SekelsenmatUsing formatting options
SekelsenmatCharting and FPSpreadsheet
BoboUsing build-in routines
SekelsenmatDownload
SekelsenmatSupport and Bug Reporting
SekelsenmatSee also
GarydaleAdded my own sample code to open an arbitrary spreadsheet
GarydaleOpening an existing spreadsheet: corrected code for SXC (minor)
GarydaleOpening an existing spreadsheet: added var declarations I'd missed in cut and paste. (minor)
GarydaleOpening an existing spreadsheet: removed SXC extension after discovering that I can't open them (minor)
GarydaleOpening an existing spreadsheet: simplified code to use fpspreadsheet consts and also ExtractFileExt
GarydaleOpening an existing spreadsheet: formatting correction (minor)
GarydaleOpening an existing spreadsheet: another formatting correction (minor)
GarydaleCurrent Progress: added information about the CSV file type which is mentioned in the source but not implemented
GarydaleOpening an existing spreadsheet: added mention of the fpspreadsheet open function
GarydaleOpening an existing spreadsheet: Added a WriteToFIle procedure to complement the ReadFromFile procedure I described
GarydaleOpening an existing spreadsheet: changed to use patches to fpspreadsheet using the latest code I've submitted
GarydaleWriting a spreadsheet to file based on extension: used the latest code I submitted.
GarydaleWriting a spreadsheet to file based on extension: aded an e.g. to clarify
SekelsenmatOpening an existing spreadsheet
SekelsenmatOpening an existing spreadsheet
SekelsenmatOpening an existing spreadsheet
SekelsenmatCurrent Progress
SekelsenmatProgress of the formatting options
BigChimpConverting a database to a spreadsheet: Fields[i].FieldName instead of Field[i].FieldName
BigChimpConverting a database to a spreadsheet: it is tested now, but I didn't use fpsallofrmats, fpspreadsheet_pkg (minor)
BigChimpConverting a database to a spreadsheet: fpspreadsheet_pkg, fpsallformats units not necessary (minor)
SekelsenmatConverting a database to a spreadsheet: fpsallformats is really necessary, otherwise there is no output support
SekelsenmatDownload
SekelsenmatSubversion
SekelsenmatLatest release
SekelsenmatChangelog
SekelsenmatCurrent Progress
SekelsenmatCurrent Progress
VincentText replace - "delphi>" to "syntaxhighlight>" (minor)
Chronoswikitable
SekelsenmatProgress of the formatting options
SekelsenmatProgress of the formatting options
SekelsenmatCurrent Progress
SekelsenmatProgress of the formatting options
BigChimpUsing formatting options: typo (minor)
BigChimpExcel 5 example
BigChimpExcel 5 example: Detail Laz requirements
BigChimpExcel 5 example (minor)
SekelsenmatChangelog
BigChimpChangelog: sorted chronologically (minor)
BigChimpCurrent Progress: Clarified which formats are supported (well, you now get an entry in the table of contents, which helps, I think) (minor)
BigChimpSupported formats (minor)
BigChimpPackages (minor)
Jwdietrich
BigChimpSubversion: New sourceforge SVN address
BigChimpSupport and Bug Reporting: Add info about file size limit, useful until new release is made
BigChimpNasty wiki syntax doesn't seem to enable http links inside notes... (minor)
JwdietrichCategorized.
BigChimpSetting a Background Color: typos (minor)
BigChimpExternal Links
BigChimpSubversion: Changes since last release
BigChimp
BigChimpChangelog (minor)
BigChimpSubversion changelog (minor)
BigChimpSupport for Date/Time cells: ods support
WpFormulas (minor)
WpAdding "Understanding RPN forumulas"
BigChimpSupport and Bug Reporting (minor)
BigChimpBIFF8 additional formulas
WpExplaining the nested formula notation
WpUsing simple constant numbers (minor)
Wp (minor)
WpUsing cells in rpn formula
WpUsing cells in formulas (minor)
WpUsing ranges of cells and the unary SUM operator
WpUsing built-in operations and functions
WpAdd operations and functions
WpAdd example LOG, Remove "builtin routines"
WpUsing cells in formulas (minor)
WpUsing built-in operations and functions
WpUnderstanding RPN formulas (minor)
WpUsing simple constant numbers (minor)
WpUsing simple constant numbers (minor)
WpUsing simple constant numbers (minor)
WpUsing cells in formulas (minor)
WpUsing ranges of cells (minor)
WpUsing built-in operations and functions
WpUsing built-in operations and functions
WpUsing built-in operations and functions (minor)
WpUsing built-in operations and functions (minor)
WpRPN Formulas (minor)
WpRemarks on RPN formulas (BIFF only, writing only)
WpUsing built-in operations and functions (minor)
BigChimpAdded reference to to do items (see bug 25104)
BigChimpSubversion changelog: wiki output
WpUpdate "Proress of formatting options"
WpProgress of the formatting options (minor)
WpProgress of the formatting options (minor)
WpProgress of the formatting options: Add column "Text align"
WpProgress of the formatting options (minor)
WpProgress of the formatting options (minor)
WpProgress of the formatting options: Update "bold" for BIFF2
Wp"Progress of the formatting options": update cell border for BIFF2
WpProgress of the formatting options: Update BIFF2 text rotation and word wrap, rename "Background colors" to "Color support"
WpAdd chapter on color management
WpUpdate background color example
WpProgress of the formatting options: Update BIFF5
WpAdd code snippet to display palette colors and show corresponding screenshot
WpNote on limitations of palette size
WpProgress of the formatting options: Update text rotation status for BIFF5
WpSetting the text orientation
WpAdd "Basics" as introduction
WpUpdate status of date support
WpAdd status of user-interface options
WpUpdate svn change logs
WpMore updates on svn changelog
WpMove chapter "Basics" underneath "API Documentation"
WpAdd info on ContentType
WpDescribes methods for accessing worksheets
WpWorksheet (minor)
WpFileformats
WpSubversion changelog: Remove entries from "contents"
WpCorrect level of date/time support
WpSupport by file format (minor)
WpAdding cell formatting to section "Cells"
WpUpdate to do list
WpMore svn changelog
WpMore to do
WpTo do list
WpUsing built-in operations and functions (minor)
WpUsing built-in operations and functions (minor)
WpRemarks
WpColor management
WpColor management
WpColor management (minor)
WpCell (minor)
BigChimpTo do list: string stuff. Would be nice to have but everything works without it
BigChimpFormulas: simplify list
BigChimpUnderstanding RPN formulas: moved stack vertically. Hope you agree.
BigChimpUsing simple constant numbers
BigChimpUsing ranges of cells
BigChimpUsing built-in operations and functions (minor)
BigChimpSubversion changelog: merge color support sections
WpNew section "Cell formatting" with sub-sections "Colors" and "Fonts"
WpColors
WpAdd text rotation
WpCell borders
WpAdd skeleton for Text alignment, word wrap, and number formats
WpTo do list (minor)
WpGrid and Charting Controls with FPSpreadsheet (minor)
WpCell borders (minor)
WpCell formatting (minor)
WpFonts (minor)
WpFonts (minor)
WpAdd word wrap
WpText rotation (minor)
WpText rotation (minor)
WpWord wrap (minor)
WpImproved font sections
WpImproved section on Borders
WpImproved section on Background colors
WpAdd section on text alignment
WpAdd number formatting
WpRemove "Formatting options" in "Examples" section
WpBasics (minor)
WpCell (minor)
WpCell (minor)
WpNumber and date/time formats (minor)
WpRemove "Store row heights" from ToDo
WpProgress of the formatting options: Mark "Col/Row size" as "Working"
WpWorkbook (minor)
WpTo do list: There's write support for the spreadsheet grid now.
WpUpdate of svn changelog regarding spreadsheet grid.
WpUpdate number and date/time formats: no more restriction on decimals, new nfCustom format code.
WpUpdate svn changelog
WpUpdate of "Support by file format" for date/time format changes.
BigChimpSupport by file format: small language fixes
WpUpdate: reading of rpn formulas, showing of rpn formulas in Excel-syntax
WpCurrency formats
WpWorksheet (minor)
WpUpdate of TCell fields and hint not to manipulate the contents of TCell directly.
WpClarification of not calculating formulax
WpMentioning ReadRPNFormulaAsString
WpFormulas: : more precise formulation
WpUpdate of number formats
WpUpdate of subversion changelog
WpUpdate of progress of the formatting options
WpProgress of the formatting options: Add column "Number format"
WpSupport by file format
Wptypo (minor)
BigChimpMake breaking change warning re direct cell manipulation a bit stronger
WpProgress of the formatting options: Update status of ods number formats
WpSupport by file format: Update status of ods date/time
BigChimpProgress of the formatting options: more positive story
BigChimpclarify custom format instead of default format. Date/time etc by itself works, right?
WpProgress of workbook/worksheet user-interface options: Update ods status
WpProgress of workbook/worksheet user-interface options: Update of ods frozen panes
WpProgress of workbook/worksheet user-interface options (minor)
BigChimpadd screenshot
WpNumber and date/time formats: update identifiers of built-in formats after removal of nfSci, nfAccounting and nfAccountingRed
BigChimpspready instead of fpsgrid
WpAPI Reference: Mention to chm file in installation folder, give hint that download link does not lead to the file directly
WpDrop Excel3 and Excel4 from the list of supported file formats.
BigChimpRemembered I would like to work on this
BigChimpinstallation instructions
BigChimpSupport by file format: Remove CSV - csvdocument can be used for that
BigChimpProgress of the formatting options: remove csv
BigChimpProgress of workbook/worksheet user-interface options: remove csv
BigChimpInstallation (minor)
BigChimpversion 1.2 released based on r3241
BigChimpSupport and Bug Reporting: bug obsolete due to release 1.2
BigChimpPackages (minor)
BigChimpclarify release date, makes it easier to search for historical wiki page
BigChimpMoved packages to installation
BigChimpInstallation (minor)
WpAdd link to "historic wiki"
BigChimpWorkbook: bullets (minor)
BigChimpSubversion changelog: Wasn't used anyway
BigChimpChangelog
BigChimpmention documentation disctinction between stable & trunk
WpCalculation of rpn formulas
WpCalculation of RPN formulas (minor)
Wpsvn change log: Calculation of formulas
WpUpdate of introduction to rpn formulas
WpUsage of the fekParen token
WpRemove my link to release wiki (Reinier's text in "Documentation" is better)
WpSpeed-up of writing for ods and xlsx; font support for xlsx; mark xlsx format capabilities as "partial" because there is no reader yet.
BigChimpadd back the link to the historical wiki page for stable release
WpProgress of the formatting options: Update xlsx for text rotation
WpProgress of the formatting options: Update text alignment for OOXML
WpProgress of the formatting options: Update border and background color support for xlsx
WpProgress of the formatting options: Update writing of xlsx wordwrap
WpProgress of the formatting options: Update for writing of number format for xlsx
WpSupport by file format: Rename "reader/writer progress" to "reader/writer support" (seems to be clearer to me...)
WpAdd VirtualMode
WpConverting a large database table to a spreadsheet format using virtual mode (minor)
WpConverting a large database table to a spreadsheet using virtual mode (minor)
WpVirtual mode: Link to example
WpSVN change log: VirtualMode
WpConverting a large database table to a spreadsheet using virtual mode (minor)
WpConverting a large database table to a spreadsheet using virtual mode (minor)
WpConverting a large database table to a spreadsheet using virtual mode (minor)
WpProgress of the formatting options: Update writing of column width and row height for xlsx
WpSVN change log: : Update xlsx reader, insert row/col
WpSupport by file format: : Update basic ooxml reader
BigChimpSVN change log
WpProgress of the formatting options: : Update xlsx reading support of font, colors and number formats
WpSupport by file format: Update xlsx datetime support
WpCell borders: Update diagonal border lines
WpSVN change log
WpProgress of the formatting options: Update xlsx reading support for cell borders
WpProgress of the formatting options (minor)
WpProgress of the formatting options: Some details on biff2 limitations.
WpProgress of the formatting options: Update xlsx reading of text rotation, alignment, wordwrap
WpProgress of the formatting options: Update xlsx reading colum widths and row heights
WpProgress of the formatting options: Update xlsx reading "bold" attribute
WpSupport by file format: Update full reading support for xlsx
WpVirtual mode: Update renamed identifiers.
WpConverting a large database table to a spreadsheet using virtual mode: Update virtual writing mode example
WpProgress of workbook/worksheet user-interface options: Update xlsx support for hidden grid lines and headers
BigChimpConverting a large database table to a spreadsheet using virtual mode: Mention reason for using virtual mode
WpProgress of workbook/worksheet user-interface options: Update xlsx reading/writing of frozen panes
WpSVN change log (minor)
WpSVN change log
WpTo do list: Remove reference to Mantis issue 25104 which is finished.
WpNew chapter on the sample projects accompanying fpspreadsheet
WpTo do list: Add more to do items, delete "Calculation of RPN formulas" (done)
WpSample projects in the fpspreadsheet installation folder: : Add x-ref links to "Sample projects"
Wp (minor)
BigChimpConverting a large database table to a spreadsheet using virtual mode: mention example
WpBring back deleted ToDo list items, strike them out
WpTo do list: Update ToDo list items
WpTo do list (minor)
WpUpdate recent fixes in ToDo list
WpSVN change log: Error logging
WpWorkbook: Explain workbook's property ErrorMsg
WpWorkbook (minor)
WpTo do list: Memory leak in unit tests fixed, basic formula support for xlsx/ods
WpTo do list: TsWorksheetGrid showing wrong fonts hopefully fixed.
WpInstallation: New section "Compiler options"
WpCompiler options: Add reference to dependence on C library
WpSVN change log: Add section "Incompatible changes"
WpTo do list (minor)
WpUpdate of formulas, add shared formulas
WpShared formulas (minor)
WpShared formulas (minor)
WpShared formulas (minor)
WpShared formulas (minor)
WpAfter version 1.2
WpFormulas: Update to new formula machinery fully supporting string formulas
WpCell: Formula contentType
WpString formulas: Move formula list to separate file
WpAfter version 1.2: Update incompatible changes
WpSVN change log: Update string formula support
WpSupport by file format: Update string formulas
WpSupport by file format (minor)
WpFormulas: Separate chapter for formula list
WpSyntax of string formula
WpList of built-in formulas: User-defined formulas
WpExtending FPSpreadsheet by user-defined formulas
WpUsing built-in operations and functions (minor)
WpExtending FPSpreadsheet by user-defined formulas (minor)
WpDisplaying RPN formulas
WpString formulas (minor)
WpString formulas (minor)
WpDisplaying RPN formulas (minor)
WpList of built-in formulas (minor)
WpNumber and date/time formats (minor)
WpNumber and date/time formats: Add "WriteDateTimeFormat"
WpProgress of the formatting options (minor)
WpProgress of workbook/worksheet user-interface options (minor)
WpTo do list: Update
WpBasics (minor)
WpTo do list
WpSupport by file format: Update OpenDocument
WpSample projects in the fpspreadsheet installation folder (minor)
WpString formulas: Localized decimal and list separators
WpString formulas: Example on decimal and list separator
BigChimpUsing <syntaxhighlight> wiki notation instead of <source> as that is deprecated
BigChimpUse syntaxhighlight wiki notation instead of source as that is deprecated
BigChimpadded category
BigChimpSample projects in the fpspreadsheet installation folder: db demo also imports now
BigChimpLatest release
BigChimp1.2.1 bugfix release
WpShared formulas: Update shared formulas
WpList of built-in formulas (minor)
WpWorkbook: Hint on reader/writer units
WpWord wrap: Merged cells
WpSVN change log: Update merged cells
WpTo do list: Update merged cells
WpProgress of the formatting options: Add merged cells
WpTo do list: Update overflow cells
WpTo do list: Update shared formulas
WpSVN change log: Update overflow cells
WpSVN change log: Update on delete rows/column
BigChimpCompiler options (minor)
BigChimpAfter version 1.2: small language fixes
Wp (minor)
WpShared formulas: Hint on splitting of shared formulas in case of added/deleted rows/columns.
BigChimpVirtual mode: simplify language; some small language fixes
BigChimpVirtual mode (minor)
WpSVN change log: Update wikitables writer
WpSVN change log (minor)
WpSVN change log: Update
WpAfter version 1.2: Update
WpSample projects in the fpspreadsheet installation folder: Add info on demo "wikitablemaker"
WpSVN change log: Add wikitablemaker to SVN change log
BigChimpWriting a spreadsheet to file based on extension: indentation (minor)
WpOpening an existing spreadsheet: Hint on exceptions during format detection
WpOpening an existing spreadsheet (minor)
WpConverting a large database table to a spreadsheet using virtual mode: Add proper try-finally blocks
BigChimpAdded fpsexport unit to export datasets
BigChimpfpsexport
BigChimpConverting a database to a spreadsheet
BigChimpTo do list: fpsexport
BigChimpVirtual mode: also works for reading files
BigChimpSVN change log (minor)
BigChimpDownload: graphical component added
WpAfter version 1.2 (minor)
WpSVN change log: CSV reader/writer
WpSupport by file format: Update for CSV and wikitables
WpProgress of the formatting options: Update for CSV and Wikitables
WpSupport by file format: Rearrange items
WpTo do list: ToDo: wikitable reading
WpSample projects in the fpspreadsheet installation folder: CSV demos
WpWorkbook: Add CSV and wikitables
BigChimpInstallation: export
BigChimpTo do list (minor)
WpTo do list
WpVirtual mode: Sorting
WpSVN change log: Sorting
WpSVN change log (minor)
WpTo do list
WpWorkbook: csv file format
WpSVN change log: Currency registration, visual controls
BigChimpSample projects in the fpspreadsheet installation folder (minor)
BigChimpSVN change log
BigChimpTo do list: fpsexport demo done
WpSorting (minor)
WpSorting
WpSVN change log (minor)
WpSample projects in the fpspreadsheet installation folder (minor)
WpSample projects in the fpspreadsheet installation folder: Update some sections for new FPSpreadsheet controls.
WpGrid and Charting Controls with FPSpreadsheet: Short description of the fpspreadsheet controls
WpLink chapter on visual controls to demos chapter
WpVisual controls for FPSpreadsheet
WpSVN change log (minor)
WpDataset export: FPSExport: multiple sheets, number format from fieldtype
WpDataset export (minor)
WpVisual controls for FPSpreadsheet: Remove TsFontNameCombobox and TsFontSizeCombobox, and replace by TsCellCombobox
WpSVN change log (minor)
WpConverting between two spreadsheet formats: CSV params record
WpSample projects in the fpspreadsheet installation folder
WpLatest release: Historic wiki versions as separate chapter
WpWiki of old releases (minor)
WpLink to icon collections used in demo programs
WpStable releases: Move "SVN changes" to "stable releases"
WpStable releases
WpSVN change log
WpAfter version 1.2
WpStable releases
WpStable releases
WpChanges (with respect to v1.2/1.2.1) (minor)
WpTo do list: Remove completed todo items.
WpAfter version 1.4
WpChange log (with respect to v1.2/1.2.1) (minor)
WpDocumentation
WpAdd wiki revision for release 1.4
WpWiki documentation of old releases
WpChangelog: ChangeLog V1.4
WpReading and writing of CSV files: Fix typos
WpAdd TsWorkbookChartSource
WpInstallation: Hint on fpc version required
WpCompiler options: Conditional defines
WpInstallation: Usable Laz and FPC versions
WpVisual controls for FPSpreadsheet: Add TsWorkbookChartSource
WpOpening an existing spreadsheet: Exceptions when reading incorrect file type
WpOpening an existing spreadsheet
WpOpening an existing spreadsheet (minor)
WpOpening an existing spreadsheet (minor)
WpDataset export (minor)
BartDataset export: typo
WpIncompatible changes: Move type declarations to new unit
WpDisplaying RPN formulas (minor)
WpExcel 5 example: uses fpstypes!
WpConverting a database to a spreadsheet: uses "fpstypes"
WpConverting between two spreadsheet formats: uses "fpstypes"
WpReading and writing of CSV files: uses fpstypes
WpCell: Needed units
WpUnits: Undo previous change
WpExamples: Re-add section on needed units, now in the Examples section.
WpSVN change log: Memory reduction, cell record helper
WpExcel 5 example: Replace rpn formula in Excel5 example by string formula
WpUnits: Add unit fpscell
WpWorkbook (minor)
WpCell: New TCell and TsCellFormat records
WpCell: Rearrange text
WpCell background color: Update example on backgroundcolor
WpCell background color: show backgroundcolor reading functions
WpCell borders: Update Borders and BorderStyles
WpFonts: Overloaded methods with cell pointer
WpText rotation: Overloaded method with cell pointer, reading method
WpText alignment: Overloaded methods with cell pointer, reading methods
WpWord wrap: Overloaded method with cell pointer, reading method
WpVersion 1.4: Version 1.4.1
WpChangelog: Version 1.4.1 and some reformatting
WpCell: Comments in TCell
WpMerged cells: Cell comments
WpSVN change log: Comments
WpProgress of the formatting options: Modify table for "Comments"
WpSupport by file format: Add "Comments" to "Progress by supported format"
WpProgress of the formatting options: Remove "Comments" from "Progress of the formatting options"
WpSupport by file format (minor)
WpSupport by file format: Comments for biff2 and biff5
WpVersion 1.4: Update current version 1.4.2
WpChangelog: Update version 1.4.2
WpSupport by file format: Reading support for cell comments in BIFF8 and OOXML
WpCurrent Progress: Rearrangement of chapters
WpCurrent Progress (minor)
WpProgress by supported format: Writing of comments to xlsx working
WpCell comments: Update comments
WpCell: Update comments and cell flags
WpCell background color: Background fill patterns
WpCell background
WpCell: Background fill patterns
WpCell (minor)
WpSVN change log: Background fill patterns
WpIncompatible changes: Background fill patterns
WpProgress of the formatting options: Background patterns
WpProgress by supported format (minor)
WpChangelog (minor)
WpMerged cells: Merged cells update
WpCell: Update merged cells
WpCell comments: Hyperlinks
WpSVN change log: Hyperlinks
WpProgress by supported cell content: Hyperlinks
WpProgress by supported cell content (minor)
WpProgress by supported cell content (minor)
WpHyperlinks (minor)
WpHyperlinks
WpHyperlinks
WpSubversion: for-in
WpIterating through all Worksheets: Iteration through cells
WpIncompatible changes (minor)
WpIncompatible changes (minor)
WpRPN formulas: Remove docs of RPN formulas (now in separate article)
WpRPN formulas (minor)
WpShared formulas: Reduced support for shared formulas
WpIncompatible changes: Reduced shared formula support
WpCell
WpFormulas (minor)
WpWiki links: More FPSpreadsheet wikilinks
WpIncompatible changes: uffBold no longer supported
WpIncompatible changes (minor)
WpHyperlinks: More details on hyperlinks
WpSample projects in the fpspreadsheet installation folder: Update example folders
WpSample projects in the fpspreadsheet installation folder (minor)
WpVersion 1.4: Stable version 1.4.3
WpChangelog: Update version 1.4.3
WpNumber and date/time formats: Fractions as number format
WpNumber and date/time formats: Some details on fraction format
WpSVN change log: Fractions
WpNumber and date/time formats: Add nfDayMonth, nfMonthYear
WpProgress of the formatting options: Page layout
WpSVN change log: Page layout
WpIncompatible changes
WpTo do list
WpNumber and date/time formats: Details on number format string symbols
WpNumber format strings: More details on number format codes
WpNumber format strings (minor)
WpNumber format strings: Remove old example for number format strings (not necessary any more)
WpNumber format strings: Show color of negative red number format
WpCell background
WpHyperlinks: Details on PageLayout
WpPage layout
WpPage layout: Pagelayout: some improvements plus example
WpMove PageLayout Chapter one level up
WpColors: Introduce new color system
WpColors: New palette screen shot
WpColors (minor)
WpColors (minor)
WpColors (minor)
WpCell background (minor)
WpColors: Hints on color functions in fpsutils
WpColors
WpColors (minor)
WpColors (minor)
WpNumber format strings: Improved and corrected examples for number format strings
WpNumber format strings (minor)
WpNumber format strings (minor)
WpNumber format strings: More corrections of number format examples
WpUpdate due to changes of color management
WpUnits: Add fpsnumformat to "units" section, some minor additions and re-formulations
WpExcel 5 example: Update package name
WpIncompatible changes (minor)
WpTo do list (minor)
WpTo do list (minor)
WpReplace code tags by tt tags (better for exporting)
WpCell (minor)
WpNumber format strings: More "code" tokens replaced by "tt"
WpNumber format strings: Fix %
WpCell (minor)
WpCell (minor)
WpFormulas: More replacements of "code" tag by "tt"
WpReplace "code" tokens by "tt"
WpReplace !! tags in the table header by || (better export)
WpShared formulas and array formuls (minor)
WpColors (minor)
WpColors (minor)
WpNumber format strings: Improved presentation of the date/time format symbols
WpFonts: Update Fonts chapter to current version
WpCell background: Some correction with Background patterns
WpRPN formulas (minor)
WpExternal Links: Fix syntax to be ready for export
WpImproved syntax of external links (for better exporting)
WpWiki documentation of old releases (minor)
WpNumber format strings (minor)
Wp (minor)
WpUndo revision 90460 by Wp (talk)
WpBasics: Unit names in italics (minor)
WpBuilt-in number formats (minor)
WpColors (minor)
WpCell borders (minor)
WpChangelog (minor)
WpChangelog (minor)
WpChangelog (minor)
WpExtending FPSpreadsheet by user-defined formulas (minor)
WpColors (minor)
WpColors (minor)
WpWiki links (minor)
Wp (minor)
WpCell (minor)
WpCell (minor)
WpVirtual mode (minor)
WpDocumentation (minor)
WpConverting a database to a spreadsheet (minor)
WpDocumentation (minor)
WpAPI Reference: Update path to chm help files
WpBasics (minor)
WpWorkbook (minor)
WpCell: Typo (minor)
WpFormulas (minor)
WpFormulas: Some corrections (minor)
WpNumber and date/time formats (minor)
WpColors (minor)
WpCell background (minor)
WpText rotation (minor)
WpText rotation (minor)
WpMerged cells: Some formatting (minor)
WpHyperlinks (minor)
WpPage layout (minor)
WpVirtual mode (minor)
WpDataset export (minor)
WpUnits (minor)
WpExcel 5 example (minor)
WpOpening an existing spreadsheet (minor)
WpWriting a spreadsheet to file based on extension: Some formatting (minor)
WpIteration through cells (minor)
WpConverting a large database table to a spreadsheet using virtual mode (minor)
WpConverting between two spreadsheet formats (minor)
WpReading and writing of CSV files (minor)
WpSVN change log: Hint on wiki snapshot added to the lib files.
WpDownload: Add v1.6 changes
WpVersion 1.6: Use separate chapter for Version 1.4
WpChangelog: Add v1.6 to change release list
WpChange log (with respect to v1.4.x) (minor)
WpAPI Reference (minor)
WpChangelog
FTurtle
WpFonts: Subscript and superscript
WpProgress of the formatting options: Add "Rich-text" (and remove the obsolete "bold")
WpText rotation: Rich-text formatting
WpCurrent Progress: HTML writer
WpSVN change log
WpSample projects in the fpspreadsheet installation folder
WpProgress of the formatting options
WpProgress of workbook/worksheet user-interface options
WpSVN change log: Searching
WpCell borders: More line styles
WpSVN change log
WpProgress by supported cell content
WpProgress by supported cell content: Hyperlinks in html tables
WpProgress of the formatting options
WpProgress of workbook/worksheet user-interface options: Active sheet
WpSVN change log: Active worksheet
WpSVN change log: Selected cell
WpProgress of workbook/worksheet user-interface options
WpProgress by supported cell content: Update HTML reader support
WpProgress of the formatting options: Update HTML reader support
WpSVN change log: Update HTML reader
WpRich-text formatting: Update rich-text formatting
WpCell: Add cell reading/writing methods
WpCell: WriteUTF8Text --> WriteUTF8Text, ReadAsUTF8Text --> ReadText
WpHyperlinks
WpExcel 5 example
WpIteration through cells
WpConverting a database to a spreadsheet
WpSVN change log: WriteTextAsHTML
WpIncompatible changes: WriteUTF8Text and ReadAsUTF8Text are deprecated
WpRich-text formatting: Update rich-text formatting, new HTML method
WpSorting: Searching
WpSearch and replace (minor)
WpSearching and replacing (minor)
WpVirtual mode: Stream selection, virtual mode
WpSVN change log: ExcelXML writer
WpWorkbook: User-defined file formats
WpLoading and saving: Add user-defined file formats
WpWorkbook: User-defined file-formats
WpAdding new file formats: User-defined file formats
WpSVN change log: Add user-provided reader/writer to SVN change log
WpSVN change log: Clipboard
WpSVN change log (minor)
WpVisual controls for FPSpreadsheet (minor)
WpSVN change log: RTL mode and TStringGrid compatibility of TsWorksheetGrid
WpIncompatible changes
WpSVN change log
WpProgress of workbook/worksheet user-interface options
WpSVN change log
WpPage layout: Print ranges, repeated header rows/columns
WpSVN change log
WpProgress of the formatting options: Print ranges
WpProgress of the formatting options (minor)
WpPage layout (minor)
WpRich-text formatting: DeleteRichTextFormatting
WpProgress of the formatting options: Print ranges for biff8
WpProgress of the formatting options: Print ranges for biff5
WpProgress of the formatting options
WpLoading and saving (minor)
WpProgress of the formatting options
WpProgress of the formatting options
WpBIFF Explorer in "applications" now
WpPage layout: Explanation for "Fit all columns on one page"
WpCell: Add row and column records
WpPage layout: Column and row operations
WpColumns and rows: More on rows and columns
WpPage layout: Update (embedded images, class instead of record)
WpPage layout
WpHeaders and footers
WpGeneral
WpGeneral
WpProgress by supported cell content: Embedded images
WpSVN change log: Embedded images
WpIncompatible changes: Pagelayout being a class now
WpAdditional data: Embedded images
WpSubversion
WpCurrent Progress
WpProgress by supported cell content
WpImages: WriteImage from stream
WpCurrent Progress: Update images (reading), add header/footer images to formatting options progress
WpProgress by supported cell content
WpProgress by supported cell content
WpImages: Limitations of image positioning
WpColumns and rows: Row height and column width units
WpSVN change log
WpIncompatible changes
WpVersion 1.6
WpColumns and rows
WpColumns and rows
WpIncompatible changes
WpSVN change log: Localization
WpIncompatible changes
WpColors
WpColors
WpVersion 1.6
WpChangelog
WpConverting a large database table to a spreadsheet using virtual mode: Fix typo
WpVirtual mode: Update VirtualMode
WpConverting a large database table to a spreadsheet using virtual mode: Update of virtual mode
WpIncompatible changes: Update virtual mode
KStarbeAdded name of unit where workbook types can be found (minor)
HeXorlink update (minor)
WpSVN change log: Add zoom factor
WpProgress of workbook/worksheet user-interface options: Zooming
KStarbeXLM -> XML in details about format. (minor)
WpSVN change log: Column and cell formats
WpSVN change log
WpTo do list
WpProgress of the formatting options: Column/row formats
WpWiki documentation of old releases: Update links to historic wiki versions
WpProgress of the formatting options: Update column/row format progress
WpProgress of the formatting options: Update xlsx col/row format
WpProgress of the formatting options (minor)
WpColumns and rows: Description of row and column formats
WpProgress of the formatting options
WpIncompatible changes
WpSample projects in the fpspreadsheet installation folder
WpProgress of the formatting options
WpProgress of the formatting options
WpProgress of the formatting options
WpProgress of the formatting options: Update wikitable progress (fix too optimistic "working" classifications
WpColumns and rows (minor)
WpSVN change log: Hidden worksheets
WpInstallation (minor)
WpStable releases: stable release v1.8
WpPrepare version 1.8
WpWiki documentation of old releases: Location of v1.8 wiki
WpProtection
WpCell protection
WpAdditional data
WpCell
WpCell
WpCell protection
WpWorkbook protection: Password for workbook protection
WpWorkbook protection (minor)
WpWorksheet protection: Password for worksheet protection
WpProtection
WpProtection: Add section Passwords
WpSVN change log: Protection
WpSVN change log
WpProgress by supported cell content: Protection
WpSVN change log: Display embedded images
WpChangelog: Release 1.8.2
WpChangelog
WpChangelog: Version 1.8.3
WpSVN change log
WpSearching and replacing: Initialization of search and replace params records
WpWorkbook: File extensions
WpFormulas: boAbortReadingOnFormulaError
WpSVN change log
WpExtending FPSpreadsheet by user-defined formulas: boIgnoreFormulas
WpSVN change log: boIgnoreFormulas
MathiasColors (minor)
WpSVN change log
WpProgress by supported cell content: 3D references
WpCell: Remove TCell.FormulaValue
WpCell: Again: Remove Cell.FormulaValue. Add info on TsCellFlags. Substructure of the TCell chapter.
WpFormulas: More details on the new formula structure
WpCell: Add some internal hyperlinks
WpFormulas: Manual calculation of formulas
WpString formulas: Syntax for 3d formulas
WpFormulas (minor)
WpProgress by supported cell content: Update "Progress of cell content" for 3d formulas
WpString formulas: Note on non-existing linked sheets
WpSubversion
WpStable releases: v1.10
WpDownload: v1.10
WpWiki documentation of old releases: v1.10
WpChangelog: v1.10
SeregaKRAdded an example to export into dbf
SeregaKRExport to DBF (minor)
SeregaKRExport to DBF: Added comment (minor)
WpChangelog: v1.10.1
WpChangelog (minor)
WpChangelog (minor)
WpTo do list
WpWiki documentation of old releases
WpColumn and row operations (minor)
WpColumn and row operations: Show/Hide columns/rows
WpSVN change log: Hide/show rows/cols
WpVersion 1.10.1
WpVersion 1.10
WpProgress of the formatting options: hide cols/rows
WpCurrent Progress (minor)
WpProgress of workbook/worksheet user-interface options
ZoltanleoHow to add and read data to/from a cell
ZoltanleoThe basic TCell record
Michael.vanhamcorrect typo in unit name (minor)
WpExtending FPSpreadsheet by user-defined formulas
ChronosSubversion
WpSearching and replacing: Fix typo related to searching (TsSearchEngine instead of TSearchEngine)
TrevFixed syntax highlighting in all 77 examples... I hope (minor)
WpSVN change log
WpProgress of the formatting options: Formatting options for Excel2003/XML format
WpProgress of the formatting options
WpProgress of the formatting options
WpProgress of workbook/worksheet user-interface options: Update worksheet user-interface optionf for Excel2003/XML format.
WpProgress by supported cell content: Update supported cell content for Excel2003/XML format.
WpProgress of the formatting options
WpCurrent Progress
WpSVN change log
WpSVN change log
WpColumns and rows
WpColumns and rows: Row and Column Options: hidden row/cols, pagebreaks
WpSVN change log: Page breaks
WpProgress of the formatting options: Page breaks
WpColumns and rows: Add sub-chapters to the "Columns and rows" chapter
WpColumn and row formats: More details on column / row formats
WpColumn and row formats
WpPage breaks: Spreadsheet events
WpEvents
WpEvents: Fix hierarchy in "contents"
WpEvents: Links to visual controls.
TrevReferenes: Fixed typo in heading (minor)
WpProgress of workbook/worksheet user-interface options: Worksheet.TabColor
WpSVN change log: Worksheet.TabColor
WpVisual controls for FPSpreadsheet: WorksheetIndicator
WpSVN change log: TsWorksheetIndicator
WpExamples: Export Examples section to separate article
WpDownload: ChangeLog v1.12
Wp
WpWiki links
WpExternal Links
WpExternal Links
WpSVN change log: Conditional formats
WpProgress by supported cell content: Conditional formats
WpChangelog
WpIncompatible changes: remove deprecated properties DefaultRowHeight and DefaultColWidth
WpRich-text formatting: Fix usage of outdated ReadCellFont call in sample code
TrevChangelog: Collapse log after first two entries (minor)
TrevStable releases: Collapse version listing after first entry (minor)
TrevUndo revision 137929 breaks ToC links (minor)
WpProgress by supported cell content: conditional format
WpSVN change log: meta data
WpSearching and replacing: Typo (fpsearch --> fpsSearch)
WpSearching and replacing: How to set up active worksheet and active cell for searching
WpSearching and replacing: Use separate local variable for found worksheet
WpSearching and replacing
WpSearching and replacing
SlawekWorkbook: dto. -> ditto (minor)
SlawekColumn width / row height: it was GetColHeight, shoult be GetColWidth (minor)
EChristianswrong.-> dbDiagUp, dbDiagDown correct -> cbDiagUp, cbDiagDown (Lazarus 2.0.10) (minor)
EChristianstypo: rt90DegreeCounterClockwizeRotation -> correct: rt90DegreeCounterClockwiseRotation (minor)
WpNumber format strings
WpCell borders: typo
WpSVN change log: TsWorksheetDataset
WpSVN change log
WpSVN change log
WpDownload: Prepare release v1.14
WpDownload
WpWiki documentation of old releases: Update "historic" help page of v1.14
WpDownload: Mention Online-Package-Manager
WpRearrange changelog items.
WpChangelog
WpSVN
WpCurrent Progress
WpHeaders and footers: Fix type
WpProgress of the formatting options
WpSVN
WpCompiler options: Update conditional defines list (fps.inc)
WpCompiler options
WpSVN
WpSVN
WpSVN
WpSVN
WpWorkbook protection: Update to password protection
WpWorkbook protection
WpText alignment: Fix typo
WpCell protection
WpCell protection
WpUndo revision 157206 by Wp (talk)
WpUndo revision 157205 by Wp (talk)
WpCell formatting: Do not print cells
WpIndex to Cell format
WpChangelog: Preparation for v1.16
WpDocumentation: Link to wiki snapshot of v1.16
WpCell protection: Fix cell protection sample code
WpText alignment: Add haJustify
WpText alignment: More hor justification

Back to the page