Since we updated the export package to the newest edition our clients started reporting errors in the excels.

as seen in picture some of the rows in excel just display some random characters, and when i debug I can see that the row that is incorrectly displayed has all the needed informaion and no special characters or something like that. All rows are defined as strings

You can see belllow an example of what it stored inside dataStore and when trying to format it in excel it displays random characters

This is really frustrating, how can you release such unstable releases of you enterprise packages. We upgraded becouse you added pivotTables to bigspreadsheet excel export, but other reports don't work properly, if I revert to old excel it works fine again, but the bigspreadsheet with pivotTable throw exceptions. This is really sloppy by your developers.

Hi

My client is also affected with that bug and it looks really serious. See me gist of code to repreduce the issue:

https://gist.github.com/woduda/00cc32417b4be0916db07f88e421ba2c

From my investigation the wrong value saved in excel cell is created in

koolreport\excel\TableBuilder::buildTableBodyRow()

in line with:

$value = Util::map($cellMap, [$colKey, $value, $dataRow], $value);

It seems that the fix is not in version 10.0.0 of koolreport/excel yet, when will there be an update?

Was the fix implemented in the new version yet? If not, when can we expect that to happen.

Also i found out that since the release of new version of PIVOT, if you have no data in your database it throws an error instead of displaying an empty table.

message: "Undefined index: title"

code: 0

file: "\vendor\koolreport\pivot\PivotUtil.php"

line: 239

Currenlty the latest is 8.5, so when will you realease the new version?

I cannot get that version, when updating packages it takes the 6.0.0, looks like it is not released yet.

In change logs on website you have latest version 5.6.2, on github 6.0.0

now other issues were found. There is an error regarding retrieving settings of the report. Exception is thrown on ResourceManager on line 79, when you run:

$assets = (string)Utility::get($this->report->getSettings(), "assets");

don't you do any testing, before you release? I am really disappointed at this point. Your trying to cast this to string while if i debug I can see that this is an array. Am I doing something wrong? This is bound to your core logic, not overriding this method or anything.

Please notify me, when this will be fixed. We urgently need to update it on our side.

i updated it and there is another issue regarding empty PIVOT tables. It throws an error in PivotUtil.cs at line 1058. You are trying to reach an index which is not defined.

We are operating Pivot process on ~700000 rows of data and displaying insde PivotTable in excell and it throws an error, it here some way we can optimize it? We are already using the BigSpreadSheetData when exporting.

Allowed memory size of 536870912 bytes exhausted (tried to allocate 20480 bytes) {"userId":1,"exception":"[object] (Symfony\Component\ErrorHandler\Error\FatalError(code: 0): Allowed memory size of 536870912 bytes exhausted (tried to allocate 20480 bytes) at {root}/vendor/koolreport/pivot/processes/Pivot.php:560)

this is the error.

I am also having some issues with the Excel package. I'd like to upgrade my code to the most stable Excel package. How do I do this? I don;'t want to upgrade everything, just Excel. Is there a doc on how to do this?

Also, I see that my question does not have the $ icon, although I am a paying customer Have you lost fact that I pay each year??

There is another exception thrown with the update of Excel BarChart library, which was not thrown prior to update

Sebastian, In response to your instructs I downloaded KR 6.01 and extracted to another dir. I don't see a dir Excel as a choice anywhere. Do you?

phpoffice/phpspreadsheet is currently on 1.25.2