Forums Home / Spread / Spread for WinForms
Posted by: patrik on 2 September 2018, 7:21 pm EST
patrik
Posted 2 September 2018, 7:21 pm EST
I use this for only Cut data and not formula, but it’s not working.
any idea why?
Dim im As FarPoint.Win.Spread.InputMap
im = FpSpread1.GetInputMap(FarPoint.Win.Spread.InputMapMode.WhenFocused)
im.Put(New FarPoint.Win.Spread.Keystroke(Keys.X, Keys.Control), FarPoint.Win.Spread.SpreadActions.ClipboardCutDataOnly)
grapecity
Posted 4 September 2018, 7:48 pm EST
Hi Patrik,
This looks like a default behavior. However we would further investigate it at our end and let you know our observations. The tracking id for this issue is 263584.
Thanks,
Deepak Sharma
reeva.dhingra
Posted 9 September 2018, 3:01 pm EST
Hello Patrik,
ClipboardCutDataOnly intend to clear cell value. And from v11, when the cell value is clear, the formula is clear too (because we cannot clear cell value if the formula existed).
Hope it clarifies.
Thanks,
Reeva
patrik
Posted 16 September 2018, 4:46 pm EST
Thanks Reeva
is there any work around?
This was working before, but I don’t want to use version 10
reeva.dhingra
Posted 18 September 2018, 2:33 pm EST
Hello,
As a workaround we have implemented CustomClipboardCutDataOnly that inherits ClipboardCutDataOnlyUndoAction.
When you run the project, select from cell A1 to C1, press Ctrl+X, values of cell A1, B1 will be lost, and “0” remains on C1. Double click on C1 and you’ll see the formulas of the cell is “SUM(A1,B1)”.
Enter any number in cell A1, B1 and you’ll see that value of C1 is changed - means formula is working correctly.
Please have a look at attached sample for more clarity.
Hope it helps.
Thanks,
Reeva
patrik
Posted 21 September 2018, 6:39 pm EST
Thanks this working perfect.
is it possible to do same with copy?
and that write only write value, not write formula.
patrik
Posted 26 September 2018, 1:23 pm EST
you know if it’s possible to do?
reeva.dhingra
Posted 27 September 2018, 6:16 pm EST
Hello,
Since, copy in Spread doesn’t change any data in Spread. Hence, you can use SpreadActions.ClipboardCopyValues as given in documentation link below:-
Hope it helps.
Thanks,
Reeva
patrik
Posted 27 September 2018, 8:36 pm EST
Thanks Reeva
Copy are working perfect now.
Cut is working to, but when I paste it’s remove the formula on the cell I paste on.
reeva.dhingra
Posted 30 September 2018, 6:19 pm EST
Hello,
This is by design that whenever a value is pasted on formula cell then the formula gets overridden by value.
Thanks,
Reeva
patrik
Posted 30 September 2018, 8:12 pm EST
When I use the Copy, it’s working. the formula are not gone.
reeva.dhingra
Posted 30 September 2018, 10:02 pm EST
Hello,
This is happening because Ctrl+ C have been set with SpreadActions.ClipboardCopyValues only.
Further if you still face any issue then please share your stripped out working sample along with exact cut/ copy /paste steps you are doing.
We will once again verify your exact steps at our end.
Thanks,
Reeva
reeva.dhingra
Posted 3 October 2018, 5:33 pm EST
Hello Patrik,
The workaround we shared first of all is to cut data only and not formula from the cells and since the same workaround is used hence, while pasting it is not pasting formula as formula has not been cut while doing Ctrl+X.
And in case you don’t want to paste just the value without formula then at first place cut formula as well and not just value i.e. don’t use the workaround. Doing this while pasting formula will be pasted.
Hope it clarifies.
Thanks,
Reeva
patrik
Posted 4 October 2018, 12:05 pm EST
The problem from begining was that it’s cut away the formula, it’s mean if I write some value in the cell that I first cut from it’s not calculate any more.
reeva.dhingra
Posted 4 October 2018, 5:24 pm EST
Hello Patrik,
There is a confusion between requirement gathering at our end. Hence, could you please share the exact use case once again collectively as in what exactly are you looking for with all the clipboard’s cut/ copy/ paste behavior collectively.
We request you to please let us know what all you want to cut/ copy and what all you want to paste.
Please confirm. We will look into the same thereon.
Thanks,
Reeva
reeva.dhingra
Posted 10 October 2018, 4:30 pm EST
Hello Patrik,
This is a generic behavior that whenever you paste anything on the cell containing formula then it would override the underlying formula in it.
I am not sure while pasting value on the cell containing formula why do you want to retain the formula( then at first you should not paste anything on cell containing formula)
Hence, please share your specific use case that why do you want such kind of behavior and in which scenario are you using it? It will help us to assist you further in better way accordingly.
Thanks,
Reeva
patrik
Posted 10 October 2018, 8:47 pm EST
I don’t know how to explane better, this was working before. I use spread for com before and it’s was working there to.
is there some way to exclude paste in column?
like in column 0 to 3 and 6 it’s paste.
but 4 to 5 it’s not paste.
patrik
Posted 16 October 2018, 12:11 am EST
Any new about this?
patrik
Posted 17 October 2018, 4:30 pm EST
Is there anymore details you need from me?
patrik
Posted 18 October 2018, 12:05 am EST
Thanks
reeva.dhingra
Posted 22 October 2018, 6:23 pm EST
Hello,
Our developers have confirmed that this is the current design, the same with excel.
If you want to implement your business logic then you could handle the clipboard event, such as clipboard changing, changed, pasting and pasted.
In the event, cache the original cell status, then write it back when pasted. Hence, you need to write your own code as per your business logic.
Thanks,
Reeva
patrik
Posted 23 October 2018, 3:50 pm EST
Hello
Do you mean that your customers should not have a subscription to your products because you never know if features that were previously will disappear?
So you recomend me to go back to Spread 10?
patrik
Posted 25 October 2018, 5:33 pm EST
This is a behavior of Spread that are changed, I don’t know how to do this.
I don’t want to go back to Spread 10, you can not help me?
reeva.dhingra
Posted 25 October 2018, 10:00 pm EST
Hello,
Apologies for the delayed response first of all. We have escalated your issue to the developer for further investigation.
Tracking id for your issue is #266392
We will get back to you as soon as we hear anything from them.
Thanks,
Reeva
reeva.dhingra
Posted 25 October 2018, 10:12 pm EST
Hello Patrik,
Can you please share a small sample using Spread version 10 wherein it was working fine at your end?
What code did you use? Please share a small sample so that we can investigate this issue further with our developers to provide you with a fix.
Thanks,
Reeva
reeva.dhingra
Posted 30 October 2018, 2:37 pm EST
Hello,
Our developers have confirmed that from v11, if you set value to a cell, which contains formula, its formula will be clear. That behavior is correct and its by design.
In v10 (and before), we allow changing value of formula cell but it isn’t correct behavior. As you can see, after the value is set, if formula is recalculated, the assigned value will be lost. Changing of v11 also make our spreadsheets compatible with Excel and other spreadsheet products. The change is listed as breaking changes in v11.
Hope it clarifies.
Regards,
Reeva
patrik
Posted 23 January 2019, 7:37 pm EST
If I understand you correct, you suggest me to go back to version 10.
there is no workaround for this in version 12?
reeva.dhingra
Posted 27 January 2019, 5:51 pm EST
Hello,
Unfortunately, we don’t have any workaround for the same in Spread V12. We regret the inconvenience.
However, we would still ask you to upgrade to latest version as any more bug fixes will be done in latest version only and also the newer version contains alot of new features and enhancements which will benefit you.
Thanks,
Reeva
patrik
Posted 27 January 2019, 9:23 pm EST
Thanks.
Then I know, I will return to version 10 on that software but go on with version 12 with never software.
reeva.dhingra
Posted 28 January 2019, 2:41 pm EST
Hello Patrik,
We have a good news on your issue.
As you know the behavior of v12 is by design. The core spreadsheet model does not support having both formula and value set at the same time for the cell now, like Excel.
Currently there is no workaround for this issue as well.
However, after discussing your issue with our developers they have confirmed that they could implement a new flag for LegacyBehaviors that handles this case differently wherein we could create a new flag KeepFormulaOnSetValue which causes any attempt to set a value to a cell that contains a formula to fail and instead raise the Error event.
This could be implemented in the upcoming service pack 1 release this May. Please let me know if this would help.
Thanks,
Reeva
