MoodleODSWorksheet Class Reference

Public Member Functions
	MoodleODSWorksheet ($name)
	write_string ($row, $col, $str, $format=0)
	write_number ($row, $col, $num, $format=0)
	write_url ($row, $col, $url, $format=0)
	write_date ($row, $col, $date, $format=0)
	write_formula ($row, $col, $formula, $format=null)
	write_blank ($row, $col, $format=0)
	write ($row, $col, $token, $format=0)
	set_row ($row, $height, $format=0, $hidden=false, $level=0)
	set_column ($firstcol, $lastcol, $width, $format=0, $hidden=false, $level=0)
	hide_gridlines ()
	hide_screen_gridlines ()
	insert_bitmap ($row, $col, $bitmap, $x=0, $y=0, $scale_x=1, $scale_y=1)
	merge_cells ($first_row, $first_col, $last_row, $last_col)
Data Fields
	$data = array()
	$columns = array()
	$rows = array()
	$name

---

Detailed Description

Definition at line 130 of file odslib.class.php.

---

Member Function Documentation

hide_gridlines

(

)

Set the option to hide gridlines on the printed page.

public

Definition at line 305 of file odslib.class.php.

hide_screen_gridlines

(

)

Set the option to hide gridlines on the worksheet (as seen on the screen).

public

Definition at line 314 of file odslib.class.php.

insert_bitmap	(	$	row,
		$	col,
		$	bitmap,
		$	x = 0,
		$	y = 0,
		$	scale_x = 1,
		$	scale_y = 1
	)

Insert a 24bit bitmap image in a worksheet.

public

Parameters:

integer	$row	The row we are going to insert the bitmap into
integer	$col	The column we are going to insert the bitmap into
string	$bitmap	The bitmap filename
integer	$x	The horizontal position (offset) of the image inside the cell.
integer	$y	The vertical position (offset) of the image inside the cell.
integer	$scale_x	The horizontal scale
integer	$scale_y	The vertical scale

Definition at line 330 of file odslib.class.php.

merge_cells	(	$	first_row,
		$	first_col,
		$	last_row,
		$	last_col
	)

Merges the area given by its arguments. merging than the normal setAlign('merge').

public

Parameters:

integer	$first_row	First row of the area to merge
integer	$first_col	First column of the area to merge
integer	$last_row	Last row of the area to merge
integer	$last_col	Last column of the area to merge

Definition at line 343 of file odslib.class.php.

MoodleODSWorksheet

(

$

name

)

Definition at line 140 of file odslib.class.php.

set_column	(	$	firstcol,
		$	lastcol,
		$	width,
		$	format = 0,
		$	hidden = false,
		$	level = 0
	)

Definition at line 290 of file odslib.class.php.

set_row	(	$	row,
		$	height,
		$	format = 0,
		$	hidden = false,
		$	level = 0
	)

Definition at line 275 of file odslib.class.php.

write	(	$	row,
		$	col,
		$	token,
		$	format = 0
	)

Analyse what are we trying to send

Match number

Match http or ftp URL

Match mailto:

Match internal or external sheet link

Match formula

Match formula

Match blank

Default: match string

Definition at line 238 of file odslib.class.php.

Here is the call graph for this function:

write_blank	(	$	row,
		$	col,
		$	format = 0
	)

Definition at line 225 of file odslib.class.php.

Here is the caller graph for this function:

write_date	(	$	row,
		$	col,
		$	date,
		$	format = 0
	)

Definition at line 198 of file odslib.class.php.

write_formula	(	$	row,
		$	col,
		$	formula,
		$	format = null
	)

Write one formula somewhere in the worksheet

Parameters:

integer	$row	Zero indexed row
integer	$col	Zero indexed column
string	$formula	The formula to write
mixed	$format	The XF format for the cell

Definition at line 216 of file odslib.class.php.

Here is the caller graph for this function:

write_number	(	$	row,
		$	col,
		$	num,
		$	format = 0
	)

Definition at line 166 of file odslib.class.php.

Here is the caller graph for this function:

write_string	(	$	row,
		$	col,
		$	str,
		$	format = 0
	)

Definition at line 150 of file odslib.class.php.

Here is the caller graph for this function:

write_url	(	$	row,
		$	col,
		$	url,
		$	format = 0
	)

Definition at line 182 of file odslib.class.php.

Here is the caller graph for this function:

---

Field Documentation

$columns = array()

Definition at line 132 of file odslib.class.php.

$data = array()

Definition at line 131 of file odslib.class.php.

$name

Definition at line 134 of file odslib.class.php.

$rows = array()

Definition at line 133 of file odslib.class.php.

---

The documentation for this class was generated from the following file:

• C:/xampp/htdocs/moodle/lib/odslib.class.php