LibSpreadsheet

Changes for rev. 41

• Added a check to ignore $ symbols in macro parsing (as it will only be needed if macros are moved)
• Added proper support for parentheses - Macros like =(SUM(D)*(2 + SQRT(5))) will now work.
  
  

Changes for rev. 40

• Removed the silly debug messages.
  
  

Changes for rev. 39

• Added macro functions POW(), ROUND(), LARGE(), LEN(), LN(), LOG(), MEDIAN(), AVERAGE(), MODE(), SIGN(), SINH(), SMALL(), COSH(), STDEV(), TAN(), TANH() and some others
• Replaced LIST() with X:Y syntax - fx B1:B7 instead of B1, B7.
  
  

Changes for rev. 38

• Updated the macro parser to be more flexible
• Added the macro functions SIN(), COS(), SQRT(), LOG(), MOD()
  
  

Changes for rev. 37

• Added rudimentary macro functionality. See the wiki for instructions.
• Changed the frame strata for the edit box in case the row has a texture set.
  
  

Changes for rev. 36

• Changed the height check for cells/rows a bit
• Changed LibSpreadTest()
  
  

Changes for rev. 35

• Fixed a bug in the editbox
• Added the icon property to cells
  
  

Changes for rev. 34

• Removed XML bindings
• Changed FontInstances to lua-only
• Added SetFont() for setting custom fonts for books
• Some more bug fixing
  
  

Changes for rev. 33

• Changed the LibSpreadTest function a bit
• Some minor bug fixings
  
  

Changes for rev. 31-32

• Major cleanup in the whole library, stripped about 200 lines of code
• Added row/cell constructors and destructors to easier handle creation/deletion
  
  

Changes for rev. 30

• Fixed some leaks in UpdateHeap() and Commit()
• Added color checks to rows, columns and cells
• Added visibility checks for frames within rowHeap
• Implemented ExtractLocation() in SortByColumn()
  
  

Changes for rev. 29

• Updated the UpdateHeap() function to employ the latest filter options
  
  

Changes for rev. 28

• Added functions AddFilter(), Commit(), HideColumn(), ClearFilters()
• Added commas to large numbers
  
  

Changes for rev. 27

• Added functions GroupBy() and UpdateHeap() for grouping rows
• Added a check to rendering functions to use the row heap if groups/filters are used
• Added a row heap toggle for SortByColumn() so it'll sort the row heap if requested
  
  

Changes for rev. 26

• Updated localized font elements
  
  

Changes for rev. 25

• Removed GoTo() as it served no purpose
• Added Delete() and GetValue()
  
  

Changes for rev. 24

• Added functions SetCellSpacing and SetCellPadding
  
  

Changes for rev. 23

• Fixed some issues with textures going AWOL
• Added a check to ignore non-numbers in a number cell
  
  

Changes for rev. 22

• Fixed the silly editbox that just wouldn't go away
• Added internal scalars for cell padding and cell spacing
  
  

Changes for rev. 21

• Added support for background coloring in both cell, row and column scopes.
• Added the SetRow() function.
  
  

Changes for rev. 20

• Added Chinese font support
  
  

Changes for rev. 19

• Added Book:Hide() to hide the entire spreadsheet frame on demand
• Added the dominant property to columns
  
  

Changes for rev. 18

• Fixed a bug in the edit box where it would show the previous entry
  
  

Changes for rev. 17

• Finished the rudimentary edit box for editing interactive cells
• Finished the callbacks
  
  

Changes for rev. 16

• Added callbacks: 'OnSelectionChange', 'OnUserInputProcessed', 'OnUserInputRequested', 'OnUserSortRequested', 'OnUserSortProcessed'
• Fixed a bug in EndSelect that would set the wrong coordinates
  
  

Changes for rev. 15

• Added DeleteRow(), SetCellValue()
• Fixed the ExtractLocation() function, which was bugging out when passed a simple number
• Added a few checks to guard against cells with nil-data
  
  

Changes for rev. 14

• Added an option to sort either numerically or lexically (with out without cases sensitivity)
• Recombobulated the entire API
• Split APIs into data and UI functions so LibSpreadsheet will work flawlessly without touching the UI part
• Changed Book:Build to Book:Render
• Added Book:ShowScrollbars()
• Set AddColumn to add empty columns and then call SetColumn for easier development
• Changed SetColumn to a speedier procedure
• Added persistent UI. Books and sheets will only be created UI-wise if needed and only removed if deleted
• Calling Book:Render() will, opposed to the old Build() only update parts that need updating.
• Fixed the broken DeleteColumn()
  
  

Changes for rev. 13

• Added function SortByColumn()
• Fixed some minor bugs in determining column widths and spacing
• Added a working 'sort' property to columns
  
  

Changes for rev. 12

• Rearranged the frames to accomplish some new features
• Added an optional sheet selector to the sheets. Use book:ShowSelector(true/false).
• Updated the spreadsheet example function ( LibSpreadTest() )
• Added a separate font object for header cells
  
  

Changes for rev. 11

• Changed the callback API for cell functions
  
  

Changes for rev. 10

• Fixed the SetColumn() function
• Fixed a bug where a colorrange would bug out if maxval and minval was the same
  
  

Changes for rev. 9

• Fixed some scrollframe snafooey
  
  

Changes for rev. 8

• More migration, UI seems to work now.
• Added the onClick property to columns
• Added the id property to cells
• Added the option to insert a table as a cell value (fx. {data="some data", color={1,1,0}, id=12345})
  
  

Changes for rev. 7

• Migrated away from AceGUI to avoid some bugs with frames resetting themselves (this means a lot of UI isn't working fully yet)
• Fixed a broken justify property
• Added a right-click feature on interactive cells to clear the selection
  
  

Changes for rev. 6

• Changed file names
  
  

Changes for rev. 5

• Added initial code for: SetColorRange()
• Added a color property to columns
  
  

Changes for rev. 4

• Added the justify property in columns.
• Added initial code for: SetInteractive()
  
  

Changes for rev. 3

• Added initial code for: SetColumn(), DeleteColumn(), GoTo(), SetVisibleSelection(), ExtractLocation(), SetColumn(), StrictMode() and interactive selections
  
  

Changes for rev. 2

• Added the initial code for: Book(), AddSheet(), AddColumn(), AddRow(), DeleteSheet(), Select(), Build()
• Added a sample function, LibSpreadTest(), for testing LibSpreadSheet-1.0