Bean Sheet demo 1
 login
Looks like you do not have the free java 1.5 (or later) plugin for your browser. Java is a plugin which lets you do alot of cool things right from your browser... You should get it so you can create and view screencasts:
Requires JAVA 1.5 or later if you do not see anything above make sure you have java

  • Description

    A quick demo showing various aspects of Bean Sheet, a Java spreadsheet application.
  • Info

    Stats

    • Created:
      Jun 3 2007
    • Public:
      Yes
    • Audio:
      No
    • Language:
      N/A
    • Views:
      2,653
    • Rating:
      • Currently 0.00/5
      • 1
      • 2
      • 3
      • 4
      • 5
      Average: 0.0 (0 votes)
       

  • URL

  • Info

    Embed code

    Choose width:
  • Info

    Notes

    • 0:00Let's start off by starting the program.
    • 0:27We have now opened a document called properties.bsz. This spreadsheet dynamically loads Java system properties and populates cells in A and B columns with them.
    • 0:37It also allows us to highlight cells that contain keywords we type into the search cell (D0).
    • 0:54Let's look at how it works.
    • 1:07The first "for" loop merely sets the background on all cells in the display range to white, while the second loop iterates over a subrange defined by the search terms in the cell to the right ([+1-0]) and sets their background to the highlight color.
    • 1:41Now let's look at a spreadsheet that performs function graphing.
    • 2:08This document relies on the presence of a charting module, which is based on JFreeChart open source Java library.
    • 2:30The graphing parameters are defines in cell A0 as a BeanShell scripted object. It defines a starting domain value (seqStart), domain value sequence (seq(n)), and two functions: func(n) and func2(n).
    • 4:16This is another document demonstrating charting and graphing. This time we use a manually input data set describing rowing exercise performance over a number of days.
    • 5:10Our final example illustrates generation of the famous "99 Bottles of Beer" song lyrics using Bean Sheet's native features: cell formatting and ranges.
    • 5:17All of the logic is constrained within cell A0.
    • 5:28These are the formats applied to the different cells.
    • 5:45As we go through the output cell range, instead of setting cell values to song lines, we set their values to a length-1 array containing the bottle count and apply an appropriate format to control the display text.
    • 6:01To show this mechanism in action, we will clear all of the generated values, save, and reopen the document with the only remaining value in cell A0.
    • 6:26As you can see, A0 recreated the song!
    More/Less Add A Note
  • Info
    ([creator] = comment is from screencast creator)

    Comments

    • No comments for this screencast. Feel free to add some by clicking on the "Add A Comment" link below.
    More/Less Add A Comment