#1907 was some work I'd started to do on a refactoring of the Trend classes, so that they could be tested more easily... it's a nasty bit of code that needs a major overhaul (especially as it has a lot of errors)... I will get back to it in time
#1961 is currently ongoing, I'm trying to implement all the ChiSquared functions for completeness; currently working on the
CHISQ.INV logic as part of that bundle (though that's proving a lot harder to implement than CHISQ.INV.RT() and the other ChiSquared functions
On my part I'd like to work on PHPOffice/PhpSpreadsheet#1962 in the next few days...
Also would you consider adding oleibman to the team ?
He has been contributing consistently high quality things to the projects for about 1 year.
Maybe we could give him Write role in GitHub ? What do you think ?
I certainly think he'd be a good addition to the team; he's done a lot of great work triaging issues, identifying/fixing bugs, as well as the work that he's been doing on refactoring the Excel functions... while one class per function might be overkill, it's still a great help, and that refactoring will make maintenance a lot easier in the future
I'd been thinking about adding him myself, but I've been a bit preoccupied these last two months with the refactoring work, and a new job in a new company
He might not be fully confident about OOP and mocking classes in unit tests yet, but he's learning quickly
PHPStan would certainly be a useful addition to the toolchain as well.... it can be quite broad in it's reporting at some levels, but still always useful
Hi, I have been using an opencart extension called "Export/Import tool" (https://www.mhccorp.com/export-import-4),
which has been working fine, until one day I found out that the exported xlsx files cannot be opened in MS Excel
the extension used the phpspreadsheet library
however, after I tried unzipping the xlsx file and re-zipping it,
I found that it can be opened in Excel
I found that it can be opened in Excel
...(1).xlsx - original file exported from the extension
...(1)-ok.xlsx - unzip + rezip version
...(1)-ok.xlsx - unzip + rezip version
the strange thing is that it worked well before
until one day it didn't, and AFAIK I didn't do anything to the files
until one day it didn't, and AFAIK I didn't do anything to the files
@PowerKiKi - Any idea what PHPStan is complaining about in PHPOffice/PhpSpreadsheet#1990 ? I can't figure out what its issue is at all
@arun-parhi This is documented here and there is an sample code demonstrating it in /samples/Basic/43_Merge_workbooks.php
If you simply want to do this in your own PHP script, and not in an actual spreadsheet; then just write your own function that calls the native Excel function implementations
Gah! I thought that we'd resolved the issue with selected cells being changed when saving the styles in a spreadsheet... but just doing some work to resolve the issue with DataBar Conditional Formats, and it's changing the selected cells.... either that PR hasn't been merged, or it doesn't apply to writing the conditional formats
The problem is that you need to install the PDF Renderer. PHPSpreadsheet provides adaptors for three different PDF Rendering libraries, allowing you to choose which one you wish to use - https://phpspreadsheet.readthedocs.io/en/latest/topics/reading-and-writing-to-file/#pdf
If you're losing charset.... PHPSpreadsheet converts everything to UTF-8 internally; so you probably need to ensure that your PDF Rendered has a version of the appropriate fonts that support the full unicode character set
Can you guys help me for a small issue
with your spreadshhet library
I am getting this error when uploading a excel sheet
Fatal error: Uncaught InvalidArgumentException: File "https://stagingreport.wpengine.com/wp-content/uploads/2021/05/Report-CSV-Template-2595.xlsx" does not exist. in /nas/content/live/stagingreport/wp-content/themes/jptr/spreadsheet/src/PhpSpreadsheet/Shared/File.php:159 Stack trace: #0 /nas/content/live/stagingreport/wp-content/themes/jptr/spreadsheet/src/PhpSpreadsheet/IOFactory.php(227): PhpOffice\PhpSpreadsheet\Shared\File::assertFile('https://staging...') #1 /nas/content/live/stagingreport/wp-content/themes/jptr/spreadsheet/src/PhpSpreadsheet/IOFactory.php(188): PhpOffice\PhpSpreadsheet\IOFactory::createReaderForFile('https://staging...') #2 /nas/content/live/stagingreport/wp-content/themes/jptr/functions.php(540): PhpOffice\PhpSpreadsheet\IOFactory::load('https://staging...') #3 /nas/content/live/stagingreport/wp-includes/class-wp-hook.php(294): save_custom_meta_data(4749) #4 /nas/content/live/stagingreport/wp-includes/class-wp-hook.php(316): WP_Hook->apply_filters(NULL, Array) #5 /nas/content/live/stagingreport/wp- in /nas/content/live/stagingreport/wp-content/themes/jptr/spreadsheet/src/PhpSpreadsheet/Shared/File.php on line 159
There has been a critical error on this website. Please check your site admin email inbox for instructions.
Fatal error: Uncaught InvalidArgumentException: File "https://stagingreport.wpengine.com/wp-content/uploads/2021/05/Report-CSV-Template-2595.xlsx" does not exist. in /nas/content/live/stagingreport/wp-content/themes/jptr/spreadsheet/src/PhpSpreadsheet/Shared/File.php:159 Stack trace: #0 /nas/content/live/stagingreport/wp-content/themes/jptr/spreadsheet/src/PhpSpreadsheet/IOFactory.php(227): PhpOffice\PhpSpreadsheet\Shared\File::assertFile('https://staging...') #1 /nas/content/live/stagingreport/wp-content/themes/jptr/spreadsheet/src/PhpSpreadsheet/IOFactory.php(188): PhpOffice\PhpSpreadsheet\IOFactory::createReaderForFile('https://staging...') #2 /nas/content/live/stagingreport/wp-content/themes/jptr/functions.php(540): PhpOffice\PhpSpreadsheet\IOFactory::load('https://staging...') #3 /nas/content/live/stagingreport/wp-includes/class-wp-hook.php(294): save_custom_meta_data(4749) #4 /nas/content/live/stagingreport/wp-includes/class-wp-hook.php(316): WP_Hook->apply_filters(NULL, Array) #5 /nas/content/live/stagingreport/wp- in /nas/content/live/stagingreport/wp-content/themes/jptr/spreadsheet/src/PhpSpreadsheet/Shared/File.php on line 159
There has been a critical error on this website. Please check your site admin email inbox for instructions.
@rahulgargmzn_twitter Check that the file really is in that folder, and has the correct name (watch out for case sensitivity); check directory and file permissions.... but the most likely issue is that you're using a url to try and access the file.... PHPSpreadsheet requires local filesystem access to the file, not web access
Hey, I've looked everywhere for an answer but didn't find one. I hope someone here can help me.
When i add a formula like this=SUMIFS($local.$C2:$C102,$local.$A2:$A102,$C4,$local.$B2:$B102,$D$3)
it adds the _xlfn between the = and the SUMIFS breaking the formule. if i open it in Libre Office and remove the _xlfn it works. (if i open it in excell online i don't even see the formula just #NAME?
is there a way to disable the _xlfn ? (i've also tried changing the . to ! breaks it even more)
hi, i've been using
IOFactory::load($filePath);for a while now to load xlsx files, but for some reason it fails on a specific xlsx i got from a client, with "Unable to identify a reader for this file". My MS excel 2019 can open it just fine, and i have version 1.17.1 in my vendors folder. The file is here: https://downloads.compulated.info/shared/ProduSoft%20train%20data%2020210506%20TRAINING.xlsx
aha, because the
switch ($rel['Type']) {type is "http://purl.oclc.org/ooxml/officeDocument/relationships/officeDocument" which is unknown in the switch statement
however, 'Target' is 'xl/workbook.xml', so i feel that it should work
should i make a github issue for this?
i don't know what program the customer used to create this xlsx for me :(