openoffice-calc

How to read an OpenOffice document spreadsheet from an android application?

I want to read a Open Office Document spreadsheet (.ods file) from my android application. I need to basically loop through the first two columns & store them in a SQLite database. I am able to do this by reading a regular text file stored in res/raw using the following code: InputStream is = context.getResources().openRawResource...

OpenOffice automation translate basic code to Delphi

Hello please help to translate the next line of basic code to Delphi for the OOoTools.pas interface. oChart.Diagram.SymbolType = com.sun.star.chart.ChartSymbolType.SYMBOL1 I know that the SYMBOL1 part is an enumeration and I think I have to use the MakePropertyValue fumction but how? ...

OpenOffice Automation Delphi how create a scattered chart from non-adjacent columns

Hello, can someone please help me on how to create a XYdiagram from non-adjacent columns? I want to do this in Delphi using the OOoTools.pas interface. This is the working code where I can only select adjacent columns: User The_Fox helped me a lot with some issues I had, thanks for that. procedure TForm1.ProcessNewChart(aFilename: Stri...

OpenOffice Automation Delphi how use a callfunction

Hello, please help me with the following: I want to determine the maximum value in an open office calc column using the OOoTools.pas interface. This as fas as I come: Procedure FindMaximum(oMySheet : Variant); Var oFuncService : Variant; Begin oFuncService := CreateUnoService('com.sun.star.sheet.FunctionAccess'); ShowMes...

OO Calc Add-in: Accessing dynamically determined cell ranges on Calc spreadsheet

Hey, i have succeeded in adding a function to Calc and reading the input figures on a Calc spreadsheet. I'm using the .impl.java file generated (on Netbeans IDE) and changing its return statement so as to give the result of my function. But I can only access a pre-defined number of cells only. i.e. the size of the array i define in the...

Import a .fil file in OpenOffice calc

Hello, I have the exe of an old VB application. It seems that this app saves the data in .hat files, txt files, and a .fil file. I'm trying to create a new app and I want to migrate the data in OpenOffice Base. I managed to migrate the .txt, .hat files but I have a problem migrating the .fil file. I open it in Calc or Writer but I can n...