Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table Filter macro allows you to fit your large tables to your screen area, hide the unnecessary table columns and apply static or dynamic row numbering.

Table of Contents

Fitting table to the screen area

...

Info

Please note that Table Filter macro allows you to hide columns if you have a too wide table. Select one or multiple columns to hide in the table below.

Table Filter
defaultCustomer Status
hideColumnstrue
cell-width150
datepatternyy-mm-ddcolumnBank Account Number,Customer Status,Suspicious Transaction Activity
id14576973735631457700769494_-1877833121817234935
separatorPoint (.)
First NameLast NameContact PhonesLast Transaction DateBank Account NumberTransaction amountTax AmountTarget Transaction CityTarget Transaction CountryCustomer StatusSuspicious Transaction ActivityTotal Transaction Number
ReubenBarnett0500 00988812/14/14DO07819385109432271545550865$129.42$10.28GuápilesTunisiaBlockedYes8
McKenzieCleveland07624 78537309/15/14CH6046131558340157475$216.75$46.19SavannahUnited StatesBlockedYes1
PortiaLang(011247) 0442009/27/14EE967962637165872502$422.53$16.29MeerutCôte D'Ivoire (Ivory Coast)RejectedNo5
EaganMcgee07212 43049209/19/14MK83589588636375406$253.03$26.26OrangevilleAfghanistanApprovedNo2
RahimVelazquez0325 526 844012/31/14FO0682149824230550$454.06$27.73Lac-SerentGeorgiaApprovedYes6
RothHull0500 31184410/11/14LU056987267796106873$142.57$14.14LuziâniaSao Tome and PrincipeBlockedNo4
JackGriffin07624 30748809/04/14BA714509342088998370$146.60$34.55GeorgiaBahamasBlockedNo4
FaithNewton0800 111109/24/14LU521764205226552485$324.96$24.60OkigweSri LankaRejectedYes1
BasiaRay0346 983 834008/13/14TR280491289079508593611789$260.39$45.19ValcourtEquatorial GuineaRejectedYes4
LeandraDuncan0359 889 682201/11/15CR0942393063075420342$380.33$34.57MySwazilandRejectedNo6

...