File: calc-example2

package info (click to toggle)
ooolib-perl 0.1.9-1
  • links: PTS
  • area: main
  • in suites: jessie, jessie-kfreebsd, lenny, squeeze, wheezy
  • size: 256 kB
  • ctags: 58
  • sloc: perl: 1,657; makefile: 89; sh: 78
file content (28 lines) | stat: -rwxr-xr-x 683 bytes parent folder | download | duplicates (4) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
 
#!/usr/bin/perl
# calc-example2 - Set Column sizes

use ooolib;

# Set variables
$doc = new ooolib("sxc");
$doc->oooSet("builddir", ".");
$doc->oooSet("title", "Calc Column Sizes");
$doc->oooSet("subject", "Calc Example");
$doc->oooSet("comments", "Sizes are set using cm");
$doc->oooSet("author", "ooolib Example");
$doc->oooSet("meta1-name", "Programmer");
$doc->oooSet("meta1-value", "Joseph Colton");

# Write the spreadsheet data
my($x, $y);
for($x=1;$x<=5;$x++) {
    $doc->oooSet("column-width", $x, $x);
    for($y=1;$y<=5;$y++) {
	$doc->oooSet("cell-loc", $x, $y);
	$doc->oooData("cell-float", $x*$y);
    }
}

my($filename) = $doc->oooGenerate("calc-example2.sxc");

exit;