/**
* @param $text
*
* @return string
*/
public function getData($text)
{
$charCount = StringUtils::countCharacters($text);
$text = StringUtils::toBiff8UnicodeLongWoLenInfo($text);
$grbit = 0x212;
$rotation = 0;
$data = pack('vv', $grbit, $rotation);
$data .= pack('vvv', 0, 0, 0);
//reserved
$txoRunsLength = 0x10;
$data .= pack('vv', $charCount, $txoRunsLength);
$data .= pack('V', 0);
//reserved
$result = $this->getFullRecord($data);
$continue = new ContinueRecord();
$result .= $continue->getDataRaw($text);
$txoRunsData = pack('H*', '00000500');
$txoRunsData .= pack('H*', '2F00');
$txoRunsData .= pack('H*', '0C00');
$lastRun = pack('v', $charCount);
$lastRun .= pack('H*', '000000000200');
$txoRunsData .= $lastRun;
$result .= $continue->getDataRaw($txoRunsData);
return $result;
}
/**
* @param $type
* @param $sheetIndex
* @param $formulaData
*
* @return string
*/
public function getData($type, $sheetIndex, $formulaData)
{
$options = 0x20;
// Option flags
$name = pack("C", $type);
$nameLen = StringUtils::countCharacters($name);
$name = StringUtils::toBiff8UnicodeLongWoLenInfo($name);
$formulaLen = strlen($formulaData);
$data = pack("vC", $options, 0);
$data .= pack("Cv", $nameLen, $formulaLen);
$data .= pack("vv", 0, $sheetIndex);
$data .= pack("CCCC", 0, 0, 0, 0);
$data .= $name . $formulaData;
return $this->getFullRecord($data);
}
