Infragistics Home

Infragistics Forums

Infragistics community online discussions.
Welcome to Infragistics Forums Sign in | FAQ
in Search

Column not within excel format limits

Last post 07-16-2008 9:22 by derfsplat. 4 replies.
Page 1 of 1 (5 items)
Sort Posts: Previous Next
  • 06-30-2008 12:55

    Column not within excel format limits

     Hi, I have a customer who is receiving the following error when attemping to export some records to excel:

     "column address is not within excel format limits
    Paramter name: column
    Actual value was:1968"

     The last number appears to be chagning slightly with each export attempt (I could be wrong here, it may have to do with a sort value where the record ends up in a new position every time or maybe there were slightly different paramters for the search results they're exporting). There is a column in the datasource named "address", it's only about 50~100 chars at its max.

     What are the excel format limits? (Suggestion: enhance this error message!)

    What should i be looking for?  (Data length, invalid chars, etc.)

    I am using v2007 vol2 with all sp's.

    Thanks!

    • Post Points: 5
  • 07-01-2008 12:38 In reply to

    Re: Column not within excel format limits

     Does anyone have any insight on this?  Do I need to supply more information??

    • Post Points: 5
  • 07-07-2008 8:39 In reply to

    Re: Column not within excel format limits

     It's been a week, does anyone have any suggestion on this problem?  Should I submit this somewhere else?  Please help!

    • Post Points: 5
  • 07-09-2008 11:50 In reply to

    Re: Column not within excel format limits

     

     Interesting update- if you group by a column (any column even if the grouping only results in one group) then everything works fine and you just ahve to expand that group in Excel.

     

    ..I'd really appreciate some sort of - ANY- response to this- does anyone have any idea abotu what I'm refering ot here??!! It's been a week and a half....
    • Post Points: 5
  • 07-16-2008 9:22 In reply to

    Re: Column not within excel format limits

     So in case anyone runs into the same problem I did here's the solution:

     In an attempt to fix/diagnose another problem (the grid wasn't exporting value list string values and if a filter was set, all the rows would get exported regardless of the filter), I used an overload of the Export Method.  It was my mistake; I misread the overload as (workbook, grid, start row, end row) when it is in fact (workbook, grid, start row, start column).

    I understand now what went wrong but in evaluating that error it's very ambiguous and confusing especially when my result set contains a column called "address"!  Suggestion: reword the error to read (at least!) somethign like "Column index is out of range of valid values."

     I will admit that in the end the error was of my own idiocy, but that being said I'm quite disappointed in the lack of any sort of response- nevermind help- with my post.  You have a fabulous product and I can't begin to explain how pleased I am with the stability and features your controls provide- they stand head and shoulders above any of your competition.  I, however, would have appreciated some-any sort of direction here even if it was to say "we can't help you here, please call this 800 number for x$/hr phone support"- I would have gladly paid to figure out my issue, but instead I got no response and (admittedly through my own doing with respect to the code) my customer ended up suffering- which I believe is the one thing we all should be working together to prevent.

     </rant>  Thanks for your time,

    Fred.

    • Post Points: 5
Page 1 of 1 (5 items)
Powered by Community Server (Commercial Edition), by Telligent Systems