Screencast-O-Matic is the free and easy way to record your screen.   Try our free Screen Recorder!

Bean Sheet demo 1

Created: Jun 3 2007

Description

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

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!

Advertisement
We use cookies to optimize the experience on our website. By continuing to use our website, you are agreeing to our use of cookies. You can learn more in our Privacy Policy.