Bug Report T247549
Visible to All Users

Cell values are incorrectly pasted from a SpreadsheetControl document into an MS Excel document (date time values, decimal number values, large number values)

created 10 years ago

Hi -

We are getting some strange results if people cut-and-paste from out application (ie. out of the Xtraspreadsheet control) pasting into Excel: big numbers are rounded to the neares whole numbers.  I also have screenshots (included) from a user of numbers being rounded to the nearest million(!) but am still trying to reporoduce that.

To reproduce the decimal issue:

  1. Open the attached spreadsheet in Xtraspreadsheet
  2. Cut and paste the values into Excel
  3. AFTER cut-and-paste, format both sheets as numbers with 4 dec places.

You will see that the numbers in Excel have dripped their decimal places.

Since it does not happen if you cut and paste AFTER formatting, I assume it has something to do with that.

We could pre-format the spreadsheet, but many of the files we present to the users in Xtraspreadsheet are CSV files, and the same problem occurs there.  Obviously we can't format those.

Thanks,
Peter

Show previous comments (5)

    Thanks Oleg, much appreciated.  Always impressed with your support, the best in the business!

    DevExpress Support Team 10 years ago

      You are welcome, Peter!
      Do not hesitate to contact us in case of any issues. We are here to assist you at any time.

      DevExpress Support Team 10 years ago

        Peter,
        As a temporary workaround for this issue (until we are searching for a solution to it), you can paste values into an MS Excel application in any other format than HTML. For example, in the CSV format.
        I recorded a video to illustrate it.

        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.