IBP Excel Add-In — IBPFormattingSheet artefacts / formatting of outdated cells w...
source link: https://answers.sap.com/questions/13636345/ibp-excel-add-in-ibpformattingsheet-artefacts-form.html
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
IBP Excel Add-In — IBPFormattingSheet artefacts / formatting of outdated cells without data
As you can see, in this Planning View, there is only 1 time period (column N). The formatting of the IBPFormattingSheet is applied correctly there.
However, seconds ago, the end-user had changed the Planning View to multiple periods (which were in columns N, O, P and beyond). Now, the end-user changed back to 1 time period (column N).
Unfortunately, now in columns O and P, the old formatting is still applied. How can we change the formatting of these cells automatically?
The same happens when you change the Planning View by adding more rows (typically Key Figures). After switching back to less rows, for example by filtering, the old formatting remains at the bottom, even though it is unnecessary and clutters the view.
How can the user or configuration restrict the formatting to only those cells which have a match of column and row, or how can we clean up these formatting artefacts of unused cells?
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK