In my iGrid I have part numbers that follow a pretty consistent format. AAA BBB CCCCCCCCCC DDDD. I could not get autowrap function to act properly it would not properly format the string for autowrap, it 100% of the time fits with this format
AAA BBB
CCCCCCCCCC
DDDD
but with autowrap it was always trying to do something crazy like this:
AAA
BBB CCCCCCCCC
CC DDDD
So to fix this i am parsing out the string and "injecting" \n at the exact places i want the 3 line string formatted. This works perfectly in the iGrid display.
HOWEVER ....
AutoFilter doesn't like it one bit. If I have 4 part numbers (first dimension is different for each)
LKS WHT .250x54x96 XXYY
LKS WHT .354x54x96 XXYY
LKS WHT .500x54x96 XXYY
LKS WHT .750x54x96 XXYY
Then iGAutoFilter only always shows this (I know why, its because I have injected the /n after this part of the string)
LKS WWHT
LKS WWHT
LKS WWHT
LKS WWHT
Now what's crazy is that the filter is actually working. If I know that the 3rd value is .500 and choose that one, the filter does work properly, its just the display is tripping off of the /n for the IGAutoFilter dropdown display.
I have tried literally everything to keep my string formatting in place but get the display for the AutoFilter to match the actual value and have had zero luck.
Can you provide any pointers or code suggestions on how to get this to work? I'm hoping its simple i'm just being obtuse and can't find it.
Or is there a different escape character that I can use to force multiline/wordwrap and tell it where to line break without messing with IGAutoFilter?
Thank you!