New Open Office account?

2024-03-27 Thread john silver
How would one go about getting a New Open Office account to submit bugs or suggestions? previously when I went to get a new account it said "User account creation has been disabled." and that I need to send an email to aoo-bugzilla-ad...@apache.org but when I sent the email it came back with a

Confirmation for replace all?

2024-03-23 Thread john silver
Would it be possible to add an option in Open Office to make it so that if you hit "replace all" it asks for a confirmation? Recently when I went to open a spreadsheet I found some of the cells empty. Then later when using the find function I accidentally hit the "replace all" button so I'm

Filling a matrix based on coordinates

2022-05-23 Thread john silver
I'm trying to fill a matrix based on the coordinates of each cell. In the formula cell I got"=CONCATENATE("RS-";TEXT(COLUMN();"##");TEXT(ROW()+;"##"))" But when I try to use the Multiple operations most of the cells end up containing the exact same value.

Getting text color?

2022-02-07 Thread john silver
Is there anyway to determine which color of text is used in a cell in a spreadshet? When going to select the color it wasn't usually marked. Something you may want to consider is some sort of eyedropper tool like they have in graphic programs.

Re: Converting arrays

2022-02-05 Thread john silver
That worked, many thanks. On Saturday, February 5, 2022, 4:12:00 PM PST, Brian Barker wrote: At 21:26 05/02/2022 +, John Silver wrote: >Is there anyway to convert a spreadsheet that was made with an array >into one where the cells can be individually edited? Saving it in

Converting arrays

2022-02-05 Thread john silver
Is there anyway to convert a spreadsheet that was made with an array into one where the cells can be individually edited? Saving it in other format would likely work, but which format is the best to preserve color and comments?