Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
JustinDallas
Specialist III
Specialist III

QS: PandL formatting breaks mysteriously

Hello Folks,

I am on QS Nov 2019 P1 and I am using the PandL extension.  I have a dataset, whereby the Stylesheet formatting seems to not apply based on how many rows I have.

When I have half the dataset , ~25 rows, it behaves correctly as below.  It doesn't matter which 25 rows (top 25, bottom 25, middle 25) I have out of the dataset, it works as intended.

Correct-2020-20-01.png

 

However, when I have the entire dataset of 50 rows, the formatting gets messed up.  The top row is not bolded and the bottom footer text is not <white> and the background is not set to  #545554

.Incorrect-2020-20-01.png

The only thing I'm doing is deleting or undeleting rows from the source spreadsheet, so what could be causing the style to be applied or ignored?

 

Any help is greatly appreciated.

Labels (2)
1 Reply
JustinDallas
Specialist III
Specialist III
Author

While debugging, I find that the P&L behaves correctly when I issue a

ExecProfitAndLoss:
First 208 LOAD DISTINCT
"Exec P&L Heading",
ExecPLStart,
ExecPLEnd,
"Exec P&L Heading"&';'&
PLBold
AS [StyleSheet]

 

But exhibits the problem when I replace the 208 with 209.

 

ExecProfitAndLoss:
First 209 LOAD DISTINCT
"Exec P&L Heading",
ExecPLStart,
ExecPLEnd,
"Exec P&L Heading"&';'&
PLBold
AS [StyleSheet]