Re: Spreadsheet

Hi, the easiest way to fix this within a spreadsheet is to do a search with regular expressions option activated. open the search dialog using Ctrl+F and activate "regular expression" within the "more options" part of that dialog. search: .* replace: & This will remove all trailing

Re: Spreadsheet

Hi Frank, Please fix the Cells first. Make sure all are formatted as Numbers and check that no value is preceded with a apostrophe ' . On Sat, 24 Jun 2023 18:22:15 +0200 wrote --- Thank Martin, havn't tried it yet. I seem to take one step forward and two back. Last

Re: Spreadsheet

=SUM(A1:A14) Not =SUM(A1;A14) On Sat, 24 Jun 2023 12:10:33 +0200 wrote --- Thanks Martin, moving on I am now having trouble summimg a column of numbers (each being the result of a multiplication). In the formula bar Iwant to  type sum(A1;A8) but ~I am trying to chick on the

Re: Spreadsheet

Is the answer to "Copy Paste Special"?Sent from my Galaxy Original message From: Martin Groenescheij Date: 23/06/2023 18:03 (GMT+00:00) To: Users Cc: frank.ledb...@sky.com Subject: Re: Spreadsheet             Could it be that one ore both Cells is

Re: Spreadsheet

Could it be that one ore both Cells is formatted as Text?If you copy values from another source it could be copied as text which you could check in the formula bar, it shows then with a leading apostrophe e.g. ‘123Simple way to check is to enter

Re: Spreadsheet Issue

Hello Conner, By any chance are you using any kind of clipboard manager software? There may be a conflict between it and OO. If you are using one, try disabling it to see if the problem persists. Regards, Leon On Sun, Dec 25, 2022 at 12:50 PM Conner Cardwell wrote: > Hello and Merry

Re: Spreadsheet

Karl, If I correctly understand your objective, try these steps: 1. Enter the desired multiplier in any cell (e.g., 1.05 for a 5% increase). 2. Select that cell and copy to the clipboard (i.e., Edit > Copy). 3. Select all the cells you want to modify (e.g., click on the first cell and

Re: Spreadsheet

I am trying to increase a number in a column by a percentage but I want to increase the entire column. On 2022-03-29 08:48, Alan B wrote: You want to... a) increase certain entries by a percentage - or - b) increase a percentage already in the spread sheet If a) then enter the percentage

Re: Spreadsheet

You want to... a) increase certain entries by a percentage - or - b) increase a percentage already in the spread sheet If a) then enter the percentage in a cell of your choice, remember percentages less than 100% are entered as fractions, e.g. 20% is entered as .2, 45% as .45, and so on.

Re: Spreadsheet to word document

You can convert to a PDF. On March 11, 2021 at 9:00:27 AM, Barry Hooks (wbho...@gmail.com) wrote: Can you convert or save an existing spreadsheet in Open Office to a word/text document? Thank you. Barry Hooks Sent from my iPad

Re: Spreadsheet Formula Hiding "0"

Hi, you can also format those cells using the user defined cell format # to suppress so called leading zeroes in cells. ->format->cells->numbers->Format Code: # Kind regards, Joost Am 02.06.2020 um 00:51 schrieb David Robley: There is an option to globally suppress display of zeros - see

Re: Spreadsheet Formula Hiding "0"

There is an option to globally suppress display of zeros - see Tools | Options | OpenOffice Calc | View and uncheck Zero Values in the Display section. Since you are not subscribed to this list you may not see all the replies to your query. To subscribe to Apache OpenOffice mailing lists go

Re: Spreadsheet

Hi Gerry, you can work wit cell templates. Therefor open the template dialog by using function key F11 and create a new one by pressing the right mouse button ontop of this dialog. Then select the "New" link. Hint: Assinging a name to this template helps... The function you want to use then

Re: Spreadsheet

On 10/31/19 11:35 AM, Johnny Rosenberg wrote: Den ons 30 okt. 2019 kl 23:29 skrev Stag Mist : Dear OpenOffice Team, I'm using OpenOffice on a Mac. My problem is that when I open the app it automatically opens a Text Document. Is there any option to change it from opening a Text Document to

Re: Spreadsheet

Den ons 30 okt. 2019 kl 23:29 skrev Stag Mist : > Dear OpenOffice Team, > > I'm using OpenOffice on a Mac. My problem is that when I open the app it > automatically opens a Text Document. Is there any option to change it from > opening a Text Document to a opening Spreadsheet? How can I set this?

Re: Spreadsheet

Den tis 15 okt. 2019 kl 18:19 skrev David Walters : > Hi, > > Can you send me the link for the Apache Open Office spreadsheet extension. > I don’t seem to be able to locate it on your website. > Do you mean this? https://extensions.openoffice.org/en/search?f%5B0%5D=field_project_application%3A4

Re: Spreadsheet

David, spreadsheets are part of the application. Just click on NEW and in the little drop down click spreadsheet. -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 On Tue, Oct 15, 2019 at 11:19 AM David Walters wrote: > > Hi, > > Can you send me the link

Re: Spreadsheet problem

Forwarding reply to users list Sent from my iPhone > On Apr 25, 2019, at 7:19 PM, Dee Thompson wrote: > > What version of Apache OpenOffice are you using? 4.1.6 > > What operating system (OS) are you using? Windows 10 > > What version of the OS are you using? Windows 10 version 1803 > >

Re: Spreadsheet problem

Dee, What version of Apache OpenOffice are you using? What operating system (OS) are you using? What version of the OS are you using? How big is the file of your spreadsheet? How much RAM does your computer have? Please respond to the users list so that we can assist you. Steve > On Apr

Re: Spreadsheet printing

On 01/03/18 7:55 AM, walter gusky wrote: When I make a spreadsheet I want to print it in Landscape form to get more columns on a page. How do I make that happen? Walt G Go to Format -> Page and tick the Landscape option -

Re: Spreadsheet

2018-02-07 19:17 GMT+01:00 steve ronneberg : > I made a spreadsheet but I am unable to send it or upload it anywhere... I > saved to my desktop and tried sending from there and still nothing > I can't see that this is an Apache OpenOffice issue, unless you tried to

Re: Spreadsheet issues (attachment)

On 1/11/2018 11:06 AM, A Appliance, Inc. wrote: > Hello, > > When I open a new document for the Spreadsheet - it's micro (very small) > I don't understand why and I would like to know how to correct this > issue.  (ATTACHMENT BELOW) > > Will you please help me with this? > > > Thank you so

Re: Spreadsheet application not working

hello. i coppied the information that you need from readme file. hope that help and God bless you. Is OpenOffice really free for any user? OpenOffice is free for use by everybody. You may take this copy of OpenOffice and install it on as many computers as you like, and use it for any purpose

Re: Spreadsheet application not working

Thank you Keith. I will use the URL you sent and reinstall the program. Most appreciative, Dan Tressler Sent from my iPhone > On Sep 29, 2017, at 12:25 PM, Keith N. McKenna > wrote: > >> On 9/29/2017 1:25 PM, Dan Tressler wrote: >> Message indicates my subscription

Re: Spreadsheet application not working

On 9/29/2017 1:25 PM, Dan Tressler wrote: > Message indicates my subscription has expired. AARP indicated this software > was free. > Is there a charge for the use of the programs associated with Apache Open > Office? > Dan Tressler > dtress4...@gmail.com > > Sent from my iPhone > No there is

Re: spreadsheet file corrupted, need to recover data

i forgot to say, make sure that Save AutoRecovery information every: be checked in your openoffice tools, options, load-save, general. On 9/14/17, zahra a wrote: > hi. > > if you use windows newer than xp and recover to previous state, just > open properties of your

Re: spreadsheet file corrupted, need to recover data

hi. if you use windows newer than xp and recover to previous state, just open properties of your file, then find previous windows in the security tab and press okay. if you need to change default encoding, just right click on your file and find open with, then select openoffice calc. it asks

Re: Spreadsheet single cell (word) replacement

At 09:00 13/08/2017 -0700, James Jenkins wrote: I have made my spread sheet (I've made many, new problem). I need to replace a single word in cells, the wood "side" with "time".no matter what cell I go into...every time, it will not replace. I've tried every thingno luck. I'm not

RE: Spreadsheet

You type in cell C30 the following =sum(c1:c29) Sent from my Samsung Galaxy S6 smartphone. Original message From: Michael Warvill Date: 3/17/17 13:33 (GMT+02:00) To: users@openoffice.apache.org Subject: Spreadsheet Please can you tell me

Re: Spreadsheet

On 17/03/17 10:20 PM, Michael Warvill wrote: Please can you tell me how to set up a calculation to enable me to: example total all of column C Rows 1 to 29 into row 30? Without using 1+2+3. Can't find answer anywhere. SUM(C1:C29) Thank you Mike W

Re: Spreadsheet - Setting Decimal Point

I found this in my drafts but don't know what it was about.Are you Edwin Irving or Alex Edwin? I know an Alex, but cannot place an Edwin. If you could send me some feedback, would be nice.Thanks; Herb Eichner of heichn...@gmail.com and text to 780 700 6242Home phone 780 433 5521Sent from my

Re: spreadsheet locked documents

At 07:03 21/10/2016 -0400, Carol Noname wrote: I have 4.1.2. Had a spreadsheet all made up, was fine, but I added a new column on the 10th, and the squares were all outlined in red. If I placed the arrow on one, info popped up. I can't make them go away, and actually, not sure what I did, but

Re: Spreadsheet - Setting Decimal Point

On 17/10/16 10:46 AM, Edwin Irving wrote: I want to have columns I set as currency to assume the last two digits should be behind a decimal point. Spreadsheets don't assume things, it expect to get clear instructions and you are the instructor. For example, if I input 1257, I

Re: Spreadsheet won't open

On 29/09/16 3:17 AM, Sabrina Massie wrote: One of my spreadsheets is no longer showing in my documents. I was able to find it in recents but it is light gray and it won't open. It doesn't show up on finder or trash. It just disappeared on me. Please help! If the file is no longer there,

Re: Spreadsheet

On Thu, 25 Aug 2016 12:35:54 -0400 wrote: > I am having difficulty getting the grid lines on a spreadsheet to print. > > Please advise > > Bob Reynolds > In Calc Select area to be printed, then /Format /Print Ranges: Define. Then /Format /Page : Sheet tab, under

Re: spreadsheet password

On 8/20/2016 6:09 AM, MICHELLE BARTON wrote: Hi Can anyone please tell me how I can access my saved spreadsheets without my password, ive tried every password ive ever used and searched the internet on recovery and have found nothing, please advise If the password was in your mind at one

RE: spreadsheet password

Michelle wrote: >tried every password ive ever used and searched the internet on recovery and >have found nothing, please advise a) How much are you willing to pay for password recovery? b) How long are you willing to wait for said password to be recovered? jonathon

Re: spreadsheet password

1. Sadly, your other responders are right: The task is close to impossible -- brute-force trial and error is the only way. 2. For the future, my suggestion is to either NEVER use passworded files, or use software like Keypass to create and store strong passwords that you won't forget. Just

Re: spreadsheet password

In addition to what Dennis says (below), it may be possible to decrypt your file using brute force; that process may tie your computer up for days/weeks while it tries every combination. While this is possible, it is hardly practicable. I remind you that passwords are case sensitive, just in

RE: spreadsheet password

The Save with Password functions of Apache OpenOffice use serious encryption techniques that require the original password to be known. There is no means to recover the password from the files. There is no means to recover the file without discovering the password. The weakest point in this

Re: Spreadsheet - extra sheets in preview

Try redefining your print area. Jim Plante > On Jul 28, 2016, at 8:58 PM, Moises wrote: > > > I am working on a huge financial report and I copy and pasted a table I had > onto the other pages and so far I have 6 pages but all of a sudden I have 7 > extra pages

Re: spreadsheet program

I had been using opened up to the right size. So he had me set it to 100%, and that was it. Now it's fine. -Original Message- From: Richard Detwiler Sent: Tuesday, June 14, 2016 7:57 AM To: users@openoffice.apache.org Subject: Re: spreadsheet program Carol, You have me and I suspect othe

Re: spreadsheet program

Groenescheij Sent: Monday, June 13, 2016 7:39 PM To: users@openoffice.apache.org Cc: mar...@groenescheij.com Subject: Re: spreadsheet program On 13/06/16 10:01 PM, Carol wrote: I had used your Open Office word processing program for a long time, but your spreadsheet program had serious problems

Re: spreadsheet program

: Monday, June 13, 2016 7:39 PM To: users@openoffice.apache.org Cc: mar...@groenescheij.com Subject: Re: spreadsheet program On 13/06/16 10:01 PM, Carol wrote: I had used your Open Office word processing program for a long time, but your spreadsheet program had serious problems. And what

Re: spreadsheet program

On 06/13/2016 06:39 PM, Martin Groenescheij wrote: On 13/06/16 10:01 PM, Carol wrote: I had used your Open Office word processing program for a long time, but your spreadsheet program had serious problems. And what are the serious problems? I believe I wrote to you about it but never got

Re: spreadsheet program

On 13/06/16 10:01 PM, Carol wrote: I had used your Open Office word processing program for a long time, but your spreadsheet program had serious problems. And what are the serious problems? I believe I wrote to you about it but never got an answer. You believe you wrote, but I can't find

Re: Spreadsheet comments

At 20:24 03/06/2016 -0700, Ron Patterson wrote: ... I use a lot of Comments. When I right click on some cells, I get the normal drop down menu that lets me leave a comment. Other cells I often get a different drop down menu without the comment commands? The nature of the rogue menu will

Re: Re spreadsheet

I suppose, that you are working on a Mailattachment. Safe it somwhere on your computer and send the copy back. Am 26.04.2016 um 11:35 schrieb joanne.winson: Hello I have opened a spreadsheet in office that was sent to me. Now I have completed it I need to sent back...but is only available

Re spreadsheet

Hello I have opened a spreadsheet in office that was sent to me. Now I have completed it I need to sent back...but is only available to view as lists instead of spreadsheet. Also I can't print off the spreadsheet...that also prints off as a list?? Please help!!  RegardsJoanne Winson. Sent

Re: Spreadsheet

On Wed, Feb 24, 2016 at 10:31 AM, wrote: > My spreadsheet is open to a large size (boxes) and I cannot change the > size. Please advise > Arlene if I understand correctly it seems your spreadsheet is zoomed to too great a size. Check Figure 1 at the top of page 6 in this

Re: Spreadsheet

Right-click in the cell. Choose “Format cells…” from the context menu. Select the “Number” tab. In the lower part of the window, you’ll find a box named “Format code” which will read “MM/DD/YY” Change the slashes to dashes, and hit “OK”. > On Nov 23, 2015, at 1:09 PM, Charles Sommervold

Re: [Spreadsheet] problem

At 16:54 29/05/2015 +0300, Algis Noname wrote: I found a mistake. See file in the attachment. There is no mistake - apart from in your understanding of what is happening. Numbers are stored in computer in binary form, so what looks like a precise number that terminates - such as your two

Re: Spreadsheet

Google Spreadsheets tutorial and see what happens. Its amazing what you can teach yourself , instead orf expecting everyone to do your research and spoon feed you. On Sat, Feb 28, 2015 at 9:24 AM, Dale Erwin dale.er...@casaerwin.org wrote: Believe it or not, I have never felt the need to use a

Re: Spreadsheet

If you go to tutorialsforopenoffice.org/tutorial/Spreadsheet_Basics.html http://www.tutorialsforopenoffice.org/tutorial/Spreadsheet_Basics.html you will find a fairly decent guide. Bruce Pierson *The Department of Redundancy Department* On Sat, Feb 28, 2015 at 12:24 PM, Dale Erwin

Re: Spreadsheet Problem

Sorry Gary, The spreadsheet is locked, therefore nobody can help without the password. Unless you have a password none of the cells will register, perhaps that is the problem. I assume you didn't create this spreadsheet form, so you need a password. Take Care. Scooter College Park, MD USA

RE: Spreadsheet Problem

] Sent: Monday, January 26, 2015 06:50 To: users@openoffice.apache.org Subject: Re: Spreadsheet Problem Sorry Gary, The spreadsheet is locked, therefore nobody can help without the password. Unless you have a password none of the cells will register, perhaps that is the problem. I assume you didn't

Re: Spreadsheet Problem

At 14:09 26/01/2015 +, Gary Jackson wrote: I don't seem to be able to complete the attached spreadsheet. Whatever I try to enter in the mileage column gives me the box saying If this is your first claim etc. Any ideas? Here's a potential workaround: o Open the spreadsheet in

Re: spreadsheet transpose

On Tue, 11 Nov 2014 02:32:19 -, Julian Thomas j...@jt-mj.net wrote: I did search AOO help for both transpose and rotate - no useful results. after i had selected 'openoffice calc' from the drop-down list in the upper-left corner of the help window, a search for 'transpose' retrieved the

Re: spreadsheet transpose

I've always rather thought a computer to be feminine--being a most demanding mistress who requires you give her a lot, lot of your time, but who rewards you with what you want from time to time. Best wishes, Anthony J. Rudgers Orlando, FL: Posted Nov. 10, 2014; 7:16 pm -Original

Re: spreadsheet transpose

At 18:53 10/11/2014 -0500, you wrote: Is there a quick way to transpose a spreadsheet so the columns become rows and vice versa? Yes. o Select the relevant range. o Copy the material. o Paste the material where you want it, but using Edit | Paste Special... (or right-click | Paste Special...

Re: spreadsheet transpose

On Nov 10, 2014, at 19:24, Dan Lewis elderdanle...@gmail.com wrote: Did you look in Help to get your information? In LibreOffice I searched help for transpose tables. AOO should have a similar entry in its Help. I did search AOO help for both transpose and rotate - no useful results. —

Re: spreadsheet transpose

Am 11.11.2014 um 03:32 schrieb Julian Thomas: On Nov 10, 2014, at 19:24, Dan Lewis elderdanle...@gmail.com wrote: Did you look in Help to get your information? In LibreOffice I searched help for transpose tables. AOO should have a similar entry in its Help. I did search AOO help for

Re: spreadsheet transpose

On 11-11-2014 17:06, Josef Latt wrote: Am 11.11.2014 um 03:32 schrieb Julian Thomas: On Nov 10, 2014, at 19:24, Dan Lewis elderdanle...@gmail.com wrote: Did you look in Help to get your information? In LibreOffice I searched help for transpose tables. AOO should have a similar entry in its

Re: Spreadsheet formulae

At 12:17 01/09/2014 +0100, Michael Gyles wrote: I am trying to create a formula using the Logical IF function to show; In cell C2, IF cell B2 is blank show C2 as blank otherwise sum cell B2 minus B1. but can't get the syntax right whatever I try. That depends on what you mean by blank! If

Re: spreadsheet problem

Hopefully, you did not save it after sorting . . . Did you try Edit, Undo? Tana McColl wrote: Hello, I use the open office spreadsheet for work. Today I went to the data tab, hit the sort tab, column A, ascending…then ok (or whatever is says to begin the process). I have certain rows

Re: spreadsheet problem

If you closed without saving, the original pre-sorted file should be available . . . rather than close the spreadsheet, try to open a second copy of it (read only message will appear). Hopefully, your information will be there - just save the read only with a new file name. As for backup, go