Return When Cell Is Copied

the addition of the return be suppressed or turned off is some way? I have looked in Options and also Customize but I did not find anything that I thought would control this behavior. Any suggestions? Thank you. David Stuhr

How to Add Conditional Formatting to Existing Data

s" conditional formatting to  existing data (dates) where dates are missing or duplicated in the column and using the fill method described above would alter/change the existing data values. Thank your for your assistance. David Stuhr

Median Function Used as "Between"

Hello, Can the Median function in Open Office Spreadsheet be used as a between function? When the following equation is entered =IF(B12=MEDIAN(120;129);"Yes";"No") and cell B12 contains 121 formatted as Number General the equation returns No. I have also tested the equation with the value

Re: Update: After Windows 11 Update Open Office Starts But Goes Into Not Responding

Hello, Microsoft Support responded last night after I had gone to bed. Support gave me a Powershell command to reverse the Windows 11 update. I had to execute the Powershell command 3 times and restart each time but it did work. David On 6/14/2022 11:55 PM, David Stuhr wrote: Hello

After Windows 11 Update Open Office Starts But Goes Into Not Responding

did the same with a spreadsheet file I attempted to open. David Stuhr - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Windows 11 Crash - OpenOffice Runs - Not Responding State

ormal behavior" of OpenOffice. Am now able to create, save and reopen OpenOffice text and spreadsheet documents. Thanks for your assistance. David Stuhr On 6/13/2022 5:11 PM, Steven Ahlers wrote: David, Have you tried forcing OpenOffice to quit from the Task Manager and then reboot

Windows 11 Crash - OpenOffice Runs - Not Responding State

spreadsheet documents. Thanks. David Stuhr

Open Office Icon in Taskbar

Hello, Not a significant issue but when I pin Open Office 4.1.12 to the Windows Taskbar the 'round blue icon with 2 white flying forms' is not shown. Previous version did display Open Office icon in the Taskbar. A white rectangle in portrait orientation is displayed for 4.1.12. Attempted to c

Applying Page Styles

I am having difficulty applying a different page style to new pages in an existing document. Double clicking, as instructed in the help, does not change the page style. The only way i have been able to apply a new page style is when the document does not have any text/content. Is this a bug?

MacOS Upgrades

Hello, After MacOS upgrades a folder "Relocated Items" is left on my Mac desktop with a PDF explaining and a file named "group.system_default" the file has something to do with the Open Directory. Does OpenOffice use OpenDirectory? And if so, how do I deal with this issue on the Mac? Thank

Can User Functions Be Created In OpenOffice Spreadsheet

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

Mac Mini M1 Chip

Hello, Does Open Office 4.1.9 for the Mac work with the new Mac Mini M1 Chip? Thanks.

Re: Get URL from Hyperlink - Solved

work. I think in this day and age that a function that would get the URL from a Hyperlink in a spreadsheet cell would be entirely appropriate. Does the team/individual that maintains OpenOffice have a "suggestion" box? David On 8/18/2020 5:40 PM, David Stuhr wrote: Hello Brian,

Re: Get URL from Hyperlink

error. Function not allowed within a procedure. What am I doing wrong? David On 8/17/2020 9:12 AM, Brian Barker wrote: At 08:18 17/08/2020 -0400, David Stuhr wrote: I have an OpenOffice spreadsheet that has over a thousand hyperlinks to an external www website. The information in each hyperlinked

Get URL from Hyperlink

Hello, I have an OpenOffice spreadsheet that has over a thousand hyperlinks to an external www website. The information in each hyperlinked cell is the URL and descriptive text. From a search of the web it appears that Excel has a "get URL" function but a search of OpenOffice help did not retu

Re: Special Characters in Hyperlink Calc

Hello Brian, It does help. Thank you very much. David Stuhr On 8/7/2020 6:19 PM, Brian Barker wrote: At 16:19 07/08/2020 -0400, David Stuhr wrote: Is it possible to insert a special character (Insert > Special Character) into the Text field of the Hyperlink (Insert > Hyperlink) pa

Special Characters in Hyperlink Calc

Hello, Is it possible to insert a special character (Intsert > Special Character) into the Text field of the Hyperlink (Intsert > Hyperlink) panel? I also tried the Hyperlink bar. The special character is inserted in the currently selected cell rather than the Text field. The work around I ca