RE: [dev] Runtime error for DocumentLoader

2009-08-12 Thread Wei Min Teo

I think i missed out some stuff that i've tried to troubleshoot. Hope this 
helps in understanding my problem. Thanks.
Reference  XComponent  xComponent = 
xComponentLoader-loadComponentFromURL(sAbsoluteDocUrl, OUString( 
RTL_CONSTASCII_STRINGPARAM(_blank),0,Sequence 
::com::sun::star:beans::PropertyValue);

I've stepped in and the code seems to return fine from OUString. I suspect 
either a Sequence structure cannot be instantiated or some error with 
loadComponentFromURL. I tried a try/catch block and it doesn't seem to throw an 
exception as well. 

 From: shaun...@hotmail.com
 To: dev@openoffice.org
 Date: Wed, 12 Aug 2009 13:52:10 +0800
 Subject: [dev] Runtime error for DocumentLoader
 
 
 
 Hi,
 I've only recently managed to get the sdk to be configured to the VS2008 
 environment. I tried to get the document loader example to work but it 
 returns the following error:
 Unhandled expcetion at 0x00b8.. Access violation reading 
 location..
 at this line of code:Reference  XComponent  xComponent = 
 xComponentLoader-loadComponentFromURL(.);
 Nothing happens in the program, but i think an instance of the component is 
 created because it has an address. However, no interface pops out or 
 anything. Or does that only happen when i loadcomponent? Or am i passing 
 argv[1] wrongly?
 How do i resolve this? Thanks.
 Cheers,
 Wei Min
 
 
 
 
 
 Previously, I had the following runtime errors:
 Error: cannot establish a connection using 'uno:socket,host=localhost, 
 post2083;urp;StarOffice.ServiceManager'   Connector : couldn't connect to 
 socket WSANOTINITIALISED, WSAStartup() has not been called
 Resolved by:
 WSADATA wsaData;WSAStartup(MAKEWORD(2,2), wsaData);
 Error: cannot establish a connection using 'uno:socket,host=localhost, 
 post2083;urp;StarOffice.ServiceManager'   Connector : couldn't connect to 
 socket WSACONNREFUSED, Connection refused
 Resolved by:
 soffice -accept=socket,host=localhost,port=2083;urp;
 
 _
 More than messages–check out the rest of the Windows Live™.
 http://www.microsoft.com/windows/windowslive/

_
What can you do with the new Windows Live? Find out
http://www.microsoft.com/windows/windowslive/default.aspx

Re: [dev] Runtime error for DocumentLoader

2009-08-12 Thread Stephan Bergmann

On 08/12/09 07:52, Wei Min Teo wrote:

I've only recently managed to get the sdk to be configured to the VS2008 
environment. I tried to get the document loader example to work but it returns 
the following error:
Unhandled expcetion at 0x00b8.. Access violation reading location..
at this line of code:Reference  XComponent  xComponent = 
xComponentLoader-loadComponentFromURL(.);
Nothing happens in the program, but i think an instance of the component is 
created because it has an address. However, no interface pops out or anything. 
Or does that only happen when i loadcomponent? Or am i passing argv[1] wrongly?
How do i resolve this? Thanks.
Cheers,
Wei Min

Previously, I had the following runtime errors:
Error: cannot establish a connection using 'uno:socket,host=localhost, 
post2083;urp;StarOffice.ServiceManager'   Connector : couldn't connect to socket 
WSANOTINITIALISED, WSAStartup() has not been called
Resolved by:
WSADATA wsaData;WSAStartup(MAKEWORD(2,2), wsaData);
Error: cannot establish a connection using 'uno:socket,host=localhost, 
post2083;urp;StarOffice.ServiceManager'   Connector : couldn't connect to socket 
WSACONNREFUSED, Connection refused
Resolved by:
soffice -accept=socket,host=localhost,port=2083;urp;


What exact version of SDK (and OOo) do you use?  The WSAStartup error is 
most probably the root of your problems.  On Windows, when the SDK 
document loader example application (or any other application, for that 
matter) wants to communicate with the OOo application, it does so using 
the winsock library, which needs to be initialized to work properly. 
This initialization code moved around a bit in OOo 3.x (it used to be in 
the sal library, but had to be moved to the applications themselves).


-Stephan

-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.org
For additional commands, e-mail: dev-h...@openoffice.org



RE: [dev] Runtime error for DocumentLoader

2009-08-12 Thread Wei Min Teo

Hi Stephan,
I'm using Openoffice 3.1 and sdk 3.1 as well. However, it seems like the 
connection is fine... the code seems to run well passed that part once i call 
WSAStartup().

 Date: Wed, 12 Aug 2009 09:16:14 +0200
 From: stephan.bergm...@sun.com
 To: dev@openoffice.org
 Subject: Re: [dev] Runtime error for DocumentLoader
 
 On 08/12/09 07:52, Wei Min Teo wrote:
  I've only recently managed to get the sdk to be configured to the VS2008 
  environment. I tried to get the document loader example to work but it 
  returns the following error:
  Unhandled expcetion at 0x00b8.. Access violation reading 
  location..
  at this line of code:Reference  XComponent  xComponent = 
  xComponentLoader-loadComponentFromURL(.);
  Nothing happens in the program, but i think an instance of the component is 
  created because it has an address. However, no interface pops out or 
  anything. Or does that only happen when i loadcomponent? Or am i passing 
  argv[1] wrongly?
  How do i resolve this? Thanks.
  Cheers,
  Wei Min
  
  Previously, I had the following runtime errors:
  Error: cannot establish a connection using 'uno:socket,host=localhost, 
  post2083;urp;StarOffice.ServiceManager'   Connector : couldn't connect 
  to socket WSANOTINITIALISED, WSAStartup() has not been called
  Resolved by:
  WSADATA wsaData;WSAStartup(MAKEWORD(2,2), wsaData);
  Error: cannot establish a connection using 'uno:socket,host=localhost, 
  post2083;urp;StarOffice.ServiceManager'   Connector : couldn't connect 
  to socket WSACONNREFUSED, Connection refused
  Resolved by:
  soffice -accept=socket,host=localhost,port=2083;urp;
 
 What exact version of SDK (and OOo) do you use?  The WSAStartup error is 
 most probably the root of your problems.  On Windows, when the SDK 
 document loader example application (or any other application, for that 
 matter) wants to communicate with the OOo application, it does so using 
 the winsock library, which needs to be initialized to work properly. 
 This initialization code moved around a bit in OOo 3.x (it used to be in 
 the sal library, but had to be moved to the applications themselves).
 
 -Stephan
 
 -
 To unsubscribe, e-mail: dev-unsubscr...@openoffice.org
 For additional commands, e-mail: dev-h...@openoffice.org
 

_
See all the ways you can stay connected to friends and family
http://www.microsoft.com/windows/windowslive/default.aspx

Re: [dev] Runtime error for DocumentLoader

2009-08-12 Thread Stephan Bergmann

On 08/12/09 09:23, Wei Min Teo wrote:

I'm using Openoffice 3.1 and sdk 3.1 as well. However, it seems like the 
connection is fine... the code seems to run well passed that part once i call 
WSAStartup().


I see.  Than I have no idea what causes your second problem.

-Stephan

-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.org
For additional commands, e-mail: dev-h...@openoffice.org



[dev] Re: [project leads] Re: [dev] Proposal : OOo4Kids as official part of OpenOffice.org Project

2009-08-12 Thread Andrea Pescetti
On 10/08/2009 eric b wrote:
 Doing that (reducing/optimizing OOo) is technically extremely  
 interesting, for a lot of reasons.

OK, I see that OOo4Kids has many more ramifications than what the name
seemed to suggest at first glance, and that you have thoroughly
considered them all.

Thanks for the interesting links, and looking forward to seeing a
presentation/demo at the OOoCon in Orvieto!

Regards,
  Andrea Pescetti - Italian N-L Project Lead.


-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.org
For additional commands, e-mail: dev-h...@openoffice.org



[dev] About myself

2009-08-12 Thread Muno

Hi

I am a native English speaker with Chinese knowledge, I was born in Hong 
Kong and went to UK study and work from 1996-2007. I have a perfect 
translation skill and currently work as a Java Programmer in a printing 
company in Hong Kong region.


Regards
Muno



-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.org
For additional commands, e-mail: dev-h...@openoffice.org



Re: [dev] Using OpenOffice.org for Chemistry on Linux

2009-08-12 Thread Jan Holst Jensen

Konstantin Tokarev wrote:

Hello!

I think every chemist which wants to use Linux faces with one serious problem: 
structural formulae cannot be inserted into the text in editable way. Also I 
think that only OpenOffice.org can provide this functionality today.

In MS Windows there are many GUI based editors, which can be used to create and 
edit formulae incorporated into documents. In *nix-like systems there are no 
OLE-like interfaces. Only possibilities for user are to insert formula as 
image, SVG, or use OLE objects, incorporated in files which were created in 
Windows, Objects, created by external software and inserted into document 
cannot be edited after incorporation.

On the other hand, there is an extension for OpenOffice.org called 'quick 
formule', which provides a language for textual description of chemical 
structural formulae. It constructs formula as OOo Draw object from text string. 
But created object cannot be edited as chemical structure. If a possibility to 
store this text string alongside with drawing, it could be used for further 
edit, and required functionality would be achieved.
  


Hi Konstantin.

I have looked into providing a somewhat similar functionality for 
protein sequences, only in Calc. I would like to custom-render Calc 
cells so the cells would display a graphical view of a protein sequence 
instead of the underlying text. To translate this to your needs, imagine 
that you could enter ph'4cy(2=O)(5=O)4ph(4-Oh)(5-Oh) in a 
spreadsheet cell and apply a special cell formatting that lets Calc 
automagically render the chemical structure directly in the cell (adding 
images to a spreadsheet doesn't work since the images do not follow the 
cells when you e.g. sort the underlying data).


You can follow the discussion at 
http://www.mail-archive.com/d...@api.openoffice.org/msg09260.html. Niklas 
Nebel suggests a method of letting an extension subscribe to events to 
let it update/add images to a document - this might work for you if you 
only consider Writer.


I haven't had time to look into this myself yet but if you are 
interested in supporting Calc too, feel free to e-mail me directly or 
post back here.


I had a look at quick formule and it's a very nice tool. However, to 
be useful in the pharmaceutical industry the formulas would need to be 
SMILES or some other standard format. Interfacing to OpenBabel or 
similar tools could potentially solve this.


Cheers
-- Jan

-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.org
For additional commands, e-mail: dev-h...@openoffice.org



Re: [dev] Using OpenOffice.org for Chemistry on Linux

2009-08-12 Thread Eike Rathke
Hi Konstantin,

On Tuesday, 2009-08-11 15:06:37 +0400, Konstantin Tokarev wrote:

 I think every chemist which wants to use Linux faces with one serious
 problem: structural formulae cannot be inserted into the text in
 editable way. Also I think that only OpenOffice.org can provide this
 functionality today.

Not sure if it would suit your needs, e.g. once exported to a graphics
document a formula lost its structural information, but you might want
to take a look at BKChem, http://bkchem.zirael.org/

I could imagine an extension that used BKChem to feed it one of the
formats it imports and let it render the graphics file. Just a quick
idea..  There's also the OASA library on the same site that could
provide the necessary functionality.

  Eike

-- 
 OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer.
 SunSign   0x87F8D412 : 2F58 5236 DB02 F335 8304  7D6C 65C9 F9B5 87F8 D412
 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS
 Please don't send personal mail to the e...@sun.com account, which I use for
 mailing lists only and don't read from outside Sun. Use er...@sun.com Thanks.


pgpzWeAO81sgZ.pgp
Description: PGP signature


Re: [dev] Using OpenOffice.org for Chemistry on Linux

2009-08-12 Thread Ariel Constenla-Haile
Hello Konstantin,

On Tuesday 11 August 2009, 08:06, Konstantin Tokarev wrote:
 Hello!

 I think every chemist which wants to use Linux faces with one serious
 problem: structural formulae cannot be inserted into the text in editable
 way. Also I think that only OpenOffice.org can provide this functionality
 today.

 In MS Windows there are many GUI based editors, which can be used to create
 and edit formulae incorporated into documents. In *nix-like systems there
 are no OLE-like interfaces. Only possibilities for user are to insert
 formula as image, SVG, or use OLE objects, incorporated in files which were
 created in Windows, Objects, created by external software and inserted into
 document cannot be edited after incorporation.

 On the other hand, there is an extension for OpenOffice.org called 'quick
 formule', which provides a language for textual description of chemical
 structural formulae. It constructs formula as OOo Draw object from text
 string. But created object cannot be edited as chemical structure. If a
 possibility to store this text string alongside with drawing, it could be
 used for further edit, and required functionality would be achieved.

 I see solution of this problem in creating new OOo application working the
 same way as OOo Math and based on its code. Using simple GUI (probably
 jchempaint), user will actually change text string with formula
 description, and when string changes, drawing object will be
 re-constructed. This complex document may be incorporated using OOo OLE
 implementation like OO Math objects are incorporated.

 My question for OOo developers: is it the simplest way to achieve such
 functionality? Or it is simpler to realize through OOo extension?


I think that Jürgen gave you the best advice: develop your own embedded 
object.

I once developed a propotype following the SDK example, embedding JMol: 
inside the document I stored the pdb file, and as replacement graphic one 
generated by JMol from this pdb together with some JMol specific data in order 
to store Jmol's state. When the user activated the embedded object I opened 
Jmol's frame, etc.

The prototype worked fine (until  - I guess - the changes in OOo classpath 
policy) but didn't have time to play with this again.
But this shows the big potential of the embedded object API.
You could do something similar with JChemPaint (and of course you're free to 
take the Jmol idea and create two embedded object types, this may make OOo 
very popular among scholars)


 I'm C++ developer, 

well, both JMol and JChemPaint are Java applications, you could benefit of the 
Netbeans OOo API plug-in 

 but I've never worked with OpenOffice.org API. 

the embedded API is rather undocumented (by documented I mean there is nothing 
AFAIK in the Developer's Guide), though you have the abstract API 
specification, and the SDK example (it's helpful but hard to follow, I remember 
it took me a 2 weeks winter holiday to understand this stuff)


Regards
-- 
Ariel Constenla-Haile
La Plata, Argentina

-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.org
For additional commands, e-mail: dev-h...@openoffice.org



[dev] Cli Uno MS visual basic 2005 - cannot format cell programatically

2009-08-12 Thread bradley36

My real need here is: How can I programatically format a scalc cell

It probably could be more easily done with OLE automation, but the
openoffice.org site recommends use of Cli Uno,
and I want to do it the recommended way.


The following code does almost all I want it to:
Starts OOoCalc
Inserts spreadsheet named test
Inserts many values into cells
etc.
But I cannot get it to format cell A7 in sheet names test - it fails at
runtime with error at line 80

All of this is because I cannot create a Locale, which is needed to format

First the code, followed by error detail.

Code:
Imports System
Imports System.Collections.Generic
Imports System.Windows.Forms
Imports unoidl.com.sun.star.lang
Imports unoidl.com.sun.star.uno
Imports unoidl.com.sun.star.bridge
Imports unoidl.com.sun.star.frame
Imports unoidl.com.sun.star.container
Imports unoidl.com.sun.star.sheet
Imports unoidl.com.sun.star.beans
Imports unoidl.com.sun.star.table
Imports unoidl.com.sun.star.util
Imports unoidl.com.sun.star.reflection

Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click

'Dim FileName As String = F:\odtfiles   est.odt
Dim FileName As String = C:\testCLIOO.ods
'oDoc = unoidl.com.sun.star.sheet.XSpreadsheetDocument
'oDoc.getSheets()
Dim localContext As unoidl.com.sun.star.uno.XComponentContext =
uno.util.Bootstrap.bootstrap()
Dim multiServiceFactory As
unoidl.com.sun.star.lang.XMultiServiceFactory =
DirectCast(localContext.getServiceManager(),
unoidl.com.sun.star.lang.XMultiServiceFactory)
Dim componentLoader As XComponentLoader =
DirectCast(multiServiceFactory.createInstance(com.sun.star.frame.Desktop),
XComponentLoader)
Dim xComponent As XComponent =
componentLoader.loadComponentFromURL(private:factory/scalc, _blank, 0,
New unoidl.com.sun.star.beans.PropertyValue(-1) {})
Dim oDoc As unoidl.com.sun.star.sheet.XSpreadsheetDocument
oDoc = xComponent
Dim oSheets As unoidl.com.sun.star.sheet.XSpreadsheets
'Dim oSheet As unoidl.com.sun.star.sheet.XSpreadsheet
Dim oSheet As XSpreadsheet
Dim oSheetsIA As XIndexAccess
Dim oCell As XCell
oSheets = oDoc.getSheets
oSheetsIA = oSheets
Dim Sheet1 As XSpreadsheet
Dim Sheet2 As XSpreadsheet
Dim cSeries As unoidl.com.sun.star.sheet.XCellSeries
oSheets.insertNewByName(test, 0)
oSheet = oSheetsIA.getByIndex(0).Value
' Now using sheet: test
oCell = oSheet.getCellByPosition(0, 0)
oCell.setFormula(Test)
oSheet.getCellByPosition(1, 0).setFormula(Sales)
oSheet.getCellByPosition(2, 0).setFormula(Month)
oSheet.getCellByPosition(3, 0).setFormula(Year)
cSeries = oSheet.getCellRangeByPosition(3, 3, 5, 3)
cSeries.fillSeries(unoidl.com.sun.star.sheet.FillDirection.TO_RIGHT,
unoidl.com.sun.star.sheet.FillMode.LINEAR,
unoidl.com.sun.star.sheet.FillDateMode.FILL_DATE_DAY, 2.0, 6.0)
oCell = oSheet.getCellByPosition(0, 1)
oCell.setValue(54321.0)
oSheet.getCellByPosition(0, 2).setValue(625.0)
oCell = oSheet.getCellByPosition(0, 3)
oCell.setFormula(=SUM(A1:A3)

oCell = oSheet.getCellByPosition(0, 5)
oCell.setFormula(=DATE(2009;8;10))
oCell = oSheet.getCellByPosition(0, 6) ' cell A7
oCell.setFormula(=40035)  ' numerical value for 08/10/2009 in A7
'Dim oFormatter As unoidl.com.sun.star.util.XNumberFormatter
Dim oFormatter As XNumberFormatter
'Dim oFormat As
unoidl.com.sun.star.util.XNumberFormatsSupplier
Dim oFormatSupp As XNumberFormatsSupplier
oFormatSupp = oDoc
Dim oTypes As XNumberFormatTypes
Dim oLocale As unoidl.com.sun.star.lang.Locale
oTypes = oFormatSupp.getNumberFormats()
Dim nFormat As uno.Any
Dim oFormat As NumberFormat
Const dateFormat = unoidl.com.sun.star.util.NumberFormat.DATE
oLocale.Language = en  ' * = this is the line 80 referred
to in error detail
oLocale.Country = US
oLocale.Variant = Traditional_WIN


' Now using sheet: Sheet3
Sheet1 = oSheetsIA.getByIndex(3).Value
'Sheet1 = oSheets.getByName(SheetName)
Sheet1.getCellByPosition(0, 1).setValue(9876)
' Now using sheet: Sheet1
oSheet = oSheetsIA.getByIndex(1).Value
oCell = oSheet.getCellByPosition(0, 4)
oCell.setValue(2.0)
oCell = oSheet.getCellByPosition(1, 4)
oCell.setValue(4.0)
cSeries = oSheet.getCellRangeByPosition(0, 4, 5, 4)
'   
cSeries.fillSeries(unoidl.com.sun.star.sheet.FillDirection.TO_RIGHT,
unoidl.com.sun.star.sheet.FillMode.LINEAR,
unoidl.com.sun.star.sheet.FillDateMode.FILL_DATE_DAY, 2.0, 6.0)
cSeries.fillAuto(unoidl.com.sun.star.sheet.FillDirection.TO_RIGHT,
2)

[dev] Cli Uno MS visual basic 2005 - cannot format cell programatically

2009-08-12 Thread bradley36

My need is: How can I programatically format a scalc cell using CLI UNO

It probably could be more easily done with OLE automation, but the
openoffice.org site recommends use of Cli Uno,
and I want to do it the recommended way.  I have spent days on this - very
difficult to find documentation.  Most of this is translated from C++ or C#.


The following code does almost all I want it to:
Starts OOoCalc
Inserts spreadsheet named test
Inserts many values into cells
etc.
But I cannot get it to format cell A7 in sheet names test - it fails at
runtime with error at line 80

All of this is because I cannot create a Locale, which is needed to format

First the code, followed by error detail.

Code:
Imports System
Imports System.Collections.Generic
Imports System.Windows.Forms
Imports unoidl.com.sun.star.lang
Imports unoidl.com.sun.star.uno
Imports unoidl.com.sun.star.bridge
Imports unoidl.com.sun.star.frame
Imports unoidl.com.sun.star.container
Imports unoidl.com.sun.star.sheet
Imports unoidl.com.sun.star.beans
Imports unoidl.com.sun.star.table
Imports unoidl.com.sun.star.util
Imports unoidl.com.sun.star.reflection

Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click

'Dim FileName As String = F:\odtfiles   est.odt
Dim FileName As String = C:\testCLIOO.ods
'oDoc = unoidl.com.sun.star.sheet.XSpreadsheetDocument
'oDoc.getSheets()
Dim localContext As unoidl.com.sun.star.uno.XComponentContext =
uno.util.Bootstrap.bootstrap()
Dim multiServiceFactory As
unoidl.com.sun.star.lang.XMultiServiceFactory =
DirectCast(localContext.getServiceManager(),
unoidl.com.sun.star.lang.XMultiServiceFactory)
Dim componentLoader As XComponentLoader =
DirectCast(multiServiceFactory.createInstance(com.sun.star.frame.Desktop),
XComponentLoader)
Dim xComponent As XComponent =
componentLoader.loadComponentFromURL(private:factory/scalc, _blank, 0,
New unoidl.com.sun.star.beans.PropertyValue(-1) {})
Dim oDoc As unoidl.com.sun.star.sheet.XSpreadsheetDocument
oDoc = xComponent
Dim oSheets As unoidl.com.sun.star.sheet.XSpreadsheets
'Dim oSheet As unoidl.com.sun.star.sheet.XSpreadsheet
Dim oSheet As XSpreadsheet
Dim oSheetsIA As XIndexAccess
Dim oCell As XCell
oSheets = oDoc.getSheets
oSheetsIA = oSheets
Dim Sheet1 As XSpreadsheet
Dim Sheet2 As XSpreadsheet
Dim cSeries As unoidl.com.sun.star.sheet.XCellSeries
oSheets.insertNewByName(test, 0)
oSheet = oSheetsIA.getByIndex(0).Value
' Now using sheet: test
oCell = oSheet.getCellByPosition(0, 0)
oCell.setFormula(Test)
oSheet.getCellByPosition(1, 0).setFormula(Sales)
oSheet.getCellByPosition(2, 0).setFormula(Month)
oSheet.getCellByPosition(3, 0).setFormula(Year)
cSeries = oSheet.getCellRangeByPosition(3, 3, 5, 3)
cSeries.fillSeries(unoidl.com.sun.star.sheet.FillDirection.TO_RIGHT,
unoidl.com.sun.star.sheet.FillMode.LINEAR,
unoidl.com.sun.star.sheet.FillDateMode.FILL_DATE_DAY, 2.0, 6.0)
oCell = oSheet.getCellByPosition(0, 1)
oCell.setValue(54321.0)
oSheet.getCellByPosition(0, 2).setValue(625.0)
oCell = oSheet.getCellByPosition(0, 3)
oCell.setFormula(=SUM(A1:A3)

oCell = oSheet.getCellByPosition(0, 5)
oCell.setFormula(=DATE(2009;8;10))
oCell = oSheet.getCellByPosition(0, 6) ' cell A7
oCell.setFormula(=40035)  ' numerical value for 08/10/2009 in A7
'Dim oFormatter As unoidl.com.sun.star.util.XNumberFormatter
Dim oFormatter As XNumberFormatter
'Dim oFormat As
unoidl.com.sun.star.util.XNumberFormatsSupplier
Dim oFormatSupp As XNumberFormatsSupplier
oFormatSupp = oDoc
Dim oTypes As XNumberFormatTypes
Dim oLocale As unoidl.com.sun.star.lang.Locale
oTypes = oFormatSupp.getNumberFormats()
Dim nFormat As uno.Any
Dim oFormat As NumberFormat
Const dateFormat = unoidl.com.sun.star.util.NumberFormat.DATE
oLocale.Language = en  ' * = this is the line 80 referred
to in error detail
oLocale.Country = US
oLocale.Variant = Traditional_WIN


' Now using sheet: Sheet3
Sheet1 = oSheetsIA.getByIndex(3).Value
'Sheet1 = oSheets.getByName(SheetName)
Sheet1.getCellByPosition(0, 1).setValue(9876)
' Now using sheet: Sheet1
oSheet = oSheetsIA.getByIndex(1).Value
oCell = oSheet.getCellByPosition(0, 4)
oCell.setValue(2.0)
oCell = oSheet.getCellByPosition(1, 4)
oCell.setValue(4.0)
cSeries = oSheet.getCellRangeByPosition(0, 4, 5, 4)
'   
cSeries.fillSeries(unoidl.com.sun.star.sheet.FillDirection.TO_RIGHT,
unoidl.com.sun.star.sheet.FillMode.LINEAR,

Re: [dev] Does building openoffice need kde?

2009-08-12 Thread huang huang
Hi Ariel,
Thanks for your help.

I have checkout DEV300_m54 and built it successfully.

Thanks

2009/8/11 Ariel Constenla-Haile ariel.constenla.ha...@googlemail.com

 Hello huang,

 On Tuesday 11 August 2009, 01:24, huang huang wrote:
  Hi,
 
  Got OOo's source code from svn://svn.services.openoffice.org/ooo/trunk,

 any special reason why you're trying to build trunk?
 Different from other projects (like KDE, where they advice people trying to
 learn/hack their source code to build from trunk), in OOo its AFAIK
 suggested
 to build the latest development build (or the latest stable build depending
 on
 what you're trying to do) which is DEV300_m54
 http://svn.services.openoffice.org/ooo/tags/DEV300_m54/ .


  while I run ./configure, it gave messages:
 
  Possible unintended interpolation of @ENABLE_KDE4 in string at
 ./set_soenv
  line 1693.
  Possible unintended interpolation of @KDE4_CFLAGS in string at
 ./set_soenv
  line 1694.
  Possible unintended interpolation of @KDE4_LIBS in string at ./set_soenv
  line 1695.
  Possible unintended interpolation of @MOC4 in string at ./set_soenv line
  1696.
  Global symbol @ENABLE_KDE4 requires explicit package name at
 ./set_soenv
  line 1693.
  Global symbol @KDE4_CFLAGS requires explicit package name at
 ./set_soenv
  line 1694.
  Global symbol @KDE4_LIBS requires explicit package name at ./set_soenv
  line 1695.
  Global symbol @MOC4 requires explicit package name at ./set_soenv line
  1696.
  Execution of ./set_soenv aborted due to compilation errors.

 mmm I never had to autoreconf, simply use the configure I checked out.
 But

 ]$ autoreconf -i

 and then

 ]$ ./configure

 let me right now pass configure from trunk

 I tested with these switchs

 ./configure  --with-use-shell=bash --disable-qadevooo
  --enable-crashdump=yes
 --enable-cairo  --with-system-cairo  --enable-opengl   --enable-kde
 --disable-
 kdeab  --with-package-format=rpm  --with-mingwin=i686-pc-mingw32-g++


  I am not sure what these mean, but I can't continue my building work. Is
  there anyone can help you?

 autoreconf'ing may help you (but as I never need it before, I guess you
 shouldn't need to run it, just use instead the configure they provide).
 If not, try updating the configure script, or try with the latest tag
 instead
 of trunk. This KDE4 stuff is from the  integration of  kde4int CWS, so sure
 when DEV300_m55 is ready your issue will be gone.

 Ah, to your question Does building openoffice need kde?

 No, only if you pass to configure
 --enable-kdefor KDE 3 integration
 --enable-kde4  for KDE 4 integration
 --enable-kdeabfor KDE [3] addressbook SDBC driver


 Regards
 --
 Ariel Constenla-Haile
 La Plata, Argentina

 -
 To unsubscribe, e-mail: dev-unsubscr...@openoffice.org
 For additional commands, e-mail: dev-h...@openoffice.org




[dev] need install the built version before debug?

2009-08-12 Thread huang huang
Hi everyone,

I have built the OOo successfully, and read some development guide, but I am
still not sure whether need to install the built version before debug? Is
there any trick to run the building result without install them, just like
some other simple application?


Re: [dev] need install the built version before debug?

2009-08-12 Thread Ariel Constenla-Haile
Hello huang,

On Wednesday 12 August 2009, 23:49, huang huang wrote:
 Hi everyone,

 I have built the OOo successfully, and read some development guide, but I
 am still not sure whether need to install the built version before debug?
 Is there any trick to run the building result without install them, just
 like some other simple application?

you mean like running ./soffice from the solver? that is

cd solver/300/unxlngx6/bin
./soffice

No, you can't do this.

But you can set PKGFORMAT=installed (see  
http://www.openoffice.org/servlets/ReadMsg?list=devmsgNo=25295 )
or install  in parallel from the RPMs[DEBs] in 
instsetoo_native/unxlngx6/OpenOffice/rpm/install/en-US/RPMS, in your home dir 
(see http://wiki.services.openoffice.org/wiki/Run_OOo_versions_parallel )

Regards
-- 
Ariel Constenla-Haile
La Plata, Argentina

-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.org
For additional commands, e-mail: dev-h...@openoffice.org