Bug Report T312046
Visible to All Users

SpreadheetControl does not check the number of characters limit in a cell when the cell value is changed by SpreasheetControl API

created 9 years ago

Hello,

in my spreadsheet I load the data via a function. I have encountered a problem with extremely long strings (100 000 chars).
When I assign this text into a CellValue, the text is OK (DevExpress.Spreadsheet.CellValue.FromObject(text) ). But when the CellValue is assigned to the cell, the CellValue of the given cell is null.

Thanks for any help.

Comments (3)
DevExpress Support Team 9 years ago

    Hello Petr,

    According to Excel specifications, the total number of characters that a cell can contain is limited by 32,767 characters. If a cell contains a greater number of characters, the obtained file will be invalid and incorrectly processed by MS Excel. I guess, it would be better to check this condition in the SpreadsheetControl API as well. So, I've passed this ticket to my team. Our developers will research this issue in detail. We will get back to you once we have any results.

      OK, I understand that the size is limited. But Excel displays approximately the first 300 characters. Do you plan to add this functionality into your component or do I have to handle it myself?
      Thanks.

      DevExpress Support Team 9 years ago

        Our developers are considering ways of resolving this issue now. We will likely provide optional behavior: a SpreadsheetControl will raise an exception if a cell value exceeds the characters limit or cut the string to an appropriate value.

        Since a cell value is changed in code, it would be better to manage this situation in client code and provide custom logic to resolve this case according to your requirements.

        Answers approved by DevExpress Support

        created 9 years ago

        We have fixed the issue described in this ticket and will include the fix in our next maintenance update. To apply this solution before the official update, request a hotfix by clicking the corresponding link for product versions you require.

        Note: Hotfixes may be unavailable for beta versions and updates that are about to be released.

          Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

          Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.