Apache OpenOffice (AOO) Bugzilla – Issue 78347
Redline service for spreadsheet documents
Last modified: 2017-05-20 11:27:49 UTC
I'm currently working on java/swing desktop applications which embed calc as a data grid editor. The weakness of this solution is that i can't efficiently detect data changes on spreadsheet, as there is no real solution to do it with spreadsheet documents. I tried to do it first using XModifyListener/XModifyBroadcaster, then using XChartDataChangeEventListener/XChartData (which goal is to be used with charts...) but it isn't efficient and safe. So looking at the IDL Reference & Developer's Guide, I saw that the all-in-one solution exists for text documents (chap 8.3.11 Redline), by the use of XRedlinesSupplier' interface. So my question is : will this solution be provided for spreadsheet docs too? As Redline recording function is also available in Calc, the hope is allowed...
jsc -> nn: can you please comment this feature request
Created attachment 45901 [details] Very incomplete example for a possible notification implementation
I attached an incomplete example of how XChangesNotifier might be implemented. The calls to this would have to be inserted to all the different user action implementations.
Thanks! YES this could be THE solution! Just a little remark : in ScModelObj::NotifyChanges method, Element and ReplacedElement "points" to the same cell or cellrange object. Is their goal to provide element's state before and after the change occurs (see below)? + rChange.Element <<= xRangeObj; + rChange.ReplacedElement <<= xRangeObj;
I've successfully tested your solution by building my own "fork" (for the first time, and under Windows (as my company uses it) => ouch! thanks god i succeeded!) I confirm that the example is incomplete, as it only notify changes occured after a cell validation (ENTER typed), whereas data modification (which is my interest) can also occur after a Copy/Paste, or a fill series (i will stop at these actions)... If someone has an idea for resolving this, could he put a supplement to this example? I took advantage of this successful test by setting the target milestone to 2.3. I think it's a great enhancement for those interested in using calc as an editor in their application. And it doesn't slow down Calc... THANKS AGAIN!!!!
Created attachment 46414 [details] Notification of cells filling (changing data)
I don't want to integrate this before it's complete, for all cell changes. So it won't go into 2.3.
Created attachment 46743 [details] Notification of copy/paste
retarget 2.x -> 3.x
Reset assigne to the default "issues@openoffice.apache.org".