Re: Can User Functions Be Created In OpenOffice Spreadsheet

2021-05-26 Thread Andrew Pitonyak
you can write user defined functions it's very easy. The easiest way is to pass the value of a cell and then just return a string or whatever you want. I don't remember what happens when you pass the cell value like that if you are parsing out text and pulling out a URL property it's probably ea

Re: problem verifying latest AOO download

2021-05-26 Thread Matthias Seidel
Hi, Am 26.05.21 um 22:49 schrieb s...@sith.me.uk: > Hi, > > Just reporting that the last few times I've downloaded OpenOffice (for > x86) I could not verify the signature because it was not created by > Juergen Schmidt's key (key ID 51B5FDE8). I had to import Matthias > Seibel's key (key ID E5731E

problem verifying latest AOO download

2021-05-26 Thread s
Hi, Just reporting that the last few times I've downloaded OpenOffice (for x86) I could not verify the signature because it was not created by Juergen Schmidt's key (key ID 51B5FDE8). I had to import Matthias Seibel's key (key ID E5731E7D) to verify. Do you need to update the key supplied on the u

Can User Functions Be Created In OpenOffice Spreadsheet

2021-05-26 Thread David Stuhr
Hello, I have an OpenOffice Calc (spreadsheet) that has over a thousand Hyperlinks and I would like to create a user defined function which would extract the URL from the Hyperlink and put it in a separate cell. I found an Excel example on the web which I pasted in below. Function GetURL(rng

data entry

2021-05-26 Thread Norman Adams
When I try to enter data into a spreadsheet cell, the cell turns black and then the data is not visible. Please help. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@op