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:
- Open the attached spreadsheet in Xtraspreadsheet
- Cut and paste the values into Excel
- 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
Here is a sample of the rounding to the nearest 10M (in this case) and also shows how if a date column is too narrow and displays ######, this is carried across instead of the date. All points to the formatted data being copied (even if it is rubbish) rather than the underlying data. Not sure how it's getting rounded the way it is, though.
Hello Peter,
The ###### symbol range is rendered in SpreadsheetControl document cells when a cell content cannot fit into cell bounds in its entirety. The same behavior can be reproduced if you open your file in an MS Excel application.
To avoid it, simply apply the "BestFitColumn" operation to all columns in the document. I have attached a video to illustrate it.
Regarding the issue with rounding cell values after executing the "Cut" and "Paste" operations from the SpreadsheetControl document into an MS Excel document, I was not able to reproduce it.
Please see the attached video. Have I missed anything important? Would you please record a video to demonstrate how the problematic behavior can be reproduced on your side? You can use the free Jing tool from TechSmith to record this video.
I am looking forward to your response.
I think you've completely missed the point. In Excel, if a column display ####### because it is too narrow and you copy the value to another Excel spreadsheet, the value (ie. underlying date or whatever) is copied. When you copy from Xtraspreadsheet to Excel, the ####### chars are pasted into excel, not the underlying value. Similar things are happening with numbers. If you follow my steps exactly, do you not see this behaviour? Because I get it every time, as do others here.
Open your XtraSpreadsheet demo app (see screenshot); choose File, Open and open the CSV file I sent above. Without changing the formatting or column widths, select the data as shown in the screenshot and paste into Excel. You will see the behaviour I am describing. It also happens if you open the Excel file. I think it's a pretty nasty problem.
Hello Peter,
Thank you for your screenshot.
I successfully reproduced all the issues you described (pasting date time values, decimal values, large number values) while pasting the SpreadsheetControl content into an MS Excel application.
I passed this ticket to our developers for further research. Please bear with us. We will update the status of this ticket once we have found a way to fix these issues.
Thanks Oleg, much appreciated. Always impressed with your support, the best in the business!
You are welcome, Peter!
Do not hesitate to contact us in case of any issues. We are here to assist you at any time.
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.