Cmdlets for Smartsheet

Build 24.0.9060

HideFormattingCharacters Parameter (Connect-Smartsheet Cmdlet)

Set to True if you want to hide currency symbols and percentage signs in numeric values. This will also convert these columns from varchar to double. Only works if TypeDetectionScheme is set to RowScan and at least the first RowScanDepth values for that column are convertable to double.

Syntax

Connect-Smartsheet -HideFormattingCharacters SwitchParameter

Data Type

bool

Default Value

false

Remarks

Set to True if you want to hide currency symbols and percentage signs in numeric values. This will also convert these columns from varchar to double. Only works if TypeDetectionScheme is set to RowScan and at least the first RowScanDepth values for that column are convertable to double.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060