Posted 8 September 2017, 2:51 pm EST
I have defined a cell type as NumberCellType as follows:
Dim nbrCT As FarPoint.Win.Spread.CellType.NumberCellType = New FarPoint.Win.Spread.CellType.NumberCellType
nbrCT.DecimalPlaces = 0
For some reason the user wants all the numbers to be left justified. I want it to remain a number cell for editing purposes. I tried using:
<span class="Apple-tab-span" style="white-space:pre;"> </span>fpsProperties.ActiveSheet.Columns(grdGlobalChgCol).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left
to set the column to left justified, but it seems to just ignore the setting. Any ideas on what I'm doing wrong? Is it possible to do this? Am I doing something wrong?