Issue 78347 - Redline service for spreadsheet documents
Summary: Redline service for spreadsheet documents
Alias: None
Product: App Dev
Classification: Unclassified
Component: api (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: All All
: P3 Trivial
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2007-06-12 15:58 UTC by fmarboeuf
Modified: 2017-05-20 11:27 UTC (History)
4 users (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---

Very incomplete example for a possible notification implementation (8.61 KB, text/plain)
2007-06-14 11:48 UTC, niklas.nebel
no flags Details
Notification of cells filling (changing data) (2.58 KB, text/plain)
2007-07-01 23:04 UTC, fmarboeuf
no flags Details
Notification of copy/paste (1.25 KB, text/plain)
2007-07-13 09:43 UTC, fmarboeuf
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description fmarboeuf 2007-06-12 15:58:06 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...
Comment 1 jsc 2007-06-12 16:38:58 UTC
jsc -> nn: can you please comment this feature request
Comment 2 niklas.nebel 2007-06-14 11:48:38 UTC
Created attachment 45901 [details]
Very incomplete example for a possible notification implementation
Comment 3 niklas.nebel 2007-06-14 11:49:47 UTC
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
Comment 4 fmarboeuf 2007-06-14 19:38:01 UTC
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;
Comment 5 fmarboeuf 2007-06-28 21:33:23 UTC
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
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...
Comment 6 fmarboeuf 2007-07-01 23:04:24 UTC
Created attachment 46414 [details]
Notification of cells filling (changing data)
Comment 7 niklas.nebel 2007-07-12 18:59:38 UTC
I don't want to integrate this before it's complete, for all cell changes. So it
won't go into 2.3.
Comment 8 fmarboeuf 2007-07-13 09:43:16 UTC
Created attachment 46743 [details]
Notification of copy/paste
Comment 9 niklas.nebel 2007-12-04 18:11:39 UTC
retarget 2.x -> 3.x
Comment 10 Marcus 2017-05-20 11:27:49 UTC
Reset assigne to the default "".