Hidden columns issue

Hidden columns issue

Posted by: p.feenstra on 28 August 2021, 6:03 pm EST

• 

  p.feenstra

  • Post Options:
  • Link
    Copy

  Posted 28 August 2021, 6:03 pm EST

  After upgrading from v12 to v14 I discovered another (very annoying) problem.
  
  Several hidden columns in my application should be never visible, several other columns should, but only by command.
  
  Now everyone can drag a hidden column visible. I can think of a workaround by using an e.cancel but that does not work well. Also this would take several days to correct this behaviour.
  
  If this is done by design I expect to have an AllowColumDragVisible (or something like that) property but that doesn’t seem to be the case, so imho this is a (nasty) bug.

  Environment

  • Win 10
  • VS 2019 Framework 4.8

  Regards Piet

• 

  jitender.yadav

  

  • Post Options:
  • Link
    Copy

  Posted 30 August 2021, 6:23 pm EST

  Hi Piet,

  You would need to set the Resizable property of the column to false to prevent it from becoming visible due to user interaction.
  
  Please refer this forum post for more information:
  
  https://www.grapecity.com/forums/spread-winforms/hide-column

  Regards,
  
  Jitender

• 

  p.feenstra

  • Post Options:
  • Link
    Copy

  Posted 1 September 2021, 5:45 pm EST

  Hi Jitender,

  Compatible with Excel is nice but we are using Spread for a reason.
  
  A new property for preventing this behaviour is needed.
  
  Now v14 seems not to be completed yet (already posted 3 bugs on this forum) this is the right time to do it. It should be very easy to fix.
  
  I’m posting this because this breaking change also may cause embarrassment and quick fixes to other users. Hope they find out in time.

  Regards Piet

• 

  jitender.yadav

  

  • Post Options:
  • Link
    Copy

  Posted 1 September 2021, 10:32 pm EST

  Hi Piet,

  If you want to have the previous behavior for hidden columns, you can use the ResizeZeroIndicator property:

  fpSpread1.ResizeZeroIndicator = FarPoint.Win.Spread.ResizeZeroIndicator.Default;
  

  You will not need to use Resizable property for each column if you do this.

  For any other breaking change, you can check the LegacyBehavior property. It has several enum options to get back previous behavior.
  
  For example, you can also get back previous behavior for hidden column by using this:

  fpSpread1.LegacyBehaviors = FarPoint.Win.Spread.LegacyBehaviors.PropertyDefaults;
  

  This would change behavior for several other properties as well. If you only want previous behavior for hidden columns then you can use ResizeZeroIndicator property.

  Regards,
  
  Jitender

• 

  p.feenstra

  • Post Options:
  • Link
    Copy

  Posted 2 September 2021, 1:06 am EST

  Thank you very much Jitender,

  Looks promising, I will investigate.

  Regards Piet

• 

  p.feenstra

  • Post Options:
  • Link
    Copy

  Posted 3 September 2021, 1:53 am EST

  Your suggestions looked very promising but none of them worked, sorry.
  
  Do I have to write functions myself to solve this? I hope not.
  
  It still seems to be a bug (or at best a shortcoming)

  Regards Piet

• 

  jitender.yadav

  

  • Post Options:
  • Link
    Copy

  Posted 5 September 2021, 9:57 pm EST

  Hi Piet,

  I checked it again. I think you were referring to the fact that although the Resize Indicator is not visible when using ResizeZeroIndicator = Default, the column is still resizable.

  You’re right, this is a bug in Spread 14.
  
  We’re sorry for the inconvenience. This will be fixed in the next release of Spread [SPNET-20229].

  Regards,
  
  Jitender