On 31.05.2011 07:34, Andrew Douglas Pitonyak wrote:
Tested on 3.3.0 en-US using the 64-bit Linux version on Fedora 15.
I use the following macro to find an existing number format, and I
create it if it does not exist. The problem is that
oDoc.getNumberFormats().queryKey(sFormat, aLocale, True) f
On 07.04.2011 22:43, Marc Santhoff wrote:
Can you explain why the intermediate step using Core Reflection is
necessary, please?
As Andrew wrote: The usual logic, where Introspection finds the methods
from all supported interfaces, requires XTypeProvider.
From those old times there is anothe
On 07.04.2011 15:48, Andrew Douglas Pitonyak wrote:
I had hoped it would be as easy as
CreateUnoService("com.sun.star.awt.PrinterServer")
Unfortunately, the returned object is not usable.
"Usable" is a relative term. You can always do something like this:
oServer = CreateUnoService("com.sun.
On 05.03.2011 01:06, Johnny Rosenberg wrote:
I just ran into a problem doing this. The problem is that I have ”fixed”
the sheet, so I am always able to see the first rows and the first
column, so the A column and the 4 first rows are always visible.
I always want A1 to be selected, keeping the s
On 04.03.2011 17:18, Johnny Rosenberg wrote:
Have been looking for it with Xray, but so far I didn't find anything
that I think does what I want.
What I want to do is to search for a cell. When I find it, I want it to
appear as the first row and the the first column. Let's say that I find
what I
Bernard Marcelly schrieb:
I am trying to attach a macro to the sheet events available in OOo 3.3
(by a right-click on the sheet tab).
With the OnSelect event, if the called macro displays a message you go
into an endless loop because, once the message appears, the slightest
move of the mouse
On 11/04/10 17:15, Scott Deerwester wrote:
I'm having trouble understanding how to get the formatted value of a date
cell. I'm using the PyUNO binding of the API, and trying to reformat a date
cell as -MM-DD. Here's (a somewhat slimmed down version of) the relevant
portion of the code, with v
On 11/02/10 20:12, Robert Plummer wrote:
My name is Robert Plummer, I've been working for some type to develop
jQuery.sheet, the web based spreadsheet and I'm looking to enhance the
functions supplied for users. The problem is that it takes a good amount of
time to research the math being used b
On 10/13/10 18:26, aladdin wrote:
oField.setPropertyValue("Function", com.sun.star.sheet.GeneralFunction.COUNT)
This source code works on 3.1 and 3.3 but not in 3.2.1, any tips ?
It's issue 109350. See
http://qa.openoffice.org/issues/show_bug.cgi?id=109350 for a description
how to make it ru
Pivithuru Wijegunawardana schrieb:
I want to insert a column and line chart (which is a chart type available in
the chart wizard) via a java code in Openoffice calc. Is it possible
directly inserting this type of a chart? I checked with api module for
charts and this type was not available. If t
On 09/14/10 17:28, Pivithuru Wijegunawardana wrote:
I want to display a histogram chart in Openoffice calc via a java code. I
have been able to get the chart, but I want to change the x axis values of
the chart (which is now 1,2,3 etc.) to values taken from a cellRange of the
same calc spreadsh
Pivithuru Wijegunawardana schrieb:
I have been trying to insert a chart to a calc spread sheet in java
language. I followed the steps in the developer's guide wiki
http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Charts/Creating_and_Adding_a_Chart_to_a_Spreadsheet
.
But I cannot se
On 07/25/10 22:05, Rudolf Huber wrote:
In calc I try to run to the following routine:
sCompany = "http://";
sFilter = "HTML (StarCalc)"
sOptions = ""
Table.LinkMode = com.sun.star.sheet.SheetLinkMode.NONE
Table.Link(sCompany, "", sFilter, sOptions, 1)
On 07/06/10 14:06, Peter Eberlein wrote:
XNumberFormatPreviewer seems only to work, if the XNumberFormatsSupplier
is attached to an (unused) XNumberFormatter, otherwise a
RuntimeException is thrown. Is this the intended behavior?
Yes, it's intended that way. It's not an unused XNumberFormatter,
On 06/11/10 00:08, Regina Henschel wrote:
please have a look at the Basic macro
sub ExamineService
dim oService
oService = CreateUnoService("com.sun.star.sheet.AddIn")
dim sProgrammaticName as String
sProgrammaticName = "getImtan"
dim sDisplayName as String
sDisplayName = oService.getDisplayFunc
On 06/09/10 16:02, Peter Eberlein wrote:
though xSheetCellRanges.getCount() gives the correct answer,
xEnumeration.hasMoreElements() is false:
XCellRangesQuery xCellRangesQuery = (XCellRangesQuery)
UnoRuntime.queryInterface(XCellRangesQuery.class,xRange);
XSheetCellRanges xSheetCellRanges =
Martin Dobiasch schrieb:
Yes, that seems clear for me.
But there is one problem I still have:
In the addin - how do I get access to the SpreadsheetDocument?
As Ariel wrote: If you know what you're doing, use the XPropertySet
parameter and queryInterface.
Niklas
-
Martin Dobiasch schrieb:
the addin won't modify the sheet. Just reed from it.
I only need read access
Reading is possible, but keep in mind that your formula won't be
recalculated if cells change that are not included as parameters.
Niklas
---
Ariel Constenla-Haile schrieb:
this looks as if you wanted to get a cell range as parameter, and in this cell
range write your result. This is possible, but IMHO is a NO-NO.
As you've been told on Tuesday, you can get a cell range as parameter to your
function, but it isn't " the area in which
On 05/20/10 07:46, Madhur Kashyap wrote:
I cross checked the options. I have not selected "Precision as shown"
option.
I found a strange Decimal places combo-box present right next to it which
has value 2 in it. What is this combo-box supposed to do ? Does this have to
do something with getValue
On 05/18/10 15:56, Madhur Kashyap wrote:
The getValue() function of a cell object returns the value with significant
digits which are visible in that cell. Is there a way to get the actual
value stored in the cell regardless of the significant digits consideration
?
Did you set the "Precision a
On 05/18/10 12:53, Martin Dobiasch wrote:
I want to write a function with a rangeaddress as parameter.
Is there a way to do this with java?
The function should be part of an extension. (Which is written in java)
The function does something like that:
Public Function CSDRangeAddress(arg As Range)
On 03/12/10 17:40, Bernard Marcelly wrote:
Now I can find if a cell uses DDE function. But retrieving the value of
its arguments is another matter, except in simple cases. Probably there
is no easy way to find which cells use a given DDE link.
If the formulas in your documents follow a simple
On 03/10/10 21:08, Bernard Marcelly wrote:
fp = ThisComponent.createInstance("com.sun.star.sheet.FormulaParser")
fp.FormulaConvention = com.sun.star.sheet.AddressConvention.XL_OOX
fp.ReferencePosition = c.CellAddress
ftseq = fp.parseFormula(c.Formula)
You can get the token sequence directly fro
On 02/01/10 04:19, Paries Luo wrote:
And the connection to openoffice.org was successful. And I had
written the catch to handle all the exception as below:
int DocTranscode::doConvert( int docIndex )
{
Reference ooStore (ooComponent, UNO_QUERY);
Sequence storeProps(1);
...
try{
ooStore->storeT
On 01/19/10 09:24, Ari Urkullu Villanueva wrote:
The first of this two, is that I don't know how to get the language
which Calc is using in the user interface
The UI locale can be read from the configuration as "ooLocale" under
"org.openoffice.Setup/L10N".
The second technical problem I hav
On 01/06/10 16:03, Peter Eberlein wrote:
the following snippet (I left out the callback functions for the
listeners) gives an error:
xSaxParser = CreateUnoListener("SaxParser","com.sun.star.xml.sax.XParser")
xDocumentHandler =
CreateUnoListener("DocHandler","com.sun.star.xml.sax.XDocumentHan
On 10/22/09 14:52, Steffen Boersig wrote:
Well,my problem is, that methods like String.equals() don't understand
that behaviour. Of course, in the GUI(at least while not looking at the
actual formula) it's shown correctly as a normal "5".
But if I'm calling cell.getFormula().equals("5") it's ret
On 10/22/09 12:57, Steffen Boersig wrote:
val[0][0] will be inserted as " '5 ", where as it should be inserted
just as "5" in my opinion.
Same with val[1][0]. It's inserted as " '5".
Is this a bug or is it working as inteded and it's just me not
understanding proper usage of this method?
The
On 10/14/09 11:05, Madhur Kashyap wrote:
I am writing a small application in OpenOffice calc using Basic programming.
There is a need to construct a list of valid strings based on current
settings in one cell and enable data validation of another cell using this
list of strings.
I am facing two
On 09/07/09 18:59, Johnny Rosenberg wrote:
2009/9/7 Steffen Grund :
I was just wondering: createCursor() creates a cursor containing the whole
sheet, which could be slow when you have a big sheet.
I guess it depends on how it is doing that. Maybe it is only setting a
bunch of pointers rather t
On 07/14/09 14:43, Gert Groenhoff wrote:
a user defined name of a cell range is unique on all sheets. but I can't
find a way to get this range from a different sheet. The only method I
know is getCellRangeByName(), but this works only with the correct
sheet. How can I get the range if I only kn
On 06/19/09 11:50, Johnny Rosenberg wrote:
I have a little follow up question to this:
When OpenOffice.org 3 arrived, some of my formulas stopped working,
because in some of my calculations a few empty cells were apart of it.
They told me that empty cells doesn't have the value 0 anymore, like
it
On 06/18/09 22:31, Johnny Rosenberg wrote:
So A should be the content of the cell A1 in this case. However, if A1
is empty, A ends up as a double with the value 0. This makes it quite
impossible to detect wether a cell is empty or not, doesn't it? At
least I can't find a way to do that.
To a Ba
On 06/18/09 08:18, Jan Holst Jensen wrote:
Whether it falls into that category really depends on how it behaves
:-). Are you suggesting adding shapes on top of the cells that I want
custom rendered - and then move the shapes whenever cells change so the
shapes follow the underlying data around
On 06/13/09 11:45, Jan Holst Jensen wrote:
I would like to be able to render cell content in an owner-draw fashion.
An intuitive way to control this for the end-user (or at least for me)
would be to add a new format to "Format Cells". I was thinking along the
lines of adding an item to "Number
On 06/10/09 11:28, Jan Holst Jensen wrote:
I am trying to work with ranges in Calc. However, I cannot figure out
how to instantiate a non-contiguous cell range from its address string.
The code below (result of AllRanges.AbsoluteName) may for example show
"$Sheet1.$C$3:$C$5;$Sheet1.$E$3:$E$4" i
On 06/06/09 08:49, Bart Aimar wrote:
I am only a normal user and often confused from issues... but te issue
101869 relate FIXED (Fixed in CWS "calc311fixes" (for 3.1.1) and
"calc50" (for 3.2) ).
Still I'm not expert about developper versions...
but I have installed OOo-dev 3.2.0 DEV300m49 (bui
On 06/05/09 11:39, Bart Aimar wrote:
The classic method "clearContents" seems not work properly in OO 3.1
under windows XP and W2k.
Here a simple test:
http://aimar.mrjive.it/node/61
It's caused by issue 101869, related to the document content (formulas),
not the clearContents API method i
On 05/26/09 16:20, Jeremy Trudel wrote:
Here is a snippet of my code:
XCellRange xRange =
(XCellRange)UnoRuntime.queryInterface(XCellRange.class, range);
Object[] array = new Object[1];
array[0] = xRange;
Object ret = xFunctionAc
On 04/19/09 23:17, Jan Holst Jensen wrote:
Did I miss something while creating the add-in or is this an actual bug
in OOo Calc import/export filters ? I badly need this or my end-users
won't be able to exchange sheets across OOo and Excel.
If you want to save to XLS, your add-in has to provide
On 04/18/09 17:51, Jan Holst Jensen wrote:
1) Is there a way that I can provide additional error information to be
shown in the status bar ? [The best option]
2) Should I fall back to defining all return types as "any" and then
return error message strings in case of errors ? [Ugly, but should w
On 02/20/09 11:01, arend harrewijne wrote:
I am a mechanical engineer, retired now, and use OpenOffice under Debian
Lenny. Sometimes I use an optimizationprogram I have used all my live when in
business, to find solutions in my technical work. It could handle all the
non-linear problems I have
On 10/ 9/08 05:14 PM, Johnny Rosenberg wrote:
Don't be… it seems like no one else has a solution neither… But I think that
DataArray structure is a bit odd, because if I create a combo box on a
spreadsheet, rather than in a dialogue, I can associate it directly with a
cell range of one column, ca
On 10/ 9/08 01:59 PM, Rudolf Huber wrote:
I can stop the routine and look at the actual value Hoch = Val(Hoch) and
get the correct result; it shows the
values after the comma (clicking at the field-Name "Hoch"); however, in
the table itself the values show after
the comma the value zero; I have
On 10/ 9/08 09:01 AM, Rudolf Huber wrote:
these are the the other statements:
Dim LokaleEinstellungen As New com.sun.star.lang.Locale
Dim ZahlenFormat As Object
Dim ZahlenFormatString As String
Dim ZahlenFormatID As Long
LokaleEinstellungen.Language = "de"
LokaleEinstellungen.
On 10/ 8/08 04:52 PM, Rudolf Huber wrote:
first of all I thank you for the prompt response. The ZahlenFormatID is
5107.
No, I mean the format code string that is shown in the Format/Cells
dialog. A key (ID) of 5107 is quite normal.
Niklas
---
On 10/ 8/08 03:04 PM, Rudolf Huber wrote:
I tried various options to get the correct declaration for NumberFormat in calc. The
LocalSetting.Language and Country is "de" for Germany.
In my table I get the value before the comma correctly, however, the after
comma values show zeros. Below, you se
On 08/14/08 16:47, Andreas Schneider wrote:
The first thing I though of, was to use the method specified here:
http://codesnippets.services.openoffice.org/Calc/Calc.CopySheet.snip
which selects all, then copies, then pastes. But since this fiddles
with the clipboard, I would really like to avoid
On 08/12/08 15:26, Ariel Constenla-Haile wrote:
Well... the display name will be converted to the fully qualified name
*only* if you *first* install the add-in; but here I'm suggesting *not*
to install anything in the current OOo installation, but use instead the
NB plug-in debugging feature th
On 07/26/08 06:05, Ariel Constenla-Haile wrote:
* create a Calc doc and add apply your function to some cell/s. The best
way is not to use the user interface name of the function ("DisplayName"
in the CalcAddIns.xcu) but to use the fully qualified service/impl. name
+ function name, for example
Jörg Schmidt wrote:
in a calc-document i need the names (display-names) of all existing
cellstyles.
i get a Error-message in a englisch OOo because .DisplayName is not
exist.
It's issue 85566.
Niklas
-
To unsubscribe, e-mail
Thomas Krumbein wrote:
Using print-areas for selected part of different sheets setting by basic
is still working, unfortunatly the new property "Print only selected
sheets" stopps the printing prozess, if set.
I cannot find this property to change by basic makro. Can someone give
me a hint?
b
Andreas Schneider wrote:
I have several problems integrating a Calc Addin and Addon to make them
work together.
1. I catch double clicks on spreadsheet cells. When certain criteria are
met, a dialog should be shown. That works more or less (see problem
number 2), but besides the dialog successf
Mikael De Bie wrote:
I'm using a XChartDataChangeEventListener to listen the changes of a
cell. But this cell depends on a lot of others, and it seems that not
all the OLE-objects are loaded. So, my listener doesn't work all the
time.
Cell formulas are no OLE objects. It's a matter of formulas
Jahn, Ray (R.) wrote:
This is a re-submission of a previous message in the [EMAIL PROTECTED] forum, as
suggested by Niklas Nebel. Niklas has kindly pointed out the issue
20044 in API.
http://sc.openoffice.org/servlets/BrowseList?list=dev&by=thread&from=178
2944
http://www.openoffice.or
Carles Pina i Estany wrote:
I have now a "problem": I have a Impress slide with a embedded
"Spreadsheet". I need to change some values from spreadsheet. How can I
get the spreadsheet model? Using ole2shape or which interface?
Use the "Model" property of OLE2Shape.
Niklas
-
Michael Jeier wrote:
Is it possible to find out in which row and column the freeze is set?
The method hasFrozenPanes() says only, whether there is a freeze or not,
but
I
would like to know where the freeze is. Thanks in advance!
Use getSplitColumn/getSplitRow from XViewSplitable. They will re
Michael Jeier wrote:
Thx for the answer, is it possible to copy the NamedRanges of a table too?
If you link with SheetLinkMode "NORMAL", the named ranges that are used
in formulas are copied (the same way as inserting a sheet from the UI).
If you want to copy other named ranges, you have to a
Michael Jeier wrote:
I tried the parameters "Name", "Index", "URL" and some more, but they
didn't
work.
I'm not sure, but could it be 3 parameters? The file, the position to
insert
and the
sheet which shoud be inserted. Is there maybe another solution to insert a
table into another sheet?
Th
Mathias Bauer wrote:
You can try to use the com.sun.star.awt.UserInputInteraction interface
that is available at the Controller object of a Calc document window.
The problem here might be that this interface only notifies that a mouse
click has happened anywhere inside the window, you still must
Stephan Wunderlich wrote:
Just a wild guess ... but when you switch to the print preview the
original view is disposed and since the listener you added to the view
isn't removed the office might crash.
Similar. The view is closed, this is notified to the API object, but not
checked later, so
Andrew Douglas Pitonyak wrote:
If the MoveSelectionDirection is set to 0 (Down) using the GUI and then
I use the macro to set the direction to 1 (Right), I must restart OOo to
see the change. Well, the macro sees the change if I run the macro a
second time. Is there a suitable method to convinc
Mikaël De Bie wrote:
Maybe you've read that I'm trying to use the java eclipse plugin to
create UNO component, but beside this, I'm also creating a calc addin in
c++. And I need some help :
I'm trying to integrate a way to create and solve contraints
satisfaction problems in a calc sheet. But
Mikaël De Bie wrote:
I'm writing a calc add-in. I've made a first function that returns an
OUString. I've also made a seond function that takes a Sequence<
Sequence < OUString >> object as argument and then return this object.
What I want to do is use the second function with an array of cells
Tobias Krais wrote:
XSheetCellCursor xSCC = xSpreadsheet.createCursor();
XPropertySet xSheetCursorProps = (XPropertySet)
UnoRuntime.queryInterface(XPropertySet.class, xSCC);
// Here I hang: the PropertyValue "PageStyleName" does not exist
// How can I get the page property to be able to c
Bart Aimar wrote:
To reset ONLY the backGroundColor I found:
... StyleFamilies.CellStyles.getByName(sStyle).PropertyToDefault ???
... StyleFamilies.CellStyles.getByName(sStyle).setPropertiesToDefault ???
Obviously I have problems about the parametres...
Any Help?
... setPropertyToDefault("Cel
Bart Aimar wrote:
I need to make full the screen (i.e. OO CAlc window) with a given range.
In other word, I need to zooming (with macro) in manner that a given
range fill the OO window.
Select the range in the view, and then set the property "ZoomType" to
"OPTIMAL":
oView.select(oRang
Laurent Godard wrote:
but this is rather strange :( i would have expected an api
(but that not simple if thinking 2D)
btw, as there were an UNO slot fordispatcher, i would guess there are
some solution already in the code so an api
If you do it yourself, you have better control over the handli
Laurent Godard wrote:
merging a cell range is quite easy
activeSheet = thiscomponent.currentController.activeSheet
range = activeSheet.getCellRangeByName("A3:B3")
range.merge(true)
btw, how can i merge also the datas of all merged cells so that they are
displayed in the merged cell (having A3
Johnny Andersson wrote:
Here are two lines from a macro I wrote to remove ' from cells in cell
ranges, for example if a cell formula is '20 my macro will convert it to
20.
Selection=ThisComponent.CurrentSelection
Data=Selection.getFormulaArray
I tested the macro and all seemed to work perfect
Alexandro Colorado wrote:
Is it possible to make a live spreadsheet, meaning that the content of
the cells are provided by a live XML feed from an APi. The idea is to
have stock charts/currency exchange/ and/or pricing of products directly
inserted into a Calc spreadsheet and users can add cal
Ennio-Sr wrote:
trying to read some .sxc files with OOo_2.0.1 Calc I found they are full
of _#VALUE_ errors, as a consequence of formulas implying numeric and
non-numeric cells. AAMOF these formulas work perfectly under old 1.1.4 Calc.
Can any of you confirm this is a _feature_ of the new Calc?
Ian Laurenson wrote:
I can not work out how to pass a range parameter that works across
sheets to a custom macro.
E.g. In a cell on a spreadsheet:
=FNMYCUSTOMFUNCTION(Sheet1.B41:Sheet6.C88)
That's not supported. You should separate the range into several
single-sheet range parameters.
Nikla
Paolo Mantovani wrote:
Unfortunately I would need to understand what kind of values can take this
property.
0 to search in formula text, 1 to search in formula results (both will
also find non-formula cell content), 2 to search in notes only.
This is needed for my "Dispatch2Api Recorder" pro
Volker Lenhardt wrote:
What is the way to delete the contents of a sheet cell? I combed the api
index, I tried Google, I used the macro recorder (...uno:Delete...), but
I find that I am too blind to see the direct way. Where in the api doc
can I find "uno:Delete"?
The macro recorder uses the Di
Martin Thoma wrote:
In the GUI, you can select some cells in calc, press DEL and then choose
"delete all" to remove everything from the selected cells.
How is this done using the API? I want to give a column and delete the
content of this completely without removing the whole column.
Okay, I
Rudolf Huber wrote:
I am trying to get the following routine with the functions HTTP and
Spreadsheet to run under OOo 1.1.4. Neither the HTML- nor the
CSV-filter-options function. When I look at the spreadsheet I see no link;
however, when I check the menue Edit-Sheet-Select the sheet names show
Douglas Staas wrote:
Or more to the point, how
can I determine a graphic's original aspect ratio?
Get the Graphic from the GraphicObjectShape (property "Graphic").
Depending on its type (pixel or vector), it has the content's size in
pixels or 1/100 mm (see service com.sun.star.graphic.Graphi
[EMAIL PROTECTED] wrote:
I tried freezing a pane by following code
// setActiveSheet
XSpreadsheetView xSpreadsheetView = (XSpreadsheetView)
UnoRuntime.queryInterface(XSpreadsheetView.class, xSpreadsheetController);
xSpreadsheetView.setActiveSheet(xSpreadsheet);
babar wrote:
I would like to know how to create a newblank sheet into an existing
spreadsheet document, I'm using basic language for now.
I've tried to use (and first understand ;) this :
http://codesnippets.services.openoffice.org/Calc/Calc.CopySheet.snip
Inserting a blank sheet is much easier tha
Stephan Wunderlich wrote:
I'd like to write a macro setting some of OOo's options (Menu
Tools->Options)
programatically. Can this be done?
most of the settings in this dialogue should be accessible through the
configuration api, you might want to take a look at the corresponding
developers guide
Tom Schindl wrote:
But where from does the GUI know? Is it hardcoded somewhere because when
switching the Format DropDown e.g. to A3 it automatically recalculates
the height and width.
The dialog actually has its own table.
Ok. Now summerized as a codesnippet:
http://codesnippets.services.openof
Tom Schindl wrote:
well flipping the orientation to IsLandscape = true is working more on
this later. Are there any predefined properties for the page-format?
There is an enum for paper formats
http://api.openoffice.org/docs/common/ref/com/sun/star/view/PaperFormat.html#A3
The VCL printer imple
Tom Schindl wrote:
I search the Developers Guide and the IDL-Docs but could find an answer
to my problem. Using the GUI I can set the Paper Format(e.g. to A3) and
Orientation of an Spreadsheet (e.g. to Landscape). I have not found yet
the functions needed to set these using the API. I only found
85 matches
Mail list logo
