Number format and clipboard operation

Suite and Optimus Suite 5
#1

Hello,

I want to copy and paste float values into an excel/ openoffice/ libreoffice spreadsheet.

As you may know, you can use either “.” or “,” as a decimal separator in excel. However, I could find no mean to set the number format used in a clipboard operation (setNumberFormat influences the values display and is not used for clipboard operation, which is fine).

Don’t we need another method like setClipboardNumberFormat? Is there a workaround for this?

Thanks in advance for your help and comments.

#2

There is no setClipboardNumberFormat method. When grid export data to CSV format it get’s values which you pass from XML (or any other source) when you load the grid.