I need a formula to extract the last two words in a cell using openoffice. For example a cell contains the words: "enjoy the rest of your day" I would like to extract "your day" using a formula. I know how to extract the last word: =RIGHT(A1;LEN(A1)-FIND("*";SUBSTITUTE(A1;" ";"*";LEN(A1)-LEN(SUBSTITUTE(A1;" ";""))))) which results in ...
Hello, for years now I have used a math formula to determine relative activity levels for message boards. Now I would like to use that formula in a php search engine to replace the non-functioning Google Page Ranking system. The data items used are: Members (B2), Posts (D2), Topics (C2), and the Boards creation date (E2). In the spreads...
Hi The requirement is to build a calculation engine which is performant and supports excel like formulas. These formulas need to be applied on huge data sets (millions of rows of data). I was thinking if something could be built on top of OpenOffice Calc service and make it available as a Calculation Engine. Does anyone have any expe...
In Excel VBA, I redefine the address of a named range with: Ranges("MyRange").Cells(1).CurrentRegion.Name = "MyRange" in the Worksheet_Deactivate event. This way, after updating the spreadsheet, MyDataRange always references to the entire data. Ok with Excel, but when I tried to migrate this to Open Office VBA (OpenOffice.org 3.1.1 /...
Hello! As far as I can see OpenOffice, when it comes to save a file as a csv-file, encloses all strings in quote-characters. So is there any need for an escape character? and related to this question: Does OpenOffice have a default escape character? ...
Hi to all, I would like to add a column in my OpenOffice Calc spreadsheet. In particular, this column should contain a hyperlink to a query on Google. For example: if in A1 I have the string "The gladiator", I would like have column B1: "www.google.it?q=The Gladiator" So I can click and open the browser to see how that "film" is (y...
How can I import data for example for the field A1? When I use etree.parse() I get an error, because I dont have a xml file. ...
Hi, I have an spreadsheet-based automated report that needs to be created daily, with some charts, aggregating functions (e.g. SUM and AVERAGE) and formatted cells (Dates, percentage, etc.). I have tried to write these results directly to an Excel file, but Python's xlwt and xlrd don'y support charts and functions. Moreover, trying t...
HI! friends I have table contains 457 columns i need to ecport this table data to Open Office Calc spreadsheet. Uisng c# in asp.net Can any one please help me. Thank You! ...
I have a list of search terms: A | B | C | D | E | _______________________________________________________________ 1 | SEARCH TERM PR #1 PR #2 PR #3 PR #4 2 | lcd screens 3 | mud 4 | eurpoean sport cars 5 | perfume How can the search term in my spreadsheet ...
I have been able to read an excel cell value with xlrd using column and row numbers as inputs. Now I need to access the same cell values in some spreadsheets that were saved in .ods format. So for example, how would I read the value stored in cell E10 from a .ods file from python? ...
I would like to write a custom OpenOffice function that runs a shell command and puts the result into the cell from which it was invoked. I have a basic macro working, but I can't find a way to capture the command's output. Function MyTest( c1 ) MyTest = Shell("bash -c "" echo hello "" ") End Function The above always returns 0....
I have absolute values of time(as in stopwatch not date/time) in various cells and I would like to add them and keep them the same format(as an absolute value). I have formatted the cells using hh:mm:ss time format. But when I add two values like, 22:34:00 4:00:00 I get, 2:34:00 because of wrapping around the 24-hour tim...
Hello I have a list of text urls in, how i can convert all of them into clickable links? ...
I want to add a Comment to a cell in a macro. I have tried recording a macro to do it, but it doesn't do anything. Any ideas? Here's the meat of the recorded macro: dim document as object dim dispatcher as object document = ThisComponent.CurrentController.Frame dispatcher = createUnoService("com.sun.star.frame.DispatchHelper") dispa...
Hi, I've got something like this (in Open Office Calc): Streetname. Number Streetname. Number a etc. Now I want to delete everything in front of the number. So I need to do a search and replace I guess. ^.*?([0-9]) this one matches Streetname. Number .. but what should I put in the replace field? If I do the search and replace, i...
What is the best way to take a database and make it a flat file? I am have an ODBC driver and need to pull the data out into a file file. Excel, Access? OpenOffice? ...
I have this function that export a datagridView in Excel sheet : public void ExportGridToExcel(DataGridView TheGrid, string FileName) { using (System.IO.StreamWriter fs = new System.IO.StreamWriter(FileName, false)) { fs.WriteLine("<?xml version=\"1.0\"?>"); fs.WriteLine("<?...
I have entries like T, 0.5T, 0.4P, 1P and so on in a spreadsheet. I want to add the similar items ie., I want to be able to add (T + 0.5T) (0.4P + 1P) and compute the total ie., 1.5T, 1.4P built-in SUM() accepts only integers. Is there a way to add algebraically in Openoffice ? Even if a solution exists in GNumeric or MS Excel it is fi...
I want to develop plugin for OoCalc Open Office, is there any good resource or link will help to start working on it. any existing article like step by step guide for developer would be great !! I want to develop the plugin based on Python Programming Language. ...