LibSpreadsheet

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