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” > > > > H

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 Belina

Re: open office software SPREADSHEETS

2019-10-25 Thread John Clipper
r > 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 success. >> >> 2. found some “answers”. without signing on.

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

Re: open office software SPREADSHEETS

2019-10-24 Thread Steven Ahlers
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 up

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 with

Re: Spreadsheets

2019-04-18 Thread John Toy
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 issue then the "problem" is the files are saved > in Excel forma

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 with

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. Not

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 desc

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
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 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
I have selected: Fewer 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 functio

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
or example, 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 dial

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
ave 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 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
indow). ** 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
t 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 Wade Smart
> OpenOffice Calc is listed as supporting 1048576 rows and 1024 columns > > It may be that a dataset of such size needs a completely different method of > processing than a spreadsheet. > > Rory Hmm I havent got to 1 million rows yet. I cant say Ive even tested the limit then HAHHAH -- Registere

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 chuck ef
: users@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?

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? &g

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 chec

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 P

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 satisfactorily) are not s

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 data (and > have been do

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, > > since upgrading to 4.1.4 charts th

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 e

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 r

Re: Crashing - Text Documents & Spreadsheets

2017-02-26 Thread nasrin khaksar
t;> Hagar >>> >>> Le 31/01/2017 à 08:45, Rory O'Farrell a écrit : >>>> On Mon, 30 Jan 2017 17:34:30 -0500 >>>> M B wrote: >>>> >>>>> I am using Open Office on a Windows 10 machine (word processing and >>>&

Re: Crashing - Text Documents & Spreadsheets

2017-02-05 Thread Martin Groenescheij
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 OpenOffice "out-of-the-box" produces a cor

Re: Crashing - Text Documents & Spreadsheets

2017-02-02 Thread nasrin khaksar
mp;t=12426 > !-) > > Hagar > > Le 31/01/2017 à 08:45, Rory O'Farrell a écrit : >> On Mon, 30 Jan 2017 17:34:30 -0500 >> M B wrote: >> >>> I am using Open Office on a Windows 10 machine (word processing and >>> spreadsheets). It constantly crashes an

Re: Crashing - Text Documents & Spreadsheets

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

Re: Crashing - Text Documents & Spreadsheets

2017-01-30 Thread Rory O'Farrell
On Mon, 30 Jan 2017 17:34:30 -0500 M B 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. > > Please advise what th

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
s data. 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 p

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

2017-01-18 Thread Girvin Herr
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 print ranges. I had to define a print r

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

2017-01-17 Thread Martin Groenescheij
t range defined 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

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

2017-01-17 Thread Girvin Herr
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 noth

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

2017-01-17 Thread tedandellen
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 printer, but still

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

2017-01-17 Thread tedandellen
7 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 pr

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

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 print

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 no

Re: spreadsheets

2016-04-28 Thread Julian Thomas
> On Apr 28, 2016, at 08:25, Tom Kennedy 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 finder, select a spreadsheet file and e

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 > Subject: spreadsheets > Date: April 28, 2016 at 8:20:52 AM EDT > To: users@openoffice.apache.org >

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

2016-01-16 Thread Johnny Rosenberg
2016-01-15 21:37 GMT+01:00 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. Aren't spreadsheets tables already? > It m

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

2016-01-15 Thread Dennis E. Hamilton
so how the name is spoken. Have to deal with that too sometimes. - Dennis > -Original Message- > From: Julian Thomas [mailto:j...@jt-mj.net] > Sent: Friday, January 15, 2016 16:22 > To: Open Office Apache list > Subject: Re: [ PROPOSAL ] A new REVERSE string function for

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 list of names. Names may or

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 sepa

[ 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 mergi

Re: Spreadsheets

2015-12-26 Thread Lucetta
chapters useful HTH Lucetta > On Dec 23, 2015, at 3:55 PM, elderdanlewis wrote: > > > > Original message > From: Dale Erwin > Date:12/23/2015 2:49 PM (GMT-05:00) > To: users@openoffice.apache.org > Subject: Re: Spreadsheets > >> On

Re: Spreadsheets

2015-12-23 Thread elderdanlewis
Original message From: Dale Erwin 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! > I am writing a c

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
o: 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 > > > >> On Dec 23, 2015, at 10:13 AM, Dan Lewis wr

Re: Spreadsheets

2015-12-23 Thread elderdanlewis
I will send you a link when I finish. Dan Original message From: Lucetta 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 s

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. The

Re: Spreadsheets

2015-12-23 Thread Lucetta
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 is easier. I wanted to show &

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 to be

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. Or

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 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 K

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 : > 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 indefin

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

2015-01-22 Thread Dennis E. Hamilton
https://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 -07

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 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 load the sprea

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: 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 he

Re: my open office 4.1.1 spreadsheets predicting

2014-10-21 Thread Steve Ahlers
Ron, If you mean 'Autofill' by 'predicting,' then you unmark the 'Autofill' option not the 'Autocorrect' option. Steve Sent from my iPad On Oct 21, 2014, at 10:20 AM, Orn Nnylf wrote: > Mr Ron Flynn. > Swansea > SA3 5LE U.K. > > Please

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: 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 s

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: open pdf documents and save them as spreadsheets or word documents

2014-07-06 Thread Tom Backer Johnsen
text editors, word processors, or > spreadsheets can use. (I use Nuance Power PDF on Windows - a commercial > product - for that, and know of other commercial alternatives. Other people > here may know of open source alternatives.) > > If the pdf file is NOT just a scanned do

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

2014-07-05 Thread Tim Deaton
document that text editors, word processors, or spreadsheets can use. (I use Nuance Power PDF on Windows - a commercial product - for that, and know of other commercial alternatives. Other people here may know of open source alternatives.) If the pdf file is NOT just a scanned document, then

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 the

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" 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 t

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" 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 d

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: 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 : > On Tue, 10 Jun 2014 17:54:06 -, Simon Harrison < > simonharrison...@gmail.com> wrote: > > For some reason since the last update when scrolling left or ri

Re: Scrolling within excel spreadsheets.

2014-06-10 Thread johnny smith
On Tue, 10 Jun 2014 17:54:06 -, Simon Harrison wrote: 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. it is a bug. more information h

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 and

Re: [Bulk] Re: Open Office Spreadsheets

2014-06-06 Thread Andrea Pescetti
Glenn Harder wrote: Suddenly my spell check is not working on calc. It is saying all my words are not spelled correctly. When I turn on the AutoSpellcheck all works are underlined in red Reset your user profile: https://forum.openoffice.org/en/forum/viewtopic.php?f=74&t=12426#p58403 Regards

Re: [Bulk] Re: Open Office Spreadsheets

2014-06-05 Thread Alexandro Colorado
he.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

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

Re: Open Office Spreadsheets

2014-06-05 Thread Greg Madden
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.

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

Open Office Spreadsheets

2014-06-05 Thread SAMR188
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 backed up but I am curious why when I upgraded to 4.1.

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

2014-04-05 Thread Greg Madden
On Saturday 05 April 2014 10:06:15 you wrote: > On 5 Apr 2014, at 13:27, Greg Madden wrote: > > Supported destination formats > > plain text (*.TXT) > > comma delimited text (*.CSV) > > HTML files (*.HTML) > > XML files (*.XML) > > > > Not to usefull, imho. > > Oh yes it is - .csv can be imported

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

2014-04-05 Thread Julian Thomas
On 5 Apr 2014, at 13:27, Greg Madden wrote: > Supported destination formats > plain text (*.TXT) > comma delimited text (*.CSV) > HTML files (*.HTML) > XML files (*.XML) > > Not to usefull, imho. Oh yes it is - .csv can be imported into almost any spreadsheet, including OO. jt --

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 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 thir

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 > &

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 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.abade

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

2014-04-02 Thread Steve Ahlers
rty. By the way 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 wrote: > Hi > > I have just down loaded Openoffice. > > How do I open spreadsheets in the QuattroPro with extension .wb3 wi

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

  1   2   >