SYLK Comments

[SheetJSDev]

This is:

- [ ] a bug report
- [x] a feature request
- [x] **not** a usage question (ask them on https://stackoverflow.com/questions/tagged/phpspreadsheet or https://gitter.im/PHPOffice/PhpSpreadsheet)

This SYLK file includes cell comments:

ID;PWXL;N;E
P;PGeneral
F;P0;DG0G10;M320
B;Y3;X1;D0 0 9 0
C;Y1;X1;AZeratul:� :En Taro Adun!
C;Y2;X2;AArthas:� :Frostmourne Hungers.
C;Y1;X1;K1
C;Y1;X2;K2
C;Y2;X1;K3
E

(The control characters are \x1b and are part of the encoding of newlines characters)

The A field in SYLK apparently specifies a cell comment.

What is the expected behavior?

Comment text should be available at $sheet->getComment("A1")->getText() and $sheet->getComment("B2")->getText()

What is the current behavior?

No text is available

What are the steps to reproduce?

Save the SYLK codeblock to comment.slk and run

<?php

require 'vendor/autoload.php';

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

$spreadsheet = \PhpOffice\PhpSpreadsheet\IOFactory::load("comment.slk");
$sheet = $spreadsheet->getActiveSheet();
print_r($sheet->getComment("B2")->getText());

Which versions of PhpSpreadsheet and PHP are affected?

All versions of PHPSpreadsheet and every commit of PHPExcel on github

[oleibman]

See #2267 for an additional issue regarding SYLK.

[PowerKiKi]

https://github.com/PHPOffice/PhpSpreadsheet/releases/tag/1.19.0