How to check scrollbar position for Table and CrossTable Plots in Spotfire® using IronPython scripting

Introduction

This article allows you to check what visualizations do not have their Scrollbar position set to their default value (Zero)

Code sample

# Copyright © 2017. TIBCO Software Inc.  Licensed under TIBCO BSD-style license.

from Spotfire.Dxp.Application.Visuals import *
from Spotfire.Dxp.Application.Visuals import VisualTypeIdentifiers, VisualContent

def checkScrollbarsPosition():
	# Check scroll bar positions			
	for p in Document.Pages:
		for vis in p.Visuals:
			if vis.TypeId.Name == 'Spotfire.Table' or vis.TypeId.Name == 'Spotfire.CrossTable' : 
				vc = vis.As[VisualContent]()
				layout = vc.CreateLayout()
				print layout.ScrollPosition.X
				print layout.ScrollPosition.Y 
				if layout.ScrollPosition.X != 0 or layout.ScrollPosition.Y != 0:
					print 'Warning: The scroll bars for "' + vc.Title + '" on the page "' + p.Title + '" are not in the correct position.'
					
	print 'Completed checkScrollbarsPosition()'

checkScrollbarsPosition()

References

• API Reference: Spotfire Analyst
• API Reference: TableLayout.ScrollPosition Property

License:  TIBCO BSD-Style License