Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
215
losing values pasting from Excel into webgrid...
posted

Hello,

I am pasting a single row of data from an excel file into a webgrid... the column count matches exactly.

The spreasheet was exported from the same page that had data on it. I then load the page up fresh with but for some reason, and I keep losing my first two row values. What could be the cause of this? Here are the two ultragridcolumns as specified at design-time.

 

<

 

igtbl:UltraGridColumn AllowResize="Free" AllowNull="False" AllowUpdate="Yes" BaseColumnName="manager_short_name" HeaderClickAction="SortSingle" IsBound="True" Key="manager_short_name">
<Header Caption="Manager" ClickAction="SortSingle">
<RowLayoutColumnInfo OriginX="5" />
</Header>
<Footer>
<RowLayoutColumnInfo OriginX="5" />
</Footer>
</igtbl:UltraGridColumn>

 

 

 

 

<igtbl:UltraGridColumn AllowNull="False" AllowResize="Free" AllowUpdate="Yes" BaseColumnName="Account #" HeaderClickAction="SortSingle" IsBound="True" Key="Account #">
<Header Caption="Account #" ClickAction="SortSingle">
<RowLayoutColumnInfo OriginX="6" />
</Header>
<Footer>
<RowLayoutColumnInfo OriginX="6" />
</Footer>
</igtbl:UltraGridColumn> 

I have about 5 hidden columns (also declared at runtime) in front of those two columns...

any ideas?