All cells black after moving to new web server

All cells black after moving to new web server

Posted by: andrew.wilkowski on 21 August 2018, 6:44 am EST

• 

  andrew.wilkowski

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 21 August 2018, 6:44 am EST

  Hello,

  We upgraded our production web server and now all of the cells in our sheets are rendering as black unless we specifically modify the cell’s color in code. Previously, the control used the colors from the template XLSX file. In our template, we mostly have grey or “no fill” and those show up black. If I change the color to red or something, that seems to work. Changing it back to grey shows black again.

  Any ideas about what is missing or how to fix this without coloring every cell individually?

  Andrew

  OLD: Windows Server 2008 R2, Excel 2010, Spread 9
  
  NEW: Windows Server 2016, Excel 2013, Spread 9

  We see the black cells whether we deploy an old version with Spread 9 or a new one with Spread 11.

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 21 August 2018, 6:03 pm EST

  Hello Andrew,

  We would like to have to debug your code at our end as we are not sure what could be the cause of the issue.

  Hence, please share your stripped out working sample replicating the issue so that we can investigate this issue here.

  Thanks,
  
  Reeva

• 

  andrew.wilkowski

  • Post Options:
  • Link
    Copy

  Posted 23 August 2018, 2:35 am EST

  It seems like some colors we were using in Excel no longer show in the Spread control. When we pick the first grey color from Theme Colors, it renders as black in Spread11. When we go in Excel to More Colors and pick the lightest standard grey, it renders correctly in Spread11. I’m not sure why one color works and the other does not, but we seem to have circumvented the problem by changing the colors in our templates.

  THIS WORKS

  Hex: C0C0c0 (192-192-192)
  
  HSV: 0-0-75
  
  Alpha 255

  THIS DOES NOT WORK ( renders as black )

  Hex: BFBFBF (191-191-191)
  
  HSV: 0-0-74
  
  Alpha 255

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 27 August 2018, 5:27 pm EST

  Hello,

  We are glad to know that you have find a workaround for your issue. However, we aren’t sure of the reason of the same.

  Tracking id for your issue is #262906

  Hence, we have contacted our development team to look into the same and share some insight.

  Thanks,
  
  Reeva

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 27 August 2018, 10:17 pm EST

  Hello,

  Our developers checked and can’t reproduce this issue using the below mentioned testing environment:-

  • Win Server 2016 x64 Standard English
  • Office Pro Plus 2013
  • Both SpreadASP V9E and V11E
  • Import xlsx file Book1.xlsx (attachment) and result as below picture
  • Test local site with client (Win10 English, Edge browser):
    • http://vn-2016eng/V9e/
    • http://vn-2016eng/V11e/

  Could you please take a look and if possible please share some more detail information like?

  • Windows Server 2016 is x86 or x64?
  • OS language?
  • Excel 2013: is x86 or x64?

  • language
  • product version

  Please confirm the same. We will look into this issue thereon.

  Thanks,
  
  Reeva
  
  Exce&Screenshot.zip