PHPExcel comment in black


We have been using PHPexcel for a while to fill in some tables from the Database, it has been running for months but lately when writing a comment and modifying the Excel the comment box appears black ...

There has been no change of code whatsoever, which leads me to think that it could be an Office update (we use office 365), has someone else happened to you or do you have any idea what it could be? Thanks!

If I select the text and change the color it appears, so I think it might be changing the background of the comment.

asked by PriNcee 28.10.2016 в 08:42

2 answers


Apparently it was due to a bad configuration in Windows, probably due to some update.

The solution has been:

  • Right click on the desktop
  • Customize
  • Window color
  • Advanced appearance settings
  • In Element dropdown look for "Information on tools" and on the right the Color 1 should be in the white-beige color, if you get black change it since that is what is causing the problem.
  • answered by 21.11.2016 / 17:21

    The only thing I can think of is that you have a problem with a "comment counter" and that counter has exceeded the maximum number allowed by the variable type.
    In Excel
    The maximum Byte is 255
    The maximum Integer is 32767
    The maximum Long is 2,147,483,647
    I do not know if it will have something to do, but it reminds me of a problem I had in a forum that I managed, since the comments stopped appearing and that's why the counter was declared as int and we exceeded 2.147.483.647

    I hope it helps, greetings.

    answered by 28.10.2016 в 08:56