Auto Detect NumberFormats

[rajeshsegu]

Hello Friends!

I have been trying to auto detect the format of values using the XNumberFormatter. I was search this forum and landed on the below url.
http://www.oooforum.org/forum/viewtopic.phtml?t=5132&highlight=numberformatter

Good that it had a code snippet which makes use of NumberFormatter. But when I tried to exectue the code I get some Proxy$x runtime exception which I could not really understand.

Here is what I am trying to do............

XComponentContext xLocalContext = com.sun.star.comp.helper.Bootstrap.createInitialComponentContext(null);
XMultiComponentFactory xLocalServiceManager = xLocalContext.getServiceManager();
Object urlResolver = xLocalServiceManager.createInstanceWithContext("com.sun.star.bridge.UnoUrlResolver", xLocalContext );
XUnoUrlResolver xUnoUrlResolver = (XUnoUrlResolver) UnoRuntime.queryInterface(XUnoUrlResolver.class, urlResolver);
Object initialObject = xUnoUrlResolver.resolve("uno:socket,host=localhost,port=8100;urp;StarOffice.ServiceManager");
XPropertySet xPropertySet = (XPropertySet)UnoRuntime.queryInterface(XPropertySet.class, initialObject);
Object context = xPropertySet.getPropertyValue("DefaultContext");
XComponentContext xRemoteContext = (XComponentContext)UnoRuntime.queryInterface(XComponentContext.class, context);
Object formatter = xRemoteContext.getServiceManager().createInstanceWithContext("com.sun.star.util.NumberFormatter", xRemoteContext);
XNumberFormatter xNumberFormatter = (XNumberFormatter) UnoRuntime.queryInterface(XNumberFormatter.class, formatter);

But after I write this code and use xNumberFormatter.detectNumberFormat(0,"1-jan-2005") it throws
$Proxy16.detectNumberFormat(Unknown Source) runtime exception.

Hope there would be an easier way to use XNumberFormatter. Any suggestions would help me a lot............ waiting for those.......

Rajesh Segu

[ms777]

Hi,

in OO BASIC it seems to work ...

[rajeshsegu]

Guys! I badly need to the code to get the xNumberFormatter interface from the UNO service handle for com.sun.star.util.NumberFormatter

The above reply, gives me code for OOBasic but I need to program it using OpenOffice Calc Java API. So please try to give me some insight.

Any help is appreciated. Thank you.