Re: COPY function noty working on SPREADSHEETS

2023-06-11 Thread Rory O'Farrell
On Sun, 11 Jun 2023 17:29:37 +0100 Rory O'Farrell wrote: > On Sun, 11 Jun 2023 11:50:05 -0400 > frank wrote: > > > The “COPY” function stopped working on my SPREADSHEETS > > > > Pressing the COPY function causes APACHE to “freeze up” > > > > HOW ca

Re: COPY function noty working on SPREADSHEETS

2023-06-11 Thread Rory O'Farrell
On Sun, 11 Jun 2023 11:50:05 -0400 frank wrote: > The “COPY” function stopped working on my SPREADSHEETS > > Pressing the COPY function causes APACHE to “freeze up” > > HOW can this be corrected? > > Sent from Mail for Windows > See https://forum.openoffice.org/en/

COPY function noty working on SPREADSHEETS

2023-06-11 Thread frank
The “COPY” function stopped working on my SPREADSHEETS Pressing the COPY function causes APACHE to “freeze up” HOW can this be corrected? Sent from Mail for Windows

Re: open office software SPREADSHEETS

2019-10-25 Thread John Clipper
Dear David, I have been to the link you provided via Google . No mention of SORT. Also I have never seen the TABLE 1 title appear on a spreadsheet. Perhaps it’s from an older version. I am now going to check out Alan’s utube presentation. Thanks > On Oct 24, 2019, at 5:11 PM, David

Re: open office software SPREADSHEETS

2019-10-25 Thread John Clipper
ote: > >> I will gladly pay for help. >> >> nearly 2 hours spent on - >> >> 1. How to sign on to a Forum in order to ask a question on Forum re >> spreadsheets. No success. >> >> 2. found some “answers”. without signing on. See #1 >

Re: open office software SPREADSHEETS

2019-10-24 Thread Alan B
nearly 2 hours spent on - > > 1. How to sign on to a Forum in order to ask a question on Forum re > spreadsheets. No success. > > 2. found some “answers”. without signing on. See #1 > > 3. The question was about how to sort data in Col A > > 4. I have used other features

Re: open office software SPREADSHEETS

2019-10-24 Thread Steven Ahlers
if you have any further questions. Sent from my iPhone > On Oct 24, 2019, at 9:29 AM, John Clipper wrote: > > I will gladly pay for help. > > nearly 2 hours spent on - > > 1. How to sign on to a Forum in order to ask a question on Forum re > spreadsheets. No suc

Re: open office software SPREADSHEETS

2019-10-24 Thread David Belina
Wiki.openoffice.org has this: The first step in sorting data is to select the data that you want to sort. To sort the data in Table 1, select the cells from A1 to G16—if you include the column headers, indicate this in the sort dialog. Use Data > Sort to open the Sort dialog. You can sort by

open office software SPREADSHEETS

2019-10-24 Thread John Clipper
I will gladly pay for help. nearly 2 hours spent on - 1. How to sign on to a Forum in order to ask a question on Forum re spreadsheets. No success. 2. found some “answers”. without signing on. See #1 3. The question was about how to sort data in Col A 4. I have used other features

Re: Spreadsheets

2019-04-18 Thread John Toy
. > > I use OpenOffice Calc and save my spreadsheets. The saved files appear to > be Excel files. I don't have Excel. Why are the files for a program I do > not have? > > If the above describes your issue then the "problem" is the files are saved > in Excel format instead

OO Spreadsheets not saving

2019-04-18 Thread Lucetta
than OO My question today is can I do anything to stop my fairly simple spreadsheets from not accepting changes when I save as with a new title or when I save them in Excel. I always save a changed document with the current date added to the title. I only discovered this in the last week

Re: Spreadsheets

2019-04-18 Thread Brian Barker
At 06:27 18/04/2019 -0400, Alan Boba wrote: On Wed, Apr 17, 2019 at 12:46 PM John Noname wrote: When I backup my spreadsheets they get noted as unlicensed Excel files. As a consequence I cannot open these files for restoration. I do not have Microsoft Office installed on my computer

Re: Spreadsheets

2019-04-18 Thread Alan B
Not certain I'm understanding your question so I will answer similar question and hope it is what you mean. I use OpenOffice Calc and save my spreadsheets. The saved files appear to be Excel files. I don't have Excel. Why are the files for a program I do not have? If the above describes your

Spreadsheets

2019-04-17 Thread Mavjon
When I backup my spreadsheets they get noted as unlicensed Excel files. As a consequence I cannot open these files for restoration. I do not have Microsoft Office installed on my computer. Why cannot the files be shown as OpenOffice? Thanks for any help you can give. Sent from Mail for Windows

Re: Is there a way to change the assigned attributes when using Find & Replace function in AOO-Calc Spreadsheets?

2019-03-14 Thread Martin Groenescheij
also selected: Search in: "Values" (near the bottom of that window). ** Is there a way to change / replace the assigned attributes when using Find & Replace function in AOO-Calc Spreadsheets? Regards, VinceB. ---

Re: Is there a way to change the assigned attributes when using Find & Replace function in AOO-Calc Spreadsheets?

2019-03-14 Thread Joost Andrae
ewer Options, with none of the boxes checked. I have also selected: Search in: "Values" (near the bottom of that window). ** Is there a way to change / replace the assigned attributes when using Find & Replace function in AOO-Calc Sprea

Re: Is there a way to change the assigned attributes when using Find & Replace function in AOO-Calc Spreadsheets?

2019-03-14 Thread Martin Groenescheij
ample, if the >> cell presently shows: >> >> Goes >> >> I want it to be replaced with: >> >> *Goes* >> >> That is, add the *bold* attribute to the existing data. >> >> In the Find & Replace dialogue

Re: Is there a way to change the assigned attributes when using Find & Replace function in AOO-Calc Spreadsheets?

2019-03-14 Thread WA.TWORSX via AOL
lso selected: Search in: "Values" (near the bottom of that window). ** Is there a way to change / replace the assigned attributes when using Find & Replace function in AOO-Calc Spreadsheets? Regards, VinceB.

Re: Is there a way to change the assigned attributes when using Find & Replace function in AOO-Calc Spreadsheets?

2019-03-14 Thread Keith N. McKenna
rch in: "Values" (near the bottom of that window). ** > > Is there a way to change / replace the assigned attributes when using > Find & Replace function in AOO-Calc Spreadsheets? > > Regards, > > VinceB. > > > signature.asc Description: OpenPGP digital signature

Re: Is there a way to change the assigned attributes when using Find & Replace function in AOO-Calc Spreadsheets?

2019-03-14 Thread David Belina
tom of that window). ** Is there a way to change / replace the assigned attributes when using Find & Replace function in AOO-Calc Spreadsheets? Regards, VinceB.

Is there a way to change the assigned attributes when using Find & Replace function in AOO-Calc Spreadsheets?

2019-03-14 Thread WA.TWORSX via AOL
tom of that window). ** Is there a way to change / replace the assigned attributes when using Find & Replace function in AOO-Calc Spreadsheets? Regards, VinceB.

Re: Mac vs Linux -- Limits on number of rows in spreadsheets?

2018-12-22 Thread Brian Barker
At 10:52 22/12/2018 -0500, Dwight Hines wrote: Mac vs Linux --Limits on number of rows in spreadsheets? See https://wiki.openoffice.org/wiki/Documentation/FAQ/Calc/Miscellaneous/What%27s_the_maximum_number_of_rows_and_cells_for_a_spreadsheet_file%3F - which says 1,048,576, i.e.2^20. It makes

Re: Mac vs Linux -- Limits on number of rows in spreadsheets?

2018-12-22 Thread Rory O'Farrell
sers@openoffice.apache.org > Subject: Mac vs Linux -- Limits on number of rows in spreadsheets? > > Mac vs Linux --Limits on number of rows in spreadsheets? > How to increase? -- Rory O'Farrell - To unsubscribe,

Re: Mac vs Linux -- Limits on number of rows in spreadsheets?

2018-12-22 Thread Wade Smart
I send and get sheets from people who use Mac and never noticed a limit on rows. -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 On Sat, Dec 22, 2018 at 9:52 AM Dwight Hines wrote: > > Mac vs Linux --Limits on number of rows in spreadsheets?

Mac vs Linux -- Limits on number of rows in spreadsheets?

2018-12-22 Thread Dwight Hines
Mac vs Linux --Limits on number of rows in spreadsheets? How to increase?

Re: printing spreadsheets

2018-05-26 Thread Martin Groenescheij
On 26/5/18 7:26 am, Gwyn Crozier-Smith wrote: Could you please tell me how to format and print a spreadsheet, I have tired different things and it does not come out right. For each sheet you need to go to Format -> Print Ranges and select the cells you like to print. If you like to

Re: printing spreadsheets

2018-05-25 Thread Wade Smart
See the printer icon? Immediately to the right is Print Preview. When you are in PP there is a slide button with - and + on either end. That helps you adjust the page to fit. -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 On Fri, May 25, 2018 at 4:26

printing spreadsheets

2018-05-25 Thread Gwyn Crozier-Smith
Could you please tell me how to format and print a spreadsheet, I have tired different things and it does not come out right. Thank You Gwyn Sent from Mail for Windows 10

Re: 4.1.4 and charts in spreadsheets

2017-10-27 Thread Dave Fisher
Hi - Mike replied to me privately and I have attached the response to #127568# Regards, Dave > On Oct 27, 2017, at 12:17 AM, Andrea Pescetti wrote: > > Mike wrote: >> since upgrading to 4.1.4 charts that I create from spreadsheet data (and >> have been doing for years

Re: 4.1.4 and charts in spreadsheets

2017-10-27 Thread Ian King
This seems to be a critical bug for me because charts are essential to my use of Calc. I guess I should not upgrade until this bug is fixed? On Oct 27, 2017, at 12:17 AM, Andrea Pescetti wrote: Mike wrote: > since upgrading to 4.1.4 charts that I create from spreadsheet

Re: 4.1.4 and charts in spreadsheets

2017-10-27 Thread Andrea Pescetti
Mike wrote: since upgrading to 4.1.4 charts that I create from spreadsheet data (and have been doing for years satisfactorily) are not saved with the spreadsheet as was the case pre 4.1.4 This seems to be the bug currently under investigation at https://bz.apache.org/ooo/show_bug.cgi?id=127568

Re: 4.1.4 and charts in spreadsheets

2017-10-26 Thread Dave Fisher
Hi Mike, If you can share the document and the steps to reproduce the issue in the bug reporting database - https://bz.apache.org/ooo/ that would be very helpful in fixing this regression. Thanks, Dave > On Oct 26, 2017, at 6:39 PM, Mike wrote: > > Hi, > >

4.1.4 and charts in spreadsheets

2017-10-26 Thread Mike
Hi, since upgrading to 4.1.4 charts that I create from spreadsheet data (and have been doing for years satisfactorily) are not saved with the spreadsheet as was the case pre 4.1.4 This is more of an irritant than a problem, the charts are created as useful visual summaries of data, and are

Recovery of Open Office .odt & spreadsheets

2017-09-01 Thread Grant Wutzke
Hello, First of all, thank you to everyone who works on this program. I think Open Office is wonderful. My problem is my MacBook Pro recently bit the dust, the week before I go back to teaching. I rarely, if ever backed up files (I will now!) and I was lucky enough to find a program that is

Re: Crashing - Text Documents & Spreadsheets

2017-02-26 Thread nasrin khaksar
ic.php?f=74=12426 >>> !-) >>> >>> Hagar >>> >>> Le 31/01/2017 à 08:45, Rory O'Farrell a écrit : >>>> On Mon, 30 Jan 2017 17:34:30 -0500 >>>> M B <mailboxe...@gmail.com> wrote: >>>> >>>>> I am using Op

Re: Crashing - Text Documents & Spreadsheets

2017-02-05 Thread Martin Groenescheij
rote: I am using Open Office on a Windows 10 machine (word processing and spreadsheets). It constantly crashes and I often lose information. I am going to have to go back to Microsoft it is so problematic. Please advise what the problem might be. mb It can happen that an installation of Ope

Re: Crashing - Text Documents & Spreadsheets

2017-02-02 Thread nasrin khaksar
org/en/forum/viewtopic.php?f=74=12426 > !-) > > Hagar > > Le 31/01/2017 à 08:45, Rory O'Farrell a écrit : >> On Mon, 30 Jan 2017 17:34:30 -0500 >> M B <mailboxe...@gmail.com> wrote: >> >>> I am using Open Office on a Windows 10 machine (word processing an

Re: Crashing - Text Documents & Spreadsheets

2017-01-31 Thread Hagar Delest
Correct link: https://forum.openoffice.org/en/forum/viewtopic.php?f=74=12426 !-) Hagar Le 31/01/2017 à 08:45, Rory O'Farrell a écrit : On Mon, 30 Jan 2017 17:34:30 -0500 M B <mailboxe...@gmail.com> wrote: I am using Open Office on a Windows 10 machine (word processing and spread

Re: Crashing - Text Documents & Spreadsheets

2017-01-30 Thread Rory O'Farrell
On Mon, 30 Jan 2017 17:34:30 -0500 M B <mailboxe...@gmail.com> wrote: > I am using Open Office on a Windows 10 machine (word processing and > spreadsheets). It constantly crashes and I often lose information. I am > going to have to go back to Microsoft it is so problematic. >

Crashing - Text Documents & Spreadsheets

2017-01-30 Thread M B
I am using Open Office on a Windows 10 machine (word processing and spreadsheets). It constantly crashes and I often lose information. I am going to have to go back to Microsoft it is so problematic. Please advise what the problem might be. mb

Re: can't print out spreadsheets on HP printer now

2017-01-18 Thread Martin Groenescheij
. That has not been my experience. I have had multi-sheet spreadsheets with all print ranges blank (undefined or "default") and they would not print. On top of that, they may have started out printing, but then for some unexplained reason, stopped printing - still with the blank prin

Re: can't print out spreadsheets on HP printer now

2017-01-18 Thread Girvin Herr
ulti-sheet spreadsheets with all print ranges blank (undefined or "default") and they would not print. On top of that, they may have started out printing, but then for some unexplained reason, stopped printing - still with the blank print ranges. I had to define a print range of &q

Re: can't print out spreadsheets on HP printer now

2017-01-17 Thread Martin Groenescheij
ed just do a print preview. That is probably what the vast majority of users need. The way it is implemented now is a PITA. If you have 10 sheets, you need to set Print Ranges for all 10. That is excessively labor intensive, which is prone to error. In complex spreadsheets you probably have m

Re: can't print out spreadsheets on HP printer now

2017-01-17 Thread Girvin Herr
ve used Open Office for several years and it is a great program. However, lately I can't get spreadsheets to print to my HP Officejet 4500 printer. I tried reinstalling the printer, but still nothing prints. When I select print from the drop down or the icon on an OO document nothing shows on t

Re: can't print out spreadsheets on HP printer now

2017-01-17 Thread tedandellen
; texteditor ... > > Am 16.01.2017 um 18:58 schrieb tedandel...@cox.net: > > Hi, > > I have used Open Office for several years and it is a great program. > > However, lately I can't get spreadsheets to print to my HP Officejet 4500 > > printer. I tried reinstalling the

Re: can't print out spreadsheets on HP printer now

2017-01-17 Thread tedandellen
> On 01/16/2017 09:58 AM, tedandel...@cox.net wrote: > > Hi, > > I have used Open Office for several years and it is a great program. > > However, lately I can't get spreadsheets to print to my HP Officejet 4500 > > printer. I tried reinstalling the printer, but still not

Re: can't print out spreadsheets on HP printer now

2017-01-16 Thread Girvin Herr
n 01/16/2017 09:58 AM, tedandel...@cox.net wrote: Hi, I have used Open Office for several years and it is a great program. However, lately I can't get spreadsheets to print to my HP Officejet 4500 printer. I tried reinstalling the printer, but still nothing prints. When I select print from t

Re: can't print out spreadsheets on HP printer now

2017-01-16 Thread Andrea
What happens if you try to print from another program? Webbrowser, texteditor ... Am 16.01.2017 um 18:58 schrieb tedandel...@cox.net: Hi, I have used Open Office for several years and it is a great program. However, lately I can't get spreadsheets to print to my HP Officejet 4500 printer. I

can't print out spreadsheets on HP printer now

2017-01-16 Thread tedandellen
Hi, I have used Open Office for several years and it is a great program. However, lately I can't get spreadsheets to print to my HP Officejet 4500 printer. I tried reinstalling the printer, but still nothing prints. When I select print from the drop down or the icon on an OO document nothing

Re: spreadsheets

2016-04-28 Thread Julian Thomas
> On Apr 28, 2016, at 08:25, Tom Kennedy <tkenn...@kennetic.org> wrote: > >> Bought a new Mac laptop and am suddenly dealing with Numbers displaying my >> spread sheets. How do I get Open Office to be the default for spreadsheets? >> Thanks tk In fin

Fwd: spreadsheets

2016-04-28 Thread Tom Kennedy
Tom Kennedy Kennetic 26 Hampton Hills Lane Richmond, VA 23226 Cell 804.519.3468 Land 804.282.4102 tkenn...@kennetic.org > Begin forwarded message: > > From: Tom Kennedy <tkenn...@kennetic.org> > Subject: spreadsheets > Date: April 28, 2016 at 8:20:52 AM EDT > To: use

[ PROPOSAL ] A new REVERSE string function for Spreadsheets

2016-01-15 Thread Ross Murray
I hope my suggestion reaches its intended target, and meets your community's standards for submission of additional functions. I would like to see a REVERSE function, which returns a new string with characters in reverse order to the target string. I am attempting to remove duplicates after

Re: [ PROPOSAL ] A new REVERSE string function for Spreadsheets

2016-01-15 Thread Maurice Howe
Oh, that's easy. The facility already exists -- No need to "add" a feature. I often have lists of names that need sorting is various ways. TABLES are the answer. It may be cumbersome to make a table from a list, but it really pays off for applications like yours. Table elements are usually

RE: [ PROPOSAL ] A new REVERSE string function for Spreadsheets

2016-01-15 Thread Dennis E. Hamilton
] A new REVERSE string function for Spreadsheets > > > > On Jan 15, 2016, at 11:49, Ross Murray <rossmurray.a...@gmail.com> > wrote: > > > > I would like to see a REVERSE function, which returns a new string > with > > characters in reverse order to the targe

Re: [ PROPOSAL ] A new REVERSE string function for Spreadsheets

2016-01-15 Thread Julian Thomas
> On Jan 15, 2016, at 11:49, Ross Murray wrote: > > I would like to see a REVERSE function, which returns a new string with > characters in reverse order to the target string. > > I am attempting to remove duplicates after merging many files to create a > very large

Re: Spreadsheets

2015-12-26 Thread Lucetta
ters useful HTH Lucetta > On Dec 23, 2015, at 3:55 PM, elderdanlewis <elderdanle...@gmail.com> wrote: > > > > Original message > From: Dale Erwin <dale.er...@casaerwin.org> > Date:12/23/2015 2:49 PM (GMT-05:00) > To: users@openoffice

Re: Spreadsheets

2015-12-23 Thread Lucetta
t;I am writing a chapter, Planning/Designing your Database, for LibreOffice. > Since many people use spreadsheets and shy away from databases, I wanted > something to compare the two. The general conception seems to be creating > databases is difficult, and creating spreadsheets

Re: Spreadsheets

2015-12-23 Thread Dan Lewis
You have given me the information that I was looking for. Thanks! I am writing a chapter, Planning/Designing your Database, for LibreOffice. Since many people use spreadsheets and shy away from databases, I wanted something to compare the two. The general conception seems

Re: Spreadsheets

2015-12-23 Thread Dale Erwin
On 12/23/2015 10:13 AM, Dan Lewis wrote: You have given me the information that I was looking for. Thanks! I am writing a chapter, Planning/Designing your Database, for LibreOffice. Since many people use spreadsheets and shy away from databases, I wanted something to compare the two

Re: Spreadsheets

2015-12-23 Thread elderdanlewis
Original message From: Dale Erwin <dale.er...@casaerwin.org> Date:12/23/2015 2:49 PM (GMT-05:00) To: users@openoffice.apache.org Subject: Re: Spreadsheets On 12/23/2015 10:13 AM, Dan Lewis wrote: > You have given me the information that I was looking for. Thanks

Re: Spreadsheets

2015-12-23 Thread Keith N. McKenna
Dale Erwin wrote: > On 12/23/2015 10:13 AM, Dan Lewis wrote: >> You have given me the information that I was looking for. Thanks! >> I am writing a chapter, Planning/Designing your Database, for >> LibreOffice. Since many people use spreadsheets and shy away from &

Re: Spreadsheets

2015-12-23 Thread Lucetta
.ca> > Date:12/23/2015 11:01 AM (GMT-05:00) > To: users@openoffice.apache.org > Subject: Re: Spreadsheets > > Hi good idea. Where would I find your writing when it is completed? I'm > looking for just such a manual. > > Kind regards > Lucetta > > > &g

Re: Spreadsheets

2015-12-23 Thread elderdanlewis
I will send you a link when I finish. Dan Original message From: Lucetta <luce...@lucetta.ca> Date:12/23/2015 11:01 AM (GMT-05:00) To: users@openoffice.apache.org Subject: Re: Spreadsheets Hi good idea. Where would I find your writing when it is completed? I'm l

Re: Spreadsheets

2015-12-22 Thread Martin Groenescheij
On 23-Dec-15 03:36, elderdanlewis wrote: Is there an equivalent in spreadsheets to relational databases? You can use lookup values from other tabs in that sense you could compare both, but the functionality in a spreadsheet is very limited in comparison with a relational database

Spreadsheets

2015-12-22 Thread elderdanlewis
Is there an equivalent in spreadsheets to relational databases? Or, are they all similar to flat databases?     I am looking for similarities and differences between databases and spreadsheets.  Dan

Re: Problem with Opening Microsoft *.xlsx Spreadsheets with Open Office

2015-01-22 Thread Johnny Rosenberg
2015-01-22 18:10 GMT+01:00 Stephen Knudsen yodocto...@gmail.com: Problem summary: I was sent a spreadsheet saved in *.xlsx format, but I do NOT have Microsoft Excel on my HP machine. When I attempt to open this file using Open Office, it locks up Open Office and pretends to load the

Re: Problem with Opening Microsoft *.xlsx Spreadsheets with Open Office

2015-01-22 Thread Tony Gallas
G'day! My machine runs W8.1 and has no trouble opening .xslx or .docx files using AOO 4.1.1. Just checked it again. Perhaps there is something not related to the different software that is causing the problem? On 23/01/2015 5:00 AM, Johnny Rosenberg wrote: 2015-01-22 18:10 GMT+01:00 Stephen

Problem with Opening Microsoft *.xlsx Spreadsheets with Open Office

2015-01-22 Thread Stephen Knudsen
Problem summary: I was sent a spreadsheet saved in *.xlsx format, but I do NOT have Microsoft Excel on my HP machine. When I attempt to open this file using Open Office, it locks up Open Office and pretends to load the spreadsheet indefinitely (with CPU resources hogged to the tune of 24% .

RE: Problem with Opening Microsoft *.xlsx Spreadsheets with Open Office

2015-01-22 Thread Dennis E. Hamilton
://forum.openoffice.org/, -Original Message- From: Rory O'Farrell [mailto:ofarr...@iol.ie] Sent: Thursday, January 22, 2015 09:27 To: users@openoffice.apache.org Cc: Stephen Knudsen Subject: Re: Problem with Opening Microsoft *.xlsx Spreadsheets with Open Office On Thu, 22 Jan 2015 10:10:34 -0700 Stephen

Re: Problem with Opening Microsoft *.xlsx Spreadsheets with Open Office

2015-01-22 Thread Rory O'Farrell
On Thu, 22 Jan 2015 10:10:34 -0700 Stephen Knudsen yodocto...@gmail.com wrote: Problem summary: I was sent a spreadsheet saved in *.xlsx format, but I do NOT have Microsoft Excel on my HP machine. When I attempt to open this file using Open Office, it locks up Open Office and pretends to

my open office 4.1.1 spreadsheets predicting

2014-10-21 Thread Orn Nnylf
Mr Ron Flynn. Swansea SA3 5LE U.K. Please how do I stop spreadsheets predicting ? the usual advice, to use auto correct options does not work, on my version. please help. Ron Flynn Regards

Re: my open office 4.1.1 spreadsheets predicting

2014-10-21 Thread Brian Barker
At 18:20 21/10/2014 +0100, Ron Flynn wrote: Please how do I stop spreadsheets predicting ? Do you mean the facility where Calc automatically suggests matching input found in the same column? To turn this off, remove the tick from Tools | Cell Content | AutoInput. I trust this helps

Finding text strings in spreadsheets

2014-08-01 Thread David Eccles
In Excel it was easy. I simply specified =COUNTIF(G8:X8;*c*) and I got the number of cells that contained the letter c I discovered in LibreOffice it was =COUNTIF(G8:X8;.*c.*) but in Openoffice whatever combination I try doesn't work. Can anyone help??? Many thanks David Eccles

Re: Finding text strings in spreadsheets

2014-08-01 Thread Brian Barker
At 19:52 01/08/2014 +0100, David Eccles wrote: In Excel it was easy. I simply specified =COUNTIF(G8:X8;*c*) and I got the number of cells that contained the letter c. I discovered in LibreOffice it was =COUNTIF(G8:X8;.*c.*) but in Openoffice whatever combination I try doesn't work. That

Re: open pdf documents and save them as spreadsheets or word documents

2014-07-03 Thread Tom Backer Johnsen
John The solution is much simpler, at least on a Mac. Simply mark, copy, and paste to wherever you want the text to be. However, you loose formatting. As to spreadsheets, copy the table to a temporary file, replace whatever separates the cell contents with a comma or semicolon, and read

open pdf documents and save them as spreadsheets or word documents

2014-07-02 Thread Thomas, John
Can open office translate .pdf files to spreadsheets or word documents? Sincerely, John Thomas John A. Thomas Application Analyst City of Dayton Central Services / Information Technology 130 W. Second Street, Suite 320 Dayton, OH 45402 Phone: 937.333.6321 FAX: 937.333.7835

Re: open pdf documents and save them as spreadsheets or word documents

2014-07-02 Thread Rory O'Farrell
On Wed, 2 Jul 2014 13:39:12 -0400 Thomas, John john.tho...@daytonohio.gov wrote: Can open office translate .pdf files to spreadsheets or word documents? Sincerely, John Thomas No. You need to use an OCR (Optical Character recognition) application to do that. For spreadsheets

Re: open pdf documents and save them as spreadsheets or word documents

2014-07-02 Thread Baccara
Rory O'Farrell wrote: On Wed, 2 Jul 2014 13:39:12 -0400 Thomas, John john.tho...@daytonohio.gov wrote: Can open office translate .pdf files to spreadsheets or word documents? Sincerely, John Thomas No. You need to use an OCR (Optical Character recognition) application

Re: Scrolling within excel spreadsheets.

2014-06-11 Thread 許哲崇
Just fun: If shifting from socialism to capitalism mean something to you, pay good attention. 2014-06-11 2:31 GMT+08:00 johnny smith ka...@krovatka.su: On Tue, 10 Jun 2014 17:54:06 -, Simon Harrison simonharrison...@gmail.com wrote: For some reason since the last update when

Scrolling within excel spreadsheets.

2014-06-10 Thread Simon Harrison
Hello, For some reason since the last update when scrolling left or right within spread sheet pages the screen only ever moves to the right. Not sure if this is a bug in the program or a glitch in my mouse. I'm running a Mac with OSX 10.7.5 and a mighty mouse. Simon Follow me on Facebook

Re: [Bulk] Re: Open Office Spreadsheets

2014-06-06 Thread Alexandro Colorado
Spreadsheets On Thursday 05 June 2014 13:02:11 you wrote: On Thu, 5 Jun 2014 16:41:06 -0400 (EDT) samr...@aol.com wrote: Hello, When I updated to 4.1.0 I noticed my previous spreadsheets in Open Office Calc have disappeared. I'm running Windows 8.1 using Windows Classic Shell. I'm

Re: Open Office Spreadsheets

2014-06-05 Thread Rory O'Farrell
On Thu, 5 Jun 2014 16:41:06 -0400 (EDT) samr...@aol.com wrote: Hello, When I updated to 4.1.0 I noticed my previous spreadsheets in Open Office Calc have disappeared. I'm running Windows 8.1 using Windows Classic Shell. I'm not concerned about the previous sheets since I have them

RE: [Bulk] Re: Open Office Spreadsheets

2014-06-05 Thread Glenn Harder
@openoffice.apache.org Subject: [Bulk] Re: Open Office Spreadsheets On Thursday 05 June 2014 13:02:11 you wrote: On Thu, 5 Jun 2014 16:41:06 -0400 (EDT) samr...@aol.com wrote: Hello, When I updated to 4.1.0 I noticed my previous spreadsheets in Open Office Calc have disappeared. I'm

Re: How do I open spreadsheets in the QuattroPro with extension .wb3 with open office?

2014-04-05 Thread Greg Madden
On Wednesday 02 April 2014 16:59:25 you wrote: On Wed, Apr 2, 2014 at 12:16 PM, Daleep Koshal dal...@ikea.co.bw wrote: How do I open spreadsheets in the QuattroPro with extension .wb3 with open office? I'm not aware of QPro w3b filters for OpenOffice, but there's third party software

Re: How do I open spreadsheets in the QuattroPro with extension .wb3 with open office?

2014-04-03 Thread upscope
On Wednesday, April 02, 2014 05:16:52 PM Daleep Koshal wrote: Hi I have just down loaded Openoffice. How do I open spreadsheets in the QuattroPro with extension .wb3 with open office? Please revert Regards Daleep Koshal --- List

Re: How do I open spreadsheets in the QuattroPro with extension .wb3 with open office?

2014-04-02 Thread Daleep Koshal
Hi I have just down loaded Openoffice. How do I open spreadsheets in the QuattroPro with extension .wb3 with open office? Please revert Regards Daleep Koshal --- List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html To unsubscribe

Re: How do I open spreadsheets in the QuattroPro with extension .wb3 with open office?

2014-04-02 Thread Steve Ahlers
windoz os is very big and requires a dvd to write to when you down load it. Steve Sent from my iPad On Apr 2, 2014, at 8:16 AM, Daleep Koshal dal...@ikea.co.bw wrote: Hi I have just down loaded Openoffice. How do I open spreadsheets in the QuattroPro with extension .wb3 with open office

Re: How do I open spreadsheets in the QuattroPro with extension .wb3 with open office?

2014-04-02 Thread Fernando Cassia
On Wed, Apr 2, 2014 at 12:16 PM, Daleep Koshal dal...@ikea.co.bw wrote: How do I open spreadsheets in the QuattroPro with extension .wb3 with open office? I'm not aware of QPro w3b filters for OpenOffice, but there's third party software which claims to convert it http://www.abadev.com

Re: Being Good, was: RE: Reading and Exporting spreadsheets--another commentary

2014-01-07 Thread Robert Holtzman
On Mon, Jan 06, 2014 at 11:09:55PM -0500, Think wrote: I seldom reply to trolls but I'll make an exception in this case. I have been quietly watching the notes back and forth and have only once or twice ventured into the writing and reading space of this list. Once, someone told me I

Re: Reading and Exporting spreadsheets--another commentary

2014-01-07 Thread Robert Holtzman
On Mon, Jan 06, 2014 at 08:16:10PM -0800, Carmen Putrino wrote: Why am I getting this email? Because you're subscribed to this list. snip -- Bob Holtzman Your mail is being read by tight lipped NSA agents who fail to see humor in Doctor Strangelove Key ID 8D549279

RE: Reading and Exporting spreadsheets--another commentary

2014-01-07 Thread Think
...@cox.net] Sent: Tuesday, January 07, 2014 3:34 PM To: users@openoffice.apache.org Subject: Re: Reading and Exporting spreadsheets--another commentary On Mon, Jan 06, 2014 at 08:16:10PM -0800, Carmen Putrino wrote: Why am I getting this email? Because you're subscribed to this list

RE: Being Good, was: RE: Reading and Exporting spreadsheets--another commentary

2014-01-07 Thread Think
To: users@openoffice.apache.org Subject: Re: Being Good, was: RE: Reading and Exporting spreadsheets--another commentary On Mon, Jan 06, 2014 at 11:09:55PM -0500, Think wrote: I seldom reply to trolls but I'll make an exception in this case. I have been quietly watching the notes back and forth

RE: Being Good, was: RE: Reading and Exporting spreadsheets--another commentary

2014-01-07 Thread Think
...@gmail.com] Sent: Tuesday, January 07, 2014 12:19 AM To: users@openoffice.apache.org Subject: Re: Being Good, was: RE: Reading and Exporting spreadsheets--another commentary On Mon, 6 Jan 2014 23:09:55 -0500 Think thinkta...@gmail.com wrote: Once, someone told me I digressed too much

RE: Being Good, was: RE: Reading and Exporting spreadsheets--another commentary

2014-01-07 Thread Felmon Davis
On Tue, 7 Jan 2014, Think wrote: And again, we have the concept of ad hominem. Attacking me voids your argument. This is not about me. This is about the behavior of those who post on this listserv. minor correction: attacking a person does not void an argument. suppose I say, p implies q, q

Reading and Exporting spreadsheets

2014-01-06 Thread Arthur Schwarz
Win7 cygwin I created and saved a spreadsheet, 'ods' ,document. When I try to read it using my cygwin alias alias ods='/ProgramFiles86/OpenOffice\ 4/program/scalc.exe' it (basically) says what's that but when I use open office directly and use Recent Documents it seems to have no problem. is

Re: Reading and Exporting spreadsheets--another commentary

2014-01-06 Thread Anthony J. Rudgers
, verbally abuse belittle the OOo users who point them out to this community? Best wishes, Anthony J. Rudgers Orlando, FL U.S.A. -Original Message- From: Arthur Schwarz Sent: Monday, January 06, 2014 6:48 PM To: users@openoffice.apache.org Subject: Reading and Exporting spreadsheets

Re: Reading and Exporting spreadsheets

2014-01-06 Thread Keith N. McKenna
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Arthur Schwarz wrote: Win7 cygwin I created and saved a spreadsheet, 'ods' ,document. When I try to read it using my cygwin alias alias ods='/ProgramFiles86/OpenOffice\ 4/program/scalc.exe' it (basically) says what's that but when I use open

Re: Reading and Exporting spreadsheets--another commentary

2014-01-06 Thread Rob Weir
, Anthony J. Rudgers Orlando, FL U.S.A. -Original Message- From: Arthur Schwarz Sent: Monday, January 06, 2014 6:48 PM To: users@openoffice.apache.org Subject: Reading and Exporting spreadsheets Win7 cygwin I created and saved a spreadsheet, 'ods' ,document. When I try to read

Re: Reading and Exporting spreadsheets--another commentary

2014-01-06 Thread Greg Madden
On Monday 06 January 2014 18:28:15 you wrote: On Mon, Jan 6, 2014 at 8:07 PM, Anthony J. Rudgers anthonyrudg...@att.net wrote: Greetings All, Here's (imho) another example of the symptoms of the coding flaws inherent in the present OOo software suite. You do something according to

Re: Reading and Exporting spreadsheets--another commentary

2014-01-06 Thread Carmen Putrino
Subject: Reading and Exporting spreadsheets Win7 cygwin I created and saved a spreadsheet, 'ods' ,document. When I try to read it using my cygwin alias alias ods='/ProgramFiles86/OpenOffice\ 4/program/scalc.exe' it (basically) says what's that but when I use open office directly and use

  1   2   >