<div>
You have to look at the api documentation, use the x-ray tool (<a href="http://wiki.services.openoffice.org/wiki/Extensions_development_basic#X-Ray_tool" rel="ugc">http://wiki.services.openoffice.org/wiki/Extensions_development_basic#X-Ray_tool</a>) or MRI tool (<a href="http://extensions.services.openoffice.org/project/MRI" rel="ugc">http://extensions.services.openoffice.org/project/MRI</a>). &nbsp;getCellRangeByName returns a cell range. The properties for a cell range can be found at <a href="http://api.openoffice.org/docs/common/ref/com/sun/star/table/CellProperties.html" rel="ugc">http://api.openoffice.org/docs/common/ref/com/sun/star/table/CellProperties.html</a>. &nbsp;<br />
<br />
-Bear
</div>


You have to look at the api documentation, use the x-ray tool (http://wiki.services.openoffice.org/wiki/Extensions_development_basic#X-Ray_tool [http://wiki.services.openoffice.org/wiki/Extensions_development_basic#X-Ray_tool]) or MRI tool (http://extensions.services.openoffice.org/project/MRI [http://extensions.services.openoffice.org/project/MRI]).  getCellRangeByName returns a cell range. The properties for a cell range can be found at http://api.openoffice.org/docs/common/ref/com/sun/star/table/CellProperties.html [http://api.openoffice.org/docs/common/ref/com/sun/star/table/CellProperties.html].  

-Bear

<div>
Hi Bear,<br />
I'm not sure I understand the first two links, and the third seems broken.<br />
<br />
Could you give me some additional information on how to use the X-Ray tool?<br />
<br />
Thanks.<br />

</div>


Hi Bear,
I'm not sure I understand the first two links, and the third seems broken.

Could you give me some additional information on how to use the X-Ray tool?

Thanks.


<div>
... not sure what happened but the third link is fine now.<br />
<br />
I'm looking through it.<br />
<br />
Thanks!<br />

</div>


... not sure what happened but the third link is fine now.

I'm looking through it.

Thanks!


<div>
<div class="content wysiwyg-content">
I can put this:<br />
firstSheet.getCellRangeByN<wbr />ame(&quot;A1&quot;).<wbr />String = &quot;FirstCell&quot;<br />
<br />
What other parameters can I use besides .String<br />
<br />
I've searched around and I can't find any documentation on it.<br />
<br />
Thanks!
</div>
</div>


I can put this:
firstSheet.getCellRangeByName("A1").String = "FirstCell"

What other parameters can I use besides .String

I've searched around and I can't find any documentation on it.

Thanks!

getCellRangeByName Parameters

LibreOffice is a free and open source office suite. The LibreOffice suite comprises programs for word processing, the creation and editing of spreadsheets, slideshows, diagrams and drawings, working with databases, and composing mathematical formulae. It is available in 110 languages. LibreOffice uses the international ISO/IEC standard OpenDocument file format as its native format to save documents for all of its applications. LibreOffice is also compatible with other major office suites through a variety of import/export filters. LibreOffice is available for a variety of computing platforms, including Windows, OS X) and Linux.