Forum Discussion

jordielane's avatar
jordielane
New Contributor III
3 years ago
Solved

Cube View Formatting

Does anyone know how to format the object lookup cell in the cubeview? We currently have formatting on the cube view as follows.    If(IsRowNumberEven = True) Then BackgroundColor = #FFFFFFFF...
Cube View
  • JackLacava's avatar
    JackLacava
    3 years ago
    BackgroundColor = #FFFFFFFF
if RowName <> '' then 

	If(IsRowNumberEven = True) then
	   BackgroundColor = #FFFFFFFF, 
	   ExcelBackgroundColor = #FFFFFFFF,
	Else
	   BackgroundColor = #FFCFF0FC, 
	   ExcelBackgroundColor = #FFCFF0FC,
	End If

	If (RowName contains 'NoZebra') or (IsColHeader = true) then
	   BackgroundColor = #FFFFFFFF, 
	   ExcelBackgroundColor = #FFFFFFFF, 
	end if

end if

     

NicolasArgente's avatar
NicolasArgente
Valued Contributor
3 years ago

Hey!
You can not change that. Onestream considers that the first row is actually the header. That means that odd are always the line with the headers. 
Do you think you could use  IsRowNumberEven = True instead?

jordielane's avatar
jordielane
New Contributor III
3 years ago

Yes, we have it switched in other reports but in a few of our reports we need the first row of data to be white so all the odd rows need to be blue. I was hoping there was a way to directly reference that cell to format it, but it seems there isn't.