LibSpreadsheet

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