Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Problem with multi-sheet plus hyperlink #37

Closed
the-kobold opened this issue May 29, 2021 · 3 comments
Closed

Problem with multi-sheet plus hyperlink #37

the-kobold opened this issue May 29, 2021 · 3 comments

Comments

@the-kobold
Copy link

the-kobold commented May 29, 2021

When I make multiple sheets with hyperlink in cells,

  • Excel drops an error but read the sheets
  • Every sheet contains the hyperlinks of first sheet.
    Test code:
        $xls['b'][] = array('a', 'b', 					'<a href="https://example.hu/b1">b1</a>');
	$xls['b'][] = array('aa', 'bb', 				'<a href="https://example.hu/b2">b2</a>' );
	$xls['m'][] = array('ma', 'mb', 'mc', 'md','me','<a href="https://example.hu/m1">m1</a>');
	$xls['m'][] = array('maa', 'mbb', 'mcc', 'mdd','mee', '<a href="https://example.hu/m2">m2</a>');
	$xls['d'][] = array('da', 'db', 'dc', 			'<a href="https://example.hu/d1">d1</a>');
	$xls['d'][] = array('daa', 'dbb', 'dcc',		'<a href="https://example.hu/d2">d2</a>');
	include_once($_SERVER['DOCUMENT_ROOT']."/.tools/simplexlsxgen/src/SimpleXLSXGen.php");
	$filename = "tst_".date('Ymd').".xlsx";
		
	$xlsx = new SimpleXLSXGen();
	$xlsx -> addSheet( $xls['b'], "1st Sheet" );
	$xlsx -> addSheet( $xls['m'], "2nd Sheet" );
	$xlsx -> addSheet( $xls['d'], "3rd Sheet" );
	$xlsx->saveAs('tmp/'.$filename);

What I do wrong ?
Thanx 4 any help as now i've to make 3 file than put them together ... not the best solution :)

@shuchkin
Copy link
Owner

shuchkin commented May 29, 2021

fixed in 1.0.13
thx for bug report

@the-kobold
Copy link
Author

the-kobold commented May 29, 2021

np, just attack the bugs if any :)
btw thx, very good job - 4 me anyway - u saved a bunch of my time with this "addon"
P.S. working now like a schaffausen watch ... I'm happy now, need a [big]bit of wine ;)

@shuchkin
Copy link
Owner

:)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants