<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[FrontAccounting forum — Bug in Excel Reports]]></title>
	<link rel="self" href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=5689&amp;type=atom" />
	<updated>2015-04-14T11:42:45Z</updated>
	<generator>PunBB</generator>
	<id>https://frontaccounting.com/punbb/viewtopic.php?id=5689</id>
		<entry>
			<title type="html"><![CDATA[Re: Bug in Excel Reports]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=23285#p23285" />
			<content type="html"><![CDATA[<p>The php closing tag issue generally comes up on PHP 5.4 onwards.<br />The include_once should have no effect and is needed to enforce authority to download only if logged in.<br />If the generated file is good, then the browser transfer may be the issue. Check the apache error logs for any clues.</p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2015-04-14T11:42:45Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=23285#p23285</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Bug in Excel Reports]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=23280#p23280" />
			<content type="html"><![CDATA[<p>I have just checked the generated file in the company folder and it was good. I tried removing the line </p><p>include_once($path_to_root . &quot;/includes/session.inc&quot;);</p><p>from the prn_redirect.php file. The new line disappeared. Not sure if not including session.inc would cause some problems.</p><p>according to some stackoverflow answers, if you declare php closing tags ?&gt; there might be newline inserts</p>]]></content>
			<author>
				<name><![CDATA[moylua]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=20312</uri>
			</author>
			<updated>2015-04-14T07:01:11Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=23280#p23280</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Bug in Excel Reports]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=23256#p23256" />
			<content type="html"><![CDATA[<p>The file <strong>reporting/includes/Workbook.php</strong> has the functions to write the Excel file and the said function is part of it that helps store the End of File characters (Eof) for the header in a hexadecimal byte packed manner. It is possible that some PHP versions on some platforms may be putting out blank headers and only these separators get to the top. </p><p><strong>BIFF</strong> means <strong>BI</strong>nary <strong>F</strong>ile <strong>F</strong>ormat. There are many types of BIFF records.&nbsp; Each has a 4 byte header.&nbsp; The first two bytes are an opcode that specifies the record type.&nbsp; The second two bytes specify record length.&nbsp; Header values are stored in byte-reversed form (less significant byte first).&nbsp; The rest of the record is the data itself</p><p>Other places where this is used so is at:<br />Line 195: http://voltampmedia.com/PHPExcel/html/_b_i_f_fwriter_8php_source.html<br />Line 195: http://phpcrossref.com/xref/moodle/lib/phpexcel/PHPExcel/Writer/Excel5/BIFFwriter.php.html#_storeeof</p><p>The Microsoft Excel Format is documented at:<br />https://www.openoffice.org/sc/excelfileformat.pdf<br /><a href="http://www.digitalpreservation.gov/formats/digformatspecs/Excel97-2007BinaryFileFormat%28xls%29Specification.pdf">Excel97-2007 Binary File Format *.xls Specification.pdf</a><br />http://www.opennet.ru/docs/formats/xls.txt</p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2015-04-13T13:44:48Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=23256#p23256</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Bug in Excel Reports]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=23255#p23255" />
			<content type="html"><![CDATA[<p>tried with chrome and firefox. still the same. </p><p>i would like to know the use of this function. since it has a Line Feed code &quot;0x000A&quot;</p><p> function _storeEof()<br />&nbsp; &nbsp; {<br />&nbsp; &nbsp; &nbsp; &nbsp; $record&nbsp; &nbsp; = 0x000A;&nbsp; &nbsp;// Record identifier<br />&nbsp; &nbsp; &nbsp; &nbsp; $length&nbsp; &nbsp; = 0x0000;&nbsp; &nbsp;// Number of bytes to follow<br />&nbsp; &nbsp; &nbsp; &nbsp; $header&nbsp; &nbsp; = pack(&quot;vv&quot;, $record, $length);<br />&nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;_append($header);<br />&nbsp; &nbsp; }</p>]]></content>
			<author>
				<name><![CDATA[moylua]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=20312</uri>
			</author>
			<updated>2015-04-13T10:21:21Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=23255#p23255</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Bug in Excel Reports]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=23217#p23217" />
			<content type="html"><![CDATA[<p>Please verify that the same result occurs when a different browser is used. Thanks for your patience in providing valuable feedback.</p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2015-04-10T16:07:56Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=23217#p23217</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Bug in Excel Reports]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=23214#p23214" />
			<content type="html"><![CDATA[<p>LF &quot;0A&quot; exists as first character. Removing the first line removes the 0A. I think is not a browser issue</p>]]></content>
			<author>
				<name><![CDATA[moylua]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=20312</uri>
			</author>
			<updated>2015-04-10T06:50:28Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=23214#p23214</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Bug in Excel Reports]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=23213#p23213" />
			<content type="html"><![CDATA[<p>Try to save the file from the URL in centos using wget and see if the blank line appears.</p><p>Also examine the file in a <a href="http://www.chmaas.handshake.de/delphi/freeware/xvi32/xvi32.htm">hex editor</a> to see if it is a CRLF or just LF - (0D 0A or just 0A).</p><p>Then we can programattically remove it if it exists as the first character(s).</p><p>Attaching your screenshot for the forum.</p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2015-04-10T06:39:14Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=23213#p23213</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Bug in Excel Reports]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=23211#p23211" />
			<content type="html"><![CDATA[<p>update:</p><p>I am using windows in my development machine. The Centos in production. I have noticed in CentOS that when viewing the raw output using notepad++. The excel file has one blank row on top. Removing that would make the excel work.</p><p><a href="http://i61.tinypic.com/bg9qe.png">http://i61.tinypic.com/bg9qe.png</a></p>]]></content>
			<author>
				<name><![CDATA[moylua]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=20312</uri>
			</author>
			<updated>2015-04-10T06:12:24Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=23211#p23211</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Bug in Excel Reports]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=23197#p23197" />
			<content type="html"><![CDATA[<p>The attached file is what you should get for the Chart of Accounts for the demo data in en_US-demo.sql CoA.</p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2015-04-09T14:51:43Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=23197#p23197</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Bug in Excel Reports]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=23192#p23192" />
			<content type="html"><![CDATA[<p>What language and fonts are you using and are they enabled in your CentOS?<br />Is it a browser mangling issue?</p><p>Try making the demo company print standard reports first before troubleshooting other issues.</p><p>Attached your Screenshot here.</p><p>It looks like you are using Arial font. See if your CentOS has that installed.</p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2015-04-09T13:14:53Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=23192#p23192</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Bug in Excel Reports]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=23185#p23185" />
			<content type="html"><![CDATA[<p>Hello, i experienced bug when generating excel reports. </p><p>My Server:<br />CENTOS 6.5 <br />mysql 5.1 <br />php 5.3 <br />Nginx 1.6 <br />Php-fpm</p><br /><p>http://i57.tinypic.com/2vk00nr.jpg</p>]]></content>
			<author>
				<name><![CDATA[moylua]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=20312</uri>
			</author>
			<updated>2015-04-09T08:21:07Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=23185#p23185</id>
		</entry>
</feed>
