Got an account? | login
Loading Screen Recorder
Screen Recorder Loaded.
Recorder already running.
Bean Sheet demo 1

Send us Feedback
Please use the form below or email us at feedback@screencast-o-matic.com

Your email address:


Your Comment:


 
Requires JAVA 1.5 or later. Test your Java
 

  • Description

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

  • Info

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

  • Share Link

  • Embed Code

    Choose width:
  • Screencast-O-Matic is a free online screen recorder for recording screen capture video and uploading it from your browser with no install!

  • Add A Note

    Notes

    • 0:00
      Let's start off by starting the program.
    • 0:27
      We 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:37
      It also allows us to highlight cells that contain keywords we type into the search cell (D0).
    • 0:54
      Let's look at how it works.
    • 1:07
      The 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:41
      Now let's look at a spreadsheet that performs function graphing.
    • 2:08
      This document relies on the presence of a charting module, which is based on JFreeChart open source Java library.
    • 2:30
      The 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:16
      This 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:10
      Our final example illustrates generation of the famous "99 Bottles of Beer" song lyrics using Bean Sheet's native features: cell formatting and ranges.
    • 5:17
      All of the logic is constrained within cell A0.
    • 5:28
      These are the formats applied to the different cells.
    • 5:45
      As 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:01
      To 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:26
      As you can see, A0 recreated the song!
      
  • Add A Comment

    Comments

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

    name

©2011 Screencast-O-Matic | Terms of Service | Privacy | Credits