1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
|
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<TITLE> [Open Office] Range impl. ...
</TITLE>
<LINK REL="Index" HREF="http://lists.ximian.com/pipermail/openoffice/2005-September/index.html" >
<LINK REL="made" HREF="mailto:openoffice%40lists.ximian.com?Subject=%5BOpen%20Office%5D%20Range%20impl.%20...&In-Reply-To=">
<META NAME="robots" CONTENT="index,nofollow">
<META http-equiv="Content-Type" content="text/html; charset=us-ascii">
<LINK REL="Previous" HREF="001145.html">
<LINK REL="Next" HREF="001148.html">
</HEAD>
<BODY BGCOLOR="#ffffff">
<H1>[Open Office] Range impl. ...</H1>
<B>michael meeks</B>
<A HREF="mailto:openoffice%40lists.ximian.com?Subject=%5BOpen%20Office%5D%20Range%20impl.%20...&In-Reply-To="
TITLE="[Open Office] Range impl. ...">michael.meeks at novell.com
</A><BR>
<I>Mon Sep 12 03:08:55 EDT 2005</I>
<P><UL>
<LI>Previous message: <A HREF="001145.html">[Open Office] go-oo mirroring
</A></li>
<LI>Next message: <A HREF="001148.html">[Open Office] Re: Range impl. ...
</A></li>
<LI> <B>Messages sorted by:</B>
<a href="date.html#1146">[ date ]</a>
<a href="thread.html#1146">[ thread ]</a>
<a href="subject.html#1146">[ subject ]</a>
<a href="author.html#1146">[ author ]</a>
</LI>
</UL>
<HR>
<!--beginarticle-->
<PRE>Hi there,
So - playing with the Range impl. it becomes increasingly clear to me
that we simply can't use (re-use) the existing OO.o XCellRange impl. for
this & our impl. needs a re-write.
A couple of reasons here:
+ bounds checking; ActiveSheet.Range("A1").Cells(5,7) is
valid in VBA - evaluating to a cell outside the 'Range':
1 cell A1.
+ relative ranges; it seems 'Cells(N, N)' generates a relative
range by default; thus:
Range offset = ActiveSheet.Cells(1,1)
ActiveSheet.Range("C5:Z20").Range(offset, Cells(3,3))
this just doesn't work - in this case the 'offset' should be
a relative reference (of the form 'A1') into C5:Z20 - but
instead we have some error. Also - clearly the XCellRange
object can't store/distinguish between $A$1 and A1.
So ... I guess we need to represent the range ourselves - preferably
using the internal sc/ representation, and resolve that to an XCellRange
as late as possible, when necessary - against the Sheet's range.
How does that sound ?
Thanks,
Michael.
--
<A HREF="http://lists.ximian.com/mailman/listinfo/openoffice">michael.meeks at novell.com</A> <><, Pseudo Engineer, itinerant idiot
</PRE>
<!--endarticle-->
<HR>
<P><UL>
<!--threads-->
<LI>Previous message: <A HREF="001145.html">[Open Office] go-oo mirroring
</A></li>
<LI>Next message: <A HREF="001148.html">[Open Office] Re: Range impl. ...
</A></li>
<LI> <B>Messages sorted by:</B>
<a href="date.html#1146">[ date ]</a>
<a href="thread.html#1146">[ thread ]</a>
<a href="subject.html#1146">[ subject ]</a>
<a href="author.html#1146">[ author ]</a>
</LI>
</UL>
<hr>
<a href="http://lists.ximian.com/mailman/listinfo/openoffice">More information about the Openoffice
mailing list</a><br>
</body></html>
|