Focal Point
Making the background white

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9017047016

October 06, 2011, 12:55 PM
Don Robison
Making the background white
Is there away to make the (background) for a excel spread sheet "White".


Version 7.17
October 06, 2011, 01:33 PM
njsden
You can only change the background colour of the cells where the reports sits but not that of the whole spreadsheet.

TABLE FILE CAR
PRINT COUNTRY AND CAR
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
TYPE=REPORT, BACKCOLOR=WHITE, $
ENDSTYLE
END




Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
October 06, 2011, 01:39 PM
prodrigu
So you do not want to show the gridlines? Is this correct?

What about creating an Excel Macro and adding the below code in the macro.

ActiveWindow.DisplayGridlines = False


Prod: WebFOCUS 7.7.03: Win 2008 & AIX hub/Servlet Mode; sub: AS/400 JDE; mostly Self Serve; DBs: Oracle, JDE, SQLServer; various output formats
October 06, 2011, 01:48 PM
Don Robison
I need the whole spreadsheet White.

I have never create a EXCEL Macro and would not know were to start.


Version 7.17