Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
  • 14:18
    oleibman commented #1767
  • 14:16
    oleibman synchronize #2088
  • 13:57
    oleibman synchronize #2088
  • 13:55
    rkyoku commented #1767
  • 13:50
    oleibman synchronize #2088
  • 13:49
    oleibman synchronize #2088
  • 13:48
    oleibman synchronize #2088
  • 13:47
    oleibman synchronize #2088
  • 13:38
    oleibman commented #1767
  • 12:49

    MarkBaker on master

    fr locale - Add JOURS function … (compare)

  • 12:49
    MarkBaker closed #2089
  • 11:48

    MarkBaker on master

    Xlsx Writer Formula with Bool R… (compare)

  • 11:48
    MarkBaker closed #2087
  • 11:43
    MarkBaker commented #2088
  • 11:43
    MarkBaker commented #2088
  • 11:43
    MarkBaker commented #2088
  • 11:42
    beblaawy starred PHPOffice/PhpSpreadsheet
  • 10:44
    xandros15 synchronize #2049
  • 09:04
    rkyoku commented #1767
Mark Baker
@MarkBaker
#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
Adrien Crivelli
@PowerKiKi
Thank you for the clarification. I took the liberty to convert PR to draft to clarify their status for everybody.
On my part I'd like to work on PHPOffice/PhpSpreadsheet#1962 in the next few days...
Adrien Crivelli
@PowerKiKi
image.png

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 ?

Mark Baker
@MarkBaker
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
Mark Baker
@MarkBaker
He's also shown a lot of commitment over the last year, so I think he would be valuable as a member of the team
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
superhansi
@superhansi
@MarkBaker Mark, can you please take a short look at the request on embedding OLEObjects? Thanks
amit-dave
@amit-dave
PhpOffice\PhpSpreadsheet\Writer\Exception: No writer found for type 1 in file C:\xampp\htdocs\test\vendor\phpoffice\phpspreadsheet\src\PhpSpreadsheet\IOFactory.php on line 47 what the error when sending two parameter
Mark Baker
@MarkBaker
So what are you passing in as the second parameter?
hokching
@hokching

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
...(1).xlsx - original file exported from the extension
...(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
Mark Baker
@MarkBaker
@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
@arun-parhi
Can we merge two excel files into one using PHPSpreadsheet ? how?
Mark Baker
@MarkBaker
@arun-parhi This is documented here and there is an sample code demonstrating it in /samples/Basic/43_Merge_workbooks.php
Roberto Tremonti
@robertotremonti
Hi guys, is there a way to add a custom function to PhpSpreadsheet? I need to add a simple function that takes a string like "123,4567,8,9012,.." and returns min/max/avg/sum/count. Thanks for your help.
Mark Baker
@MarkBaker
@robertotremonti We don't yet support Office365 Lambdas, that's something I'm planning on looking at over the next quarter
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
Mark Baker
@MarkBaker
Forget that last; the problem with selected cells is in the Reader, not in the Writer
Mohsen Khalafi
@mohsenkhalafi
when i want to convert xls to pdf i saw this error "Uncaught Error: Class 'Dompdf\Dompdf'" not found.. .. what is problem?
Mark Baker
@MarkBaker
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
Mohsen Khalafi
@mohsenkhalafi
Tnx its solved.. now pdf file after convert lost style and charset.. what should I do??
Mark Baker
@MarkBaker
If you're losing styles, then it's most likely that you're setting readDataOnly to true when loading the file, which tells the Reader not to load style information, only the basic data in the spreadsheet
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
rahul garg
@rahulgargmzn_twitter
Hi Support team
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.
Mark Baker
@MarkBaker
@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
Gnomeslayer
@Gnomeslayer
Hello. I just downloaded the files and I want to know if there's a guide to using this? A 'getting started' guide would also do nicely. I am sorry if this question has been asked/answered before.
Gnomeslayer
@Gnomeslayer
Nevermind. Sorry. I didn't google hard enough. I managed to find a quick installation guide on youtube. Apparently I needed to use composer and not just download directly from github.
Brian Verschoore
@briavers

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)

Tom
@Lambik
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
Tom
@Lambik
apparently, in the Xlsx reader class, the $workbookBasename = $this->getWorkbookBaseName($zip);line (85) fails (returns empty string)
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
Tom
@Lambik
i changed the switch, and it does continue, but the public function load($pFilename)fails, because all xml properties are in the other namespace too
should i make a github issue for this?
i don't know what program the customer used to create this xlsx for me :(