function FrontReport($title, $filename, $size = 'A4', $fontsize = 9, $orientation = 'P', $margins = NULL, $excelColWidthFactor = 6.5)
{
- global $comp_path, $dateseps, $page_security;
+ global $dateseps, $page_security;
if (!$_SESSION["wa_current_user"]->can_access_page($page_security))
{
display_error(_("The security settings on your account do not permit you to print this report"));
$this->endLine = 760;
$this->fontSize = $fontsize;
$this->oldFontSize = 0;
- $this->y = 1;
+ $this->y = 0;
$this->currency = '';
$this->excelColWidthFactor = $excelColWidthFactor;
$rtl = ($_SESSION['language']->dir == 'rtl');
$this->code = strtolower($_SESSION['language']->encoding);
$this->filename = $filename.".xls";
$this->unique_name = uniqid('').".xls";
- $this->path = $comp_path.'/'.user_company(). '/pdf_files';
+ $this->path = company_path(). '/pdf_files';
$this->Spreadsheet_Excel_Writer_Workbook($this->path."/".$this->unique_name);
//$this->setCountry(48);
if ($this->code != "iso-8859-1")
function Header()
{
- $this->y = 0;
$tcol = $this->numcols - 1;
$this->sheet->setRow($this->y, 20);
for ($i = 0; $i < $this->numcols; $i++)
function TextCol($c, $n, $txt, $corr=0, $r=0, $border=0, $fill=0, $link=NULL, $stretch=0)
{
+ $txt = html_entity_decode($txt);
if ($this->aligns[$c] == 'right')
$this->sheet->writeString($this->y, $c, $txt, $this->formatRight);
else
function TextCol2($c, $n, $txt, $corr=0, $r=0, $border=0, $fill=0, $link=NULL, $stretch=0)
{
+ $txt = html_entity_decode($txt);
$this->sheet->writeString($this->y, $c, $txt, $this->formatLeft);
if ($n - $c > 1)
$this->sheet->mergeCells($this->y, $c, $this->y, $n - 1);
{
$this->y += $l;
}
-
+
+ function NewPage()
+ {
+ return;
+ }
+
function ymd2Date($year, $mon, $day) // XLS internal date representation is a number between 1900-01-01 and 2078-12-31
{ // if we need the time part too, we have to add this value after a decimalpoint.
$mo = array(0,31,28,31,30,31,30,31,31,30,31,30,31);