mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-25 09:58:18 +00:00
oleibman
9428552d94
* Add editAs Property for 2-cell Anchor Drawings This change builds on PR #2532 (@naotake51 as PR #2532), using ideas from PR #2237 (@AdamGaskins), which has had changes requested for several months. It covers a lot of the same ground as 2532. In Excel, two-cell anchor drawings can be edited as "twocell", "onecell", or "absolute". This PR adds support for those options, with a sample file that demonstrates the difference in addition to unit tests. Several other tests are added to improve the spotty coverage for Drawings. There have been several other tickets referencing two cell anchors, including issue #1159 and PR #1160 (@sgarwood, who also added support for editAs), PR #643, and issue #126, all now closed but not necessarily entirely resolved. I will try to ensure that those tickets are addressed with this one. And, in trying to make sure 1160 is covered, I stumbled upon a bug. If you use the same image resource to create two+ memory drawings, the MemoryDrawing destructor for the first will cause the rest to generate a very long warning message. This is not a problem for Php8+, only for Php7-. I have suppressed the message in the MemoryDrawing constructor. 1160 went stale due to an unresolved test error, but I don't think this was the problem. At any rate, its test works now. * Scrutinizer It reported 1 minor issue (fixed normally), and 2 major. One is fixed with a kludge. The other is a case where Scrutinizer's analysis is just wrong, and I can't figure out a kludge. But I was able to add an annotation (the first time I've managed to get one past phpcs/php-cs-fixer). We'll see.
608 lines
27 KiB
PHP
608 lines
27 KiB
PHP
<?php
|
|
|
|
namespace PhpOffice\PhpSpreadsheetTests\Writer\Xlsx;
|
|
|
|
use PhpOffice\PhpSpreadsheet\Comment;
|
|
use PhpOffice\PhpSpreadsheet\Exception as PhpSpreadsheetException;
|
|
use PhpOffice\PhpSpreadsheet\IOFactory;
|
|
use PhpOffice\PhpSpreadsheet\Reader\Xlsx;
|
|
use PhpOffice\PhpSpreadsheet\Shared\File;
|
|
use PhpOffice\PhpSpreadsheet\Spreadsheet;
|
|
use PhpOffice\PhpSpreadsheet\Worksheet\BaseDrawing;
|
|
use PhpOffice\PhpSpreadsheet\Worksheet\Drawing;
|
|
use PhpOffice\PhpSpreadsheet\Worksheet\MemoryDrawing;
|
|
use PhpOffice\PhpSpreadsheetTests\Functional\AbstractFunctional;
|
|
|
|
class DrawingsTest extends AbstractFunctional
|
|
{
|
|
/**
|
|
* Test save and load XLSX file with drawing on 2nd worksheet.
|
|
*/
|
|
public function testSaveLoadWithDrawingOn2ndWorksheet(): void
|
|
{
|
|
// Read spreadsheet from file
|
|
$inputFilename = 'tests/data/Writer/XLSX/drawing_on_2nd_page.xlsx';
|
|
$reader = new Xlsx();
|
|
$spreadsheet = $reader->load($inputFilename);
|
|
|
|
// Save spreadsheet to file and read it back
|
|
$reloadedSpreadsheet = $this->writeAndReload($spreadsheet, 'Xlsx');
|
|
|
|
// Fake assert. The only thing we need is to ensure the file is loaded without exception
|
|
self::assertNotNull($reloadedSpreadsheet);
|
|
$spreadsheet->disconnectWorksheets();
|
|
$reloadedSpreadsheet->disconnectWorksheets();
|
|
}
|
|
|
|
/**
|
|
* Test save and load XLSX file with drawing with the same file name.
|
|
*/
|
|
public function testSaveLoadWithDrawingWithSamePath(): void
|
|
{
|
|
// Read spreadsheet from file
|
|
$originalFileName = 'tests/data/Writer/XLSX/saving_drawing_with_same_path.xlsx';
|
|
|
|
$originalFile = file_get_contents($originalFileName);
|
|
|
|
$tempFileName = File::sysGetTempDir() . '/saving_drawing_with_same_path';
|
|
|
|
file_put_contents($tempFileName, $originalFile);
|
|
|
|
$reader = new Xlsx();
|
|
$spreadsheet = $reader->load($tempFileName);
|
|
|
|
$spreadsheet->getActiveSheet()->setCellValue('D5', 'foo');
|
|
// Save spreadsheet to file to the same path. Success test case won't
|
|
// throw exception here
|
|
$writer = IOFactory::createWriter($spreadsheet, 'Xlsx');
|
|
$writer->save($tempFileName);
|
|
|
|
$reloadedSpreadsheet = $reader->load($tempFileName);
|
|
|
|
unlink($tempFileName);
|
|
|
|
// Fake assert. The only thing we need is to ensure the file is loaded without exception
|
|
self::assertNotNull($reloadedSpreadsheet);
|
|
$spreadsheet->disconnectWorksheets();
|
|
$reloadedSpreadsheet->disconnectWorksheets();
|
|
}
|
|
|
|
/**
|
|
* Test save and load XLSX file with drawing in comment.
|
|
*/
|
|
public function testSaveLoadWithDrawingInComment(): void
|
|
{
|
|
// Read spreadsheet from file
|
|
$originalFileName = 'tests/data/Writer/XLSX/drawing_in_comment.xlsx';
|
|
|
|
$originalFile = file_get_contents($originalFileName);
|
|
|
|
$tempFileName = File::sysGetTempDir() . '/drawing_in_comment.xlsx';
|
|
|
|
file_put_contents($tempFileName, $originalFile);
|
|
|
|
// Load native xlsx file with drawing in comment background
|
|
$reader = new Xlsx();
|
|
$spreadsheet = $reader->load($tempFileName);
|
|
|
|
$sheet = $spreadsheet->getActiveSheet();
|
|
$comment = $sheet->getComment('A1');
|
|
|
|
self::assertTrue($comment instanceof Comment);
|
|
self::assertTrue($comment->hasBackgroundImage());
|
|
self::assertTrue($comment->getBackgroundImage() instanceof Drawing);
|
|
self::assertEquals($comment->getBackgroundImage()->getWidth(), 178);
|
|
self::assertEquals($comment->getBackgroundImage()->getHeight(), 140);
|
|
self::assertEquals($comment->getBackgroundImage()->getType(), IMAGETYPE_JPEG);
|
|
|
|
$writer = IOFactory::createWriter($spreadsheet, 'Xlsx');
|
|
$writer->save($tempFileName);
|
|
|
|
$reloadedSpreadsheet = $reader->load($tempFileName);
|
|
unlink($tempFileName);
|
|
|
|
self::assertNotNull($reloadedSpreadsheet);
|
|
$spreadsheet->disconnectWorksheets();
|
|
$reloadedSpreadsheet->disconnectWorksheets();
|
|
}
|
|
|
|
/**
|
|
* Test save and load XLSX file with drawing in comment, image in BMP/GIF format saved as PNG.
|
|
*/
|
|
public function testDrawingInCommentImageFormatsConversions(): void
|
|
{
|
|
$reader = new Xlsx();
|
|
$spreadsheet = new Spreadsheet();
|
|
$sheet = $spreadsheet->getActiveSheet();
|
|
|
|
// Add gif image to comment background
|
|
$sheet->setCellValue('A1', '.gif');
|
|
$drawing = new Drawing();
|
|
$drawing->setName('Green Square');
|
|
$drawing->setPath('tests/data/Writer/XLSX/green_square.gif');
|
|
self::assertEquals($drawing->getWidth(), 150);
|
|
self::assertEquals($drawing->getHeight(), 150);
|
|
$comment = $sheet->getComment('A1');
|
|
$comment->setBackgroundImage($drawing);
|
|
$comment->setSizeAsBackgroundImage();
|
|
self::assertEquals($comment->getWidth(), '112.5pt');
|
|
self::assertEquals($comment->getHeight(), '112.5pt');
|
|
self::assertTrue($comment instanceof Comment);
|
|
self::assertTrue($comment->hasBackgroundImage());
|
|
self::assertTrue($comment->getBackgroundImage() instanceof Drawing);
|
|
self::assertEquals($comment->getBackgroundImage()->getType(), IMAGETYPE_GIF);
|
|
|
|
// Add bmp image to comment background
|
|
$sheet->setCellValue('A2', '.bmp 16 colors');
|
|
$drawing = new Drawing();
|
|
$drawing->setName('Yellow Square');
|
|
$drawing->setPath('tests/data/Writer/XLSX/yellow_square_16.bmp');
|
|
self::assertEquals($drawing->getWidth(), 70);
|
|
self::assertEquals($drawing->getHeight(), 70);
|
|
$comment = $sheet->getComment('A2');
|
|
$comment->setBackgroundImage($drawing);
|
|
$comment->setSizeAsBackgroundImage();
|
|
self::assertEquals($comment->getWidth(), '52.5pt');
|
|
self::assertEquals($comment->getHeight(), '52.5pt');
|
|
self::assertTrue($comment instanceof Comment);
|
|
self::assertTrue($comment->hasBackgroundImage());
|
|
self::assertTrue($comment->getBackgroundImage() instanceof Drawing);
|
|
self::assertEquals($comment->getBackgroundImage()->getType(), IMAGETYPE_BMP);
|
|
|
|
// Write file
|
|
$writer = IOFactory::createWriter($spreadsheet, 'Xlsx');
|
|
$tempFileName = File::sysGetTempDir() . '/drawings_in_comments_conversions.xlsx';
|
|
$writer->save($tempFileName);
|
|
|
|
// Read new file
|
|
$reloadedSpreadsheet = $reader->load($tempFileName);
|
|
$sheet = $reloadedSpreadsheet->getActiveSheet();
|
|
|
|
// Check first image in comment background
|
|
$comment = $sheet->getComment('A1');
|
|
self::assertEquals($comment->getWidth(), '112.5pt');
|
|
self::assertEquals($comment->getHeight(), '112.5pt');
|
|
self::assertTrue($comment instanceof Comment);
|
|
self::assertTrue($comment->hasBackgroundImage());
|
|
self::assertTrue($comment->getBackgroundImage() instanceof Drawing);
|
|
self::assertEquals($comment->getBackgroundImage()->getWidth(), 150);
|
|
self::assertEquals($comment->getBackgroundImage()->getHeight(), 150);
|
|
self::assertEquals($comment->getBackgroundImage()->getType(), IMAGETYPE_PNG);
|
|
|
|
// Check second image in comment background
|
|
$comment = $sheet->getComment('A2');
|
|
self::assertEquals($comment->getWidth(), '52.5pt');
|
|
self::assertEquals($comment->getHeight(), '52.5pt');
|
|
self::assertTrue($comment instanceof Comment);
|
|
self::assertTrue($comment->hasBackgroundImage());
|
|
self::assertTrue($comment->getBackgroundImage() instanceof Drawing);
|
|
self::assertEquals($comment->getBackgroundImage()->getWidth(), 70);
|
|
self::assertEquals($comment->getBackgroundImage()->getHeight(), 70);
|
|
self::assertEquals($comment->getBackgroundImage()->getType(), IMAGETYPE_PNG);
|
|
|
|
unlink($tempFileName);
|
|
$spreadsheet->disconnectWorksheets();
|
|
$reloadedSpreadsheet->disconnectWorksheets();
|
|
}
|
|
|
|
/**
|
|
* Test build and save XLSX with drawings in comments with comment size correction.
|
|
*/
|
|
public function testBuildWithDifferentImageFormats(): void
|
|
{
|
|
$reader = new Xlsx();
|
|
$spreadsheet = new Spreadsheet();
|
|
$sheet = $spreadsheet->getActiveSheet();
|
|
|
|
// Add png image to comment background
|
|
$sheet->setCellValue('A1', '.png');
|
|
$drawing = new Drawing();
|
|
$drawing->setName('Blue Square');
|
|
$drawing->setPath('tests/data/Writer/XLSX/blue_square.png');
|
|
self::assertEquals($drawing->getWidth(), 100);
|
|
self::assertEquals($drawing->getHeight(), 100);
|
|
$comment = $sheet->getComment('A1');
|
|
$comment->setBackgroundImage($drawing);
|
|
$comment->setSizeAsBackgroundImage();
|
|
self::assertEquals($comment->getWidth(), '75pt');
|
|
self::assertEquals($comment->getHeight(), '75pt');
|
|
|
|
$comment = $sheet->getComment('A1');
|
|
self::assertTrue($comment instanceof Comment);
|
|
self::assertTrue($comment->hasBackgroundImage());
|
|
self::assertTrue($comment->getBackgroundImage() instanceof Drawing);
|
|
self::assertEquals($comment->getBackgroundImage()->getType(), IMAGETYPE_PNG);
|
|
|
|
// Add gif image to comment background
|
|
$sheet->setCellValue('A2', '.gif');
|
|
$drawing = new Drawing();
|
|
$drawing->setName('Green Square');
|
|
$drawing->setPath('tests/data/Writer/XLSX/green_square.gif');
|
|
self::assertEquals($drawing->getWidth(), 150);
|
|
self::assertEquals($drawing->getHeight(), 150);
|
|
$comment = $sheet->getComment('A2');
|
|
$comment->setBackgroundImage($drawing);
|
|
$comment->setSizeAsBackgroundImage();
|
|
self::assertEquals($comment->getWidth(), '112.5pt');
|
|
self::assertEquals($comment->getHeight(), '112.5pt');
|
|
|
|
$comment = $sheet->getComment('A2');
|
|
self::assertTrue($comment instanceof Comment);
|
|
self::assertTrue($comment->hasBackgroundImage());
|
|
self::assertTrue($comment->getBackgroundImage() instanceof Drawing);
|
|
self::assertEquals($comment->getBackgroundImage()->getType(), IMAGETYPE_GIF);
|
|
|
|
// Add jpeg image to comment background
|
|
$sheet->setCellValue('A3', '.jpeg');
|
|
$drawing = new Drawing();
|
|
$drawing->setName('Red Square');
|
|
$drawing->setPath('tests/data/Writer/XLSX/red_square.jpeg');
|
|
self::assertEquals($drawing->getWidth(), 50);
|
|
self::assertEquals($drawing->getHeight(), 50);
|
|
$comment = $sheet->getComment('A3');
|
|
$comment->setBackgroundImage($drawing);
|
|
$comment->setSizeAsBackgroundImage();
|
|
self::assertEquals($comment->getWidth(), '37.5pt');
|
|
self::assertEquals($comment->getHeight(), '37.5pt');
|
|
|
|
$comment = $sheet->getComment('A3');
|
|
self::assertTrue($comment instanceof Comment);
|
|
self::assertTrue($comment->hasBackgroundImage());
|
|
self::assertTrue($comment->getBackgroundImage() instanceof Drawing);
|
|
self::assertEquals($comment->getBackgroundImage()->getType(), IMAGETYPE_JPEG);
|
|
|
|
// Add bmp image to comment background
|
|
$sheet->setCellValue('A4', '.bmp 16 colors');
|
|
$drawing = new Drawing();
|
|
$drawing->setName('Yellow Square');
|
|
$drawing->setPath('tests/data/Writer/XLSX/yellow_square_16.bmp');
|
|
self::assertEquals($drawing->getWidth(), 70);
|
|
self::assertEquals($drawing->getHeight(), 70);
|
|
$comment = $sheet->getComment('A4');
|
|
$comment->setBackgroundImage($drawing);
|
|
$comment->setSizeAsBackgroundImage();
|
|
self::assertEquals($comment->getWidth(), '52.5pt');
|
|
self::assertEquals($comment->getHeight(), '52.5pt');
|
|
|
|
$comment = $sheet->getComment('A4');
|
|
self::assertTrue($comment instanceof Comment);
|
|
self::assertTrue($comment->hasBackgroundImage());
|
|
self::assertTrue($comment->getBackgroundImage() instanceof Drawing);
|
|
self::assertEquals($comment->getBackgroundImage()->getType(), IMAGETYPE_BMP);
|
|
|
|
// Add bmp image to comment background
|
|
$sheet->setCellValue('A5', '.bmp 256 colors');
|
|
$drawing = new Drawing();
|
|
$drawing->setName('Brown Square');
|
|
$drawing->setPath('tests/data/Writer/XLSX/brown_square_256.bmp');
|
|
self::assertEquals($drawing->getWidth(), 70);
|
|
self::assertEquals($drawing->getHeight(), 70);
|
|
$comment = $sheet->getComment('A5');
|
|
$comment->setBackgroundImage($drawing);
|
|
$comment->setSizeAsBackgroundImage();
|
|
self::assertEquals($comment->getWidth(), '52.5pt');
|
|
self::assertEquals($comment->getHeight(), '52.5pt');
|
|
|
|
$comment = $sheet->getComment('A5');
|
|
self::assertTrue($comment instanceof Comment);
|
|
self::assertTrue($comment->hasBackgroundImage());
|
|
self::assertTrue($comment->getBackgroundImage() instanceof Drawing);
|
|
self::assertEquals($comment->getBackgroundImage()->getType(), IMAGETYPE_BMP);
|
|
|
|
// Add bmp image to comment background
|
|
$sheet->setCellValue('A6', '.bmp 24 bit');
|
|
$drawing = new Drawing();
|
|
$drawing->setName('Orange Square');
|
|
$drawing->setPath('tests/data/Writer/XLSX/orange_square_24_bit.bmp');
|
|
self::assertEquals($drawing->getWidth(), 70);
|
|
self::assertEquals($drawing->getHeight(), 70);
|
|
self::assertSame(IMAGETYPE_PNG, $drawing->getImageTypeForSave());
|
|
$comment = $sheet->getComment('A6');
|
|
$comment->setBackgroundImage($drawing);
|
|
$comment->setSizeAsBackgroundImage();
|
|
self::assertEquals($comment->getWidth(), '52.5pt');
|
|
self::assertEquals($comment->getHeight(), '52.5pt');
|
|
|
|
$comment = $sheet->getComment('A6');
|
|
self::assertTrue($comment instanceof Comment);
|
|
self::assertTrue($comment->hasBackgroundImage());
|
|
self::assertTrue($comment->getBackgroundImage() instanceof Drawing);
|
|
self::assertEquals($comment->getBackgroundImage()->getType(), IMAGETYPE_BMP);
|
|
|
|
// Add unsupported tiff image to comment background
|
|
$sheet->setCellValue('A7', '.tiff');
|
|
$drawing = new Drawing();
|
|
$drawing->setName('Purple Square');
|
|
$drawing->setPath('tests/data/Writer/XLSX/purple_square.tiff');
|
|
self::assertStringContainsString('purple_square.tiff', $drawing->getFilename());
|
|
self::assertFalse($drawing->getIsUrl());
|
|
$comment = $sheet->getComment('A7');
|
|
self::assertTrue($comment instanceof Comment);
|
|
self::assertFalse($comment->hasBackgroundImage());
|
|
self::assertTrue($comment->getBackgroundImage() instanceof Drawing);
|
|
self::assertEquals($comment->getBackgroundImage()->getType(), IMAGETYPE_UNKNOWN);
|
|
|
|
try {
|
|
$comment->setBackgroundImage($drawing);
|
|
self::fail('Should throw exception when attempting to add tiff');
|
|
} catch (PhpSpreadsheetException $e) {
|
|
self::assertTrue($e instanceof PhpSpreadsheetException);
|
|
self::assertEquals($e->getMessage(), 'Unsupported image type in comment background. Supported types: PNG, JPEG, BMP, GIF.');
|
|
}
|
|
|
|
try {
|
|
$drawing->getImageTypeForSave();
|
|
self::fail('Should throw exception when attempting to get image type for tiff');
|
|
} catch (PhpSpreadsheetException $e) {
|
|
self::assertTrue($e instanceof PhpSpreadsheetException);
|
|
self::assertEquals($e->getMessage(), 'Unsupported image type in comment background. Supported types: PNG, JPEG, BMP, GIF.');
|
|
}
|
|
|
|
try {
|
|
$drawing->getMediaFilename();
|
|
self::fail('Should throw exception when attempting to get media file name for tiff');
|
|
} catch (PhpSpreadsheetException $e) {
|
|
self::assertTrue($e instanceof PhpSpreadsheetException);
|
|
self::assertEquals($e->getMessage(), 'Unsupported image type in comment background. Supported types: PNG, JPEG, BMP, GIF.');
|
|
}
|
|
|
|
try {
|
|
$drawing->getImageFileExtensionForSave();
|
|
self::fail('Should throw exception when attempting to get image file extention for tiff');
|
|
} catch (PhpSpreadsheetException $e) {
|
|
self::assertTrue($e instanceof PhpSpreadsheetException);
|
|
self::assertEquals($e->getMessage(), 'Unsupported image type in comment background. Supported types: PNG, JPEG, BMP, GIF.');
|
|
}
|
|
|
|
try {
|
|
$drawing->getImageMimeType();
|
|
self::fail('Should throw exception when attempting to get image mime type for tiff');
|
|
} catch (PhpSpreadsheetException $e) {
|
|
self::assertTrue($e instanceof PhpSpreadsheetException);
|
|
self::assertEquals($e->getMessage(), 'Unsupported image type in comment background. Supported types: PNG, JPEG, BMP, GIF.');
|
|
}
|
|
|
|
// Write file
|
|
$writer = IOFactory::createWriter($spreadsheet, 'Xlsx');
|
|
$tempFileName = File::sysGetTempDir() . '/drawings_in_comments.xlsx';
|
|
$writer->save($tempFileName);
|
|
|
|
// Read new file
|
|
$reloadedSpreadsheet = $reader->load($tempFileName);
|
|
$sheet = $reloadedSpreadsheet->getActiveSheet();
|
|
|
|
// Check first image in comment background
|
|
$comment = $sheet->getComment('A1');
|
|
self::assertEquals($comment->getWidth(), '75pt');
|
|
self::assertEquals($comment->getHeight(), '75pt');
|
|
self::assertTrue($comment instanceof Comment);
|
|
self::assertTrue($comment->hasBackgroundImage());
|
|
self::assertTrue($comment->getBackgroundImage() instanceof Drawing);
|
|
self::assertEquals($comment->getBackgroundImage()->getWidth(), 100);
|
|
self::assertEquals($comment->getBackgroundImage()->getHeight(), 100);
|
|
self::assertEquals($comment->getBackgroundImage()->getType(), IMAGETYPE_PNG);
|
|
|
|
// Check second image in comment background
|
|
$comment = $sheet->getComment('A2');
|
|
self::assertEquals($comment->getWidth(), '112.5pt');
|
|
self::assertEquals($comment->getHeight(), '112.5pt');
|
|
self::assertTrue($comment instanceof Comment);
|
|
self::assertTrue($comment->hasBackgroundImage());
|
|
self::assertTrue($comment->getBackgroundImage() instanceof Drawing);
|
|
self::assertEquals($comment->getBackgroundImage()->getWidth(), 150);
|
|
self::assertEquals($comment->getBackgroundImage()->getHeight(), 150);
|
|
self::assertEquals($comment->getBackgroundImage()->getType(), IMAGETYPE_PNG);
|
|
|
|
// Check third image in comment background
|
|
$comment = $sheet->getComment('A3');
|
|
self::assertEquals($comment->getWidth(), '37.5pt');
|
|
self::assertEquals($comment->getHeight(), '37.5pt');
|
|
self::assertTrue($comment instanceof Comment);
|
|
self::assertTrue($comment->hasBackgroundImage());
|
|
self::assertTrue($comment->getBackgroundImage() instanceof Drawing);
|
|
self::assertEquals($comment->getBackgroundImage()->getWidth(), 50);
|
|
self::assertEquals($comment->getBackgroundImage()->getHeight(), 50);
|
|
self::assertEquals($comment->getBackgroundImage()->getType(), IMAGETYPE_JPEG);
|
|
|
|
// Check fourth image in comment background
|
|
$comment = $sheet->getComment('A4');
|
|
self::assertEquals($comment->getWidth(), '52.5pt');
|
|
self::assertEquals($comment->getHeight(), '52.5pt');
|
|
self::assertTrue($comment instanceof Comment);
|
|
self::assertTrue($comment->hasBackgroundImage());
|
|
self::assertTrue($comment->getBackgroundImage() instanceof Drawing);
|
|
self::assertEquals($comment->getBackgroundImage()->getWidth(), 70);
|
|
self::assertEquals($comment->getBackgroundImage()->getHeight(), 70);
|
|
self::assertEquals($comment->getBackgroundImage()->getType(), IMAGETYPE_PNG);
|
|
|
|
// Check fifth image in comment background
|
|
$comment = $sheet->getComment('A5');
|
|
self::assertEquals($comment->getWidth(), '52.5pt');
|
|
self::assertEquals($comment->getHeight(), '52.5pt');
|
|
self::assertTrue($comment instanceof Comment);
|
|
self::assertTrue($comment->hasBackgroundImage());
|
|
self::assertTrue($comment->getBackgroundImage() instanceof Drawing);
|
|
self::assertEquals($comment->getBackgroundImage()->getWidth(), 70);
|
|
self::assertEquals($comment->getBackgroundImage()->getHeight(), 70);
|
|
self::assertEquals($comment->getBackgroundImage()->getType(), IMAGETYPE_PNG);
|
|
|
|
// Check sixth image in comment background
|
|
$comment = $sheet->getComment('A6');
|
|
self::assertEquals($comment->getWidth(), '52.5pt');
|
|
self::assertEquals($comment->getHeight(), '52.5pt');
|
|
self::assertTrue($comment instanceof Comment);
|
|
self::assertTrue($comment->hasBackgroundImage());
|
|
self::assertTrue($comment->getBackgroundImage() instanceof Drawing);
|
|
self::assertEquals($comment->getBackgroundImage()->getWidth(), 70);
|
|
self::assertEquals($comment->getBackgroundImage()->getHeight(), 70);
|
|
self::assertEquals($comment->getBackgroundImage()->getType(), IMAGETYPE_PNG);
|
|
|
|
// Check seventh image in comment background
|
|
$comment = $sheet->getComment('A7');
|
|
self::assertTrue($comment instanceof Comment);
|
|
self::assertFalse($comment->hasBackgroundImage());
|
|
self::assertTrue($comment->getBackgroundImage() instanceof Drawing);
|
|
self::assertEquals($comment->getBackgroundImage()->getWidth(), 0);
|
|
self::assertEquals($comment->getBackgroundImage()->getHeight(), 0);
|
|
self::assertEquals($comment->getBackgroundImage()->getType(), IMAGETYPE_UNKNOWN);
|
|
|
|
unlink($tempFileName);
|
|
|
|
$spreadsheet->disconnectWorksheets();
|
|
$reloadedSpreadsheet->disconnectWorksheets();
|
|
}
|
|
|
|
/**
|
|
* Test save and load XLSX file with drawing image that coordinate is two cell anchor.
|
|
*/
|
|
public function testTwoCellAnchorDrawing(): void
|
|
{
|
|
$spreadsheet = new Spreadsheet();
|
|
$sheet = $spreadsheet->getActiveSheet();
|
|
|
|
// Add gif image that coordinates is two cell anchor.
|
|
$drawing = new Drawing();
|
|
$drawing->setName('Green Square');
|
|
$drawing->setPath('tests/data/Writer/XLSX/green_square.gif');
|
|
self::assertEquals($drawing->getWidth(), 150);
|
|
self::assertEquals($drawing->getHeight(), 150);
|
|
$drawing->setCoordinates('A1');
|
|
$drawing->setOffsetX(30);
|
|
$drawing->setOffsetY(10);
|
|
$drawing->setCoordinates2('E8');
|
|
$drawing->setOffsetX2(-50);
|
|
$drawing->setOffsetY2(-20);
|
|
$drawing->setWorksheet($sheet);
|
|
|
|
// Write file
|
|
$reloadedSpreadsheet = $this->writeAndReload($spreadsheet, 'Xlsx');
|
|
$spreadsheet->disconnectWorksheets();
|
|
$rsheet = $reloadedSpreadsheet->getActiveSheet();
|
|
|
|
// Check image coordinates.
|
|
$drawingCollection = $rsheet->getDrawingCollection();
|
|
self::assertCount(1, $drawingCollection);
|
|
$drawing = $drawingCollection[0];
|
|
self::assertNotNull($drawing);
|
|
|
|
self::assertSame(150, $drawing->getWidth());
|
|
self::assertSame(150, $drawing->getHeight());
|
|
self::assertSame('A1', $drawing->getCoordinates());
|
|
self::assertSame(30, $drawing->getOffsetX());
|
|
self::assertSame(10, $drawing->getOffsetY());
|
|
self::assertSame('E8', $drawing->getCoordinates2());
|
|
self::assertSame(-50, $drawing->getOffsetX2());
|
|
self::assertSame(-20, $drawing->getOffsetY2());
|
|
self::assertSame($rsheet, $drawing->getWorksheet());
|
|
$reloadedSpreadsheet->disconnectWorksheets();
|
|
}
|
|
|
|
/**
|
|
* Test editAs attribute for two-cell anchors.
|
|
*
|
|
* @dataProvider providerEditAs
|
|
*/
|
|
public function testTwoCellEditAs(string $editAs, ?string $expectedResult = null): void
|
|
{
|
|
if ($expectedResult === null) {
|
|
$expectedResult = $editAs;
|
|
}
|
|
$spreadsheet = new Spreadsheet();
|
|
$sheet = $spreadsheet->getActiveSheet();
|
|
|
|
// Add gif image that coordinates is two cell anchor.
|
|
$drawing = new Drawing();
|
|
$drawing->setName('Green Square');
|
|
$drawing->setPath('tests/data/Writer/XLSX/green_square.gif');
|
|
self::assertEquals($drawing->getWidth(), 150);
|
|
self::assertEquals($drawing->getHeight(), 150);
|
|
$drawing->setCoordinates('A1');
|
|
$drawing->setOffsetX(30);
|
|
$drawing->setOffsetY(10);
|
|
$drawing->setCoordinates2('E8');
|
|
$drawing->setOffsetX2(-50);
|
|
$drawing->setOffsetY2(-20);
|
|
if ($editAs !== '') {
|
|
$drawing->setEditAs($editAs);
|
|
}
|
|
$drawing->setWorksheet($sheet);
|
|
|
|
// Write file
|
|
$reloadedSpreadsheet = $this->writeAndReload($spreadsheet, 'Xlsx');
|
|
$spreadsheet->disconnectWorksheets();
|
|
$rsheet = $reloadedSpreadsheet->getActiveSheet();
|
|
|
|
// Check image coordinates.
|
|
$drawingCollection = $rsheet->getDrawingCollection();
|
|
$drawing = $drawingCollection[0];
|
|
self::assertNotNull($drawing);
|
|
|
|
self::assertSame(150, $drawing->getWidth());
|
|
self::assertSame(150, $drawing->getHeight());
|
|
self::assertSame('A1', $drawing->getCoordinates());
|
|
self::assertSame(30, $drawing->getOffsetX());
|
|
self::assertSame(10, $drawing->getOffsetY());
|
|
self::assertSame('E8', $drawing->getCoordinates2());
|
|
self::assertSame(-50, $drawing->getOffsetX2());
|
|
self::assertSame(-20, $drawing->getOffsetY2());
|
|
self::assertSame($rsheet, $drawing->getWorksheet());
|
|
self::assertSame($expectedResult, $drawing->getEditAs());
|
|
$reloadedSpreadsheet->disconnectWorksheets();
|
|
}
|
|
|
|
public function providerEditAs(): array
|
|
{
|
|
return [
|
|
'absolute' => ['absolute'],
|
|
'onecell' => ['onecell'],
|
|
'twocell' => ['twocell'],
|
|
'unset (will be treated as twocell)' => [''],
|
|
'unknown (will be treated as twocell)' => ['unknown', ''],
|
|
];
|
|
}
|
|
|
|
public function testMemoryDrawingDuplicateResource(): void
|
|
{
|
|
$gdImage = imagecreatetruecolor(120, 20);
|
|
$textColor = ($gdImage === false) ? false : imagecolorallocate($gdImage, 255, 255, 255);
|
|
if ($gdImage === false || $textColor === false) {
|
|
self::fail('imagecreatetruecolor or imagecolorallocate failed');
|
|
} else {
|
|
$spreadsheet = new Spreadsheet();
|
|
$aSheet = $spreadsheet->getActiveSheet();
|
|
imagestring($gdImage, 1, 5, 5, 'Created with PhpSpreadsheet', $textColor);
|
|
$listOfModes = [
|
|
BaseDrawing::EDIT_AS_TWOCELL,
|
|
BaseDrawing::EDIT_AS_ABSOLUTE,
|
|
BaseDrawing::EDIT_AS_ONECELL,
|
|
];
|
|
|
|
foreach ($listOfModes as $i => $mode) {
|
|
$drawing = new MemoryDrawing();
|
|
$drawing->setName('In-Memory image ' . $i);
|
|
$drawing->setDescription('In-Memory image ' . $i);
|
|
|
|
$drawing->setCoordinates('A' . ((4 * $i) + 1));
|
|
$drawing->setCoordinates2('D' . ((4 * $i) + 4));
|
|
$drawing->setEditAs($mode);
|
|
|
|
$drawing->setImageResource($gdImage);
|
|
$drawing->setRenderingFunction(
|
|
MemoryDrawing::RENDERING_JPEG
|
|
);
|
|
|
|
$drawing->setMimeType(MemoryDrawing::MIMETYPE_DEFAULT);
|
|
|
|
$drawing->setWorksheet($aSheet);
|
|
}
|
|
$reloadedSpreadsheet = $this->writeAndReload($spreadsheet, 'Xlsx');
|
|
$spreadsheet->disconnectWorksheets();
|
|
|
|
foreach ($reloadedSpreadsheet->getActiveSheet()->getDrawingCollection() as $index => $pDrawing) {
|
|
self::assertEquals($listOfModes[$index], $pDrawing->getEditAs(), 'functional test drawing twoCellAnchor');
|
|
}
|
|
$reloadedSpreadsheet->disconnectWorksheets();
|
|
}
|
|
}
|
|
}
|