hello guys , i'm new at phpexcel, i have a question, is there any possible way to use phpspreadsheet without using composer?, because i'm using shared hosting right now, thanks before
@panjidia995 no, there is no way. But you can use composer locally and upload everything, including ./vendor to your host
oh thanks @PowerKiKi , i got it, that means i can search for package that needed and add it manually?
no, it means you do everything locally, by using composer the normal way. And when everything is done, you zip the entire project and upload everything to your host
@PowerKiKi oh i'm sorry i didn't got it before, but thanks saving my day it work
Hi all! I have a problem with updating cell reference in another worksheet after adding columns and rows
Example: Sheet AAA : cell D4, Sheet BBB: cell A! with value AAA!D4 . After adding rows and columns in sheet AAA i would like that in sheet BBB the reference of D4 to change to the current location. So after adding rows and columns in AAA sheet, the cell moves from D4 to E6, but in sheet BBB it still remains D4. Could you help please?
@andreipreotu so the formula using cells from another sheet is not correctly updated when columns/rows are inserted into that sheet ? This might be a bug. I believe PHPExcel should update formula in this case, at least for formulas on the same sheet. Maybe you could check for that first. Does it work on the same sheet ? and if yes, why doesn't it on a different sheet ?
@PowerKiKi the formula is updating for the same sheet. It's not updated when it refers to other sheets ex: =Sheet1!C5
@andreipreotu can you reproduce all of that with PhpSpreadsheet also ?
PHPExcel has never adjusted formulae on other sheets when inserting/deleting rows/columns in one sheet because it's a big performance overhead. Unlike MS Excel itself which uses a reference map to link all formulae referencing a cell making it easy to identify which cells need updating, we can't afford the memory that requires; so we use a brute force approach checking every cell... to keep execution times as low as possible, we made a decision to only apply that brute force check to the current worksheet
I need help！
Paulo Victor Leite Lima Gomes
Hi @Rianley what do you need?
Daniel Hernán Vargas Osorio
Hi, any there?
@danvaros, and everyone else in the future, you better ask your questions right away, instead of waiting for someone to say hi. That way you'll save both our time
@jb181991 oh, I just realized I am talking about the wrong project. But docs and samples for PhpSpreadsheet are very similar to PHPExcel. And anyway if you are starting now, you better go with PhpSpreadsheet instead of PHPExcel