sarettah

I am using phpExcel to write workbooks on the server.

I am having an issue with cell formatting. The cell formatting shows for a while but then disappears, then comes back.

Watching the behavior (and after reading a bit more about phpexcel) I am inclined to think it is a memory issue of some sort but I am not getting any errors thrown and the data is all good. Just the formatting is fucked.

Any insight is appreciated.

Thank you in advance.

bean-aid

My insight is that your cells are going from standard to $ sign format. You are likely copying cells over to below and it is not carrying over the format of those cells. Or... all your cells are defaulted at $ sign format and then when you copy non-$ format it doesn't carry over. The above 2 sentences say the same thing really.

I don't know shit though which is why I'm always looking for a competent programmer!

sarettah

Fixed that for you

Good try but I am not doing any copying of any kind. I am writing a raw spreadsheet. It is all coming from the same loop.


Thanks anyway ;p

.

bean-aid

So the loop is defaulting $. Pretty sure i am right...

sarettah

No, my friend, you are wrong on this one. You are missing what I am saying. Look at the image. All cell formatting starts disappearing near where I have the arrow pointing to the formatting is disappearing. The borders disappear, the formatting (bolding, number format, all) disappears.

It later comes back.

There is no default format. It is a programming object, you have to tell it what to do in a program. I am telling it to format this way, that way, the other way. At a certain point, it just stops listening.

I will do another test file and show you what it does with just borders but no actual number formatting. Eventually the borders just disappear. That will take a few minutes to create.

Thanks again.

bean-aid

Oh... i bet it is the number of rows allowed that breaks your table then. Did you manually fix the second one?

sarettah

Nope, I did not manually do anything except put the screenprints together.

Here is the same program but I have all number formatting turned off. I left bold and centering on and the borders on. The borders disappear further down the page then they were in the first image I put up.

bean-aid

I use excel all the time. Not php stuff... but i have a suspicion your table is breaking because of a set row, ir possibly column, default setting.

Carry on, someone else who knows much more should respond.

sarettah

Use of Excel doesn't really help on this one. I work in Excel and also write Excel in desktop apps using OLE and directly with Excel using VBA, so I am fairly well versed in Excel..

PhpExcel is a server object that allows you to write workbooks and spreadsheets on the server using open XML but it does not actually use Excel at all. It just writes the file.

https://phpexcel.codeplex.com/

sarettah

Well, changed it from writing Excel 2005 to writing Excel 2007 and it all works right.

So, it is a bug somewhere with PHPEXcel writing Excel 2005 format.

I can live with that ;p

bean-aid

Can i invoice you for my consultation time?

sarettah

Nah, I don't think you asked enough questions. ;p

.