Re: COPY function noty working on SPREADSHEETS

[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 can this be corrected?
> > 
> > Sent from Mail for Windows
> > 
> 
> See
> 
> https://forum.openoffice.org/en/forum/viewtopic.php?p=53
> 
> The problem is possibly caused by new clipboard utility installed by Windows 
> update.  The above link tells how to turn that utility off.

The above URL has been truncated in copy paste.

Try this one instead

https://ask.libreoffice.org/t/calc-freezes-on-copy-nov-22-solution-recomendations-make-no-difference/87840/9

-- 
Rory O'Farrell 

Re: COPY function noty working on SPREADSHEETS

[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/forum/viewtopic.php?p=53

The problem is possibly caused by new clipboard utility installed by Windows 
update.  The above link tells how to turn that utility off.

-- 
Rory O'Farrell 

COPY function noty working on SPREADSHEETS

[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

[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  wrote:
> 
> 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 to three columns or rows at a time.
> 
> the link is:
> 
> https://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide
> 
> On October 24, 2019 at 8:30:01 AM, John Clipper (clip...@casema.nl.invalid) 
> wrote:
> 
> how to sort data in Col A 


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: open office software SPREADSHEETS

[John Clipper]

Dear Alan and David,

I finally got it.

I highlighted all the rows by scrolling from top to bottom in col A. Row 
numbers were highlighted.

Clicked on data-sort and voila, it worked.

Thanks for your patience.

> On Oct 24, 2019, at 9:25 PM, Alan B  wrote:
> 
> Do you want to sort data in column A -or- sort entire rows using column A
> to order the rows?
> 
> The two operations produce different results.
> 
> I posted a video on YouTube ages ago showing these operations. The
> interface is changed a bit since but the ideas, select what you want to
> sort, then sort, haven't changed.
> 
> If you want a look, check here... Sorting a table in a spreadsheet,
> https://www.youtube.com/watch?v=RjTgDyNqqQY
> 
> If it doesn't address your issue, post back with a bit more detail.
> 
> On Thu, Oct 24, 2019 at 10: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 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 success.
>> 
>> J.Clipper
>> 
>> clip...@casema.nl
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> -
>> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
>> For additional commands, e-mail: users-h...@openoffice.apache.org
>> 
>> 
> 
> -- 
> Alan Boba
> CISSP, CCENT, ITIL v3 Foundations 2011


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: open office software SPREADSHEETS

[Alan B]

Do you want to sort data in column A -or- sort entire rows using column A
to order the rows?

The two operations produce different results.

I posted a video on YouTube ages ago showing these operations. The
interface is changed a bit since but the ideas, select what you want to
sort, then sort, haven't changed.

If you want a look, check here... Sorting a table in a spreadsheet,
https://www.youtube.com/watch?v=RjTgDyNqqQY

If it doesn't address your issue, post back with a bit more detail.

On Thu, Oct 24, 2019 at 10: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 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 success.
>
> J.Clipper
>
> clip...@casema.nl
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: open office software SPREADSHEETS

[Steven Ahlers]

In the Data drop down menu choose:

1) Define Range: give it a one word name, in the Range box specify the first 
and last cells
2) Select Range: choose a named range
3) Sort: Options tab—allows you to select options 
 Sort Criteria—allows you to choose column(s) to sort on and 
order in each column

If it produces something you don’t like go to Edit drop down and Undo Sort

This may seem works for simple lists or multi column databases as long as you 
define the range correctly.

Please reply to the users list: users@openoffice.apache.org
so that all users can assist you 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 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 success.
> 
> J.Clipper 
> 
> clip...@casema.nl
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
> 


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: open office software SPREADSHEETS

[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 to three columns or rows at a time.

the link is:

https://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide

On October 24, 2019 at 8:30:01 AM, John Clipper (clip...@casema.nl.invalid) 
wrote:

how to sort data in Col A 

open office software SPREADSHEETS

[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 success.

J.Clipper 

clip...@casema.nl



















-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Spreadsheets

[John Toy]

Thank you for your reply. I will have a look when I return from holiday at your 
suggestion.

John Toy
Sent from my IPad

> On 18 Apr 2019, at 11:27, Alan B  wrote:
> 
> 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 issue then the "problem" is the files are saved
> in Excel format instead of Calc format. This setting can be changed each
> time a file is saved and can be set to default to save as Excel in Tools >
> Options > Load Save.
> 
> If this is not the problem then I do not understand your question. I have
> created files in Calc for use in Excel many times. And I have created files
> in Calc for use in Calc but saved them in Excel format. Also, many times.
> 
> As far as I am aware the file that is created is not licensed, it is the
> program (Excel, Calc, etc.) that is licensed.
> 
> On Wed, Apr 17, 2019 at 12:46 PM Mavjon 
> 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.
>> Why cannot the files be shown as OpenOffice?
>> Thanks for any help you can give.
>> 
>> 
>> 
>> Sent from Mail for Windows 10
>> 
>> 
> 
> -- 
> Alan Boba
> CISSP, CCENT, ITIL v3 Foundations 2011


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

OO Spreadsheets not saving

[Lucetta]

Hi all!

Firstly I’ve been getting the emails and following the questions and answers 
and really appreciate the work done by the community. Have learnt a lot by just 
reading the digest everyday. Sadly I’m not really knowledgeable enough to 
participate much, actually once, a Mac problem more 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 our accountant. She would get 
gobble gook when she opened my spreadsheets. 

I resolved the issue by using another macbookpro, same in all respects but with 
Microsoft Excel 

It was still a lot of work to move everything over and check line by line. But 
I learnt a lot.
I am using a MacBookPro (27-inch,early 2009 with IS X Yosemite

2.66 GHz intel Core Duo
4GB 1067 MH z DFR3

W/ Apache OpenOffice 4.1.1

This was installed in 2009 by my techie and has have no problems until very 
recently. 

I know my equipment is old but hesitate to replace until I can work out the 
issue as I love Mac products for there low electrical field and don’t want to 
switch to something else. If I have to I’d appreciate any recommendations. 

My techie suggests switching to custom build w/ ubantu

Any and all advice would be appreciated. I only get the digest so won’t be 
replying in a timely manner

Thanks in advance

Lucetta

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Spreadsheets

[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 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 issue then the "problem" is the files 
are saved in Excel format instead of Calc format.


Note that this may not necessarily be so. Recent versions of 
Microsoft Office can handle document files in (Microsoft's version 
of?) Open Document Formats - such as .ods for spreadsheets. The 
questioner may be saving as .ods and still seeing file icons showing 
association with Microsoft Excel.


As far as I am aware the file that is created is not licensed, it is 
the program (Excel, Calc, etc.) that is licensed.


Indeed so. But the questioner appears to be using Windows 10 and may 
have had either a temporary or vestigial version of Microsoft Office 
bundled with his system. If the .ods format is still associated with 
Microsoft Excel (or if a Windows update has perhaps re-associated it) 
and he double-clicks an .ods file, he will see this remnant of Excel 
explaining that he "must" purchase a licence for Excel if he wishes to use it.


Brian Barker  



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Spreadsheets

[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 issue then the "problem" is the files are saved
in Excel format instead of Calc format. This setting can be changed each
time a file is saved and can be set to default to save as Excel in Tools >
Options > Load Save.

If this is not the problem then I do not understand your question. I have
created files in Calc for use in Excel many times. And I have created files
in Calc for use in Calc but saved them in Excel format. Also, many times.

As far as I am aware the file that is created is not licensed, it is the
program (Excel, Calc, etc.) that is licensed.

On Wed, Apr 17, 2019 at 12:46 PM Mavjon 
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.
> Why cannot the files be shown as OpenOffice?
> Thanks for any help you can give.
>
>
>
> Sent from Mail for Windows 10
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Spreadsheets

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

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

[Martin Groenescheij]

On 14/03/2019 20:59, Joost Andrae wrote:

Hi,

if you format cells using a cell formating template (function key F11)


F11 refers to Styles and Formatting which is not the same as Templates.

To achieve the desired results you have to  create a Cell Style using 
the F11 Function Key.
Then in one of the Cells Select Conditional Formatting and change "Cell 
value is" to "Formula is" then enter "FIND("GOES";UPPER(A1);1)" in the 
condition box.

In the Cell Style you select the newly created Cell Style.
Now you can Copy and Paste Special the format to a range of cells.

then you can easily change this cell formating by changing the cell 
formating template (eg. by adding background color red to this 
template). If you change this template then all cells where you 
assinged the template to change it's formating immediately.


It think it's a better way then using search&replace.

Kind regards, Joost



Am 14.03.2019 um 19:44 schrieb Martin Groenescheij:



On 14 Mar 2019, at 6:33 pm, WA.TWORSX via AOL 
 wrote:



Hi David:

I do not think you understand what I am attempting to do, so I'll 
try to clarify what my goal is.


In my spreadsheet cells I have typed a word, e.g., Goes,many times.  
I meant to type that word in Bold font.  Is there a way to change 
the already typed word (e.g., Goes) to be in bold font by use of the 
Find & Replace function?


You can use Conditional Formatting to make a whole Cell bold, just 
check if the Cell contains “Goes” and create a new Paragraph Stype.




I am not attempting to highlight an area within the spreadsheet.  I 
do not program in vbs, or any other language for that matter. :-) 
Years ago, I started to learn machine language for the Motorola 
6809E chip, but have not ever put what I learned to use.


TNX for your reply.


VinceB.




On 3/14/2019 11:54 AM, David Belina wrote:
The way the data is displayed in any spreadsheet is determined by 
the formatting which is linked to cell/row/column and not the 
particular data.  The search and replace function searches the data 
not the format.


You might be able to write a script (in excel you do this in vbs 
(visual basic) but I’m not sure in OO.


The question is what you want to highlight.  If it is a summary or 
other function you eventually want to arrive at - you can just 
format the last result cell.



On March 14, 2019 at 9:24:27 AM, WA.TWORSX via AOL 
(wa.two...@verizon.net.invalid) wrote:



AOO415m1(Build:9789)  -  Rev. 1817496
2017-12-11 17:25

Desktop Windows 10-64 Home





I am trying to change the attributes on data that exists within an AOO
Calc cell when using the Find & Replace function. For 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 dialogue window, 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 function in AOO-Calc Spreadsheets?

Regards,

VinceB.







-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org




-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

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

[Joost Andrae]

Hi,

if you format cells using a cell formating template (function key F11)
then you can easily change this cell formating by changing the cell 
formating template (eg. by adding background color red to this 
template). If you change this template then all cells where you assinged 
the template to change it's formating immediately.


It think it's a better way then using search&replace.

Kind regards, Joost



Am 14.03.2019 um 19:44 schrieb Martin Groenescheij:




On 14 Mar 2019, at 6:33 pm, WA.TWORSX via AOL  
wrote:


Hi David:

I do not think you understand what I am attempting to do, so I'll try to 
clarify what my goal is.

In my spreadsheet cells I have typed a word, e.g., Goes,many times.  I meant to 
type that word in Bold font.  Is there a way to change the already typed word 
(e.g., Goes) to be in bold font by use of the Find & Replace function?


You can use Conditional Formatting to make a whole Cell bold, just check if the 
Cell contains “Goes” and create a new Paragraph Stype.



I am not attempting to highlight an area within the spreadsheet.  I do not 
program in vbs, or any other language for that matter. :-) Years ago, I started 
to learn machine language for the Motorola 6809E chip, but have not ever put 
what I learned to use.

TNX for your reply.


VinceB.




On 3/14/2019 11:54 AM, David Belina wrote:
The way the data is displayed in any spreadsheet is determined by the 
formatting which is linked to cell/row/column and not the particular data.  The 
search and replace function searches the data not the format.

You might be able to write a script (in excel you do this in vbs (visual basic) 
but I’m not sure in OO.

The question is what you want to highlight.  If it is a summary or other 
function you eventually want to arrive at - you can just format the last result 
cell.


On March 14, 2019 at 9:24:27 AM, WA.TWORSX via AOL 
(wa.two...@verizon.net.invalid) wrote:


AOO415m1(Build:9789)  -  Rev. 1817496
2017-12-11 17:25

Desktop Windows 10-64 Home





I am trying to change the attributes on data that exists within an AOO
Calc cell when using the Find & Replace function. For 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 dialogue window, 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 function in AOO-Calc Spreadsheets?

Regards,

VinceB.







-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

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

[Martin Groenescheij]

> On 14 Mar 2019, at 6:33 pm, WA.TWORSX via AOL  
> wrote:
> 
> 
> Hi David:
> 
> I do not think you understand what I am attempting to do, so I'll try to 
> clarify what my goal is.
> 
> In my spreadsheet cells I have typed a word, e.g., Goes,many times.  I meant 
> to type that word in Bold font.  Is there a way to change the already typed 
> word (e.g., Goes) to be in bold font by use of the Find & Replace function?

You can use Conditional Formatting to make a whole Cell bold, just check if the 
Cell contains “Goes” and create a new Paragraph Stype.

> 
> I am not attempting to highlight an area within the spreadsheet.  I do not 
> program in vbs, or any other language for that matter. :-) Years ago, I 
> started to learn machine language for the Motorola 6809E chip, but have not 
> ever put what I learned to use.
> 
> TNX for your reply.
> 
> 
> VinceB.
> 
> 
> 
>> On 3/14/2019 11:54 AM, David Belina wrote:
>> The way the data is displayed in any spreadsheet is determined by the 
>> formatting which is linked to cell/row/column and not the particular data.  
>> The search and replace function searches the data not the format.
>> 
>> You might be able to write a script (in excel you do this in vbs (visual 
>> basic) but I’m not sure in OO.
>> 
>> The question is what you want to highlight.  If it is a summary or other 
>> function you eventually want to arrive at - you can just format the last 
>> result cell.
>> 
>> 
>> On March 14, 2019 at 9:24:27 AM, WA.TWORSX via AOL 
>> (wa.two...@verizon.net.invalid) wrote:
>> 
>> 
>> AOO415m1(Build:9789)  -  Rev. 1817496
>> 2017-12-11 17:25
>> 
>> Desktop Windows 10-64 Home
>> 
>> 
>> 
>> 
>> 
>> I am trying to change the attributes on data that exists within an AOO
>> Calc cell when using the Find & Replace function. For 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 dialogue window, 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 function in AOO-Calc Spreadsheets?
>> 
>> Regards,
>> 
>> VinceB.
>> 
>> 
>> 


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

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

[WA.TWORSX via AOL]

Hi David:

I do not think you understand what I am attempting to do, so I'll try to 
clarify what my goal is.


In my spreadsheet cells I have typed a word, e.g., Goes,many times.  I 
meant to type that word in Bold font.  Is there a way to change the 
already typed word (e.g., Goes) to be in bold font by use of the Find & 
Replace function?


I am not attempting to highlight an area within the spreadsheet.  I do 
not program in vbs, or any other language for that matter. :-) Years 
ago, I started to learn machine language for the Motorola 6809E chip, 
but have not ever put what I learned to use.


TNX for your reply.


VinceB.



On 3/14/2019 11:54 AM, David Belina wrote:

The way the data is displayed in any spreadsheet is determined by the 
formatting which is linked to cell/row/column and not the particular data.  The 
search and replace function searches the data not the format.

You might be able to write a script (in excel you do this in vbs (visual basic) 
but I’m not sure in OO.

The question is what you want to highlight.  If it is a summary or other 
function you eventually want to arrive at - you can just format the last result 
cell.


On March 14, 2019 at 9:24:27 AM, WA.TWORSX via AOL 
(wa.two...@verizon.net.invalid) wrote:


AOO415m1(Build:9789)  -  Rev. 1817496
2017-12-11 17:25

Desktop Windows 10-64 Home





I am trying to change the attributes on data that exists within an AOO
Calc cell when using the Find & Replace function. For 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 dialogue window, 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 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?

[Keith N. McKenna]

On 3/14/2019 11:54 AM, David Belina wrote:
> The way the data is displayed in any spreadsheet is determined by the
> formatting which is linked to cell/row/column and not the particular
> data.  The search and replace function searches the data not the
> format.
> 
> You might be able to write a script (in excel you do this in vbs
> (visual basic) but I’m not sure in OO.
> 
In AOO you would use OpenOffice Basic the guide for which can be found
at https://wiki.openoffice.org/wiki/Documentation/BASIC_Guide
Keith

> The question is what you want to highlight.  If it is a summary or
> other function you eventually want to arrive at - you can just format
> the last result cell.
> 
> 
> On March 14, 2019 at 9:24:27 AM, WA.TWORSX via AOL
> (wa.two...@verizon.net.invalid) wrote:
> 
> 
> AOO415m1(Build:9789)  -  Rev. 1817496 2017-12-11 17:25
> 
> Desktop Windows 10-64 Home
> 
> 
> 
> 
> 
> I am trying to change the attributes on data that exists within an
> AOO Calc cell when using the Find & Replace function. For 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 dialogue window, 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 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?

[David Belina]

The way the data is displayed in any spreadsheet is determined by the 
formatting which is linked to cell/row/column and not the particular data.  The 
search and replace function searches the data not the format.

You might be able to write a script (in excel you do this in vbs (visual basic) 
but I’m not sure in OO.

The question is what you want to highlight.  If it is a summary or other 
function you eventually want to arrive at - you can just format the last result 
cell.


On March 14, 2019 at 9:24:27 AM, WA.TWORSX via AOL 
(wa.two...@verizon.net.invalid) wrote:


AOO415m1(Build:9789)  -  Rev. 1817496  
2017-12-11 17:25  

Desktop Windows 10-64 Home  


  


I am trying to change the attributes on data that exists within an AOO  
Calc cell when using the Find & Replace function. For 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 dialogue window, 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 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?

[WA.TWORSX via AOL]

AOO415m1(Build:9789)  -  Rev. 1817496
2017-12-11 17:25

Desktop Windows 10-64 Home





I am trying to change the attributes on data that exists within an AOO 
Calc cell when using the Find & Replace function. For 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 dialogue window, 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 function in AOO-Calc Spreadsheets?


Regards,

VinceB.

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

[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
-- 
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

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

[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 no distinction between 
operating systems.


The above will be for saving in OpenOffice's native Open Document 
Format format, i.e. .ods; saving in other formats may have other 
limitations. Recent versions of Microsoft Excel have the same limit 
for number of rows, but this appears to apply only to its newer .xlsx 
format. Older version of Microsoft Excel were limited to 65,536 (i.e. 
2^16) rows. I'm guessing that if you save from OpenOffice in .xls 
format, you will be limited to this smaller value as well. Even if 
you are not, it may be that Microsoft Excel (any version?) will not 
be able to open an .xls file with more rows than this smaller limit.


Remember that if you are passing your documents to others, any limits 
of whatever spreadsheet software they use will apply.



How to increase?


Use different spreadsheet software. Write your own? Redesign your 
spreadsheet? Use a database?


I trust this helps.

Brian Barker


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

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

[Rory O'Farrell]

On Sat, 22 Dec 2018 18:04:39 +
chuck ef  wrote:

> I am not aware of a limit on rows in an .ods file but then I have never tried 
> to find one. And why, if one exists, it would be unique to Mac systems is a 
> mystery to me.
> 
> I use Macs frequently.


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
> 
> 
> 
> >From: Dwight Hines 
> Sent: Saturday, December 22, 2018 9:52 AM
> To: 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?


-- 
Rory O'Farrell 

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

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

[chuck ef]

I am not aware of a limit on rows in an .ods file but then I have never tried 
to find one. And why, if one exists, it would be unique to Mac systems is a 
mystery to me.

I use Macs frequently.



From: Dwight Hines 
Sent: Saturday, December 22, 2018 9:52 AM
To: 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?

[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?
> How to increase?

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

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

[Dwight Hines]

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

Re: printing spreadsheets

[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 check page breaks go to View -> Page Break Preview
You can insert a break wherever you want by Insert -> Manual Break



Thank You
 Gwyn
Sent from Mail for Windows 10





-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: printing spreadsheets

[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 PM, 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.
>
>Thank You
> Gwyn
> Sent from Mail for Windows 10
>

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

printing spreadsheets

[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

[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 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
> 
> You can follow the conversation there if you register to Bugzilla and add 
> yourself to CC for that bug. Your feedback could also be useful for the 
> analysis.
> 
> Regards,
>  Andrea.
> 
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
> 



signature.asc
Description: Message signed with OpenPGP

Re: 4.1.4 and charts in spreadsheets

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

You can follow the conversation there if you register to Bugzilla and add 
yourself to CC for that bug. Your feedback could also be useful for the 
analysis.

Regards,
 Andrea.

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: 4.1.4 and charts in spreadsheets

[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

You can follow the conversation there if you register to Bugzilla and 
add yourself to CC for that bug. Your feedback could also be useful for 
the analysis.


Regards,
  Andrea.

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: 4.1.4 and charts in spreadsheets

[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 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 easily recreated and then copied into text 
> documents.  Even so, ideas for a workaround would be welcomed, pending 
> correction of what I assume is a bug or oversight.
> 
> I use OSX 10.9.5 on a MacBook Pro.
> 
> Thanks
> 
> Mike Shearer
> 
> 
> 
> 
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
> 



signature.asc
Description: Message signed with OpenPGP

4.1.4 and charts in spreadsheets

[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 easily recreated and then 
copied into text documents.  Even so, ideas for a workaround would be 
welcomed, pending correction of what I assume is a bug or oversight.


I use OSX 10.9.5 on a MacBook Pro.

Thanks

Mike Shearer




-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Recovery of Open Office .odt & spreadsheets

[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 recovering a lot of my information of my hard 
drive. The problem is that It doesn't appear that it is able to search for Open 
Office files. 

Do you know of any program that will recover Open Office files?

Any information would be helpful…

Desparately…

Grant Wutzke


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Crashing - Text Documents & Spreadsheets

[nasrin khaksar]

hi.
i am not sure about problem using skype and openoffice libreoffice.
but i realy wish to know about it!
about avast, i studied in reputable site for downloading portable softwares.
www.portableapps.com

On 2/5/17, Martin Groenescheij  wrote:
>
>
> On 03/02/17 2:44 AM, nasrin khaksar wrote:
>> hi.
>> i use frequent crash in use both libreoffice openoffice editing my
>> documents.
>> i sincerely waite for your advice.
>> also i have skype.
>> how skype can affect the stability of the office programs?
>> i realy appreciate and need your help, because i use skype every day
>> and also wish that use office programs without any problem.
>
> Have you reported the problem with Skype to Microsoft?
>
>> also i read that avast antivirus recognizes openoffice libreoffice as
>> trojan and stops them from working properly!
>
> Don't believe everything you read.
>
>> i am waiting for any of your advice.
>>
>> On 2/1/17, Hagar Delest  wrote:
>>> 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 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 corrupt user profile, which can cause instability.  The cure
>>>> for this is to delete or rename the old user profile; OO will then
>>>> generate a new profile on next startup.
>>>>
>>>> Details of the User Profile for various operating systems
>>>> are given in
>>>>
>>>> https://forum.openoffice.org/en/forum/v ... 74&t=12426
>>>>
>>>> If you are using Windows close OpenOffice and the Quickstarter. Open
>>>> File
>>>> Explorer. Copy and paste %appdata%\OpenOffice\4 in the File Explorer
>>>> Address Bar and press Enter. Rename the "user" folder - "user.old" is a
>>>> good choice. Start OpenOffice.
>>>>
>>>> If that does not improve stability, start Windows in Safe Mode.  If OO
>>>> runs stable in Windows safe mode the culprit is some program or driver
>>>> that runs in Windows normal mode, which program or driver is
>>>> interfering
>>>> with OpenOffice. Common culprits are Skype, Anti virus, continuous
>>>> backup
>>>> programs ad utilities which monitor the Clipboard.  To locate the
>>>> culprit
>>>> needs systematic detective work on the affected computer.
>>>>
>>>>
>>>
>>> -
>>> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
>>> For additional commands, e-mail: users-h...@openoffice.apache.org
>>>
>>>
>>
>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>


-- 
we have not sent you but as a mercy to the creation.
holy quran, chapter 21, verse 107.
in the very authentic narration is:
imam hosein is the beacon of light and the ark of salvation.
best website for studying islamic book in different languages
al-islam.org

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Crashing - Text Documents & Spreadsheets

[Martin Groenescheij]

On 03/02/17 2:44 AM, nasrin khaksar wrote:

hi.
i use frequent crash in use both libreoffice openoffice editing my documents.
i sincerely waite for your advice.
also i have skype.
how skype can affect the stability of the office programs?
i realy appreciate and need your help, because i use skype every day
and also wish that use office programs without any problem.


Have you reported the problem with Skype to Microsoft?


also i read that avast antivirus recognizes openoffice libreoffice as
trojan and stops them from working properly!


Don't believe everything you read.


i am waiting for any of your advice.

On 2/1/17, Hagar Delest  wrote:

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 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 corrupt user profile, which can cause instability.  The cure
for this is to delete or rename the old user profile; OO will then
generate a new profile on next startup.

Details of the User Profile for various operating systems
are given in

https://forum.openoffice.org/en/forum/v ... 74&t=12426

If you are using Windows close OpenOffice and the Quickstarter. Open File
Explorer. Copy and paste %appdata%\OpenOffice\4 in the File Explorer
Address Bar and press Enter. Rename the "user" folder - "user.old" is a
good choice. Start OpenOffice.

If that does not improve stability, start Windows in Safe Mode.  If OO
runs stable in Windows safe mode the culprit is some program or driver
that runs in Windows normal mode, which program or driver is interfering
with OpenOffice. Common culprits are Skype, Anti virus, continuous backup
programs ad utilities which monitor the Clipboard.  To locate the culprit
needs systematic detective work on the affected computer.




-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org







-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Crashing - Text Documents & Spreadsheets

[nasrin khaksar]

hi.
i use frequent crash in use both libreoffice openoffice editing my documents.
i sincerely waite for your advice.
also i have skype.
how skype can affect the stability of the office programs?
i realy appreciate and need your help, because i use skype every day
and also wish that use office programs without any problem.
also i read that avast antivirus recognizes openoffice libreoffice as
trojan and stops them from working properly!
i am waiting for any of your advice.

On 2/1/17, Hagar Delest  wrote:
> 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 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 corrupt user profile, which can cause instability.  The cure
>> for this is to delete or rename the old user profile; OO will then
>> generate a new profile on next startup.
>>
>> Details of the User Profile for various operating systems
>> are given in
>>
>> https://forum.openoffice.org/en/forum/v ... 74&t=12426
>>
>> If you are using Windows close OpenOffice and the Quickstarter. Open File
>> Explorer. Copy and paste %appdata%\OpenOffice\4 in the File Explorer
>> Address Bar and press Enter. Rename the "user" folder - "user.old" is a
>> good choice. Start OpenOffice.
>>
>> If that does not improve stability, start Windows in Safe Mode.  If OO
>> runs stable in Windows safe mode the culprit is some program or driver
>> that runs in Windows normal mode, which program or driver is interfering
>> with OpenOffice. Common culprits are Skype, Anti virus, continuous backup
>> programs ad utilities which monitor the Clipboard.  To locate the culprit
>> needs systematic detective work on the affected computer.
>>
>>
>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>


-- 
we have not sent you but as a mercy to the creation.
holy quran, chapter 21, verse 107.
in the very authentic narration is:
imam hosein is the beacon of light and the ark of salvation.
best website for studying islamic book in different languages
al-islam.org

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Crashing - Text Documents & Spreadsheets

[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 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 
corrupt user profile, which can cause instability.  The cure for this is to delete or 
rename the old user profile; OO will then generate a new profile on next startup.

Details of the User Profile for various operating systems
are given in

https://forum.openoffice.org/en/forum/v ... 74&t=12426

If you are using Windows close OpenOffice and the Quickstarter. Open File
Explorer. Copy and paste %appdata%\OpenOffice\4 in the File Explorer
Address Bar and press Enter. Rename the "user" folder - "user.old" is a
good choice. Start OpenOffice.

If that does not improve stability, start Windows in Safe Mode.  If OO runs 
stable in Windows safe mode the culprit is some program or driver that runs in 
Windows normal mode, which program or driver is interfering with OpenOffice. 
Common culprits are Skype, Anti virus, continuous backup programs ad utilities 
which monitor the Clipboard.  To locate the culprit needs systematic detective 
work on the affected computer.





-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Crashing - Text Documents & Spreadsheets

[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 the problem might be.
> 
> mb

It can happen that an installation of OpenOffice "out-of-the-box"  produces a 
corrupt user profile, which can cause instability.  The cure for this is to 
delete or rename the old user profile; OO will then generate a new profile on 
next startup.

Details of the User Profile for various operating systems
are given in

https://forum.openoffice.org/en/forum/v ... 74&t=12426

If you are using Windows close OpenOffice and the Quickstarter. Open File
Explorer. Copy and paste %appdata%\OpenOffice\4 in the File Explorer
Address Bar and press Enter. Rename the "user" folder - "user.old" is a
good choice. Start OpenOffice.

If that does not improve stability, start Windows in Safe Mode.  If OO runs 
stable in Windows safe mode the culprit is some program or driver that runs in 
Windows normal mode, which program or driver is interfering with OpenOffice. 
Common culprits are Skype, Anti virus, continuous backup programs ad utilities 
which monitor the Clipboard.  To locate the culprit needs systematic detective 
work on the affected computer.


-- 
Rory O'Farrell 

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Crashing - Text Documents & Spreadsheets

[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

[Martin Groenescheij]

On 19/01/17 5:48 AM, Girvin Herr wrote:



On 01/17/2017 06:32 PM, Martin Groenescheij wrote:



On 18/01/17 10:32 AM, Girvin Herr wrote:
Yes, I have seen that too.  Usually a new spreadsheet may print 
until at some unpredictable time in the future, it stops printing.  
I don't know why it changes. I have not tested it. IMHO, the whole 
print ranges process should default to "Entire Sheet" for all 
sheets, including added sheets, unless changed.


That's exactly what it does, if no tab has a print range defined (the 
default) than it print all sheets where it finds 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 print ranges.


You said: "they would not print.  On top of that, they may have started 
out printing" that sound likes a contradiction to me.
There are two options you can check if OpenOffice will generate output 
something:

1. File -> Page Preview - this shows if there is anything to print.
2. View -> Page Break Preview - this shows all data and highlight the 
area which has a Print Range defined.


If something start printing and stops for some unexplained reason it is 
not by definition an OpenOffice problem.


  I had to define a print range of "Entire Sheet" on each sheet to get 
it to print all of the sheets. It sounds like the OP has experienced 
the same thing (bug?).  I am just saying the default behavior is 
sometimes frustrating for the non-power user and when it fails, the 
cause is not very intuitive.


The default behavior is very clear, when it behave different from your 
expectation there could be reasons:
It could be that you use a non default template, which has a Print Range 
defined.
Go to File -> Templates and double click on My Templates to see if there 
s a Non Default template.
If there is one you find under the Commands pull-down menu a option 
"Reset Default Template"


The fact that the OP, and other previous posters with the same 
problem, had to ask for help on this forum is proof of that.


The only proof is that we all have areas we don't understand, I learn 
everyday new things.




Girvin


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org





-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

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

[Girvin Herr]

On 01/17/2017 06:32 PM, Martin Groenescheij wrote:



On 18/01/17 10:32 AM, Girvin Herr wrote:
Yes, I have seen that too.  Usually a new spreadsheet may print until 
at some unpredictable time in the future, it stops printing.  I don't 
know why it changes.  I have not tested it. IMHO, the whole print 
ranges process should default to "Entire Sheet" for all sheets, 
including added sheets, unless changed.


That's exactly what it does, if no tab has a print range defined (the 
default) than it print all sheets where it finds 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 print 
ranges.  I had to define a print range of "Entire Sheet" on each sheet 
to get it to print all of the sheets. It sounds like the OP has 
experienced the same thing (bug?).  I am just saying the default 
behavior is sometimes frustrating for the non-power user and when it 
fails, the cause is not very intuitive. The fact that the OP, and other 
previous posters with the same problem, had to ask for help on this 
forum is proof of that.


Girvin


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

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

[Martin Groenescheij]

On 18/01/17 10:32 AM, Girvin Herr wrote:
Yes, I have seen that too.  Usually a new spreadsheet may print until 
at some unpredictable time in the future, it stops printing.  I don't 
know why it changes.  I have not tested it. IMHO, the whole print 
ranges process should default to "Entire Sheet" for all sheets, 
including added sheets, unless changed.


That's exactly what it does, if no tab has a print range defined (the 
default) than it print all sheets where it finds data.
E.g. if you have data in Cell B6 and X12 than it print from B6 to X12 if 
you have some data on an other sheet it will check

where you have data, if the sheet is empty it will not print that sheet.
But if you have a print range defined on just one sheet, even if there 
is no data, it will print just that print range, an that is

what you want.
If you're unsure where you have a print 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 probably have many sheets were you maintain 
lookup tables, like employee names,
purchase price and sales prices etc. it's most likely you don't show 
your customers your profit margin.

Most likely you only send them an invoice.



Glad to hear it worked for you.

Girvin



On 01/17/2017 09:33 AM, tedandel...@cox.net wrote:

Hi,
Thanks for the suggestion. It worked! Don't know why after several 
years of doing things one way they mysteriously don't work anymore.

Ted
 Girvin Herr  wrote:

Ted,

Do you have a "Print Range" defined?

If not, you would see the symptoms you describe.

Format > Print Ranges > edit... Then select "Entire Sheet" from the
"Print Range" list.  If you want rows to be repeated on each page, then
select  "User Defined" under "Rows to Repeat" and/or enter a row
designation (i.e. $1 for row #1) in the box to the right.

Note that this is required on a sheet-by-sheet basis, so if you have
more than one sheet to print, then you must select the print range for
each sheet.

HTH.

Girvin Herr



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 
nothing prints. When I select print from the drop down or the icon 
on an OO document nothing shows on the to be printed display, and 
thus nothing prints out.HELP!

Thanks,
Ted

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org






-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org





-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

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

[Girvin Herr]

Yes, I have seen that too.  Usually a new spreadsheet may print until at 
some unpredictable time in the future, it stops printing.  I don't know 
why it changes.  I have not tested it. IMHO, the whole print ranges 
process should default to "Entire Sheet" for all sheets, including added 
sheets, unless changed. 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.


Glad to hear it worked for you.

Girvin



On 01/17/2017 09:33 AM, tedandel...@cox.net wrote:

Hi,
Thanks for the suggestion. It worked! Don't know why after several years of 
doing things one way they mysteriously don't work anymore.
Ted
 Girvin Herr  wrote:

Ted,

Do you have a "Print Range" defined?

If not, you would see the symptoms you describe.

Format > Print Ranges > edit... Then select "Entire Sheet" from the
"Print Range" list.  If you want rows to be repeated on each page, then
select  "User Defined" under "Rows to Repeat" and/or enter a row
designation (i.e. $1 for row #1) in the box to the right.

Note that this is required on a sheet-by-sheet basis, so if you have
more than one sheet to print, then you must select the print range for
each sheet.

HTH.

Girvin Herr



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 nothing prints. When I select print 
from the drop down or the icon on an OO document nothing shows on the to be 
printed display, and thus nothing prints out.HELP!
Thanks,
Ted

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org






-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

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

[tedandellen]

Hi,
I'm not that much into newer ways of doing things. Got a couple of suggestions 
on how to get Open Office to print and they work.
Thanks for your suggestions.
Ted
 Andrea  wrote: 
> 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 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 the to be printed display, and thus nothing prints out.HELP!
> > Thanks,
> > Ted
> >
> > -
> > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> > For additional commands, e-mail: users-h...@openoffice.apache.org
> >
> >
> 
> 
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
> 
> 
> 


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

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

[tedandellen]

Hi,
Thanks for the suggestion. It worked! Don't know why after several years of 
doing things one way they mysteriously don't work anymore.
Ted
 Girvin Herr  wrote: 
> Ted,
> 
> Do you have a "Print Range" defined?
> 
> If not, you would see the symptoms you describe.
> 
> Format > Print Ranges > edit... Then select "Entire Sheet" from the 
> "Print Range" list.  If you want rows to be repeated on each page, then 
> select  "User Defined" under "Rows to Repeat" and/or enter a row 
> designation (i.e. $1 for row #1) in the box to the right.
> 
> Note that this is required on a sheet-by-sheet basis, so if you have 
> more than one sheet to print, then you must select the print range for 
> each sheet.
> 
> HTH.
> 
> Girvin Herr
> 
> 
> 
> 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 nothing prints. When I 
> > select print from the drop down or the icon on an OO document nothing shows 
> > on the to be printed display, and thus nothing prints out.HELP!
> > Thanks,
> > Ted
> >
> > -
> > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> > For additional commands, e-mail: users-h...@openoffice.apache.org
> >
> 
> 
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
> 
> 
> 


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

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

[Girvin Herr]

Ted,

Do you have a "Print Range" defined?

If not, you would see the symptoms you describe.

Format > Print Ranges > edit... Then select "Entire Sheet" from the 
"Print Range" list.  If you want rows to be repeated on each page, then 
select  "User Defined" under "Rows to Repeat" and/or enter a row 
designation (i.e. $1 for row #1) in the box to the right.


Note that this is required on a sheet-by-sheet basis, so if you have 
more than one sheet to print, then you must select the print range for 
each sheet.


HTH.

Girvin Herr



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 nothing prints. When I select print 
from the drop down or the icon on an OO document nothing shows on the to be 
printed display, and thus nothing prints out.HELP!
Thanks,
Ted

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org




-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

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

[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 
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 the to be 
printed display, and thus nothing prints out.HELP!
Thanks,
Ted

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org





-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

can't print out spreadsheets on HP printer now

[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 shows on the to be 
printed display, and thus nothing prints out.HELP!
Thanks,
Ted

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: spreadsheets

[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 either use Cmd-I or right click to get 
the info panel for the file.

Near the bottom of the  window, there is a 'Open with' section.  Select OO and 
click the 'Change All' button.  You may need to do this both for filetype .xls 
and .xlsx

 —
jt - j...@jt-mj.net

Always remember to close all parentheses. We're not paying to air condition the 
entire paragraph. 





-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Fwd: spreadsheets

[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
> 
> I have been using Open Office for years, happily. 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

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

[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 may be cumbersome to make a table from a list,
> but it really pays off for applications like yours.  Table elements are
> usually separated with tabs but spaces work, as well.  And it's easy to
> convert a table to text when that's appropriate.  Play around -- you'll
> find a way that fits your need.
>
> Maurice Howe
>
>
> On Fri, Jan 15, 2016 at 11:49 AM, Ross Murray 
> wrote:
>
> > 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 merging many files to create a
> > very large list of names. Names may or may not have middle names; and/or
> > initials which may or may not be follows by full stops. I would like to
> > extract the last names and use those the primary sort key. While feasible
> > with existing functions, it would seem easiest to - REVERSE the full
> names;
> > FIND the first space; RIGHT to extract the last names; and REVERSE those
> to
> > their original form.
> >
> > It seems like a simple new tool that the imaginations of users could
> create
> > more effective ways to complete many different objectives.
> >
> > ... From a devoted and appreciative user,
> >
> > Ross Murray.
> >
>

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

[Dennis E. Hamilton]

These are always fun:

   [The Right Honorable] Sir Winston Leonard Spencer-Churchill, KG, OM, CH, TD, 
PC, DL, FRS, RA

   William Henry Gates II
   William Henry "Bill" Gates III

The only solution I have managed for this is to separate the printed/presented 
form of the name from the form of name to be used in sorting, ranking, and 
maybe searching.  There is redundancy, but it all works.

The presented form might be derived from the fragments which are more easily 
handled in separate fields, especially for sorting and searching purposes.  
I've seen forms that ask for a prefix, given name(s), family name, and 
suffixes.  Then they are arranged appropriately into a concatenated form for 
presentation, mailing labels, organization rosters, whatever. 

Now, in some cultures and languages, the family name is written before, not 
after the given name(s), and that is also 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 Spreadsheets
> 
> 
> > 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 may not have middle names;
> and/or
> > initials which may or may not be follows by full stops. I would like
> to
> > extract the last names and use those the primary sort key. While
> feasible
> > with existing functions, it would seem easiest to - REVERSE the full
> names;
> > FIND the first space; RIGHT to extract the last names; and REVERSE
> those to
> > their original form.
> 
> If I were to face this issue today [I think I've struggled with it in
> the past and most of the manipulations were manual], I'd save the file
> as a CSV. I would then in the scripting language of your choice [Rexx or
> Python would be mine] process each line of the CSV, parsing the name
> fields and add a new field for last name, writing out a new CSV which
> could then be opened and sorted.
> 
> Don't forget John Smith PhD or Sam Adams IV or Jr.
> 
>  —
> jt - j...@jt-mj.net
> 
> Hard work pays off in the future. Laziness pays off now.
> 
> 
> 
> 
> 
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

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

[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 may not have middle names; and/or
> initials which may or may not be follows by full stops. I would like to
> extract the last names and use those the primary sort key. While feasible
> with existing functions, it would seem easiest to - REVERSE the full names;
> FIND the first space; RIGHT to extract the last names; and REVERSE those to
> their original form.

If I were to face this issue today [I think I've struggled with it in the past 
and most of the manipulations were manual], I'd save the file as a CSV. I would 
then in the scripting language of your choice [Rexx or Python would be mine] 
process each line of the CSV, parsing the name fields and add a new field for 
last name, writing out a new CSV which could then be opened and sorted.

Don't forget John Smith PhD or Sam Adams IV or Jr. 

 —
jt - j...@jt-mj.net

Hard work pays off in the future. Laziness pays off now. 





-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

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

[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 separated with tabs but spaces work, as well.  And it's easy to
convert a table to text when that's appropriate.  Play around -- you'll
find a way that fits your need.

Maurice Howe


On Fri, Jan 15, 2016 at 11:49 AM, Ross Murray 
wrote:

> 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 merging many files to create a
> very large list of names. Names may or may not have middle names; and/or
> initials which may or may not be follows by full stops. I would like to
> extract the last names and use those the primary sort key. While feasible
> with existing functions, it would seem easiest to - REVERSE the full names;
> FIND the first space; RIGHT to extract the last names; and REVERSE those to
> their original form.
>
> It seems like a simple new tool that the imaginations of users could create
> more effective ways to complete many different objectives.
>
> ... From a devoted and appreciative user,
>
> Ross Murray.
>

[ PROPOSAL ] A new REVERSE string function for Spreadsheets

[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 merging many files to create a
very large list of names. Names may or may not have middle names; and/or
initials which may or may not be follows by full stops. I would like to
extract the last names and use those the primary sort key. While feasible
with existing functions, it would seem easiest to - REVERSE the full names;
FIND the first space; RIGHT to extract the last names; and REVERSE those to
their original form.

It seems like a simple new tool that the imaginations of users could create
more effective ways to complete many different objectives.

... From a devoted and appreciative user,

Ross Murray.

Re: Spreadsheets

[Lucetta]

While tidying up my office recently rediscovered a manual from The TECHBOOK 
series 

Libre Office The Complete Guide $ 26,99ca. 

There are three very short chapters on Base

Create powerful databases
Build your first database
Use forms & queries

I've already found some of the other 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 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 general 
>> conception seems to be creating databases is difficult, and creating 
>> spreadsheets is easier. I wanted to show that the basic principles for 
>> creating a database are not very different from creating a spreadsheet.
> 
> One problem I see with your premise is that with the database, after it 
> is created you have to then create some sort of application to 
> manipulate/retrieve the data.
> 
> Dale
> 
>   As with any database, a DBMS is used to give the database its structure. A 
> RDBMS is used for a relational database. I want to show that creating tables 
> is not too different than placing related data in a spreadsheet including the 
> formatting of the cells that hold the raw data. Also, location of a cell is 
> similar: column and row vs column and primary key. Of course if talking about 
> the entire spreadsheet or database,sheet or tables would also be used. 
> 
> Dan

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Spreadsheets

[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 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 that the basic principles for 
> creating a database are not very different from creating a spreadsheet.

One problem I see with your premise is that with the database, after it 
is created you have to then create some sort of application to 
manipulate/retrieve the data.

Dale

   As with any database, a DBMS is used to give the database its structure. A 
RDBMS is used for a relational database. I want to show that creating tables is 
not too different than placing related data in a spreadsheet including the 
formatting of the cells that hold the raw data. Also, location of a cell is 
similar: column and row vs column and primary key. Of course if talking about 
the entire spreadsheet or database,sheet or tables would also be used. 

Dan

Re: Spreadsheets

[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
>> 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 that the basic principles for
>> creating a database are not very different from creating a spreadsheet.
> 
> One problem I see with your premise is that with the database, after it
> is created you have to then create some sort of application to
> manipulate/retrieve the data.
> 
> Dale
Dale;

An integral part of any Data Base Management System (DBMS)that I am
aware of is a report generator that allows you to define reports to
present the data as needed.

Regards
Keith



signature.asc
Description: OpenPGP digital signature

Re: Spreadsheets

[Lucetta]

Thanks Dan! lLoking forward to seeing your work.

Lucetta 

> On Dec 23, 2015, at 3:31 PM, elderdanlewis  wrote:
> 
> 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 such a manual. 
> 
> Kind regards
> Lucetta
> 
> 
> 
>> On Dec 23, 2015, at 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 general conception seems to be creating 
>> databases is difficult, and creating spreadsheets is easier. I wanted to 
>> show that the basic principles for creating a database are not very 
>> different from creating a spreadsheet.
>> 
>>> On 12/23/2015 01:08 AM, Martin Groenescheij wrote:
>>> 
>>> 
>>>> 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, are they all similar to flat databases?
>>> 
>>> No because in a spreadsheet you can have multiple sets of data.
>>> A flat database is limited to one set of data.
>>> 
>>>>   I am looking for similarities and differences between databases and 
>>>> spreadsheets.
>>> 
>>> This is an open ended question, could you be more specific on what you try 
>>> to achieve?
>>> 
>>>> 
>>>> Dan
>>> 
>>> 
>>> -
>>> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
>>> For additional commands, e-mail: users-h...@openoffice.apache.org
>> 
>> 
>> -
>> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
>> For additional commands, e-mail: users-h...@openoffice.apache.org
> 
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
> 

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Spreadsheets

[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 such a manual. 

Kind regards
Lucetta



> On Dec 23, 2015, at 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 general conception seems to be creating 
> databases is difficult, and creating spreadsheets is easier. I wanted to show 
> that the basic principles for creating a database are not very different from 
> creating a spreadsheet.
> 
>> On 12/23/2015 01:08 AM, Martin Groenescheij wrote:
>> 
>> 
>>> 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, are they all similar to flat databases?
>> 
>> No because in a spreadsheet you can have multiple sets of data.
>> A flat database is limited to one set of data.
>> 
>>>I am looking for similarities and differences between databases and 
>>> spreadsheets.
>> 
>> This is an open ended question, could you be more specific on what you try 
>> to achieve?
>> 
>>> 
>>> Dan
>> 
>> 
>> -
>> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
>> For additional commands, e-mail: users-h...@openoffice.apache.org
> 
> 
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Spreadsheets

[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 general 
conception seems to be creating databases is difficult, and creating 
spreadsheets is easier. I wanted to show that the basic principles for 
creating a database are not very different from creating a spreadsheet.


One problem I see with your premise is that with the database, after it 
is created you have to then create some sort of application to 
manipulate/retrieve the data.


Dale

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Spreadsheets

[Lucetta]

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  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 general conception seems to be creating 
> databases is difficult, and creating spreadsheets is easier. I wanted to show 
> that the basic principles for creating a database are not very different from 
> creating a spreadsheet.
> 
>> On 12/23/2015 01:08 AM, Martin Groenescheij wrote:
>> 
>> 
>>> 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, are they all similar to flat databases?
>> 
>> No because in a spreadsheet you can have multiple sets of data.
>> A flat database is limited to one set of data.
>> 
>>>I am looking for similarities and differences between databases and 
>>> spreadsheets.
>> 
>> This is an open ended question, could you be more specific on what you try 
>> to achieve?
>> 
>>> 
>>> Dan
>> 
>> 
>> -
>> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
>> For additional commands, e-mail: users-h...@openoffice.apache.org
> 
> 
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Spreadsheets

[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 creating databases is difficult, and creating spreadsheets 
is easier. I wanted to show that the basic principles for creating a 
database are not very different from creating a spreadsheet.


On 12/23/2015 01:08 AM, Martin Groenescheij wrote:



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, are they all similar to flat databases?


No because in a spreadsheet you can have multiple sets of data.
A flat database is limited to one set of data.

I am looking for similarities and differences between databases 
and spreadsheets.


This is an open ended question, could you be more specific on what you 
try to achieve?




Dan



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org




-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Spreadsheets

[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, are they all similar to flat databases?


No because in a spreadsheet you can have multiple sets of data.
A flat database is limited to one set of data.


I am looking for similarities and differences between databases and 
spreadsheets.


This is an open ended question, could you be more specific on what you 
try to achieve?




Dan



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Spreadsheets

[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

[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 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% . WTF?)
Tried to rename the offending *.xlsx  file to a different extension,
an  "ods" file extensionbut my Win7 does not allow me using "save as"
to do this

What is the problem here?   And what is the workaround?



I always drag them to the trash and drop them there. Then I ask the sender
to send the files in another format, such as PDF or ODF (usually the sender
doesn't know what ODF is so it usually ends up with a PDF). Solves the
problem for me…


Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ



-Stephen Knudsen





-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

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

[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 indefinitely
> (with CPU resources hogged to the tune of 24% . WTF?)
> Tried to rename the offending *.xlsx  file to a different extension,
> an  "ods" file extensionbut my Win7 does not allow me using "save as"
> to do this
>
> What is the problem here?   And what is the workaround?
>


I always drag them to the trash and drop them there. Then I ask the sender
to send the files in another format, such as PDF or ODF (usually the sender
doesn't know what ODF is so it usually ends up with a PDF). Solves the
problem for me…


Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ


>
> -Stephen Knudsen
>

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

[Dennis E. Hamilton]

You can rename a file in the File Explorer, but that is not going to be 
helpful.  Leave it named .xslx for the greatest possible success.

As Rory suggests, you can try the Kingsoft (now WPS Office) 30-day freee trial 
to see if that will open the file successfully.  WPS office is strongly-focused 
on interoperability with the Microsoft Office formats.

You can also try the free Excel on the Web in your browser.  You will need a 
OneDrive account, if you don't have one yet.  Then you can upload Office files 
to OneDrive and then open and work with them in your browser.  It is best to 
have Windows 7 or later on your HP machine.


 - Dennis

PS: For any follow-up, please reply to users @ openoffice.apache.org where 
other experts may have advice and others can learn the solutions to common 
problems.  The OpenOffice Forums have an extensive knowledge base at 
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 -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 spreadsheet indefinitely
> (with CPU resources hogged to the tune of 24% . WTF?)
> Tried to rename the offending *.xlsx  file to a different extension,
> an  "ods" file extensionbut my Win7 does not allow me using "save as"
> to do this
> 
> What is the problem here?   And what is the workaround?
> 
> -Stephen Knudsen

You can try using www.zamzar.com who offer a free online conversion service. It 
is also possible that LibreOffice or Kingsoft Office may open the file.
-- 
Rory O'Farrell 

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

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

[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 spreadsheet indefinitely
> (with CPU resources hogged to the tune of 24% . WTF?)
> Tried to rename the offending *.xlsx  file to a different extension,
> an  "ods" file extensionbut my Win7 does not allow me using "save as"
> to do this
> 
> What is the problem here?   And what is the workaround?
> 
> -Stephen Knudsen

You can try using www.zamzar.com who offer a free online conversion service. It 
is also possible that LibreOffice or Kingsoft Office may open the file.
-- 
Rory O'Farrell 

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Problem with Opening Microsoft *.xlsx Spreadsheets with Open Office

[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% . WTF?)
Tried to rename the offending *.xlsx  file to a different extension,
an  "ods" file extensionbut my Win7 does not allow me using "save as"
to do this

What is the problem here?   And what is the workaround?

-Stephen Knudsen

Re: my open office 4.1.1 spreadsheets predicting

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

Brian Barker


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: my open office 4.1.1 spreadsheets predicting

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

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

my open office 4.1.1 spreadsheets predicting

[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

[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 should work in OpenOffice. Go to Tools | Options... | OpenOffice 
Calc | Calculate and ensure that "Enable regular expressions in 
formulae" is ticked. (That's in Preferences under Mac OS.)


I trust this helps.

Brian Barker


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Finding text strings in spreadsheets

[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

[Tom Backer Johnsen]

Tim

I have to admit that my experience is evidently limited, I only have experience 
with the text type of pdf file.  I was not aware of the “image” type of pdf 
file.  Thank you for that information!

Tom
On 6. Jul 2014, at 07:04 , Tim Deaton  wrote:

> Much depends on the type of pdf file.
> 
> If the pdf file is an image (what you normally get when you scan a document 
> into the computer), then a program with OCR capabilities is needed to try to 
> recognize the text in the image and either add that text to the pdf document 
> or save that text into a 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 it probably actually 
> contains the text (not just a photo) in the file.  In that case, you can 
> highlight the text you want to copy and do a copy-and-paste into Writer.  As 
> Rory wrote, spreadsheet use may need much more care.  Special-purpose 
> programs like Acrobat, Nuance, Foxit, etc. can make such tasks easier -- but 
> they still need careful proof-reading.
> 
> -- Tim
> ===
> 
> 
> On 7/3/2014 3:05 AM, Tom Backer Johnsen wrote:
>> 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 
>> temporary file as a .CSV file.
>> On 2. Jul 2014, at 22:21 , Baccara  wrote:
>> 
>>> 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 to 
>>>> do that. For spreadsheets and other work involving figures most careful 
>>>> proof-reading of the OCR output is required.
>>>> 
>>>> 
>>> OCR - does that equate to Adobe creates an image (jpg or ?) from any 
>>> document "printed to / saved as" a pdf document?
>>> PDF document can be opened with a pdf reader (free from Adobe and other 
>>> sources), content highlighted, copied then pasted to another program such 
>>> as OO Writer; MS Word then saved in the new format?
>> 
>> -
>> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
>> For additional commands, e-mail: users-h...@openoffice.apache.org
>> 
>> 
> 
> 
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
> 

Tom Backer Johnsen
Søndre Steinkjellersmauet 7
5003 Bergen
Mobil: +47 9169 3346
Email: backer(at)psych.uib.no


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

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

[Tim Deaton]

Much depends on the type of pdf file.

If the pdf file is an image (what you normally get when you scan a 
document into the computer), then a program with OCR capabilities is 
needed to try to recognize the text in the image and either add that 
text to the pdf document or save that text into a 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 it probably 
actually contains the text (not just a photo) in the file.  In that 
case, you can highlight the text you want to copy and do a 
copy-and-paste into Writer.  As Rory wrote, spreadsheet use may need 
much more care.  Special-purpose programs like Acrobat, Nuance, Foxit, 
etc. can make such tasks easier -- but they still need careful 
proof-reading.


-- Tim
===


On 7/3/2014 3:05 AM, Tom Backer Johnsen wrote:

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 temporary file as a 
.CSV file.
  
On 2. Jul 2014, at 22:21 , Baccara  wrote:



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 to do 
that. For spreadsheets and other work involving figures most careful 
proof-reading of the OCR output is required.

  

OCR - does that equate to Adobe creates an image (jpg or ?) from any document 
"printed to / saved as" a pdf document?
PDF document can be opened with a pdf reader (free from Adobe and other 
sources), content highlighted, copied then pasted to another program such as OO 
Writer; MS Word then saved in the new format?


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org





-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

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

[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 temporary file as a 
.CSV file.
 
On 2. Jul 2014, at 22:21 , Baccara  wrote:

> 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 to do 
>> that. For spreadsheets and other work involving figures most careful 
>> proof-reading of the OCR output is required.
>> 
>>  
> OCR - does that equate to Adobe creates an image (jpg or ?) from any document 
> "printed to / saved as" a pdf document? 
> PDF document can be opened with a pdf reader (free from Adobe and other 
> sources), content highlighted, copied then pasted to another program such as 
> OO Writer; MS Word then saved in the new format?


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

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

[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 to do 
that. For spreadsheets and other work involving figures most careful 
proof-reading of the OCR output is required.

  
OCR - does that equate to Adobe creates an image (jpg or ?) from any 
document "printed to / saved as" a pdf document? 

PDF document can be opened with a pdf reader (free from Adobe and other 
sources), content highlighted, copied then pasted to another program 
such as OO Writer; MS Word then saved in the new format?

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

[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 do 
that. For spreadsheets and other work involving figures most careful 
proof-reading of the OCR output is required.

-- 
Rory O'Farrell 

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

open pdf documents and save them as spreadsheets or word documents

[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

Email: john.tho...@daytonohio.gov

 

Re: Scrolling within excel spreadsheets.

[許哲崇]

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 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 here:
>
> https://issues.apache.org/ooo/show_bug.cgi?id=124191
>
> solutions here:
>
> https://issues.apache.org/ooo/show_bug.cgi?id=124191#c11
> https://issues.apache.org/ooo/show_bug.cgi?id=124191#c21
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

Re: Scrolling within excel spreadsheets.

[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 here:

https://issues.apache.org/ooo/show_bug.cgi?id=124191

solutions here:

https://issues.apache.org/ooo/show_bug.cgi?id=124191#c11
https://issues.apache.org/ooo/show_bug.cgi?id=124191#c21

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Scrolling within excel spreadsheets.

[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 Twitter
T: +44 (0) 121 439 8906

M: +44 (0) 79 8989 1523

E: simonharrison...@gmail.com

Re: [Bulk] Re: Open Office Spreadsheets

[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,
  Andrea.

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: [Bulk] Re: Open Office Spreadsheets

[Alexandro Colorado]

Please tell us which dictionary are you using and if it shows the
checkup symbol on it.
Languages that dont have this 'checkup' means that it cant find a
dictionary for that language.

On 6/6/14, 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
> Please help!!!
> Glenn
>
> -Original Message-
> From: Greg Madden [mailto:gomadtr...@gci.net]
> Sent: June-05-14 9:49 PM
> To: users@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 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.0
>> > that the previous sheets didn't carry  over.
>> >
>> > In any reply's please make it simple because I'm an old fart who's
>> > not too smart with computers. Hell, I don't even know how to use a
>> > cell phone.
>> >
>> > Thank You,
>> >
>> > Sam
>>
>> They are still on your computer and can be opened by /File /Open - you
>> may need to navigate to the directory in which  they live. As you open
>> each file, it will be added to the recent Files indicator. A new
>> install upgrading from OO 3.x to OO 4.x has had no recent files, so
>> cannot display them.
>
> The OP did not say, but for claification, The 'recent file' list should
> survive a 4.01>4,1.0 upgrade? bug if it did not?
>
> --
> Peace,
>
> Greg
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>


-- 
Alexandro Colorado
Apache OpenOffice Contributor
882C 4389 3C27 E8DF 41B9  5C4C 1DB7 9D1C 7F4C 2614

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

RE: [Bulk] Re: Open Office Spreadsheets

[Glenn Harder]

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
Please help!!!
Glenn

-Original Message-
From: Greg Madden [mailto:gomadtr...@gci.net] 
Sent: June-05-14 9:49 PM
To: users@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 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.0 
> > that the previous sheets didn't carry  over.
> >
> > In any reply's please make it simple because I'm an old fart who's 
> > not too smart with computers. Hell, I don't even know how to use a 
> > cell phone.
> >
> > Thank You,
> >
> > Sam
>
> They are still on your computer and can be opened by /File /Open - you 
> may need to navigate to the directory in which  they live. As you open 
> each file, it will be added to the recent Files indicator. A new 
> install upgrading from OO 3.x to OO 4.x has had no recent files, so 
> cannot display them.

The OP did not say, but for claification, The 'recent file' list should
survive a 4.01>4,1.0 upgrade? bug if it did not?

--
Peace,

Greg

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Open Office Spreadsheets

[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.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.0
> > that the previous sheets didn't carry  over.
> >
> > In any reply's please make it simple because I'm an old fart who's
> > not too smart with computers. Hell, I don't even know how to use a
> > cell phone.
> >
> > Thank You,
> >
> > Sam
>
> They are still on your computer and can be opened by /File /Open -
> you may need to navigate to the directory in which  they live. As you
> open each file, it will be added to the recent Files indicator. A new
> install upgrading from OO 3.x to OO 4.x has had no recent files, so
> cannot display them.

The OP did not say, but for claification, The 'recent file' list should 
survive a 4.01>4,1.0 upgrade? bug if it did not?

-- 
Peace,

Greg

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Open Office Spreadsheets

[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 backed up but 
> I am  curious why when I upgraded to 4.1.0 that the previous sheets didn't 
> carry  over.
>  
> In any reply's please make it simple because I'm an old fart who's not too  
> smart with computers. Hell, I don't even know how to use a cell phone.
>  
> Thank You,   
> 
> Sam

They are still on your computer and can be opened by /File /Open - you may need 
to navigate to the directory in which  they live. As you open each file, it 
will be added to the recent Files indicator. A new install upgrading from OO 
3.x to OO 4.x has had no recent files, so cannot display them.

-- 
Rory O'Farrell 

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Open Office Spreadsheets

[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.0 that the previous sheets didn't 
carry  over.
 
In any reply's please make it simple because I'm an old fart who's not too  
smart with computers. Hell, I don't even know how to use a cell phone.
 
Thank You,   

Sam

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

[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 into almost any spreadsheet,
> including OO.  jt ---

Thanks, for viewing archived  data, cvs works. At least I can view the 
data. None of the formulas,formatting, etc are there, can not use it to 
reuse templates but I can view my wokbooks from 15 years ago. 

For archiving data one needs to archive the platform/OS, application, 
and hardware. Thanks to virtualization vm 's replace hardware, I have 
vm's stored that  allow me access to my old Wordperfect office stuff. 
That is my solution, that and not creating more docs in obscured 
formats. 

Peace,

Greg

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

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

[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
---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

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

[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 third
> party software which claims to convert it
> http://www.abadev.com/xls_conv/
>
> FC

re: http://www.abadev.com/xls_conv/

Supported destination formats
plain text (*.TXT)
comma delimited text (*.CSV)
HTML files (*.HTML)
XML files (*.XML)

Not to usefull, imho.

Peace,

Greg

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

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

[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 Conduct Guidelines:
> http://openoffice.apache.org/list-conduct.html To unsubscribe,
> e-mail: users-unsubscr...@openoffice.apache.org For additional
> commands, e-mail: users-h...@openoffice.apache.org
Does Qpro allow you to save your spreadsheet as a .wb2 file? If it does 
check Openoffice and see if allows you to open .wb2 files. I use 
LibreOffice and it will open a wb2 file. Another choice would be save 
your spreadsheet as a .csv file then use OO to open it.

Hope this helps.
Russ
-- 
openSUSE 13.1(Linux 3.11.10-7-desktop x86_64|
Intel(R) Quad Core(TM) i5-4440 CPU @ 3.10GHz|8GB DDR3|
GeForce 8400GS (NVIDIA-Linux-x86_64-331.49)|KDE 4.12.3


---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

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

[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.abadev.com/xls_conv/

FC
-- 
During times of Universal Deceit, telling the truth becomes a revolutionary
act
Durante épocas de Engaño Universal, decir la verdad se convierte en un Acto
Revolucionario
- George Orwell

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

[Steve Ahlers]

1) open file in quattropro, save as excel 97..., open xls file in calc, save as 
ods, work with ods file in calc.

2) if you don't have quattropro, down load free trial of wordperfect office and 
then proceed with step 1).

3) if you don't run windoz, create a windoz virtual machine and then proceed 
with 2) and then 1).

4) go to www.zamzar.com, follow steps to convert to ods

I had several files to convert from wp and qp and use an iMac so chose to use 
3). Zamzar limits the size of files that you can convert, plus I didn't want to 
share confidential data with a third party. 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 with open 
> office?
> 
> Please revert
> 
> Regards
> 
> Daleep Koshal
> 
> 
> ---
> List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
> 

---
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

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

[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, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org