Re: Date Format error in Spreadsheet

[Fred Lipske]

When using dates if you present it like 1-15, it will show as 1/15/2024 if you 
have it formatted as date!

Sent from Fritz Lipske 

On Jan 16, 2024, at 2:05 AM, David  wrote:

Duane wrote:
> Cell formatted for date in form 12/31/99 reads as the fraction, 1/2  when the 
> date is specified as 1/2/2024.  I have the latest version of installed.  The 
> same problem existed with the down level version.   Let me know if this is a 
> bug or if I am doing something wrong.  All other dates seem to work as they 
> should.
> Thank you for your help and consideration.
> Duane Weber
> du...@austin.rr.com
> [1d73218c-758c-45c9-a2cc-ef10f108762a]
You may have Use replacement table activated under Tools | Autocorrect Options. 
By default this will correct 1/2 to the fraction ½

If you don't want automatic correction, turn it off; alternatively you can 
remove the correction from the replacement table and continue to have 
autocorrection.

Since you are not subscribed to this list you may not see all the replies to 
your query. To subscribe to Apache OpenOffice mailing lists go to 
http://openoffice.apache.org/mailing-lists.html

As a courtesy I have forwarded a copy of this reply to you as well as to the 
mailing list. Do Not reply to me personally but just to the list at 
 - replies to my personal email address will be 
ignored.

-
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: Date Format error in Spreadsheet

[David]

Duane wrote:

Cell formatted for date in form 12/31/99 reads as the fraction, 1/2  when the 
date is specified as 1/2/2024.  I have the latest version of installed.  The 
same problem existed with the down level version.   Let me know if this is a 
bug or if I am doing something wrong.  All other dates seem to work as they 
should.
Thank you for your help and consideration.
Duane Weber
du...@austin.rr.com
[1d73218c-758c-45c9-a2cc-ef10f108762a]
You may have Use replacement table activated under Tools | Autocorrect 
Options. By default this will correct 1/2 to the fraction ½


If you don't want automatic correction, turn it off; alternatively you 
can remove the correction from the replacement table and continue to 
have autocorrection.


Since you are not subscribed to this list you may not see all the 
replies to your query. To subscribe to Apache OpenOffice mailing lists 
go to http://openoffice.apache.org/mailing-lists.html


As a courtesy I have forwarded a copy of this reply to you as well as to 
the mailing list. Do Not reply to me personally but just to the list at 
 - replies to my personal email address 
will be ignored.


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

Re: Date Format error in Spreadsheet

[alannpearce]

I use a Hyphen rather than a forward slash. Alan,Lurking near Bristol UK.Sent 
from my Galaxy
 Original message From: dk...@tuta.io.INVALID Date: 16/01/2024  
00:30  (GMT+00:00) To: Users  Subject: Re: Date 
Format error in Spreadsheet It sees 1/2 as one-half. Type 01/2 and it should 
work OK.--  Sent with Tuta; enjoy secure & ad-free emails:  https://tuta.comJan 
15, 2024, 17:35 by du...@austin.rr.com:> Cell formatted for date in form 
12/31/99 reads as the fraction, 1/2  when the date is specified as 1/2/2024.  I 
have the latest version of installed.  The same problem existed with the down 
level version.   Let me know if this is a bug or if I am doing something wrong. 
 All other dates seem to work as they should.> Thank you for your help and 
consideration.> Duane Weber> du...@austin.rr.com> 
[1d73218c-758c-45c9-a2cc-ef10f108762a]>

Re: Date Format error in Spreadsheet

[Alan B]

Ctrl+Z at the right time also creates the entry as a date.

Type "1/2/". When the 2nd "/" is typed the 1/2 becomes ½.
Immediately type Ctrl+Z and ½ reverts back to 1/2.
Now type /2024 and complete the cell entry.
The date will be correctly entered as "1/2/2024".

On Mon, Jan 15, 2024 at 6:35 PM Duane  wrote:

> Cell formatted for date in form 12/31/99 reads as the fraction, 1/2  when
> the date is specified as 1/2/2024.  I have the latest version of
> installed.  The same problem existed with the down level version.   Let me
> know if this is a bug or if I am doing something wrong.  All other dates
> seem to work as they should.
> Thank you for your help and consideration.
> Duane Weber
> du...@austin.rr.com
> [1d73218c-758c-45c9-a2cc-ef10f108762a]



--

Re: Date Format error in Spreadsheet

[dkoch]

It sees 1/2 as one-half. Type 01/2 and it should work OK.
-- 
 Sent with Tuta; enjoy secure & ad-free emails: 
 https://tuta.com


Jan 15, 2024, 17:35 by du...@austin.rr.com:

> Cell formatted for date in form 12/31/99 reads as the fraction, 1/2  when the 
> date is specified as 1/2/2024.  I have the latest version of installed.  The 
> same problem existed with the down level version.   Let me know if this is a 
> bug or if I am doing something wrong.  All other dates seem to work as they 
> should.
> Thank you for your help and consideration.
> Duane Weber
> du...@austin.rr.com
> [1d73218c-758c-45c9-a2cc-ef10f108762a]
>

Re: Mail merge from spreadsheet

[Krotka]

A pisałeś na adres:
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org


pon., 25 gru 2023, 05:20 użytkownik gerdab...@bigpond.com.INVALID
 napisał:

> Please unsubscribe me from any further mail!
>
> I have tried to unsubscribe several times before, but without sucess! I
> still keep getting them every day!
> Please acknowledge  you have received, and stopped further mail.
>
> Regards
> Gerda
> 
> From: Dick Groskamp 
> Sent: Sunday, December 24, 2023 8:56 AM
> To: users@openoffice.apache.org 
> Subject: Re: Mail merge from spreadsheet
>
> Or visit the wiki:
>
> https://wiki.openoffice.org/wiki/Documentation/How_Tos/Creating_Mail_Merge_Documents_From_Text/CSV_or_Spreadsheets
>
> On 2023/12/23 23:50:32 David wrote:
> > Originally posted by kshan...@twcny.rr.com in a different context.
> >
> > > I'm not the original poster for this subject and I apologize if I'm
> > > doing this wrong.
> > >
> > > I Have Open Office 4.1.14 and I'm having problems following the
> directions below. Might be I am trying to do this starting from the wrong
> place. I have a file "addresses.ods" where I have saved about 70+
> addresses. I was hoping that I could use this file to print out address
> labels in the Avery 8160 format.
> > >
> > > First question might be is it possible to print these out using an ODS
> file?
> > >
> > > Years ago I used Excell to keep service records at the heavy equipment
> shop where I worked and had pretty good luck doing that and putting
> formulas in to flag when something was due for service.
> >
> > Yes, you are doing it wrong; proper way would be to start a new topic.
> > I've done that for you.
> >
> > See
> >
> https://www.openoffice.org/documentation/HOW_TO/word_processing/writer2_EN.html
> >
> > -
> > 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: Mail merge from spreadsheet

[gerdab...@bigpond.com.INVALID]

Please unsubscribe me from any further mail!

I have tried to unsubscribe several times before, but without sucess! I still 
keep getting them every day!
Please acknowledge  you have received, and stopped further mail.

Regards
Gerda

From: Dick Groskamp 
Sent: Sunday, December 24, 2023 8:56 AM
To: users@openoffice.apache.org 
Subject: Re: Mail merge from spreadsheet

Or visit the wiki:
https://wiki.openoffice.org/wiki/Documentation/How_Tos/Creating_Mail_Merge_Documents_From_Text/CSV_or_Spreadsheets

On 2023/12/23 23:50:32 David wrote:
> Originally posted by kshan...@twcny.rr.com in a different context.
>
> > I'm not the original poster for this subject and I apologize if I'm
> > doing this wrong.
> >
> > I Have Open Office 4.1.14 and I'm having problems following the directions 
> > below. Might be I am trying to do this starting from the wrong place. I 
> > have a file "addresses.ods" where I have saved about 70+ addresses. I was 
> > hoping that I could use this file to print out address labels in the Avery 
> > 8160 format.
> >
> > First question might be is it possible to print these out using an ODS file?
> >
> > Years ago I used Excell to keep service records at the heavy equipment shop 
> > where I worked and had pretty good luck doing that and putting formulas in 
> > to flag when something was due for service.
>
> Yes, you are doing it wrong; proper way would be to start a new topic.
> I've done that for you.
>
> See
> https://www.openoffice.org/documentation/HOW_TO/word_processing/writer2_EN.html
>
> -
> 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: Mail merge from spreadsheet

[Dick Groskamp]

Or visit the wiki:
https://wiki.openoffice.org/wiki/Documentation/How_Tos/Creating_Mail_Merge_Documents_From_Text/CSV_or_Spreadsheets

On 2023/12/23 23:50:32 David wrote:
> Originally posted by kshan...@twcny.rr.com in a different context.
> 
> > I'm not the original poster for this subject and I apologize if I'm 
> > doing this wrong.
> > 
> > I Have Open Office 4.1.14 and I'm having problems following the directions 
> > below. Might be I am trying to do this starting from the wrong place. I 
> > have a file "addresses.ods" where I have saved about 70+ addresses. I was 
> > hoping that I could use this file to print out address labels in the Avery 
> > 8160 format.
> > 
> > First question might be is it possible to print these out using an ODS file?
> > 
> > Years ago I used Excell to keep service records at the heavy equipment shop 
> > where I worked and had pretty good luck doing that and putting formulas in 
> > to flag when something was due for service. 
> 
> Yes, you are doing it wrong; proper way would be to start a new topic. 
> I've done that for you.
> 
> See 
> https://www.openoffice.org/documentation/HOW_TO/word_processing/writer2_EN.html
> 
> -
> 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

Mail merge from spreadsheet

[David]

Originally posted by kshan...@twcny.rr.com in a different context.

I'm not the original poster for this subject and I apologize if I'm 
doing this wrong.


I Have Open Office 4.1.14 and I'm having problems following the directions below. Might 
be I am trying to do this starting from the wrong place. I have a file 
"addresses.ods" where I have saved about 70+ addresses. I was hoping that I 
could use this file to print out address labels in the Avery 8160 format.

First question might be is it possible to print these out using an ODS file?

Years ago I used Excell to keep service records at the heavy equipment shop where I worked and had pretty good luck doing that and putting formulas in to flag when something was due for service. 


Yes, you are doing it wrong; proper way would be to start a new topic. 
I've done that for you.


See 
https://www.openoffice.org/documentation/HOW_TO/word_processing/writer2_EN.html


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

How to completely protect the OPEN DOCUMENT SPREADSHEET.

[West Mambalam]

Dear Sir,

I would like to request you kindly help in the procedure for protecting the
SPREADSHEET completely. I have protected my sheet as per procedure but even
after protecting the sheet, when we click right button the copy option is
enabled. I want to protect the sheet in which even COPY option also should
not work. The spreadsheet should in such a way that with password it should
be modified. Kindly help me in this regards.

With Regards
D Naresh Kumar

Lost Spreadsheet

[Eugene Hacker]

I was updating a spreadsheet that had a lot of previous data on it
when the system reacted strangely and came back with a spreadsheet
that was completely blank.
I tried to restart OpenOffice to see if I had a copy that needed to be
restored.  There was no indication a a bad file.
My question is, can I locate a previous version of my spreadsheet as I
have not saved any new copy since.
Is there any way to access a previous version from any directory that
might have a copy of my previous version of my spreadsheet

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

Re: Copying cells locks up spreadsheet

[Leon Zar]

If you have any kind of clipboard manager, try disabling it to see if that
helps.  If so, then you'll need to configure it (if possible) to ignore
copies from OO.  I had this problem on a Mac and fixed it by doing the
same thing.
Regards,
  Leon

On Mon, Sep 18, 2023 at 10:20 AM Robert Burt  wrote:

> I am having the exact same problem!  Had to buy a copy of excel to be able
> to work spreadsheets.  Bob
>
> Bob
>
>
> > On Sep 17, 2023, at 11:39 PM, David Robley  wrote:
> >
> > Using Windows 11 ? Windows 11 has a new Clipboard Manager - go to Start
> > Settings, Click Clipboard on the System tab and turn off Suggested
> Actions; if that doesn't help, try turning off Clipboard History.
> >
> > Since you are not subscribed to this list you may not see all the
> replies to your query. To subscribe to Apache OpenOffice mailing lists go
> to http://openoffice.apache.org/mailing-lists.html
> >
> > As a courtesy I have forwarded a copy of this reply to you as well as to
> the mailing list. Do Not reply to me personally but just to the list at <
> users@openoffice.apache.org> - replies to my personal email address will
> be ignored.
> >
> >> On 18/09/2023 09:56, Jim Wilde wrote:
> >> I’ve tried removing the software and re-loading it, and nothing seems
> to work. Every time I copy cells, the spreadsheet locks up and closes the
> program. Any ideas?
> >>
> >> Jim
> >> Arizona, USA
> >>
> >> Sent from my iPhone
> >>
> >> -
> >> 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: Copying cells locks up spreadsheet

[Robert Burt]

I am having the exact same problem!  Had to buy a copy of excel to be able to 
work spreadsheets.  Bob

Bob


> On Sep 17, 2023, at 11:39 PM, David Robley  wrote:
> 
> Using Windows 11 ? Windows 11 has a new Clipboard Manager - go to Start > 
> Settings, Click Clipboard on the System tab and turn off Suggested Actions; 
> if that doesn't help, try turning off Clipboard History.
> 
> Since you are not subscribed to this list you may not see all the replies to 
> your query. To subscribe to Apache OpenOffice mailing lists go to 
> http://openoffice.apache.org/mailing-lists.html
> 
> As a courtesy I have forwarded a copy of this reply to you as well as to the 
> mailing list. Do Not reply to me personally but just to the list at 
>  - replies to my personal email address will be 
> ignored.
> 
>> On 18/09/2023 09:56, Jim Wilde wrote:
>> I’ve tried removing the software and re-loading it, and nothing seems to 
>> work. Every time I copy cells, the spreadsheet locks up and closes the 
>> program. Any ideas?
>> 
>> Jim
>> Arizona, USA
>> 
>> Sent from my iPhone
>> 
>> -
>> 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: Copying cells locks up spreadsheet

[David Robley]

Using Windows 11 ? Windows 11 has a new Clipboard Manager - go to Start 
> Settings, Click Clipboard on the System tab and turn off Suggested 
Actions; if that doesn't help, try turning off Clipboard History.


Since you are not subscribed to this list you may not see all the 
replies to your query. To subscribe to Apache OpenOffice mailing lists 
go to http://openoffice.apache.org/mailing-lists.html


As a courtesy I have forwarded a copy of this reply to you as well as to 
the mailing list. Do Not reply to me personally but just to the list at 
 - replies to my personal email address 
will be ignored.


On 18/09/2023 09:56, Jim Wilde wrote:

I’ve tried removing the software and re-loading it, and nothing seems to work. 
Every time I copy cells, the spreadsheet locks up and closes the program. Any 
ideas?

Jim
Arizona, USA

Sent from my iPhone

-
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: Copying cells locks up spreadsheet

[Thats only me.]

And that it should beWell missunderstanding 
Sent from AOL on Android 
 
  On Mon, 18 Sept 2023 at 7:38, Jim Wilde wrote:   I’ve tried 
removing the software and re-loading it, and nothing seems to work. Every time 
I copy cells, the spreadsheet locks up and closes the program. Any ideas?

Jim
Arizona, USA

Sent from my iPhone

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

  

Copying cells locks up spreadsheet

[Jim Wilde]

I’ve tried removing the software and re-loading it, and nothing seems to work. 
Every time I copy cells, the spreadsheet locks up and closes the program. Any 
ideas?

Jim
Arizona, USA

Sent from my iPhone

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

Re: Spreadsheet

[Joost Andrae]

Hi,

the easiest way to fix this within a spreadsheet is to do a 
search with regular expressions option activated.


open the search dialog using Ctrl+F and activate "regular 
expression" within the "more options" part of that dialog.


search: .*

replace: &

This will remove all trailing single quotes from cells.

Kind regards, Joost

Am 26.06.2023 um 16:00 schrieb Martin Groenescheij:

Hi Frank, Please fix the Cells first.



Make sure all are formatted as Numbers and check that no value is preceded with 
a apostrophe ' .












 On Sat, 24 Jun 2023 18:22:15 +0200   wrote ---





Thank Martin, havn't tried it yet. I seem to take one step forward and two 
back. Last time I tried to build this spreadsheet Im could do a multiplication 
like A1*A2 then grab a symbols in the bottom right corner of the cell and drag 
it down to get B1*B2 etc. Now I can't get the symbol.

Sorry to be pain in the proverbial

Frank




On Saturday, 24 June 2023 at 16:41:40 BST, Martin Groenescheij 
<mailto:mar...@groenescheij.com> wrote:







=SUM(A1:A14) Not =SUM(A1;A14)










 On Sat, 24 Jun 2023 12:10:33 +0200  <mailto:frank.ledb...@sky.com> wrote 
---





Thanks Martin, moving on I am now having trouble summimg a column of numbers 
(each being the result of a multiplication). In the formula bar Iwant to  type 
sum(A1;A8) but ~I am trying to chick on the cells A1 etc which puts the cell in 
the formula but when I hit ; the whole formula is replaced with the colon.

Frank




On Friday, 23 June 2023 at 18:02:56 BST, Martin Groenescheij 
<mailto:mar...@groenescheij.com> wrote:





Could it be that one ore both Cells is formatted as Text?

If you copy values from another source it could be copied as text which you 
could check in the formula bar, it shows then with a leading apostrophe e.g. 
‘123



Simple way to check is to enter =VALUE(B1)*VALUE(C1)

















 On Fri, 23 Jun 2023 18:40:36 +0200 
mailto:frank.ledb...@sky.com.INVALID<mailto:frank.ledb...@sky.com.INVALID> 
wrote 



Having problem multiplying the values in two cella.I have tried =B1*C1 for 
example but it doesn't workDisappointed as my attempt at division worked fine 
on a previous worksheet using for example=A1/B1Please help if you canFrank




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

Re: Spreadsheet

[Martin Groenescheij]

Hi Frank, Please fix the Cells first.



Make sure all are formatted as Numbers and check that no value is preceded with 
a apostrophe ' .












 On Sat, 24 Jun 2023 18:22:15 +0200   wrote ---





Thank Martin, havn't tried it yet. I seem to take one step forward and two 
back. Last time I tried to build this spreadsheet Im could do a multiplication 
like A1*A2 then grab a symbols in the bottom right corner of the cell and drag 
it down to get B1*B2 etc. Now I can't get the symbol.

Sorry to be pain in the proverbial 

Frank




On Saturday, 24 June 2023 at 16:41:40 BST, Martin Groenescheij 
<mailto:mar...@groenescheij.com> wrote:







=SUM(A1:A14) Not =SUM(A1;A14)










 On Sat, 24 Jun 2023 12:10:33 +0200  <mailto:frank.ledb...@sky.com> wrote 
---





Thanks Martin, moving on I am now having trouble summimg a column of numbers 
(each being the result of a multiplication). In the formula bar Iwant to  type 
sum(A1;A8) but ~I am trying to chick on the cells A1 etc which puts the cell in 
the formula but when I hit ; the whole formula is replaced with the colon.

Frank




On Friday, 23 June 2023 at 18:02:56 BST, Martin Groenescheij 
<mailto:mar...@groenescheij.com> wrote:





Could it be that one ore both Cells is formatted as Text?

If you copy values from another source it could be copied as text which you 
could check in the formula bar, it shows then with a leading apostrophe e.g. 
‘123



Simple way to check is to enter =VALUE(B1)*VALUE(C1)

















 On Fri, 23 Jun 2023 18:40:36 +0200 
mailto:frank.ledb...@sky.com.INVALID<mailto:frank.ledb...@sky.com.INVALID> 
wrote 



Having problem multiplying the values in two cella.I have tried =B1*C1 for 
example but it doesn't workDisappointed as my attempt at division worked fine 
on a previous worksheet using for example=A1/B1Please help if you canFrank

Re: Spreadsheet

[Martin Groenescheij]

=SUM(A1:A14) Not =SUM(A1;A14)










 On Sat, 24 Jun 2023 12:10:33 +0200   wrote ---





Thanks Martin, moving on I am now having trouble summimg a column of numbers 
(each being the result of a multiplication). In the formula bar Iwant to  type 
sum(A1;A8) but ~I am trying to chick on the cells A1 etc which puts the cell in 
the formula but when I hit ; the whole formula is replaced with the colon.

Frank




On Friday, 23 June 2023 at 18:02:56 BST, Martin Groenescheij 
 wrote:





Could it be that one ore both Cells is formatted as Text?

If you copy values from another source it could be copied as text which you 
could check in the formula bar, it shows then with a leading apostrophe e.g. 
‘123



Simple way to check is to enter =VALUE(B1)*VALUE(C1)

















 On Fri, 23 Jun 2023 18:40:36 +0200 
mailto:frank.ledb...@sky.com.INVALID 
wrote 



Having problem multiplying the values in two cella.I have tried =B1*C1 for 
example but it doesn't workDisappointed as my attempt at division worked fine 
on a previous worksheet using for example=A1/B1Please help if you canFrank

Re: Spreadsheet

[alannpearce]

Is the answer to "Copy Paste Special"?Sent from my Galaxy
 Original message From: Martin Groenescheij 
 Date: 23/06/2023  18:03  (GMT+00:00) To: 
Users  Cc: frank.ledb...@sky.com Subject: Re: 
Spreadsheet             Could it be that one ore both Cells is 
formatted as Text?If you copy values from another source it could be copied as 
text which you could check in the formula bar, it shows then with a leading 
apostrophe e.g. ‘123Simple way to check is to enter =VALUE(B1)*VALUE(C1)    
 On Fri, 23 Jun 2023 18:40:36 +0200  
frank.ledb...@sky.com.INVALID wrote  Having 
problem multiplying the values in two cella.I have tried =B1*C1 for example but 
it doesn't workDisappointed as my attempt at division worked fine on a previous 
worksheet using for example=A1/B1Please help if you canFrank            
      

Re: Spreadsheet

[Martin Groenescheij]

Could it be that one ore both Cells is formatted as Text?If you 
copy values from another source it could be copied as text which you could 
check in the formula bar, it shows then with a leading apostrophe e.g. 
‘123Simple way to check is to enter =VALUE(B1)*VALUE(C1) On Fri, 23 Jun 
2023 18:40:36 +0200  
frank.ledb...@sky.com.INVALID wrote  Having 
problem multiplying the values in two cella.I have tried =B1*C1 for example but 
it doesn't workDisappointed as my attempt at division worked fine on a previous 
worksheet using for example=A1/B1Please help if you canFrank  

Spreadsheet

[frank.ledb...@sky.com.INVALID]

Having problem multiplying the values in two cella.I have tried =B1*C1 for 
example but it doesn't workDisappointed as my attempt at division worked fine 
on a previous worksheet using for example=A1/B1Please help if you canFrank

Spreadsheet crash

[Glenn Little WB4UIV]

I may have reached some software limitations.
I have a large spreadsheet that I am editing.
The spreadsheet has 31 sheets.
Each sheet has 7 columns.
The largest sheet currently has 25000 lines.
The next largest sheet has 8500 lines.

When I try and save the file I sometimes get the following error message:
OpenOffice 4.1.14 - Fatal Error
! Bad Allocation.
When I press OK the program gives me the option to recover the file.

Sometimes the program just crashes, usually after moving data around 
giving the following error message:

OpenOffice 4.1.14
OpenOffice Document Recovery
Due to an unexpected error. OpenOffice crashed. All the files you were 
working on will now be saved. The next time OpenOffice is launched, your 
files will be recovered automatically.

The following files will be recovered:
(the file I was working on).

Other times I get the following error message:
Microsoft Visual C++ Runtime Library
Runtime error
Program C:/Program Files (x86)\OpenOffice 4\program\soffice.bin
This application has requested the Runtime to terminate it in an unusual 
way.

Please contact the application's support team for more information.

The os is Windows 10.

Have I exceeded the design limits of the program?
If so, what limit have I exceeded?

What causes the above error messages?

Thank you
Glenn

--
---
Glenn LittleARRL Technical Specialist   QCWA  LM 28417
Amateur Callsign:  WB4UIVwb4...@arrl.netAMSAT LM 2178
QTH:  Goose Creek, SC USA (EM92xx)  USSVI, FRA, NRA-LMARRL TAPR
"It is not the class of license that the Amateur holds but the class
of the Amateur that holds the license"

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

Re: Spreadsheet Issue

[Leon Zar]

Hello Conner,
By any chance are you using any kind of clipboard manager software?  There
may be a conflict between it and OO.  If you are using one, try disabling
it to see if the problem persists.
Regards,
  Leon

On Sun, Dec 25, 2022 at 12:50 PM Conner Cardwell 
wrote:

> Hello and Merry Christmas.  I am hoping you can help me with a problem we
> are having on the spreadsheet within OpenOffice.  When we attempt to copy
> and paste data from one cell to another, the application freezes up and the
> copy paste function does not complete.  Please let me know how we can
> remedy this.  We are using Windows 11 Home with 8 GB of RAM.
>
> Thanks
> Conner
>

Spreadsheet Issue

[Conner Cardwell]

Hello and Merry Christmas.  I am hoping you can help me with a problem we
are having on the spreadsheet within OpenOffice.  When we attempt to copy
and paste data from one cell to another, the application freezes up and the
copy paste function does not complete.  Please let me know how we can
remedy this.  We are using Windows 11 Home with 8 GB of RAM.

Thanks
Conner

RE: Take a cell value from a spreadsheet into another

[Brian Barker]

At 13:19 16/11/2022 +0200, Amin Jack Pedziwiater  wrote:
You struggling because you misunderstand the OO Suite's 
construction. There are the different programs with different 
engines to do different functions for create and manage different 
forms of documentation within one compatible System itself. Results 
of formulas are counted and displayed only on subprograms they 
created. That's idea of open source software.


Isn't this roughly the opposite of the real situation? Some office 
suites are indeed collections of separate programs. Microsoft may 
present its collection of Word, Excel, Powerpoint, and so on as 
"Microsoft Office", but they are still separate programs. (If you 
don't believe me, try opening a spreadsheet document from within 
Word. It won't open in Excel.) But OpenOffice is an integrated 
package, and when you have it open, you can open documents of various 
types - text, spreadsheet, presentation - within it. And, contrary to 
what you say, you can transfer or link results from one type of 
document to another.


If there is any difference in this matter between commercial and open 
source software, it is surely the reverse of what you suggest?


Brian Barker 




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

Re: Take a cell value from a spreadsheet into another

[PCS]

Dear Richard,

I think you will find that if you copy the cell in the original spreadsheet 
normally, then in the spreadsheet you want to paste the information into use 
the Paste Special command in the Edit Menu instead of doing a standard paste, 
and in the window that opens select what you want to be pasted, e.g. in this 
case (if I have correctly understood) “Paste Value”, or maybe it’s “Paste 
Number”, I’m going from memory here, and I’m currently using LO, and OO and LO 
do it a little differently, so the details may not be exactly as I have 
outlined, but the fundamental is to use Paste Special instead of a normal 
paste. And it is not limited to copying single cells, you can copy a selected 
group of cells. This works not only between OpenOffice spreadsheets and between 
OpenOffice and LibreOffice, I also routinely paste data from Google Sheets to 
OO or LO using Paste Special to get it from another person’s Android phone to 
my records.

If I’ve understood your problem correctly I think this should solve your 
problem.

Peter.


> On 16 Nov 2022, at 9:19 pm, Amin Jack P©dziwiater 
>  wrote:
> 
> Dearer Sir
> You struggling because you misunderstand the OO Suite's construction. There 
> are the different programs with different engines to do different functions 
> for create and manage different forms of documentation within one compatible 
> System itself. Results of formulas are counted and displayed only on 
> subprograms they created. That's idea of open source software. I seem, I 
> cannot help you with your problem anymore.
> A.J.P.
> 
> -Original Message-
> From: Richard Gill [mailto:richard.gill1...@gmail.com] 
> Sent: Wednesday, November 16, 2022 11:23 AM
> To: users@openoffice.apache.org
> Subject: Take a cell value from a spreadsheet into another
> 
> Dear Sir
> 
> I am struggling to find a way to display the results of a formula when
> editing into a different document. It picks up the formatting, but not the
> results.
> 
> Can you help please?
> 
> Richard Gill
> 
> 
> -
> 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: Take a cell value from a spreadsheet into another

[Regina Henschel]

Hi Richard,

Richard Gill schrieb am 16.11.2022 um 10:23:

Dear Sir

I am struggling to find a way to display the results of a formula when
editing into a different document. It picks up the formatting, but not the
results.

Can you help please?


1. Make sure source and target file are already saved.
2. Open source and target file.
3. Write = in the cell in the target file.
4. Click on the cell in the source file.
5. Go back to the target file.
You should have got something like this in the formula bar:
='file:///D:/Desktop/KannwegSource.ods'#$Sheet1.A4
The cell itself will show the result.

When the source changes, you can go to Edit > Links, select the 
corresponding entry and click on Update button.


Of course you can write the formula manually too.

Notice, that URL is absolute. So you need to change the formula when 
moving the source file.


Or you can try function DDE. For syntax see help. But I cannot get it to 
update, at least not as array function for a range, so there might be 
something broken with DDE.


Kind regards,
Regina





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

RE: Take a cell value from a spreadsheet into another

[Amin Jack P©dziwiater]

Dearer Sir
You struggling because you misunderstand the OO Suite's construction. There are 
the different programs with different engines to do different functions for 
create and manage different forms of documentation within one compatible System 
itself. Results of formulas are counted and displayed only on subprograms they 
created. That's idea of open source software. I seem, I cannot help you with 
your problem anymore.
A.J.P.

-Original Message-
From: Richard Gill [mailto:richard.gill1...@gmail.com] 
Sent: Wednesday, November 16, 2022 11:23 AM
To: users@openoffice.apache.org
Subject: Take a cell value from a spreadsheet into another

Dear Sir

I am struggling to find a way to display the results of a formula when
editing into a different document. It picks up the formatting, but not the
results.

Can you help please?

Richard Gill


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

Re: Take a cell value from a spreadsheet into another

[David Robley]

For context see https://forum.openoffice.org/en/forum/viewtopic.php?t=108886

On 16/11/2022 19:53, Richard Gill wrote:

Dear Sir

I am struggling to find a way to display the results of a formula when
editing into a different document. It picks up the formatting, but not the
results.

Can you help please?

Richard Gill



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

Take a cell value from a spreadsheet into another

[Richard Gill]

Dear Sir

I am struggling to find a way to display the results of a formula when
editing into a different document. It picks up the formatting, but not the
results.

Can you help please?

Richard Gill

Re: Calc Spreadsheet Questions (Linda)

[PCS]

1.  Make the font size bigger, then make the row height bigger, to fit the 
selected font size, or select optimal height to have the spreadsheet 
automatically adjust the row height for the text size, and also to auto-adjust 
for multiple lines of text in a cell if you use text wrapping, and finally 
adjust the cell width to fit the larger text or to determine where to wrap it.

•   If it is possible to change the default font size I don't know how, but 
if you create a template with the settings you prefer and save it as stationery 
you can open a new document that is ready to use without having to change font 
sizes etc.

2.  I don’t know how Windows deals with this but I believe OO and LO are 
pretty consistent across platforms (they certainly are on Mac and Linux, that 
is one of their ’selling’ points), so try copying the data in the Word document 
and using Edit / Paste Special / Paste Special… (in the first Paste Special 
menu), and in the next dialog box select “Use text import dialog”, then OK. 
Using LO on the Mac (I’ve recently switched from OO) that placed a group of tab 
or return separated numbers (see below) from a text document into different 
cells in the spreadsheet and made them able to be used in it (a simple copy and 
paste does not do this, it ignores the tabs and puts a whole row of numbers 
into a single cell). I’m pretty sure OO did the much same on the Mac and it 
should be pretty similar on Windows. Expert users probably have a better way of 
doing this, which could be worth learning if you are doing it often, but if you 
only do it occasionally and this works for you why waste time and effort 
learning to become an expert, just use the tools that you already have to hand.

123 456 789
987 654 321

This group of numbers was pasted into a spreadsheet as described above.

123 456 789 
1368
987 654 321 
1962





111011101110
3330





And these calculations were performed on them (the imported text size has been 
adjusted to be the same as the other text in this document).

•   If I have misunderstood and you are copying from a Spreadsheet to a 
text document, a simple copy and paste should work, though some text resizing 
and tidying up may be required. To copy largish portions of a sheet you could 
make a screen pic of the portion you want to use and insert that into your text 
document, but it will be displayed as a graphics object instead of being 
integrated into the text. If all that you want is a particular sheet or a 
selected portion of a sheet, with no other text or data that is not in the 
spreadsheet itself, it may be better just to save the selected portion of the 
spreadsheet as a PDF document, e.g. my wife operates a very small business and 
I do her monthly invoices that way and email out the PDF documents, because we 
can’t justify the cost of proper invoicing software for such a micro-business.

3.  Sorry, I’m not sure what’s happening there, maybe a Windows issue or 
maybe an OO setting that I’ve forgotten exists, or maybe something else 
entirely.

I hope some of this may be of use to you,

Peter.


> On 7 Nov 2022, at 4:03 am, Linda Hull  wrote:
> 
> I'm on Windows 10, Open Office 4.1.11.
> 
> I'd like to:
> 
> 1. Make the cells and text in a Calc spreadsheet larger, easier to read.
> 2. Put data on a spreadsheet that appears in a Writer document.  I send
> simple letters, don't know page styles etc.
> 
> Are there directions somewhere or can someone explain the steps?
> 
> 3. In the past, when I've saved and reopened a spreadsheet, the headings I
> put in appear lower down.  Is there a way to make them stay at the top?
> 
> Thanks so much!
> 
> Linda

Calc Spreadsheet Questions

[Linda Hull]

I'm on Windows 10, Open Office 4.1.11.

I'd like to:

1. Make the cells and text in a Calc spreadsheet larger, easier to read.
2. Put data on a spreadsheet that appears in a Writer document.  I send
simple letters, don't know page styles etc.

Are there directions somewhere or can someone explain the steps?

3. In the past, when I've saved and reopened a spreadsheet, the headings I
put in appear lower down.  Is there a way to make them stay at the top?

Thanks so much!

Linda

Win 10 ... Apache "Spreadsheet"

[James Jenkins]

I've been using this Spreadsheet file for a month now, suddenly in one 
cell,  a very bold bottom and right side line appears unable to get 
rid of it, (tried several, ways, no luck).

re: Extracting info from various columns in a Spreadsheet

[hardmo...@gtoast.net.INVALID]

Hello Open Office,
  
 re: Extracting info from various columns in a Spreadsheet
  
 I have been using Open Office for years, it's a great tool.
  
 Can you please help me with the following;
  
 Let's say I have a Spreadsheet where multiple columns have data (say 
columns A-K), but I only need email addresses and names (say from column A 
& D).
  
 I need a list as follows;
 email address;name
 danad...@unitedyxxx.com;Dan Adams
joelambr...@unitedyxxx.com;Joel Ambrose
a...@unitedyxxx.com;Alex Andrades
t...@unitedyxxx.com;Todd Astles
  
 How do I get a list with just the data from columns A & D, with a semi 
colon between the two?
  
 Thank You very much.
  
 Best Regards,
 Eric R. Sanders
  
   Eric R. Sanders RANDOLPH CAPITAL LLC  www.Premium-Auctions.net

  Tel  386-789-9441

"IMPORTANT LEGAL NOTICE: The foregoing message (including all attachments)  
contains CONFIDENTIAL and/or PRIVILEGED INFORMATION and is for the use of 
the intended recipient(s) only.  It is covered by the Electronic 
Communications Privacy Act, 18 U.S.C. Sections 2510-2521.  It  contains 
CONFIDENTIAL and/or PRIVILEGED INFORMATION and may also be protected by 
other PRIVILEGE. If you are not the intended recipient of this message, you 
are hereby notified that any retention, dissemination, distribution or 
copying of this communication is strictly prohibited and subject to 
CRIMINAL and/or CIVIL SANCTIONS. Please reply to the sender that you have 
received this message in error, then permanently delete it and destroy all 
of its contents immediately."  

Re: Spreadsheet

[Chuck Spalding]

Karl,

If I correctly understand your objective, try these steps:

1. Enter the desired multiplier in any cell (e.g., 1.05 for a 5% increase).
2. Select that cell and copy to the clipboard (i.e., Edit > Copy).
3. Select all the cells you want to modify (e.g., click on the first cell
and Shift-Click on the last cell).
4. Select Edit > Paste Special...
5. Click on the "Multiply" selection under "Operations".
6. Make sure "Numbers" is selected in the "Selection" choices, or simply
select "Paste all".
7. Click on "OK".

If you don't like the result, you can select Edit > Undo: Copy to restore
the previous values. (Don't ask me why it's "Undo: *Copy*" when you just
did a *Paste*. ;-)

Note that the "Multiply" selection in the Paste Special dialog is retained,
so you will need to be careful if you next want to use Paste Special for a
different behavior.

Chuck

On Tue, Mar 29, 2022 at 9:27 AM stmo  wrote:

>   I am trying to increase a number in a column by a percentage but I want
> to increase the entire column.
> [snip]

>
> > On Mon, Mar 28, 2022 at 11:40 AM stmo  wrote:
> >
> >> I have spent an entire week trying to find an answer to this.
> >>
> >> I need the formula and exactly where to put it in order to increase a
> >> percentage amount in a spread sheet with numerous entry's   Could not
> >> find in FAQs   We use windows 10 and OO 4.4.5
> >>
> >> Thanks
> >> Karl G
>
[snip]

Re: Spreadsheet

[stmo]

 I am trying to increase a number in a column by a percentage but I want 
to increase the entire column.

On 2022-03-29 08:48, Alan B wrote:


You want to...

a) increase certain entries by a percentage

- or -

b) increase a percentage already in the spread sheet

If a) then enter the percentage in a cell of your choice, remember
percentages less than 100% are entered as fractions, e.g. 20% is 
entered as
.2, 45% as .45, and so on. Multiply the value that needs to increase by 
the

percentage and add that amount to the value.
If the value is 55 and is in cell B1
and the percentage to increase is 10% and .1 is entered in C1
and the new value should appear in D1, then in D1 enter the following
=B1+(B1*C1)

If b) and there is a cell with a percentage already in the spreadsheet, 
and
that percentage is being used already in formulas in the spreadsheet, 
then

change the percentage to the new value.

On Mon, Mar 28, 2022 at 11:40 AM stmo  wrote:


I have spent an entire week trying to find an answer to this.

I need the formula and exactly where to put it in order to increase a
percentage amount in a spread sheet with numerous entry's   Could not
find in FAQs   We use windows 10 and OO 4.4.5

Thanks
Karl G


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

Re: Spreadsheet

[Alan B]

You want to...

a) increase certain entries by a percentage

- or -

b) increase a percentage already in the spread sheet

If a) then enter the percentage in a cell of your choice, remember
percentages less than 100% are entered as fractions, e.g. 20% is entered as
.2, 45% as .45, and so on. Multiply the value that needs to increase by the
percentage and add that amount to the value.
If the value is 55 and is in cell B1
and the percentage to increase is 10% and .1 is entered in C1
and the new value should appear in D1, then in D1 enter the following
=B1+(B1*C1)

If b) and there is a cell with a percentage already in the spreadsheet, and
that percentage is being used already in formulas in the spreadsheet, then
change the percentage to the new value.

On Mon, Mar 28, 2022 at 11:40 AM stmo  wrote:

>
> I have spent an entire week trying to find an answer to this.
>
>   I need the formula and exactly where to put it in order to increase a
> percentage amount in a spread sheet with numerous entry's   Could not
> find in FAQs   We use windows 10 and OO 4.4.5
>
> Thanks
> Karl G



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

Spreadsheet

[stmo]

   I have spent an entire week trying to find an answer to this.

 I need the formula and exactly where to put it in order to increase a 
percentage amount in a spread sheet with numerous entry's   Could not 
find in FAQs   We use windows 10 and OO 4.4.5


Thanks
Karl G

Re: working in spreadsheet

[Alan B]

Cannot see how the spreadsheet looks. Pictures are not saved / displayed on
the help list.

And... what happened, how did you save the spreadsheet? I do not understand
what you mean, "...saved it md titmrd off computer...".

On Thu, Feb 3, 2022 at 2:45 PM Linda Howell 
wrote:

> i saved my spreadsheet and saved it md titmrd off computer. next meet
> morning i woke up to the spreadsheet looking like this
> i need help. asap. i have 7 months of stuff on this. thank u
> Sent from my iPhone
>


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

working in spreadsheet

[Linda Howell]

i saved my spreadsheet and saved it md titmrd off computer. next meet morning i 
woke up to the spreadsheet looking like 
this[cid:4231365B-F3B8-4B4C-AF1E-9F030C35AB55]
i need help. asap. i have 7 months of stuff on this. thank u
Sent from my iPhone

Re: Apache Spreadsheet Issue

[Dick Groskamp]

On 2021/10/24 02:45:55, Bill T  wrote: 
> On the Apache Spreadsheet (OpenOffice Calc), an equal sign cannot be
> entered into a cell.  Apparently the program will expect an equation to be
> built in the cell when it sees an equal sign.  A solution seen on the
> internet was to go to File>Autocorrect to fix this but there is no
> Autocorrect as an option.  My version is 4.1.11.  I need the ability to
> enter any typewriter character into a cell as text.
> 
> Let me know, if you can, what I can do to correct this problem.  I thought
> that perhaps there is a pay-for version for Apache that has the Autocorrect
> function but I saw nothing about that on the internet.
> 
> Thank you, Bill
> 
Autocorrect  =  Tools  ⇾ Autocorrect Options

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

Re: Apache Spreadsheet Issue

[Rory O'Farrell]

On Sat, 23 Oct 2021 19:45:55 -0700
Bill T  wrote:

> On the Apache Spreadsheet (OpenOffice Calc), an equal sign cannot be
> entered into a cell.  Apparently the program will expect an equation to be
> built in the cell when it sees an equal sign.  A solution seen on the
> internet was to go to File>Autocorrect to fix this but there is no
> Autocorrect as an option.  My version is 4.1.11.  I need the ability to
> enter any typewriter character into a cell as text.
> 
> Let me know, if you can, what I can do to correct this problem.  I thought
> that perhaps there is a pay-for version for Apache that has the Autocorrect
> function but I saw nothing about that on the internet.
> 
> Thank you, Bill

Format your cell as "Text".

-- 
Rory O'Farrell 

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

Apache Spreadsheet Issue

[Bill T]

On the Apache Spreadsheet (OpenOffice Calc), an equal sign cannot be
entered into a cell.  Apparently the program will expect an equation to be
built in the cell when it sees an equal sign.  A solution seen on the
internet was to go to File>Autocorrect to fix this but there is no
Autocorrect as an option.  My version is 4.1.11.  I need the ability to
enter any typewriter character into a cell as text.

Let me know, if you can, what I can do to correct this problem.  I thought
that perhaps there is a pay-for version for Apache that has the Autocorrect
function but I saw nothing about that on the internet.

Thank you, Bill

Need help with cascading spreadsheet inserts

[K Salisbury]

Dear OO,
I'm using OO for creating a book to contain a collection of 8,600
dictionary entries that are in spreadsheet format. (My previous collection,
of 7,000 entries, was accepted and complimented by the President of Wolfson
College, Oxford University.  It's a novel type of collection.  48-hour
Books made the finished book from the pdf I made using OO.)
*The Problem:*
I place a section of the spreadsheet on each page of the text document,
within the margins.  It often happens that two or more sections of
spreadsheet will cascade into a mess, leaving several blank text pages
below them.  It seems to happen if I try to adjust the position of the
spreadsheet section on the text page.

I've tried to figure out the problem, but cannot be 100% sure.  Can you
kindly advise me?
(Happy to email you a PDF of the first book, *The Global Evolution of Words*
.)
Thank you!
Kim Salisbury
PO Box 304
Bodfish CA 93205  USA
760-223-5970 text ok

problem with spreadsheet

[Greenvolt Solutions]

Dear Open office support team,
Good day to you.
Been using open office for some years now, and facing the same problem all
this while, it just shut down automatically and go under the recovery. may
i know is there any way to solve this problem?.
OpenOffice 4.1.10 is up to date.

Stay safe and stay healthy.

Thank you.
Best regards,
Suntek

Re: Can User Functions Be Created In OpenOffice Spreadsheet

[Julian Thomas]

> On May 26, 2021, at 16:58, David Stuhr  
> wrote:
> 
> I have an OpenOffice Calc (spreadsheet) that has over a thousand Hyperlinks 
> and I would like to create a user defined function which would extract the 
> URL from the Hyperlink and put it in a separate cell.

If all else fails this should work:

- export as CSV [or TSV]
- write a program to find the URLs and rebuild the CSV with the new cell
- open in calc and save as .calc

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

Do unto those downstream as you would have those upstream do unto you. - 
Wendell Berry 






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

Re: Can User Functions Be Created In OpenOffice Spreadsheet

[Andrew Pitonyak]

you can write user defined functions it's very easy. The easiest way is to pass 
the value of a cell and then just return a string or whatever you want. I don't 
remember what happens when you pass the cell value like that if you are parsing 
out text and pulling out a URL property it's probably easier if you have the 
address so you can actually pull the cell and then look at properties but I'm 
hanging out in the car far from any of my documentation so that would be tricky 
to find.

The easiest way to do that is to make sure that the user-defined macro that you 
created is embedded in the document in question and then put it in the standard 
library so that it's automatically loaded. They're better ways to get around 
that but that's absolutely the easiest way to do it.

If you really can't figure it out let me know.

⁣Get BlueMail for Android ​

On May 26, 2021, 4:58 PM, at 4:58 PM, David Stuhr 
 wrote:
>Hello,
>
>I have an OpenOffice Calc (spreadsheet) that has over a thousand
>Hyperlinks and I would like to create a user defined function which
>would extract the URL from the Hyperlink and put it in a separate cell.
>
>I found an Excel example on the web which I pasted in below.
>
>Function GetURL(rng As Range) As String
> On Error Resume Next
> GetURL = rng.Hyperlinks(1).Address
>End Function
>
>Can this be done in OpenOffice Calc? I have looked for documentation
>but
>I probably using the incorrect terms so I have not found any
>information. I use both the Windows and Mac versions of Open office.
>Thank you. I enjoy reading the support you provide to users and I have
>learned several things. dds

Can User Functions Be Created In OpenOffice Spreadsheet

[David Stuhr]

Hello,

I have an OpenOffice Calc (spreadsheet) that has over a thousand 
Hyperlinks and I would like to create a user defined function which 
would extract the URL from the Hyperlink and put it in a separate cell.


I found an Excel example on the web which I pasted in below.

Function GetURL(rng As Range) As String
On Error Resume Next
GetURL = rng.Hyperlinks(1).Address
End Function

Can this be done in OpenOffice Calc? I have looked for documentation but 
I probably using the incorrect terms so I have not found any 
information. I use both the Windows and Mac versions of Open office. 
Thank you. I enjoy reading the support you provide to users and I have 
learned several things. dds

Re: Spreadsheet to word document

[David Belina]

You can convert to a PDF.


On March 11, 2021 at 9:00:27 AM, Barry Hooks (wbho...@gmail.com) wrote:

Can you convert or save an existing spreadsheet in Open Office to a word/text 
document? Thank you. 

Barry Hooks 

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

Spreadsheet to word document

[Barry Hooks]

Can you convert or save an existing spreadsheet in Open Office to a word/text 
document?  Thank you.

Barry Hooks

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

Re: Saving spreadsheet data from an outside source

[Robin Lord]

use the ' save as' option and then specify the file type for an open office 
format from the list by clicking the little down arrow

On Wed, 9 Dec 2020, at 04:42, ed fiscus wrote:
> My desktop runs on Microsoft 10 but I can’t save a spreadsheet file 
> from the outside to Open Officer.  It wants me to save it as excel 
> which I don’t have.
> I can create spreadsheets in my bank account but when I run the report, 
>  it won’t save it in Open office.  
> 
> Can you help me?
> 
> Ed  
> 
> Sent from Mail for Windows 10
> 
>

-- 
Best Regards

Robin

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

Saving spreadsheet data from an outside source

[ed fiscus]

My desktop runs on Microsoft 10 but I can’t save a spreadsheet file from the 
outside to Open Officer.  It wants me to save it as excel which I don’t have.
I can create spreadsheets in my bank account but when I run the report,  it 
won’t save it in Open office.  

Can you help me?

Ed  

Sent from Mail for Windows 10

Open office spreadsheet troubles

[vi blaha]

I am running open office on Microsoft Pro with arm processor
I keep losing data in my spreadsheets. I open a file and look at a tab and half 
my data is missing. 

Do an unexpected error Open Office crashed. All the files you were working on 
will be saved. The next time Open Office is launched your files will be 
recovered automatically. 

The data is not recovered

When I try to copy the data from a backup to just this tab it crashes



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

Re: problems with spreadsheet

[Shari Lynn Smith]

Are you saying the program closes by itself? Without you clicking the X?
Are you seeing an error message when it does that?

On Wed, Sep 9, 2020, 10:09 AM casey rost 
wrote:

> 1. I really need to be able to use the spreadsheet. I entered everything
> individually. While typing it would just close. I would go back in recover
> the spreadsheet but none of the entries I made would be there so I would
> have to retype everything again. As entering it closes and loose
> everything. This happened on 4.1 and 4.7.   The friend who created the
> spreadsheet had saved everything prior to my using it. She had done some
> tests to see if it was totaling. Made sure it was saved. When I started
> using her total rows were not there. Because it closes at random during
> entering we learned to save often. But it doesn’t seem to be doing that.
> Jean
>
>
> Sent from Yahoo Mail for iPhone
>
>
> On Wednesday, September 9, 2020, 7:36 AM, Martin Groenescheij <
> mar...@groenescheij.com> wrote:
>
>
> On 08/09/2020 15:30, casey rost wrote:
> > I have never used the spreadsheet before but a friend set me up and I am
> having problems.
> So it looks that your friend has set you up and now you are upset
> >It closes out before I get all my info entered.
> So where does it closes out? How do you enter the data? Via the keyboard
> or with copy and paste?
> >I tried to update and receive message not compatable.
> Try to enter data in small portions, save it during data entry and see
> where it is not compatible.
> >  I retype info and keeps doing same error.  I uploaded the newer version
> available.  And it does the same thing.
> So it looks like the problem is with your data
> >Wondering if someone can fix it.  My computer is Asus.  Jean Rost
> >
> > Sent from Mail for Windows 10
> >
> >
>
>
>
>

Re: problems with spreadsheet

[Martin Groenescheij]

On 09/09/2020 17:00, casey rost wrote:

1. I really need to be able to use the spreadsheet. I entered everything 
individually. While typing it would just close. I would go back in recover the 
spreadsheet but none of the entries I made would be there so I would have to 
retype everything again. As entering it closes and loose everything. This 
happened on 4.1 and 4.7.   The friend who created the spreadsheet had saved 
everything prior to my using it.
There could be many setting which differ from the settings at your 
friends PC e.g. memory settings

or security settings.

  She had done some tests to see if it was totaling.

Did your friend tested it on your or here system?

  Made sure it was saved. When I started using her total rows were not there.

When you open the spreadsheet, can you see the rows that should total?

  Because it closes at random during entering we learned to save often.
Try to enter data with the AutoCalculate option switched off from the 
Tools - Cell Contents

But it doesn’t seem to be doing that. Jean


Sent from Yahoo Mail for iPhone


On Wednesday, September 9, 2020, 7:36 AM, Martin Groenescheij 
 wrote:


On 08/09/2020 15:30, casey rost wrote:

I have never used the spreadsheet before but a friend set me up and I am having 
problems.

So it looks that your friend has set you up and now you are upset

     It closes out before I get all my info entered.

So where does it closes out? How do you enter the data? Via the keyboard
or with copy and paste?

     I tried to update and receive message not compatable.

Try to enter data in small portions, save it during data entry and see
where it is not compatible.

   I retype info and keeps doing same error.  I uploaded the newer version 
available.  And it does the same thing.

So it looks like the problem is with your data

     Wondering if someone can fix it.  My computer is Asus.  Jean Rost

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: problems with spreadsheet

[casey rost]

1. I really need to be able to use the spreadsheet. I entered everything 
individually. While typing it would just close. I would go back in recover the 
spreadsheet but none of the entries I made would be there so I would have to 
retype everything again. As entering it closes and loose everything. This 
happened on 4.1 and 4.7.   The friend who created the spreadsheet had saved 
everything prior to my using it. She had done some tests to see if it was 
totaling. Made sure it was saved. When I started using her total rows were not 
there. Because it closes at random during entering we learned to save often. 
But it doesn’t seem to be doing that. Jean 


Sent from Yahoo Mail for iPhone


On Wednesday, September 9, 2020, 7:36 AM, Martin Groenescheij 
 wrote:


On 08/09/2020 15:30, casey rost wrote:
> I have never used the spreadsheet before but a friend set me up and I am 
> having problems.
So it looks that your friend has set you up and now you are upset
>    It closes out before I get all my info entered.
So where does it closes out? How do you enter the data? Via the keyboard 
or with copy and paste?
>    I tried to update and receive message not compatable.
Try to enter data in small portions, save it during data entry and see 
where it is not compatible.
>  I retype info and keeps doing same error.  I uploaded the newer version 
>available.  And it does the same thing.
So it looks like the problem is with your data
>    Wondering if someone can fix it.  My computer is Asus.  Jean Rost
>
> Sent from Mail for Windows 10
>
>

Re: problems with spreadsheet

[Martin Groenescheij]

On 08/09/2020 15:30, casey rost wrote:

I have never used the spreadsheet before but a friend set me up and I am having 
problems.

So it looks that your friend has set you up and now you are upset

   It closes out before I get all my info entered.
So where does it closes out? How do you enter the data? Via the keyboard 
or with copy and paste?

   I tried to update and receive message not compatable.
Try to enter data in small portions, save it during data entry and see 
where it is not compatible.

  I retype info and keeps doing same error.  I uploaded the newer version 
available.  And it does the same thing.

So it looks like the problem is with your data

   Wondering if someone can fix it.  My computer is Asus.  Jean Rost

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

problems with spreadsheet

[casey rost]

I have never used the spreadsheet before but a friend set me up and I am having 
problems.  It closes out before I get all my info entered.  I tried to update 
and receive message not compatable.  I retype info and keeps doing same error.  
I uploaded the newer version available.  And it does the same thing.  Wondering 
if someone can fix it.  My computer is Asus.  Jean Rost

Sent from Mail for Windows 10

Re: Open Office [spreadsheet document?]

[mermaidlady]

Thanks so much for those who have responded to me. I have posted answers
to the detailed questions in the beginner area of the forum.

All best, Joelle

On 2020-08-23 16:39, Brian Barker wrote:

At 12:36 23/08/2020 -0400, you wrote: 


One of my Open Office Excel files ...


Excel is a proprietary product of Microsoft and has nothing to do with 
OpenOffice. Do you perhaps mean a spreadsheet document file prepared in 
OpenOffice?


... is not opening.


So what *exactly* happens when you try to open it? As long as you keep this a 
secret, it is unlikely that anyone will be able to help you.


My other files are opening fine.


Good-oh: so there is nothing wrong with your computer or your installation of 
the OpenOffice program.


It is a very big file with a list of emails. I wonder if the links are too 
heavy or complex?


I doubt that. If there had been a problem, you would very likely have 
discovered that when you created the document or last edited it.


Is there anything I can do to retrieve my data?


Yes: explain (1) exactly how you are trying to open the document (there are 
many ways), and (2) exactly what happens when you try - including details of 
what error messages you see.

I trust this helps.

Brian Barker - privately

Re: add formula to cell in openoffice spreadsheet

[David Robley]

A simple =D1*E1 placed in F1 should do what you want - assuming that D 
and E contain numbers, not text. You can check the type of content in 
cells using View | Value Highlighting or the keyboard shortcut Ctrl+F8. 
The formula can then be copied or dragged down as needed.


Text cells are formatted in black, formulas in green, and number cells 
in blue, no matter how their display is formatted.


Since you are not subscribed to this list you may not see all the 
replies to your query. To subscribe to Apache OpenOffice mailing lists 
go to http://openoffice.apache.org/mailing-lists.html


As a courtesy I have sent a copy of this reply to you as well as to the 
mailing list. Do Not reply to me personally but just to the list at 
 - replies to my personal email address 
will be ignored.


On 10/8/20 3:04 pm, mick howe wrote:

been battling to use a simple formula in a spreadsheet to cause each cell
'Fx' to equal the contents of cell 'Ex' of the same row multiplied by the
contents of cell 'Dx'. I have done this in MS Office v2 to v6 and 97, Star
Office on both OS/2 & various Linux versions and libreoffice until version
6.
When I try to do this, either on Linux or win10 I get either no result or
messages along the lines of #error=NAME?, #NAME=#508? or just no result.
I can't see any explanation when I search for the meaning of the error
messages
Even when I tried to open a sheet I did a couple of years ago with very
similar calculations in LibreOffice I experienced the same problems.
Please help, it is doing my head in.

mick in glen innes 2370



Cheers
--
David Robley

Remember, UNIX spelled backwards is XINU.
 

add formula to cell in openoffice spreadsheet

[mick howe]

been battling to use a simple formula in a spreadsheet to cause each cell
'Fx' to equal the contents of cell 'Ex' of the same row multiplied by the
contents of cell 'Dx'. I have done this in MS Office v2 to v6 and 97, Star
Office on both OS/2 & various Linux versions and libreoffice until version
6.
When I try to do this, either on Linux or win10 I get either no result or
messages along the lines of #error=NAME?, #NAME=#508? or just no result.
I can't see any explanation when I search for the meaning of the error
messages
Even when I tried to open a sheet I did a couple of years ago with very
similar calculations in LibreOffice I experienced the same problems.
Please help, it is doing my head in.

mick in glen innes 2370

Spreadsheet errors

[Karen Werkheiser]

Hello
I have been using an OpenOffice  spreadsheet for 7 years now.  
Suddenly this week when when I open it it, a pop up box opens with ASCII Filter 
options.
If I leave as selected the page opens with a Full page of #’s. And all my data 
is not showing.
What to I do to get the information back?
I have it saved on a flash drive.
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Open Office Spreadsheet question

[Martin Groenescheij]

On 10/07/2020 21:50, Glenn Little WB4UIV wrote:

How can I display non printable characters?



So my first reply was wrong?

Now the real question here should not be how to display non printable 
characters,
but how do non printable characters came in the first place into your 
spreadsheet.


Using your keyboard as a source of input it will be impossible to enter 
non printable characters.


The only way is to copy data from an other source e.g. from a website. 
Websites have al kind of non
printable characters and you should clean the source before you paste 
them into your spreadsheet.


One way is to copy the data into a writer document and use the 
functionality to View non printable

characters there. Clean it and copy the result into your spreadsheet.




Thank you
Glenn



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

Re: Open Office Spreadsheet question

[Chuck Spalding]

Using OpenOffice 4.1.7 on macOS High Sierra (10.13.6), I do not see that
menu selection in *Calc*. (I do see View > "Nonprinting Characters" in
*Writer*.)

Chuck

On Fri, Jul 10, 2020 at 1:14 PM Martin Groenescheij 
wrote:

>
>
> > On 10 Jul 2020, at 21:50, Glenn Little WB4UIV <
> glennmaill...@bellsouth.net> wrote:
> >
> > How can I display non printable characters?
>
> Top menu select View than select View non printable characters
>
> [snip]

Re: Open Office Spreadsheet question

[Martin Groenescheij]

> On 10 Jul 2020, at 21:50, Glenn Little WB4UIV  
> wrote:
> 
> How can I display non printable characters?

Top menu select View than select View non printable characters

> 
> Thank you
> Glenn
> 
> -- 
> ---
> Glenn LittleARRL Technical Specialist   QCWA  LM 28417
> Amateur Callsign:  WB4UIVwb4...@arrl.netAMSAT LM 2178
> QTH:  Goose Creek, SC USA (EM92xx)  USSVI LM   NRA LM   SBE ARRL TAPR
> "It is not the class of license that the Amateur holds but the class
> of the Amateur that holds the license"
> 
> 
> -
> 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

Open Office Spreadsheet question

[Glenn Little WB4UIV]

How can I display non printable characters?

Thank you
Glenn

--
---
Glenn LittleARRL Technical Specialist   QCWA  LM 28417
Amateur Callsign:  WB4UIVwb4...@arrl.netAMSAT LM 2178
QTH:  Goose Creek, SC USA (EM92xx)  USSVI LM   NRA LM   SBE ARRL TAPR
"It is not the class of license that the Amateur holds but the class
of the Amateur that holds the license"


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

Re: Another spreadsheet formatting query

[Martin Groenescheij]

Optimal Row Height is not the same as Optimal Column Width

On 10/06/2020 23:55, David Deeks wrote:

Sorry, here’s attachment ! ...


On 10 Jun 2020, at 22:53, Prof  wrote:

Having had my cell colours query sorted so quickly by you very helpful people, 
I’m gonna push my luck because I have discovered another one!

I am finding that apparently random rows do not set themselves to my selected 
‘optimal height’?

See attached extract from a recordings catalogue. Optimal row height default value 
is set to 0.0 cm, and many rows appear to set themselves to this. Note however the 
rows for the following artists/albums (columns A & B). I’d really appreciate it 
if someone can identify what creates the wider row spacing?

Ruby Braff Hear me talkin’!
Ry Cooder The slide area
Shakatak Out of this world
Steve Forbert Jackrabbit slim
Steve Miller Band Greatest hits
Steve Miller Band Abracadbra







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

Re: Another spreadsheet formatting query

[David Deeks]

Sorry, here’s attachment ! ...

> On 10 Jun 2020, at 22:53, Prof  wrote:
> 
> Having had my cell colours query sorted so quickly by you very helpful 
> people, I’m gonna push my luck because I have discovered another one!
> 
> I am finding that apparently random rows do not set themselves to my selected 
> ‘optimal height’?
> 
> See attached extract from a recordings catalogue. Optimal row height default 
> value is set to 0.0 cm, and many rows appear to set themselves to this. Note 
> however the rows for the following artists/albums (columns A & B). I’d really 
> appreciate it if someone can identify what creates the wider row spacing?
> 
> Ruby Braff Hear me talkin’!
> Ry Cooder The slide area
> Shakatak Out of this world
> Steve Forbert Jackrabbit slim
> Steve Miller Band Greatest hits
> Steve Miller Band Abracadbra
> 
> 
> 



linespacing.ods
Description: application/vnd.oasis.opendocument.spreadsheet

> 



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

Another spreadsheet formatting query

[Prof]

Having had my cell colours query sorted so quickly by you very helpful people, 
I’m gonna push my luck because I have discovered another one!

I am finding that apparently random rows do not set themselves to my selected 
‘optimal height’?

See attached extract from a recordings catalogue. Optimal row height default 
value is set to 0.0 cm, and many rows appear to set themselves to this. Note 
however the rows for the following artists/albums (columns A & B). I’d really 
appreciate it if someone can identify what creates the wider row spacing?

Ruby Braff Hear me talkin’!
Ry Cooder The slide area
Shakatak Out of this world
Steve Forbert Jackrabbit slim
Steve Miller Band Greatest hits
Steve Miller Band Abracadbra





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

Re: Text/background colours on spreadsheet

[David Deeks]

Brian, Dan

Thanks so much for these replies, really helpful.

Very glad I joined the support group!

All best

David

On Wed, 10 Jun 2020, 13:44 Dan Lewis,  wrote:

> There is  third way to do this using styles. Had you created a style
> which described all of the characteristics you want (background AND
> text) the particular cell to have, giving other cells involves only two
> simple steps:
>
> 1) Click the cell.
> 2) Double click the style.
>
> If you want to do this to several cells at one time, select the cells
> and then double click.
>
> AOO is designed to use styles to define properties that can be used over
> and over again if necessary. This is especially true in Writer when it
> simplifies formatting text documents. It is just as true for cells,
> rows, columns, and group of cells in Calc. There should be information
> in the Calc Guide as to how to do this.
>
> Dan
>
> On 6/10/20 06:35, David Deeks wrote:
> > Hi all
> >
> > I am editing a previously created spreadsheet that uses a variety of
> colours for background and text. I need to add more cells that use the same
> colours. If I select an existing cell, is there a way of identifying the
> previously used colours? At the moment I’m selecting all colours that look
> close, until I find the right one!
> >
> > Thanks
> >
> > David D
> > -
> > 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: Text/background colours on spreadsheet

[Dan Lewis]

There is  third way to do this using styles. Had you created a style 
which described all of the characteristics you want (background AND 
text) the particular cell to have, giving other cells involves only two 
simple steps:


1) Click the cell.
2) Double click the style.

If you want to do this to several cells at one time, select the cells 
and then double click.


AOO is designed to use styles to define properties that can be used over 
and over again if necessary. This is especially true in Writer when it 
simplifies formatting text documents. It is just as true for cells, 
rows, columns, and group of cells in Calc. There should be information 
in the Calc Guide as to how to do this.


Dan

On 6/10/20 06:35, David Deeks wrote:

Hi all

I am editing a previously created spreadsheet that uses a variety of colours 
for background and text. I need to add more cells that use the same colours. If 
I select an existing cell, is there a way of identifying the previously used 
colours? At the moment I’m selecting all colours that look close, until I find 
the right one!

Thanks

David D
-
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: Text/background colours on spreadsheet

[Brian Barker]

At 11:35 10/06/2020 +0100, David Deeks wrote:
I am editing a previously created spreadsheet that uses a variety of 
colours for background and text. I need to add more cells that use 
the same colours. If I select an existing cell, is there a way of 
identifying the previously used colours? At the moment I'm selecting 
all colours that look close, until I find the right one!


You probably don't need to identify the colours, but merely to 
reproduce them. Two ways to do this:


(As has already been suggested)
o Select a representative cell.
o Click the Format Paintbrush in the Standard toolbar.
o Either click in a target cell or drag across a target range.
Note that you can double-click the Format Paintbrush if you wish to 
format multiple cells or ranges. Press Esc to cancel the facility.


o Copy a representative cell.
o Select a target cell or target range.
o Paste, but using Paste Special (or Ctrl+Shift+V) instead of ordinary paste.
o In the Paste Special dialogue, untick Paste All if necessary and 
ensure that only Formats is selected.


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: Text/background colours on spreadsheet

[Peter Kovacs]

You could copy the format from and existing cell.
Just select the cell you want to copy from.
Then select the brush from the toolbar.
Then select the target cell you want to copy to.


Am 10. Juni 2020 12:35:19 MESZ schrieb David Deeks :
>Hi all
>
>I am editing a previously created spreadsheet that uses a variety of
>colours for background and text. I need to add more cells that use the
>same colours. If I select an existing cell, is there a way of
>identifying the previously used colours? At the moment I’m selecting
>all colours that look close, until I find the right one!
>
>Thanks
>
>David D
>-
>To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
>For additional commands, e-mail: users-h...@openoffice.apache.org

Text/background colours on spreadsheet

[David Deeks]

Hi all

I am editing a previously created spreadsheet that uses a variety of colours 
for background and text. I need to add more cells that use the same colours. If 
I select an existing cell, is there a way of identifying the previously used 
colours? At the moment I’m selecting all colours that look close, until I find 
the right one!

Thanks

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

Re: Spreadsheet Formula Hiding "0"

[Joost Andrae]

Hi,

you can also format those cells using the user defined cell format # to 
suppress so called leading zeroes in cells.


->format->cells->numbers->Format Code: #

Kind regards, Joost

Am 02.06.2020 um 00:51 schrieb David Robley:
There is an option to globally suppress display of zeros - see Tools | 
Options | OpenOffice Calc | View and uncheck Zero Values in the Display 
section.


Since you are not subscribed to this list you may not see all the 
replies to your query. To subscribe to Apache OpenOffice mailing lists 
go to http://openoffice.apache.org/mailing-lists.html


As a courtesy I have sent a copy of this reply to you as well as to the 
mailing list. Do Not reply to me personally but just to the list at 
 - replies to my personal email address 
will be ignored.


On 2/6/20 7:43 am, Snapafun wrote:

Great suite - Thanks.

I love to hide the "0" value in cells yet to be populated and to do so 
I use the =IF(Target Cell>0;Actual Formula;"") setup.


This works well for me upon the Target Cell being the result or a 
manual entry.


However, this doesn't work when the Target Cell contains a formula. ( 
I appreciate that the formula setup as above is correct and that it 
now recognizes that the Target Cell is populated so is ">0" - just 
that viewed in real life - no actual value yet exists.)


Maybe there's a way of re-addressing the value "0" in the 1st part 
though it would be nice for a private user to be able to keep their 
formulas simple.


So - not necessary a fault or bug or anything at all - just a thought 
in case it's possible.




Cheers




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

Re: Spreadsheet Formula Hiding "0"

[David Robley]

There is an option to globally suppress display of zeros - see Tools | 
Options | OpenOffice Calc | View and uncheck Zero Values in the Display 
section.


Since you are not subscribed to this list you may not see all the 
replies to your query. To subscribe to Apache OpenOffice mailing lists 
go to http://openoffice.apache.org/mailing-lists.html


As a courtesy I have sent a copy of this reply to you as well as to the 
mailing list. Do Not reply to me personally but just to the list at 
 - replies to my personal email address 
will be ignored.


On 2/6/20 7:43 am, Snapafun wrote:

Great suite - Thanks.

I love to hide the "0" value in cells yet to be populated and to do so 
I use the =IF(Target Cell>0;Actual Formula;"") setup.


This works well for me upon the Target Cell being the result or a 
manual entry.


However, this doesn't work when the Target Cell contains a formula. ( 
I appreciate that the formula setup as above is correct and that it 
now recognizes that the Target Cell is populated so is ">0" - just 
that viewed in real life - no actual value yet exists.)


Maybe there's a way of re-addressing the value "0" in the 1st part 
though it would be nice for a private user to be able to keep their 
formulas simple.


So - not necessary a fault or bug or anything at all - just a thought 
in case it's possible.




Cheers
--
David Robley

Its a JOKE, like the funny kind but different.
 



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

Spreadsheet Formula Hiding "0"

[Snapafun]

Great suite - Thanks.

I love to hide the "0" value in cells yet to be populated and to do so I 
use the =IF(Target Cell>0;Actual Formula;"") setup.


This works well for me upon the Target Cell being the result or a manual 
entry.


However, this doesn't work when the Target Cell contains a formula. ( I 
appreciate that the formula setup as above is correct and that it now 
recognizes that the Target Cell is populated so is ">0" - just that 
viewed in real life - no actual value yet exists.)


Maybe there's a way of re-addressing the value "0" in the 1st part 
though it would be nice for a private user to be able to keep their 
formulas simple.


So - not necessary a fault or bug or anything at all - just a thought in 
case it's possible.


--
Regards
Frank
SnapafunFrank
facebook.com/JanFrankBreezie

New doc in calc spreadsheet

[Victoria Lehman]

I created a new spreadsheet, titled it and saved it.  Now I am trying to
open another new untitled spreadsheet and everytime I click on Spreadsheet
I get an untitled copy of the spreadsheet I did first.  Do I have to select
and delete all the information in new spreadsheets every time?  Why don't I
just get a blank untitled spreadsheet?

Re: Numbers automatically advance in spreadsheet columns

[David Deeks]

Thanks for this - a really useful suggestion!

David D

On Tue, 28 Apr 2020, 04:50 Jean Lear,  wrote:

> As a regular user of Calc in Apache OpenOffice I have added two extra items
> to my tool bar (another learning curve to do this).  I have added 'Fill
> Down' and 'Fill Series'
> Fill Series will bring up the Fill Series window which allows a lot  of
> alternatives for what is being done in the column or row selected.
> Fill down is also useful to repeat text down a number of rows.
> Hope this extra information helps.
> Jean
>
> On Tue, Apr 28, 2020 at 4:27 AM Peter Kovacs  wrote:
>
> > 1) Mark the Cell
> >
> > 2) Right Klick -> select copy
> >
> > 3) select first Cell of your row. (i.e. the cell below)
> >
> > 4) Press shift And mark the last cell -> you now see the rows that you
> > target marked.
> >
> > 5) right click select copy.
> >
> >
> > Am 27.04.20 um 19:08 schrieb David Deeks:
> > > I have been an Open Office user for many years, but only recently
> > discovered this group, and have already learned a couple of things!
> > >
> > > I am hoping however that someone can help with a specific and
> > longstanding problem with numbers in spreadsheet columns. If I have a
> cell
> > with a number in that I want repeated down the column, I would love to
> able
> > to simply highlight the cell and drag down the column. The problem is
> that
> > in each line the numbers always increase by 1. This is useful of course
> > sometimes, but not always! I have tried all formats, including text etc,
> > and feel as though I’ve looked through every menu - but cannot find how
> to
> > stop it doing this. I am sure there must be a way?
> > >
> > > Thanks
> > >
> > > David Deeks
> > > -
> > > 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: Numbers automatically advance in spreadsheet columns

[Jean Lear]

As a regular user of Calc in Apache OpenOffice I have added two extra items
to my tool bar (another learning curve to do this).  I have added 'Fill
Down' and 'Fill Series'
Fill Series will bring up the Fill Series window which allows a lot  of
alternatives for what is being done in the column or row selected.
Fill down is also useful to repeat text down a number of rows.
Hope this extra information helps.
Jean

On Tue, Apr 28, 2020 at 4:27 AM Peter Kovacs  wrote:

> 1) Mark the Cell
>
> 2) Right Klick -> select copy
>
> 3) select first Cell of your row. (i.e. the cell below)
>
> 4) Press shift And mark the last cell -> you now see the rows that you
> target marked.
>
> 5) right click select copy.
>
>
> Am 27.04.20 um 19:08 schrieb David Deeks:
> > I have been an Open Office user for many years, but only recently
> discovered this group, and have already learned a couple of things!
> >
> > I am hoping however that someone can help with a specific and
> longstanding problem with numbers in spreadsheet columns. If I have a cell
> with a number in that I want repeated down the column, I would love to able
> to simply highlight the cell and drag down the column. The problem is that
> in each line the numbers always increase by 1. This is useful of course
> sometimes, but not always! I have tried all formats, including text etc,
> and feel as though I’ve looked through every menu - but cannot find how to
> stop it doing this. I am sure there must be a way?
> >
> > Thanks
> >
> > David Deeks
> > -
> > 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: Numbers automatically advance in spreadsheet columns

[Peter Kovacs]

1) Mark the Cell

2) Right Klick -> select copy

3) select first Cell of your row. (i.e. the cell below)

4) Press shift And mark the last cell -> you now see the rows that you 
target marked.


5) right click select copy.


Am 27.04.20 um 19:08 schrieb David Deeks:

I have been an Open Office user for many years, but only recently discovered 
this group, and have already learned a couple of things!

I am hoping however that someone can help with a specific and longstanding 
problem with numbers in spreadsheet columns. If I have a cell with a number in 
that I want repeated down the column, I would love to able to simply highlight 
the cell and drag down the column. The problem is that in each line the numbers 
always increase by 1. This is useful of course sometimes, but not always! I 
have tried all formats, including text etc, and feel as though I’ve looked 
through every menu - but cannot find how to stop it doing this. I am sure there 
must be a way?

Thanks

David Deeks
-
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: Numbers automatically advance in spreadsheet columns

[David Deeks]

Brian, Alan

Thanks so much for your very prompt replies - problem solved!

Well pleased I discovered the group!

All best

David

> On 27 Apr 2020, at 18:25, Brian Barker  
> wrote:
> 
> At 18:08 27/04/2020 +0100, David Deeks wrote:
>> I have been an Open Office user for many years, but only recently discovered 
>> this group, and have already learned a couple of things!
> 
> Only two?
> 
> ;^)
> 
>> I am hoping however that someone can help with a specific and longstanding 
>> problem with numbers in spreadsheet columns. If I have a cell with a number 
>> in that I want repeated down the column, I would love to able to simply 
>> highlight the cell and drag down the column. The problem is that in each 
>> line the numbers always increase by 1. This is useful of course sometimes, 
>> but not always!
> 
> There are various ways to do this.
> 
> o (As someone has already said) Use Ctrl+fill instead of normal fill.
> 
> o Enter the same number again in the cell immediately below the original. 
> Select both cells. (Drag over them or use click and Shift+click). Now fill 
> down as usual.
> 
> o Select the entire range you want filled - including your original cell. Go 
> to Edit | Fill > | Down.
> 
> o For more complex requirements, select the entire range and use Edit | Fill 
> > | Series... .
> 
> 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
> 


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

Re: Numbers automatically advance in spreadsheet columns

[WA.TWORSX via AOL]

TNX Alan:

I had experienced same as David did; now I know that I must hold Ctrl 
key to repeat the number while dragging the mouse pointer.


Regards, and please ALL, stay safe.

VinceB.

On 4/27/2020 1:13 PM, Alan B wrote:

Hello David,

Have you tried,
- select cell
- grab cell handle at bottom right with mouse left click and hold
- press and hold Ctrl key
- drag mouse

That will produce a column that repeats the number in the highlighted cell.

On Mon, Apr 27, 2020 at 1:08 PM David Deeks 
wrote:


I have been an Open Office user for many years, but only recently
discovered this group, and have already learned a couple of things!

I am hoping however that someone can help with a specific and longstanding
problem with numbers in spreadsheet columns. If I have a cell with a number
in that I want repeated down the column, I would love to able to simply
highlight the cell and drag down the column. The problem is that in each
line the numbers always increase by 1. This is useful of course sometimes,
but not always! I have tried all formats, including text etc, and feel as
though I’ve looked through every menu - but cannot find how to stop it
doing this. I am sure there must be a way?

Thanks

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

Re: Numbers automatically advance in spreadsheet columns

[Brian Barker]

At 18:08 27/04/2020 +0100, David Deeks wrote:
I have been an Open Office user for many years, but only recently 
discovered this group, and have already learned a couple of things!


Only two?

;^)

I am hoping however that someone can help with a specific and 
longstanding problem with numbers in spreadsheet columns. If I have 
a cell with a number in that I want repeated down the column, I 
would love to able to simply highlight the cell and drag down the 
column. The problem is that in each line the numbers always increase 
by 1. This is useful of course sometimes, but not always!


There are various ways to do this.

o (As someone has already said) Use Ctrl+fill instead of normal fill.

o Enter the same number again in the cell immediately below the 
original. Select both cells. (Drag over them or use click and 
Shift+click). Now fill down as usual.


o Select the entire range you want filled - including your original 
cell. Go to Edit | Fill > | Down.


o For more complex requirements, select the entire range and use Edit 
| Fill > | Series... .


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: Numbers automatically advance in spreadsheet columns

[Alan B]

Hello David,

Have you tried,
- select cell
- grab cell handle at bottom right with mouse left click and hold
- press and hold Ctrl key
- drag mouse

That will produce a column that repeats the number in the highlighted cell.

On Mon, Apr 27, 2020 at 1:08 PM David Deeks 
wrote:

> I have been an Open Office user for many years, but only recently
> discovered this group, and have already learned a couple of things!
>
> I am hoping however that someone can help with a specific and longstanding
> problem with numbers in spreadsheet columns. If I have a cell with a number
> in that I want repeated down the column, I would love to able to simply
> highlight the cell and drag down the column. The problem is that in each
> line the numbers always increase by 1. This is useful of course sometimes,
> but not always! I have tried all formats, including text etc, and feel as
> though I’ve looked through every menu - but cannot find how to stop it
> doing this. I am sure there must be a way?
>
> Thanks
>
> David Deeks
> -
> 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

Numbers automatically advance in spreadsheet columns

[David Deeks]

I have been an Open Office user for many years, but only recently discovered 
this group, and have already learned a couple of things!

I am hoping however that someone can help with a specific and longstanding 
problem with numbers in spreadsheet columns. If I have a cell with a number in 
that I want repeated down the column, I would love to able to simply highlight 
the cell and drag down the column. The problem is that in each line the numbers 
always increase by 1. This is useful of course sometimes, but not always! I 
have tried all formats, including text etc, and feel as though I’ve looked 
through every menu - but cannot find how to stop it doing this. I am sure there 
must be a way?

Thanks

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

Re: sorting in spreadsheet

[Shari Lynn Smith]

Have you check to see if you set some sort of protection on the area?

On Sun, Apr 26, 2020, 2:19 PM Michael Thomas 
wrote:

> I have used Open Office for decades. I have used it for my finances. I
> have many tabs and have always moved thing around – deleted – copied –
> pasted - and sorted.
>
>
>
> But something happened this weekend. I have red lines around things I have
> moved. And I cannot sort. The sort button is greyed out. I cannot sort
> anything in any of my tabs. I can sort stuff in other files but not in any
> of the tabs in my finances file.
>
>
> Sent from Mail for
> Windows 10
>
>

Re: sorting in spreadsheet

[Brian Barker]

At 19:08 26/04/2020 +, Michael Thomas wrote:
I have used Open Office for decades. [...] But something happened 
this weekend. I have red lines around things I have moved. And I 
cannot sort. The sort button is greyed out. I cannot sort anything 
in any of my tabs. I can sort stuff in other files but not in any of 
the tabs in my finances file.


You have - presumably inadvertently - toggled on the recording of 
changes for this document file.


o If you want to keep all the changes you have made, toggle this off 
again at Edit | Changes > | Record.


o If you want to be selective about what changes you keep, go to Edit 
| Changes > | Accept or Reject... first, and deal with the changes 
one by one. Then toggle recording off again at Edit | Changes > | Record.


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

sorting in spreadsheet

[Michael Thomas]

I have used Open Office for decades. I have used it for my finances. I have 
many tabs and have always moved thing around – deleted – copied – pasted - and 
sorted.



But something happened this weekend. I have red lines around things I have 
moved. And I cannot sort. The sort button is greyed out. I cannot sort anything 
in any of my tabs. I can sort stuff in other files but not in any of the tabs 
in my finances file.


Sent from Mail for Windows 10

Re: Time Sheet:Suggestion from an outsider to fix $ in spreadsheet= use find and replace - Don Minow

[DON MINOW]

> On March 27, 2020 at 3:19 PM David Belina  wrote:
> 
> 
> Try just selecting Number as that seems to be what you want.  Does your 
> screen look like the attached?
> 
> 
>  
> 
> 
> On March 27, 2020 at 2:47:46 PM, Jan Macdonald (jmacbellt...@gmail.com 
> mailto:jmacbellt...@gmail.com ) wrote:
> 
> > >  
> > Hello Johnny,
> > 
> > My time sheet was originally in Excel and must have been 
> > automatically formatted to OpenOffice when I originally saved it on my Mac. 
> > So possibly the dollar sign could have defaulted from this transition? When 
> > the spreadsheet is open I go to format ~ cell protection ~ numbers, then I 
> > have a list starting with:
> > 
> > All
> > User ~ defined
> > Number
> > Percent
> > 
> > I have no idea how to change this as I’ve tried several things to 
> > no avail. All I need the time sheet column to do is add up my hours and not 
> > display a dollar sign. If you know how to change this please share. If not 
> > no worries.
> > 
> > 
> > Thank you!
> > 
> > 
> > Jan
> > 
> > > On Mar 27, 2020, at 12:34 PM, Johnny Rosenberg 
> >  wrote:
> > >
> > > Den fre 27 mars 2020 kl 00:00 skrev Jan Macdonald 
> > :
> > >
> > >> Hello OpenOffice,
> > >>
> > >> Wow ~ this is one complicated program. During my career I used 
> > Excel,
> > >> what a breeze. Then for a fun part-time job post-retirement I 
> > was directed
> > >> to use OpenOffice. It’s a challenge!
> > >>
> > >> I have a time sheet that is showing the $ sign in the hour 
> > column. So for
> > >> example if I worked five hours it displays $5.00. How can I 
> > remove the
> > >> dollar sign and still have the format add my hours?
> > >>
> > >
> > > You do it exactly the same way as you do it in Excel, so this 
> > should be a
> > > breeze too.
> > >
> > >
> > >
> > > Kind regards
> > >
> > > Johnny Rosenberg
> > >
> > >
> > >>
> > >> Thank you!
> > >>
> > >> Jan MacDonald
> > >> 
> > -
> > >> 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: Spreadsheet

[Joost Andrae]

Hi Gerry,

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


The function you want to use then is the water can button where you can 
assign multiple cells with all that formating defined within the cell 
template.


Otherwise (without using templates) you could also multi select all 
those cells there you want to change the colour and then assign the 
background colour at once.
In the icon bar you find a button for background color. Press it once 
and then select the dialog title and drag it somewhere else (select the 
title and hold down the right mouse button)


Using templates is a very powerful tool as it allows you to work with 
inheritance of templates so a child template can inherit objects of it's 
mother template. And cell templates can be exported to an other 
document, so you can easily create a template library.


Based upon the usage of cell templates it's quite easy to use the 
feature of conditional formatting (Format menu)


Kind regards, Joost


Am 20.03.2020 um 16:19 schrieb Gerry Woodard:

I would like to not have the color table change to the cell color when
selected. I would prefer that the color selection indicator remain fixed
until needed. For example, if I want to change several cells from red to
black, need only select black once from the table, Hope this is clear.
Thanks.
Jerry Woodard
*.* “Energy and persistence conquer all things.”* – Benjamin Franklin*
* “Make America Great Again.” - Donald Trump*





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

Spreadsheet

[Gerry Woodard]

I would like to not have the color table change to the cell color when
selected. I would prefer that the color selection indicator remain fixed
until needed. For example, if I want to change several cells from red to
black, need only select black once from the table, Hope this is clear.
Thanks.
Jerry Woodard
*.* “Energy and persistence conquer all things.”* – Benjamin Franklin*
* “Make America Great Again.” - Donald Trump*

Re: corrupted.....Apache Open Office Spreadsheet.......(Text Import)

[Rory O'Farrell]

On Mon, 30 Dec 2019 08:51:05 -0800
James Jenkins  wrote:

> I recently open my file in "Apache Openoffice Spreadsheet", I've had 
> this file over a couple years, it worked perfectly, and now another 
> files has red wavy lines as if there not spelled correctly:
> 
> _when I open I get "Text Import":_
> 
>          TEXT IMPORT ...unicode, default English USA
> 
>          FROM...Row 1
> 
>          SEPARATED BY...semicolon, space,  text delimiter
> 
>          OTHER OPTIONS...(nothing here)
> 
>          FIELDS...gray and a  # (1)
> 
> This started (I think) when I used the Tool-Bar (reverse input arrow), I 
> used it 3-4 times....
> 
> As I was emailing this to you, I tried to open my four other spreadsheet 
> files that I use every day for over a couple years... now there not 
> opening.  Need help One of these file goes to my doctor 
> regarding my health condition, and the other is business related. The 
> more I tried to open.now the Open Office "Start Bar" will not 
> openprogressively getting worse the more I attempt to open the 
> spreadsheet the worse it gets.
> 
> James L. Jenkins
> 

Have you tried restarting your computer?  Do not, repeat _NOT_ save over any of 
the files in question until they open correctly. 

If restarting computer does not help, try deleting or renaming your OpenOffice 
user profile.

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

-- 
Rory O'Farrell 

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

Re: corrupted.....Apache Open Office Spreadsheet.......(Text Import)

[David Belina]

Sounds like you have changed something in your computer.  When you tried to 
open the file from the file manager of your os, did it try to “recover” the 
file.  If it did and you canceled the recovery, try to open it again and do the 
recovery.

Dave B.


On December 30, 2019 at 8:51:58 AM, James Jenkins (ljenki...@centurylink.net) 
wrote:

dbel...@gmail.com file in "Apache Openoffice Spreadsheet", I've had  
this file over a couple years, it worked perfectly, and now another  
files has red wavy lines as if there not spelled correctly:  

_when I open I get "Text Import":_  

        TEXT IMPORT ...unicode, default English USA  

        FROM...Row 1  

        SEPARATED BY...semicolon, space,  text delimiter  

        OTHER OPTIONS...(nothing here)  

        FIELDS...gray and a  # (1)  

This started (I think) when I used the Tool-Bar (reverse input arrow), I  
used it 3-4 times  

As I was emailing this to you, I tried to open my four other spreadsheet  
files that I use every day for over a couple years... now there not  
opening.  Need help One of these file goes to my doctor  
regarding my health condition, and the other is business related. The  
more I tried to open.now the Open Office "Start Bar" will not  
openprogressively getting worse the more I attempt to open the  
spreadsheet the worse it gets.  

James L. Jenkins  

corrupted.....Apache Open Office Spreadsheet.......(Text Import)

[James Jenkins]

I recently open my file in "Apache Openoffice Spreadsheet", I've had 
this file over a couple years, it worked perfectly, and now another 
files has red wavy lines as if there not spelled correctly:


_when I open I get "Text Import":_

        TEXT IMPORT ...unicode, default English USA

        FROM...Row 1

        SEPARATED BY...semicolon, space,  text delimiter

        OTHER OPTIONS...(nothing here)

        FIELDS...gray and a  # (1)

This started (I think) when I used the Tool-Bar (reverse input arrow), I 
used it 3-4 times


As I was emailing this to you, I tried to open my four other spreadsheet 
files that I use every day for over a couple years... now there not 
opening.  Need help One of these file goes to my doctor 
regarding my health condition, and the other is business related. The 
more I tried to open.now the Open Office "Start Bar" will not 
openprogressively getting worse the more I attempt to open the 
spreadsheet the worse it gets.


James L. Jenkins

Re: Spreadsheet

[Girvin Herr]

On 10/31/19 11:35 AM, Johnny Rosenberg wrote:

Den ons 30 okt. 2019 kl 23:29 skrev Stag Mist :


Dear OpenOffice Team,

I'm using OpenOffice on a Mac. My problem is that when I open the app it
automatically opens a Text Document. Is there any option to change it from
opening a Text Document to a opening Spreadsheet? How can I set this?


I don't have a Mac and it was a long time since I had Apache OpenOffice,
but do n't you have icons somewhere for each and every one of the different
parts of Open Office?
if not, maybe you can change the line that starts the application? On my
system, Manjaro with LibreOffice, the line for launching LibreOffice Calc
looks like this:
libreoffice --calc %U
I' don't remember what command starts Apache OpenOffice, maybe it's still
”soffice”? In that case, did you try ”soffice --calc %U”?
Maybe opening a terminal and enter something like ”man soffice” will give
you a hint or two?


Kind regards

Johnny Rosenberg




Thanks in advance,
SM


Greetings,

It has been a long time since I had no documents open and I am not a Mac 
user, but I think when you have all but the last document closed, there 
is a second "X" on the last document's window at the top right. There is 
the usual "X" to close the window (AOO), but the lower "X" will close 
the last document and then the window should display the options page, 
including options to create a new document or open an existing document. 
If you shut down with this "default" window, AOO should then start with 
this window when next started. However, if you shut down AOO with a 
document open, that document should be opened the next time you start 
AOO. I have several documents that I use a lot and they all open up when 
I start AOO.


HTH.

Girvin



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

Re: Spreadsheet

[Johnny Rosenberg]

Den ons 30 okt. 2019 kl 23:29 skrev Stag Mist :

> Dear OpenOffice Team,
>
> I'm using OpenOffice on a Mac. My problem is that when I open the app it
> automatically opens a Text Document. Is there any option to change it from
> opening a Text Document to a opening Spreadsheet? How can I set this?
>

I don't have a Mac and it was a long time since I had Apache OpenOffice,
but do n't you have icons somewhere for each and every one of the different
parts of Open Office?
if not, maybe you can change the line that starts the application? On my
system, Manjaro with LibreOffice, the line for launching LibreOffice Calc
looks like this:
libreoffice --calc %U
I' don't remember what command starts Apache OpenOffice, maybe it's still
”soffice”? In that case, did you try ”soffice --calc %U”?
Maybe opening a terminal and enter something like ”man soffice” will give
you a hint or two?


Kind regards

Johnny Rosenberg



>
> Thanks in advance,
> SM
>

Spreadsheet

[Stag Mist]

Dear OpenOffice Team,

I'm using OpenOffice on a Mac. My problem is that when I open the app it
automatically opens a Text Document. Is there any option to change it from
opening a Text Document to a opening Spreadsheet? How can I set this?

Thanks in advance,
SM

Re: Spreadsheet

[Johnny Rosenberg]

Den tis 15 okt. 2019 kl 18:19 skrev David Walters
:

> Hi,
>
> Can you send me the link for the Apache Open Office spreadsheet extension.
> I don’t seem to be able to locate it on your website.
>

Do you mean this?
https://extensions.openoffice.org/en/search?f%5B0%5D=field_project_application%3A4

These are extensions for Apache OpenOffice Calc, I think.


Kind regards

Johnny Rosenberg


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