Brand New to Open Office and have a question re Date Formatting

[Rick Malkin]

Hi there

I have looked in documentation and on the web in general, but don't seem to be 
able to find what I am after. Please forgive IF this is such a newbie dumb 
question..


I am inserting the date into a template (ready Made) to show date document 
printed or created. I would like the dates to look like


Friday, 21st or Sat, 2nd, Sun 3rd Mon 4th  .

Is there a way to have this happen within the date formatting??

Also I would like the time to show say 2345 hrs. So with Hours as text after the 
time.. Is there a way to have this happen within the time formatting??



Many Thanks

Rick M

New Zealand

How to Add Conditional Formatting to Existing Data

[David Stuhr]

Hello,

I have been teaching/learning how "Conditional Formatting" (cell value 
and formula is) in OpenOffice Calc works. On new columns (or rows) of 
data applying the conditional formatting is/has been a very straight 
forward and an easy process. I have been able to apply the conditional 
formatting using the "fill" method; define the conditional formatting in 
a cell and the grab the small square in the lower right corner of the 
cell and drag the cell to apply the conditional formatting to the 
desired number of cells.


My question is about applying "formula is" conditional formatting to  
existing data (dates) where dates are missing or duplicated in the 
column and using the fill method described above would alter/change the 
existing data values.


Thank your for your assistance.

David Stuhr

Re: Calc data sorting problem - cell formatting appears same but mustn't be?

[David Deeks]

Well Brian, here you go again - yes, ’twas indeed you last time!

Thanks so much. A bit late tonight now for an oldie to try out your 
suggestions, but will certainly aim to do so tomorrow!

All best

David

> On 1 Jul 2022, at 21:25, Brian Barker  
> wrote:
> 
> At 19:20 01/07/2022 +0100, David Deeks wrote:
>> I am using Calc on a MacBook Pro running OS High Sierra 10.13.6 (the highest 
>> version this Mac will run). A long while back I had a problem sorting data 
>> on Calc spreadsheets which boiled down to cell formatting being different, 
>> solved by a friendly Brian if I remember correctly!
> 
> Could that be me?!
> 
>> But I have now had the problem occur again with the cell formatting 
>> appearing to be consistent. I am attaching a copy of a spreadsheet with data 
>> sorted by column I. The cells in this column all identify their 
>> category/format as 'Text/@' and I have not to my knowledge changed anything. 
>> Note however that from row 1813 the sort begins again - I have highlighted 
>> these rows in orange for clarity.
> 
> Although the cell formatting is indeed Text, the majority of the values in 
> column I are actually numbers. You can see that fairly simply by selecting 
> the column and then going to Format | Cells... | Alignment | Text alignment | 
> Horizontal and selecting Default from the drop-down menu. Your black numbers 
> will show as right-aligned, with your orange text values left-aligned. I'm 
> guessing that the black values were entered into cells that were formatted as 
> Number, the column was then formatted as Text, and the orange values entered 
> after this. Note that Text formatting will ensure that entered values are 
> saved as text, but will not change the actual contents of cells already 
> occupied, so your numbers stay as numbers.
> 
> A simple way forward would be to convert all the values in column I to 
> numbers - thus changing your orange values from text values to numerical 
> values. An easy way to do this is to select the column and use Data | Text to 
> Columns... | OK. But note that you will need to deal with the rogue value in 
> I1812 first, or it will scupper the effect. The you can sort column I as you 
> wish.
> 
>> I have tried reformatting these 'rogue' cells. I have tried a blanket 
>> reformat of both columns.
> 
> Note that changing format does not change the actual contents of cells.
> 
> I think there are also some strange effects caused by cell protection which 
> may be causing confusion.
> 
> 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: Calc data sorting problem - cell formatting appears same but mustn't be?

[Brian Barker]

At 19:20 01/07/2022 +0100, David Deeks wrote:
I am using Calc on a MacBook Pro running OS High Sierra 10.13.6 (the 
highest version this Mac will run). A long while back I had a 
problem sorting data on Calc spreadsheets which boiled down to cell 
formatting being different, solved by a friendly Brian if I remember correctly!


Could that be me?!

But I have now had the problem occur again with the cell formatting 
appearing to be consistent. I am attaching a copy of a spreadsheet 
with data sorted by column I. The cells in this column all identify 
their category/format as 'Text/@' and I have not to my knowledge 
changed anything. Note however that from row 1813 the sort begins 
again - I have highlighted these rows in orange for clarity.


Although the cell formatting is indeed Text, the majority of the 
values in column I are actually numbers. You can see that fairly 
simply by selecting the column and then going to Format | Cells... | 
Alignment | Text alignment | Horizontal and selecting Default from 
the drop-down menu. Your black numbers will show as right-aligned, 
with your orange text values left-aligned. I'm guessing that the 
black values were entered into cells that were formatted as Number, 
the column was then formatted as Text, and the orange values entered 
after this. Note that Text formatting will ensure that entered values 
are saved as text, but will not change the actual contents of cells 
already occupied, so your numbers stay as numbers.


A simple way forward would be to convert all the values in column I 
to numbers - thus changing your orange values from text values to 
numerical values. An easy way to do this is to select the column and 
use Data | Text to Columns... | OK. But note that you will need to 
deal with the rogue value in I1812 first, or it will scupper the 
effect. The you can sort column I as you wish.


I have tried reformatting these 'rogue' cells. I have tried a 
blanket reformat of both columns.


Note that changing format does not change the actual contents of cells.

I think there are also some strange effects caused by cell protection 
which may be causing confusion.


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

formatting at new technition

[Null REPLY]

I'm telling you guys are doing a good job in the right thing but no more
plugins start working on the base feature and its modules

text formatting definitely needs improvement
 because some fonts don't display properly
or adjust with print option or other changes!

/fun ticket

secondly you guys have a lot of hard stop full app crashes
now I know you have the recovery but it doesn't always catch it at the
right glimpse
maybe work on some user feedback and sorting through the page error fault
in scripting

lastly it's only because Libra took your number one deserved place on
alternatives too what shows it's a fan favorite over what this featured
suite used to have

<http://www.avg.com/email-signature?utm_medium=email_source=link_campaign=sig-email_content=webmail>
Virus-free.
www.avg.com
<http://www.avg.com/email-signature?utm_medium=email_source=link_campaign=sig-email_content=webmail>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Re: Formatting for USA Telephone Numbers

[Brian Barker]

At 13:08 27/02/2022 -0500, Vince Bonly wrote:
I must figure a way to convert existing cell contents such as (877) 
300- to the desired display format. Can this task be 
accomplished using a formula?


Yup: =VALUE(MID(Xn;2;3)(Xn;7;3)(Xn;11;4))
- where Xn is the cell containing the original (text) entry. That 
will give the number 877300, and you can format that in the way 
you now want.


Alternatively, you could use Data | Text to Columns..., putting "()-" 
(no quotes) in the Other box and ticking both Space and "Merge 
delimiters". That returns the three numerical strings, still as text 
items. Then you can concatenate these and convert them to a number 
using the VALUE() function. Again, apply your desired format.


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: Formatting for USA Telephone Numbers

[Steven Ahlers]

Vince,

1) Yes, it’s normal to switch to User Defined.

2) Not sure what you’re referring to.

Steve

Sent from my iPhone

> On Feb 27, 2022, at 11:58 AM, wa.two...@verizon.net.invalid wrote:
> 
> 
> My thanks to all that have replied.  It has been wild here with home repair 
> concerns, or I would have acknowledged sooner.
> 
> I will attempt 1^(###)^###- (where ^ is a space) under the numbers tab, 
> when time permits.
> 
> 1. I believe that as soon as I begin typing into the definition box, it
>becomes "User Defined". Is that normal?
> 2. If I choose to edit the comment line, e.g., USA Telephone Numbers,
>will my revision then appear in the selection box-right side, above
>the definition box?
> 
> I hope that these characters are displayed correctly in the actual posted 
> message;  sometimes, somehow, things get jumbled up.
> 
> Regards, VinceB.
> 
> 
> 
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
> 


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

Re: Formatting for USA Telephone Numbers

[Vince@Verizon]

Some success here 

I have made a mental note of the resultant Format code line after 
highlighting the most recently added/available format, i.e., " F_o_rmat 
-+1 () -1234) ".  Also, I noticed that what appears within the _F_ormat 
code line is NOT what I had entered. The Comment line shows what I expected.


What I typed into the cell is: 111222.  ( NumLk is enabled ). The 
resultant display within that cell is +1 (111) 222-, which is 
absolutely acceptable to me.


I must figure a way to convert existing cell contents such as (877) 
300- to the desired display format.  Can this task be accomplished 
using a formula?


I think I saw a toolbar feature that converts to numbers, but that might 
have been within LibreOffice, not AOO. Two clicks in LO changed the 
existing data to 1234567890 format, and from there, I applied the 
desired display format, as shown in image included above. Ultimately, I 
want to be able to use LO or AOO for USA Telephone Number formatting.  
Then, I must deal with very few international telephone numbers within 
my Calc file.


TIA.














On 2/27/2022 12:58 PM, Vince@Verizon wrote:


My thanks to all that have replied.  It has been wild here with home 
repair concerns, or I would have acknowledged sooner.


I will attempt 1^(###)^###- (where ^ is a space) under the numbers 
tab, when time permits.


1. I believe that as soon as I begin typing into the definition box, it
   becomes "User Defined". Is that normal?
2. If I choose to edit the comment line, e.g., USA Telephone Numbers,
   will my revision then appear in the selection box-right side, above
   the definition box?

I hope that these characters are displayed correctly in the actual 
posted message;  sometimes, somehow, things get jumbled up.


Regards, VinceB.

Re: Formatting for USA Telephone Numbers

[Vince@Verizon]

My thanks to all that have replied.  It has been wild here with home 
repair concerns, or I would have acknowledged sooner.


I will attempt 1^(###)^###- (where ^ is a space) under the numbers 
tab, when time permits.


1. I believe that as soon as I begin typing into the definition box, it
   becomes "User Defined". Is that normal?
2. If I choose to edit the comment line, e.g., USA Telephone Numbers,
   will my revision then appear in the selection box-right side, above
   the definition box?

I hope that these characters are displayed correctly in the actual 
posted message;  sometimes, somehow, things get jumbled up.


Regards, VinceB.



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

Re: Formatting for USA Telephone Numbers

[Steven Ahlers]

Jonathan,

Actually Vince’s (the OP) original question was about 1+ (###) ###- not +1 
(###) ###-.

He also asked about (###) ###- as an alternative. Both were addressed 
several responses ago including an incorrection in regards to those solutions.

Steve 

Sent from my iPhone

> On Feb 26, 2022, at 9:39 PM, toki  wrote:
> 
> 
>> On 25/02/2022 19:58, Alan B wrote:
>> Correction
>> After applying the recommended format, (###) ###-, and entering
>> 1234567890 the displayed value will be (123) 456-7890.
> 
> Your original question was asking about +1 (###) ###-, not (###) ###-.
> 
> jonathon


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

Re: Formatting for USA Telephone Numbers

[toki]

On 25/02/2022 19:58, Alan B wrote:

Correction
After applying the recommended format, (###) ###-, and entering
1234567890 the displayed value will be (123) 456-7890.


Your original question was asking about +1 (###) ###-, not (###) 
###-.


jonathon


OpenPGP_0xA759EEC77A18EA38.asc
Description: OpenPGP public key


OpenPGP_signature
Description: OpenPGP digital signature

Re: Formatting for USA Telephone Numbers

[Alan B]

Correction
After applying the recommended format, (###) ###-, and entering
1234567890 the displayed value will be (123) 456-7890.

No idea how/why I typed what's in my original answer.

My apology for any confusion I may have caused.


On Fri, Feb 25, 2022, 8:20 AM Alan B  wrote:

> To format a ten digit number as (555) 555-1212 use the following format
> code
>
> (###) ###-
>
> Enter the ten digits into the cell, e.g. 1234567890, and the number will
> be displayed as (120) 456-7890
> NOTE: area code must not start with zero. Zero in any other position will
> maintain the format. There is a space between the right paren ) and the
> next #.
>
> To enter only ten digits and have the US dialing prefix, +1 displayed use
> the following format code
>
> "+1" (###) ###-
>
> Enter the ten digits into the cell, e.g. 1234567890, and the number will
> be displayed as +1 (123) 456-7890
> NOTE: there must be a space between the second quote " and left paren (.
> If there is no space then the formatted result will be +1(123) 456-7890
>
> On Wed, Feb 23, 2022 at 9:33 PM Vince@Verizon
>  wrote:
>
>> Hi:
>>
>> How do I format cells for entry of USA Telephone Numbers, as: 1
>> (###) ###*-*
>>
>> whenever, for example,I have typed a ten-digit number, e.g., 1234567890
>> (no spaces, no negative/minus sign, no parenthesis, by use of the number
>> keypad (NumLk is enabled).
>>
>> Yes, I want the "1" prefix, the area code to appear within parenthesis,
>> and a negative/minus sign between the 3rd digit and the 4th digit. A
>> space follows the prefix "1" and a space follows the closing parenthesis.
>>
>> I have tried to set a user defined number-format, but am getting strange
>> results with apostrophes and/or double quote markings mixed in when
>> viewing the Format Cells dialogue, e.g., (#") "###"*-*". And, I
>> don;t understand why that is. I was hoping to find a pre-defined/default
>> format for use when entering USA telephone numbers. I am flexible; I can
>> probably do without the "1" prefix and/or the parenthesis.
>>
>> Should I be formatting these cells as "text" (left-justified) rather
>> than as numbers (right-justified)?
>>
>> Regards,
>>
>> VinceB.
>>
>>
>
> --
> Alan Boba
> CISSP, CCENT, ITIL v3 Foundations 2011
>
>

Re: Formatting for USA Telephone Numbers

[Alan B]

To format a ten digit number as (555) 555-1212 use the following format code

(###) ###-

Enter the ten digits into the cell, e.g. 1234567890, and the number will be
displayed as (120) 456-7890
NOTE: area code must not start with zero. Zero in any other position will
maintain the format. There is a space between the right paren ) and the
next #.

To enter only ten digits and have the US dialing prefix, +1 displayed use
the following format code

"+1" (###) ###-

Enter the ten digits into the cell, e.g. 1234567890, and the number will be
displayed as +1 (123) 456-7890
NOTE: there must be a space between the second quote " and left paren (. If
there is no space then the formatted result will be +1(123) 456-7890

On Wed, Feb 23, 2022 at 9:33 PM Vince@Verizon 
wrote:

> Hi:
>
> How do I format cells for entry of USA Telephone Numbers, as: 1
> (###) ###*-*
>
> whenever, for example,I have typed a ten-digit number, e.g., 1234567890
> (no spaces, no negative/minus sign, no parenthesis, by use of the number
> keypad (NumLk is enabled).
>
> Yes, I want the "1" prefix, the area code to appear within parenthesis,
> and a negative/minus sign between the 3rd digit and the 4th digit. A
> space follows the prefix "1" and a space follows the closing parenthesis.
>
> I have tried to set a user defined number-format, but am getting strange
> results with apostrophes and/or double quote markings mixed in when
> viewing the Format Cells dialogue, e.g., (#") "###"*-*". And, I
> don;t understand why that is. I was hoping to find a pre-defined/default
> format for use when entering USA telephone numbers. I am flexible; I can
> probably do without the "1" prefix and/or the parenthesis.
>
> Should I be formatting these cells as "text" (left-justified) rather
> than as numbers (right-justified)?
>
> Regards,
>
> VinceB.
>
>

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

Re: Formatting for USA Telephone Numbers

[Brian Barker]

At 19:53 24/02/2022 -0500, Keith N. McKenna wrote:
Format the cell as text and enter the characters as you want them to 
be displayed.


But that doesn't address the problem I understood the questioner to 
be posing: he wants, I think, to be able to enter just the ten digits 
and have the punctuation appear as if by magic. A suitable cell 
format does that - and entering data that way is less prone to error 
in the formatting. Isn't that what cell formatting is all about?



As Brian stated, Entering the way you want are not numeric values, but text.


An alternative way that creates text values would be to enter the 
plain ten-digit values into one column and to create a suitable 
formula in another column to extract the appropriate parts and add 
the punctuation. The unwanted entry column could then be hidden or 
have the reformatted values pasted over it, or it could have been 
placed elsewhere, perhaps even on another sheet.


Brian Barker  




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

Re: Formatting for USA Telephone Numbers

[Brian Barker]

At 10:17 24/02/2022 -0600, Steven Ahlers wrote:
It does drop a leading zero in the area code. It doesn't drop 
leading zeros from the prefix series or the exchange series. In the 
USA no area code starts with a zero so this would be a nonissue.


Ho, ho: indeed so!

But look what happens if the user types a string of zeroes - perhaps 
to represent that no phone number is provided. In any case, it is odd 
to choose to use the character (hash) that specifically drops leading 
zeroes instead of the obvious one (zero) that faithfully reproduces 
the input digits when one knows that dropping zeroes will never be needed.


Brian Barker 




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

Re: Formatting for USA Telephone Numbers

[Steven Ahlers]

Keith,

The formatting that I shared works fine for USA phone numbers. I’ve used it for 
many years for tracking a list of contact information of a fantasy football 
league.

Steve

Sent from my iPhone

> On Feb 24, 2022, at 6:53 PM, Keith N. McKenna  
> wrote:
> 
> In article <64a75984-4f03-422e-7ccb-0358112cb1f6
> @verizon.net>, wa.two...@verizon.net.INVALID says...
>> 
>> Hi:
>> 
>> How do I format cells for entry of USA Telephone Numbers, as: Â Â Â  1 
>> (###) ###*-*
>> 
>> whenever, for example,I have typed a ten-digit number, e.g., 1234567890 
>> (no spaces, no negative/minus sign, no parenthesis, by use of the number 
>> keypad (NumLk is enabled).
>> 
>> Yes, I want the "1" prefix, the area code to appear within parenthesis, 
>> and a negative/minus sign between the 3rd digit and the 4th digit. A 
>> space follows the prefix "1" and a space follows the closing parenthesis.
>> 
>> I have tried to set a user defined number-format, but am getting strange 
>> results with apostrophes and/or double quote markings mixed in when 
>> viewing the Format Cells dialogue, e.g., (#") "###"*-*". And, I 
>> don;t understand why that is. I was hoping to find a pre-defined/default 
>> format for use when entering USA telephone numbers. I am flexible; I can 
>> probably do without the "1" prefix and/or the parenthesis.
>> 
>> Should I be formatting these cells as "text" (left-justified) rather 
>> than as numbers (right-justified)?
>> 
>> Regards,
>> 
>> VinceB.
> 
> Format the cell as text and enter the characters as you 
> want them to be displayed. trying to enter it as a number 
> format will not get you to where you want. As Brian 
> stated, Entering the way you want are not numeric values, 
> but text.
> 
> Keith N. McKenna
> 
> 
> 
> -
> 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: Formatting for USA Telephone Numbers

[Keith N. McKenna]

In article <64a75984-4f03-422e-7ccb-0358112cb1f6
@verizon.net>, wa.two...@verizon.net.INVALID says...
> 
> Hi:
> 
> How do I format cells for entry of USA Telephone Numbers, as:     1 
> (###) ###*-*
> 
> whenever, for example,I have typed a ten-digit number, e.g., 1234567890 
> (no spaces, no negative/minus sign, no parenthesis, by use of the number 
> keypad (NumLk is enabled).
> 
> Yes, I want the "1" prefix, the area code to appear within parenthesis, 
> and a negative/minus sign between the 3rd digit and the 4th digit. A 
> space follows the prefix "1" and a space follows the closing parenthesis.
> 
> I have tried to set a user defined number-format, but am getting strange 
> results with apostrophes and/or double quote markings mixed in when 
> viewing the Format Cells dialogue, e.g., (#") "###"*-*". And, I 
> don;t understand why that is. I was hoping to find a pre-defined/default 
> format for use when entering USA telephone numbers. I am flexible; I can 
> probably do without the "1" prefix and/or the parenthesis.
> 
> Should I be formatting these cells as "text" (left-justified) rather 
> than as numbers (right-justified)?
> 
> Regards,
> 
> VinceB.

Format the cell as text and enter the characters as you 
want them to be displayed. trying to enter it as a number 
format will not get you to where you want. As Brian 
stated, Entering the way you want are not numeric values, 
but text.

Keith N. McKenna



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

Re: Formatting for USA Telephone Numbers

[Steven Ahlers]

Brian,

It does drop a leading zero in the area code. It doesn’t drop leading zeros 
from the prefix series or the exchange series. In the USA no area code starts 
with a zero so this would be a nonissue.

Steve

Sent from my iPhone

> On Feb 24, 2022, at 9:44 AM, Brian Barker  
> wrote:
> 
> At 09:18 24/02/2022 -0600, Steven Ahlers wrote:
>> If you want the format of 1 (123) 456-7890 simply type in the format 
>> definition box (near the bottom of the pop up menu for Format Cell under the 
>> Numbers tab) 1^(###)^###- (where ^ is a space).
> 
> But that format will (inappropriately) lose leading zeroes in any of the 
> three groups - which can certainly occur in the final group.
> 
> 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: Formatting for USA Telephone Numbers

[Brian Barker]

At 09:18 24/02/2022 -0600, Steven Ahlers wrote:
If you want the format of 1 (123) 456-7890 simply type in the format 
definition box (near the bottom of the pop up menu for Format Cell 
under the Numbers tab) 1^(###)^###- (where ^ is a space).


But that format will (inappropriately) lose leading zeroes in any of 
the three groups - which can certainly occur in the final group.


Brian Barker 




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

Re: Formatting for USA Telephone Numbers

[Steven Ahlers]

Vince,

If you want the format of 1 (123) 456-7890 simply type in the format definition 
box (near the bottom of the pop up menu for Format Cell under the Numbers tab) 
1^(###)^###- (where ^ is a space). There is no need for quotation marks. 
You can put any text you want when you are defining the format of a number.

Make sure the width of the column is wide enough for all of the characters 
otherwise you’ll get the error code ### which signifies a number too wide to 
display.

Steve

Sent from my iPhone

> On Feb 23, 2022, at 10:14 PM, PCS  wrote:
> 
> 
> Setting the cell format to “Text” and entering the number exactly as you want 
> it to look should do the trick, though the use of brackets (and maybe some 
> other characters?) will give an invalid formula correction warning to which 
> you will have to respond “No”. The resultant text does not have to be left 
> justified, you can select the justification you want in the top menu bar, as 
> normal. However the number entered as text will be text, you will not be able 
> to do any numerical operations with it.
> 
> You can also enter a number as text without setting the cell format to text 
> by typing ="123 456” (with your number of course, not 123 446)
> 
> PCS
> 
> 
>> On 24 Feb 2022, at 12:33 pm, Vince@Verizon  
>> wrote:
>> 
>> Hi:
>> 
>> How do I format cells for entry of USA Telephone Numbers, as: 1 (###) 
>> ###*-*
>> 
>> whenever, for example,I have typed a ten-digit number, e.g., 1234567890 (no 
>> spaces, no negative/minus sign, no parenthesis, by use of the number keypad 
>> (NumLk is enabled).
>> 
>> Yes, I want the "1" prefix, the area code to appear within parenthesis, and 
>> a negative/minus sign between the 3rd digit and the 4th digit. A space 
>> follows the prefix "1" and a space follows the closing parenthesis.
>> 
>> I have tried to set a user defined number-format, but am getting strange 
>> results with apostrophes and/or double quote markings mixed in when viewing 
>> the Format Cells dialogue, e.g., (#") "###"*-*". And, I don;t understand 
>> why that is. I was hoping to find a pre-defined/default format for use when 
>> entering USA telephone numbers. I am flexible; I can probably do without the 
>> "1" prefix and/or the parenthesis.
>> 
>> Should I be formatting these cells as "text" (left-justified) rather than as 
>> numbers (right-justified)?
>> 
>> Regards,
>> 
>> VinceB.
>> 
> 


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

Re: Formatting for USA Telephone Numbers

[PCS]

Setting the cell format to “Text” and entering the number exactly as you want 
it to look should do the trick, though the use of brackets (and maybe some 
other characters?) will give an invalid formula correction warning to which you 
will have to respond “No”. The resultant text does not have to be left 
justified, you can select the justification you want in the top menu bar, as 
normal. However the number entered as text will be text, you will not be able 
to do any numerical operations with it.

You can also enter a number as text without setting the cell format to text by 
typing ="123 456” (with your number of course, not 123 446)

PCS


> On 24 Feb 2022, at 12:33 pm, Vince@Verizon  
> wrote:
> 
> Hi:
> 
> How do I format cells for entry of USA Telephone Numbers, as: 1 (###) 
> ###*-*
> 
> whenever, for example,I have typed a ten-digit number, e.g., 1234567890 (no 
> spaces, no negative/minus sign, no parenthesis, by use of the number keypad 
> (NumLk is enabled).
> 
> Yes, I want the "1" prefix, the area code to appear within parenthesis, and a 
> negative/minus sign between the 3rd digit and the 4th digit. A space follows 
> the prefix "1" and a space follows the closing parenthesis.
> 
> I have tried to set a user defined number-format, but am getting strange 
> results with apostrophes and/or double quote markings mixed in when viewing 
> the Format Cells dialogue, e.g., (#") "###"*-*". And, I don;t understand 
> why that is. I was hoping to find a pre-defined/default format for use when 
> entering USA telephone numbers. I am flexible; I can probably do without the 
> "1" prefix and/or the parenthesis.
> 
> Should I be formatting these cells as "text" (left-justified) rather than as 
> numbers (right-justified)?
> 
> Regards,
> 
> VinceB.
> 

Re: Formatting for USA Telephone Numbers

[Brian Barker]

At 21:33 23/02/2022 -0500, Vince Bonly wrote:
How do I format cells for entry of USA Telephone Numbers, as: 1 
(###) ###*-*


I don't understand those asterisks; I'm assuming you don't mean them.

Yes, I want the "1" prefix, the area code to appear within 
parenthesis, and a negative/minus sign between the 3rd digit and the 
4th digit. A space follows the prefix "1" and a space follows the 
closing parenthesis.


What's wrong with "1 (000) 000-" (no quotes, of course)?

Should I be formatting these cells as "text" (left-justified) rather 
than as numbers (right-justified)?


You don't have control over this if you set a user-defined format in 
this way - and OpenOffice will think they are numbers. But telephone 
numbers are definitely really text, not numeric values. If you don't 
believe this, ask yourself the significance of someone else having 
exactly twice your phone number - or of your number being even and 
your friend's odd. You can set alignment independently of this anyway.


If you really wanted those peculiar asterisks, you would have to 
escape each of them with a backslash, as \*


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

Formatting for USA Telephone Numbers

[Vince@Verizon]

Hi:

How do I format cells for entry of USA Telephone Numbers, as:     1 
(###) ###*-*


whenever, for example,I have typed a ten-digit number, e.g., 1234567890 
(no spaces, no negative/minus sign, no parenthesis, by use of the number 
keypad (NumLk is enabled).


Yes, I want the "1" prefix, the area code to appear within parenthesis, 
and a negative/minus sign between the 3rd digit and the 4th digit. A 
space follows the prefix "1" and a space follows the closing parenthesis.


I have tried to set a user defined number-format, but am getting strange 
results with apostrophes and/or double quote markings mixed in when 
viewing the Format Cells dialogue, e.g., (#") "###"*-*". And, I 
don;t understand why that is. I was hoping to find a pre-defined/default 
format for use when entering USA telephone numbers. I am flexible; I can 
probably do without the "1" prefix and/or the parenthesis.


Should I be formatting these cells as "text" (left-justified) rather 
than as numbers (right-justified)?


Regards,

VinceB.

Re: formatting; hyphens, dashes and SpellCheck

[Brian Barker]

At 20:41 16/12/2021 +, Ralph McCrum wrote:
Good Luck Ken [who asked to be able to turn off all automatic 
formatting changes].
I DON'T want automatic bulleting or paragraph numbering And A Few 
Other Things either. But After The Answers I Got On Bullets And 
Numbering, I Never Ask About Anything Else. I'll Be Watching To See 
If You Get Better Answers Than I Did


That's odd, since I explained this on 10 November. What's more, you 
were kind enough to write back and thank me, saying that my 
suggestions "Worked Great And Fixed The Problem".


For the benefit of others, there are two parts to the answer:

o First, the easy way. When you type something that stimulates this 
automatic "correction", the typing and the correction are treated as 
separate actions. This means that you can easily cancel the 
correction using Edit | Undo (or Ctrl+Z), leaving the original typing 
that you intended. Since the automatic facility is often helpful - 
ensuring, for example, that your numbers are properly sequential - 
this may well be the way to go.


o But if you do want to disable the facility, just remove the ticks 
from appropriate options at Tools | AutoCorrect Options... | Options 
- in particular, from "Apply numbering - symbol: *".


Brian Barker 



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

Re: formatting; hyphens, dashes and SpellCheck

[Ralph McCrum]

Good Luck Ken.
I DON'T want automatic bulleting or paragraph numbering And A Few Other 
Things either.
But After The Answers I Got On Bullets And Numbering, I Never Ask About 
Anything Else.

I'll Be Watching To See If You Get Better Answers Than I Did
Ralph


-- Original Message --
From: "Ken" 
To: "users@openoffice.apache.org" 
Sent: 12/16/2021 14:27:05
Subject: formatting; hyphens, dashes and SpellCheck


I have simply lost track of formatting changes.  I want to undo the lot of them 
and start over. Particularly I want to turn off Spell Check and restore the 
hyphen-to-dash feature, and I DON'T want automatic bulleting or paragraph 
numbering. Community forums aren't helpful because there are a million posts up 
there, most of which have nothing to do with my problem and most of the rest 
involve a different computer or a different mistake someone made, and when I do 
get to a question that looks like mine, the solution given there doesn't work.  
I just want to go back to start. What do I do?  I just downloaded and installed 
Open Office 4.1.11 on my computer, which has Windows 10.  Still on my computer 
are shortcuts to OO 4.1.6, 4.1.9, and 4.1.10.
Ken Howes



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

formatting; hyphens, dashes and SpellCheck

[Ken]

I have simply lost track of formatting changes.  I want to undo the lot of them 
and start over. Particularly I want to turn off Spell Check and restore the 
hyphen-to-dash feature, and I DON'T want automatic bulleting or paragraph 
numbering. Community forums aren't helpful because there are a million posts up 
there, most of which have nothing to do with my problem and most of the rest 
involve a different computer or a different mistake someone made, and when I do 
get to a question that looks like mine, the solution given there doesn't work.  
I just want to go back to start. What do I do?  I just downloaded and installed 
Open Office 4.1.11 on my computer, which has Windows 10.  Still on my computer 
are shortcuts to OO 4.1.6, 4.1.9, and 4.1.10.
Ken Howes 

Re: PLEASE DISCONTINUE AUTOMATIC FORMATTING

[Rory O'Farrell]

On Thu, 12 Aug 2021 19:14:06 -0400
David Cobble  wrote:

> DEAR OPEN-OFFICE,
> 
> THE AUTOMATIC FORMATTING FEATURES ON YOUR SOFTWARE *IS A NIGHTMARE FOR
> WRITERS!*
> 
> WE DO NOT NEED IT.  WE DO NOT NEED YOUR PLATFORM MAKING FORMATTING
> DECISIONS FOR US.
> 
> I'M SURE I SPEAK FOR LOTS OF WRITERS.
> 
> YOUR "DROP CAP" FEATURE KEEPS ASSERTING ITSELF INTO MY WRITING.  WHY WOULD
> YOU MAKE SUCH A FEATURE AUTOMATIC?
> 
> *DROP CAPS ARE RARELY USED!  IT IS TOTALLY USELESS TO MAKE THEM
> AUTOMATIC!!!*
> 
> __
> 
> AND WHY WOULD YOU MAKE AUTO CAPITALIZATION A FEATURE?
> 
> *IF I DO NOT CAPITALIZE A LINE OR WORD, IT'S BECAUSE I DO NOT WANT IT
> CAPITALIZED!!!*
> 
> *IT IS EXTREMELY AGGRAVATING TO STOP MY WRITING ALL THE TIME TO CORRECT
> YOUR AUTO FORMATTING. IT INTERFERES WITH RHYTHM AND PRODUCTIVITY AND
> CONSUMES MENTAL ENERGY.*
> 
> *PLEASE DISCONTINUE AUTO FORMATTING. WRITERS LIKE TO DO THEIR OWN
> FORMATTING.*

Another "writer" who cannot or does not read any instructions!  

There are many works on formatting long documents in either OpenOffice or 
LibreOffice; the "Writer for Students" reference is relatively brief.

https://wiki.openoffice.org/wiki/Documentation/Writer_for_Students

PDF file at at
http://openoffice-uni.org

See the file referenced in this posting for an overview of the use of Styles
https://forum.openoffice.org/en/forum/viewtopic.php?p=275320#p275320

This document may be helpful for those writing a book
http://documentation.openoffice.org/whitepapers/

Bruce Byfield's book, Designing with LibreOffice, also covers Apache 
OpenOffice. It focuses on the use of styles and templates, mainly in Writer but 
with some info on Calc, Impress, and Draw. 

A PDF of the book, and/or a zip file of the chapter ODTs, can be downloaded 
free from the book's website. If you prefer, you can buy a printed copy. 
http://designingwithlibreoffice.com

Another work on writing and formatting a book in LibreOffice is
https://frommindtotype.wordpress.com/writer-book/

For Macs, there is much useful information in
https://forum.openoffice.org/en/forum/viewtopic.php?f=74=89283


If you don't like the editor you are using there are many others you can choose.

-- 
Rory O'Farrell 

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

Re: PLEASE DISCONTINUE AUTOMATIC FORMATTING

[Fernando Cassia]

If you Google for "automatic capitalization OpenOffice" the first search
result is this:

*How do I stop OpenOffice.org from changing the first letter of a word to
uppercase?*

   1. Select Tools > AutoCorrect Options and then the Options tab.
   2. Near the top of the list, uncheck the [T] box next to "Capitalize
   first letter of every sentence".
   3. Click OK at the bottom of the dialog to apply the change.

Aug 7, 2018
Best
,
FC


On Thu., 12 Aug. 2021, 21:39 David Cobble,  wrote:

> DEAR OPEN-OFFICE,
>
> THE AUTOMATIC FORMATTING FEATURES ON YOUR SOFTWARE *IS A NIGHTMARE FOR
> WRITERS!*
>
> WE DO NOT NEED IT.  WE DO NOT NEED YOUR PLATFORM MAKING FORMATTING
> DECISIONS FOR US.
>
> I'M SURE I SPEAK FOR LOTS OF WRITERS.
>
> YOUR "DROP CAP" FEATURE KEEPS ASSERTING ITSELF INTO MY WRITING.  WHY WOULD
> YOU MAKE SUCH A FEATURE AUTOMATIC?
>
> *DROP CAPS ARE RARELY USED!  IT IS TOTALLY USELESS TO MAKE THEM
> AUTOMATIC!!!*
>
> __
>
> AND WHY WOULD YOU MAKE AUTO CAPITALIZATION A FEATURE?
>
> *IF I DO NOT CAPITALIZE A LINE OR WORD, IT'S BECAUSE I DO NOT WANT IT
> CAPITALIZED!!!*
>
> *IT IS EXTREMELY AGGRAVATING TO STOP MY WRITING ALL THE TIME TO CORRECT
> YOUR AUTO FORMATTING. IT INTERFERES WITH RHYTHM AND PRODUCTIVITY AND
> CONSUMES MENTAL ENERGY.*
>
> *PLEASE DISCONTINUE AUTO FORMATTING. WRITERS LIKE TO DO THEIR OWN
> FORMATTING.*
>
>
>
>
> *.*
>

Re: PLEASE DISCONTINUE AUTOMATIC FORMATTING

[Fernando Cassia]

You seem to have no problems with writing in all caps, that's for sure.

FC

On Thu., 12 Aug. 2021, 21:39 David Cobble,  wrote:

> DEAR OPEN-OFFICE,
>
> THE AUTOMATIC FORMATTING FEATURES ON YOUR SOFTWARE *IS A NIGHTMARE FOR
> WRITERS!*
>
> WE DO NOT NEED IT.  WE DO NOT NEED YOUR PLATFORM MAKING FORMATTING
> DECISIONS FOR US.
>
> I'M SURE I SPEAK FOR LOTS OF WRITERS.
>
> YOUR "DROP CAP" FEATURE KEEPS ASSERTING ITSELF INTO MY WRITING.  WHY WOULD
> YOU MAKE SUCH A FEATURE AUTOMATIC?
>
> *DROP CAPS ARE RARELY USED!  IT IS TOTALLY USELESS TO MAKE THEM
> AUTOMATIC!!!*
>
> __
>
> AND WHY WOULD YOU MAKE AUTO CAPITALIZATION A FEATURE?
>
> *IF I DO NOT CAPITALIZE A LINE OR WORD, IT'S BECAUSE I DO NOT WANT IT
> CAPITALIZED!!!*
>
> *IT IS EXTREMELY AGGRAVATING TO STOP MY WRITING ALL THE TIME TO CORRECT
> YOUR AUTO FORMATTING. IT INTERFERES WITH RHYTHM AND PRODUCTIVITY AND
> CONSUMES MENTAL ENERGY.*
>
> *PLEASE DISCONTINUE AUTO FORMATTING. WRITERS LIKE TO DO THEIR OWN
> FORMATTING.*
>
>
>
>
> *.*
>

PLEASE DISCONTINUE AUTOMATIC FORMATTING

[David Cobble]

DEAR OPEN-OFFICE,

THE AUTOMATIC FORMATTING FEATURES ON YOUR SOFTWARE *IS A NIGHTMARE FOR
WRITERS!*

WE DO NOT NEED IT.  WE DO NOT NEED YOUR PLATFORM MAKING FORMATTING
DECISIONS FOR US.

I'M SURE I SPEAK FOR LOTS OF WRITERS.

YOUR "DROP CAP" FEATURE KEEPS ASSERTING ITSELF INTO MY WRITING.  WHY WOULD
YOU MAKE SUCH A FEATURE AUTOMATIC?

*DROP CAPS ARE RARELY USED!  IT IS TOTALLY USELESS TO MAKE THEM
AUTOMATIC!!!*

__

AND WHY WOULD YOU MAKE AUTO CAPITALIZATION A FEATURE?

*IF I DO NOT CAPITALIZE A LINE OR WORD, IT'S BECAUSE I DO NOT WANT IT
CAPITALIZED!!!*

*IT IS EXTREMELY AGGRAVATING TO STOP MY WRITING ALL THE TIME TO CORRECT
YOUR AUTO FORMATTING. IT INTERFERES WITH RHYTHM AND PRODUCTIVITY AND
CONSUMES MENTAL ENERGY.*

*PLEASE DISCONTINUE AUTO FORMATTING. WRITERS LIKE TO DO THEIR OWN
FORMATTING.*




*.*

Re: Formatting a Newsletter Containing an Index

[Brian Barker]

At 22:12 10/12/2020 +0100, Martin Groenescheij wrote:

The definition from PC Magazine

What is the difference between a hard and soft return in Word?
*Hard return*: Pressing the *Enter* key in 
*Word* ends a paragraph. It's officially known 
as typing a *hard return*. ... The *soft 
return*, or *line break*, is used primarily in 
titles and headings; when you have a long title 
and need to split it up *between* two lines, you 
press Shift+*Enter* to insert the *soft return*.


It would be interesting to know as well what 
point you are wishing to make  - apart, perhaps, 
from merely advertising your copy-and-paste skills!


The key word in your quotation is "Word": this 
definition of "soft return" is the language 
apparently used by Microsoft in describing the 
behaviour of Microsoft Word. As you will realise, 
I was attempting instead to assist a user of 
OpenOffice. If you do a little more research, you 
will indeed find many references to Microsoft's 
(mis-?)usage, but find most other references disagreeing:


Computer Hope says:
A … soft return … is a carriage return 
automatically inserted by the software program usually because of a word wrap.


Webopedia says
… soft returns are inserted automatically by the 
word processor as part of its word wrap capability.


and PCMag, Your Dictionary, The Computer Language 
Company Inc., and McGraw-Hill Dictionary of 
Scientific & Technical Terms all say (more or less):
A control code that is automatically entered into 
a text document by the word-processing program to 
mark the end of a line, based on the current right margin.


(There are also some references that don't 
mention Word, but I suspect they are in the "Oh, 
but everyone uses Microsoft Word, don't they?" camp.)


These definitions refer to the natural wrapping 
of text in a word processor document from line to 
line, and have nothing to do with manually 
inserted line breaks, of course. In any case, 
Microsoft's usage makes no sense: there is no 
sense in which a line break is in any way "soft". 
Just like paragraph breaks, line breaks are 
hard-coded into any text document and do not move 
around nor disappear and reappear - as the word 
"soft" might suggest. Microsoft (if it was them) 
and their followers have hijacked a useful term inappropriately.


The original questioner's problem occurred 
because she was looking at the appearance of her 
document and failing to be being aware of its 
structure - in particular of the significance of 
paragraph breaks in separating parts with 
different paragraph styles. Talking of "hard 
returns" and "soft returns" does not clarify 
where paragraphs begin and end. Surely it is more 
helpful to use self-explanatory language? Why 
should anyone recommend OpenOffice users to use 
unhelpful terms apparently promulgated by Microsoft?


Brian Barker  



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

Re: formatting

[Nicholas Andrefsky]

Thanks, I'll check it out.

On Fri, Dec 11, 2020, 7:27 AM Rory O'Farrell  wrote:

> On Fri, 11 Dec 2020 11:33:09 + (UTC)
> nicholas  wrote:
>
> > Hi
> >
> > In an effort to create a document that can be printed in landscape
> as an 8.5 x 5.5 folding book, I have been struggling with the page set up.
> >
> > Top and bottom margins are set at .59
> > Left and right margins set at 2.99
> >
> > These don't seem to be working properly and I just can't figure it
> out. It works OK if I don't use two columns but is not perfect and doubles
> the amount of paper I need. When I use two columns, my preference, it's a a
> nightmare. Have looked at the forum but issue not addressed.
> >
> > Help.
> >
> > Nicholas
>
> Forget about using columns.  Set your page size to 8.5 x 5.5 inches.  Set
> margins as you think appropriate ("nice") for such a page size.  Then use
> /File /Print : Page Layout tab to either print Brochure (if you are going
> to fold the printout) or 2 pages to a printer sheet.  In /File /Print :
> Properties make sure your printer is set to "Letter", and Horizontal.
>
> I suggest playing with a small test file of at least 8 pages until you
> become familiar with this.
>
> --
> Rory O'Farrell 
>

formatting

[nicholas]

    Hi

    In an effort to create a document that can be printed in landscape as an 
8.5 x 5.5 folding book, I have been struggling with the page set up.

    Top and bottom margins are set at .59
    Left and right margins set at 2.99

    These don't seem to be working properly and I just can't figure it out. It 
works OK if I don't use two columns but is not perfect and doubles the amount 
of paper I need. When I use two columns, my preference, it's a a nightmare. 
Have looked at the forum but issue not addressed.

    Help.

    Nicholas

Re: Formatting a Newsletter Containing an Index

[Martin Groenescheij]

On 10/12/2020 18:33, Brian Barker wrote:

At 21:05 10/12/2020 +1000, Jean Lear wrote:
I knew there were Hard Returns and Soft Returns but never consciously 
used them. I now have to understand which, when and where to use them 
as I add items to the Newsletter.


The terms "hard return" and "soft return" are probably unhelpful. 
Indeed, Wikipedia explains a "soft return" as the line break that 
occurs as text flows naturally from line to line. These will move 
about in the text as fonts are changed (or substituted) or paper sizes 
or margins change (or the text is modified), so they do not exist 
within the word processor document and you cannot "use" them, as you 
claim. The useful distinction - and one that will help you understand 
your problem - is between line breaks and paragraph breaks (both of 
which are varieties of "hard return").



The definition from PC Magazine

What is the difference between a hard and soft return in Word?
*Hard return*: Pressing the *Enter* key in *Word* ends a paragraph. It's 
officially known as typing a *hard return*. ... The *soft return*, or 
*line break*, is used primarily in titles and headings; when you have a 
long title and need to split it up *between* two lines, you press 
Shift+*Enter* to insert the *soft return*.






I do not know how I have managed to format the Newsletter for the 
last several months without encountering the problem that started 
this week.


Luck, rather than judgement.

"... the appearance of the relevant parts of the text changes or are 
you actually looking at the applied paragraph style name?"

The appearance of the text actually changes along with the style name


Er, yes - well, of course it does: that's the idea! But the question 
was whether you were detecting the apparent change of paragraph style 
by looking at the style name or *just* by observing the appearance of 
the text. In the former (and more probable) case, it must be that you 
had changed the paragraph style applied to some text, but in the 
latter you may instead have changed the properties of the existing 
paragraph style.


Incidentally, there was one point that I forgot to mention. You said 
"When that body text is highlighted and changed back to Body Text 
...", which suggests that you think the change is applied to the 
selected text. But no: "Text body" is a *paragraph* style (not a 
character style), so any such application is to the entire paragraph 
containing the current cursor position or to all paragraphs (possibly 
only partially) included in the selection. Don't select anything: just 
put the cursor somewhere in the required paragraph. Understanding that 
will help you see what is happening.


Brian Barker

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

Re: Formatting a Newsletter Containing an Index

[Brian Barker]

At 21:05 10/12/2020 +1000, Jean Lear wrote:
I knew there were Hard Returns and Soft Returns but never 
consciously used them. I now have to understand which, when and 
where to use them as I add items to the Newsletter.


The terms "hard return" and "soft return" are probably unhelpful. 
Indeed, Wikipedia explains a "soft return" as the line break that 
occurs as text flows naturally from line to line. These will move 
about in the text as fonts are changed (or substituted) or paper 
sizes or margins change (or the text is modified), so they do not 
exist within the word processor document and you cannot "use" them, 
as you claim. The useful distinction - and one that will help you 
understand your problem - is between line breaks and paragraph breaks 
(both of which are varieties of "hard return").


I do not know how I have managed to format the Newsletter for the 
last several months without encountering the problem that started this week.


Luck, rather than judgement.

"... the appearance of the relevant parts of the text changes or 
are you actually looking at the applied paragraph style name?"

The appearance of the text actually changes along with the style name


Er, yes - well, of course it does: that's the idea! But the question 
was whether you were detecting the apparent change of paragraph style 
by looking at the style name or *just* by observing the appearance of 
the text. In the former (and more probable) case, it must be that you 
had changed the paragraph style applied to some text, but in the 
latter you may instead have changed the properties of the existing 
paragraph style.


Incidentally, there was one point that I forgot to mention. You said 
"When that body text is highlighted and changed back to Body Text 
...", which suggests that you think the change is applied to the 
selected text. But no: "Text body" is a *paragraph* style (not a 
character style), so any such application is to the entire paragraph 
containing the current cursor position or to all paragraphs (possibly 
only partially) included in the selection. Don't select anything: 
just put the cursor somewhere in the required paragraph. 
Understanding that will help you see what is happening.


Brian Barker  



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

Re: Formatting a Newsletter Containing an Index

[Jean Lear]

Thank you to Martin and Brian I have now sorted this out.
I knew there were Hard Returns and Soft Returns but never consciously used
them. I now have to understand which, when and where to use them as I add
items to the Newsletter.  I do not know how I have managed to format the
Newsletter for the last several months without encountering the problem
that started this week.
For Martin - I use the Index part of the template I work from and update it
when I change  the items that are changed in the next week's Newsletter.
For Brian - I made an error in using the words "Body Text" instead of "Text
Body" for Writer. The term becomes "Body Text" in Thunderbird email.
" the appearance of the relevant parts of the text changes or are you
actually looking at the applied paragraph style name?" The appearance of
the text actually changes along with the style name"
Thank you both for your help sorting this out for me.
Jean

On Thu, Dec 10, 2020 at 12:13 AM Brian Barker 
wrote:

> At 20:13 09/12/2020 +1000, you wrote:
> >I have a template for a weekly newsletter with an index which I use.
> >I open the template and below the index copy into it the body of the
> >previous weeks newsletter as some of the items remain the same each
> >week or have minor date changes etc. Also new items are added. The
> >basic layout is
> >Heading 1
> >Body Text
> >Heading 1
> >Body Text
> >Occasionally I use a Heading 2
>
> I'm guessing that by "Body Text" you actually mean the built-in "Text
> body" paragraph style?
>
> >When an item is copied to or written in the Newsletter it needs to
> >be formatted as Heading and Body Text. The index is then Updated.
> >The problem starting this week is that when a Heading is formatted
> >as Heading the Body Text is also changes to Heading. When that body
> >text is highlighted and changed back to Body Text the Heading also
> >changes back to Body Text. I can change the Heading back to Heading
> >and the Body Text also changed to Heading again.
>
> In taking about these changes, do you mean that the appearance of the
> relevant parts of the text changes or are you actually looking at the
> applied paragraph style name?
>
> >The procedure I have been given to use has worked well for months
> >until this week.
>
> So the question is: what have you changed? There are various
> possibilities, I think:
>
> o You have changed the details of one or other of the paragraph
> styles involved to match the other - or at least have sufficient
> changes to show the problem.
>
> o You have applied local formatting to some parts of your material to
> mimic the appearance of the other style without actually changing the
> style.
>
> o You do not have proper paragraph breaks (as created by pressing
> "Enter") between your various elements. If you have line breaks
> instead, or if the text flows from one line to the next without any
> break, there cannot be a change in paragraph style. If you are not
> careful about how you paste material, you may be deleting necessary
> paragraph breaks. Have you (perhaps temporarily) toggled on the
> display of "non-printing characters", so that you can see what is
> happening?
>
> It's impossible to tell exactly what you are doing from your
> description, and you may need to send a sample copy to someone for
> diagnosis.
>
> I trust this helps.
>
> Brian Barker - privately
>
>

Re: Formatting

[Howard Bennett]

Brian


Thanks. That works.

Howard

On Mon, Aug 10, 2020 at 11:06 Brian Barker
 wrote:

> At 10:42 10/08/2020 -0400, Howard Bennett wrote:
> >In Excel ...
>
> Excel is also available!
>
> >For instance, I might have 2 or 3 columns fall under the heading
> >Summer (weight, height, blood pressure). I cannot find a way to center
> "Summer"
>
> o Select the three cells which you want the main heading to span (one
> of which will contain the word "Summer").
> o Go to Format | Merge Cells (or click the Merge Cells button in the
> Formatting toolbar).
> o If challenged, accept the offer to move the contents of cells now
> to be hidden to the first cell.
> o Click the Align Centre Horizontally button in the Formatting
> toolbar (or press Ctrl+E).
>
> 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
>
> --
Howard

Re: Formatting

[Brian Barker]

At 10:42 10/08/2020 -0400, Howard Bennett wrote:

In Excel ...


Excel is also available!

For instance, I might have 2 or 3 columns fall under the heading 
Summer (weight, height, blood pressure). I cannot find a way to center "Summer"


o Select the three cells which you want the main heading to span (one 
of which will contain the word "Summer").
o Go to Format | Merge Cells (or click the Merge Cells button in the 
Formatting toolbar).
o If challenged, accept the offer to move the contents of cells now 
to be hidden to the first cell.
o Click the Align Centre Horizontally button in the Formatting 
toolbar (or press Ctrl+E).


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

Formatting

[Howard Bennett]

In Excel there is a command under formatting "format cells/alignment/center
across selection."

This is useful when preparing a spreadsheet for presentation. For instance,
I might have 2 or 3 columns fall under the heading Summer (weight, height,
blood pressure). I cannot find a way to center "Summer"

Help

Howard

Re: OpenOffice page formatting

[Rory O'Farrell]

On Fri, 7 Aug 2020 11:49:38 -0700
Robert Freedman  wrote:

> Dear Friends,
> 
> The full text of my document exceeds the visible right hand margin and I
> have to keep moving
> the bottom horizontal scroll bar back and forth to compose and edit.
> I tried to find a solution, under the ‘Format’ menu but saw nothing. I also
> tried changing Portrait  to Landscape and increasing the page width from
> 8/5"to over 9" but neither worked
> 
> Many thanks, for any help.
> 
> Kind regards,
> 
> Bob Freedman

/View /Zoom and chose a Page Width, or click in the % box at bottom right of 
OpenOffice window and chose  scaling factor.

-- 
Rory O'Farrell 

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

OpenOffice page formatting

[Robert Freedman]

Dear Friends,

The full text of my document exceeds the visible right hand margin and I
have to keep moving
the bottom horizontal scroll bar back and forth to compose and edit.
I tried to find a solution, under the ‘Format’ menu but saw nothing. I also
tried changing Portrait  to Landscape and increasing the page width from
8/5"to over 9" but neither worked

Many thanks, for any help.

Kind regards,

Bob Freedman

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: Telephone Number Formatting

[Brian Barker]

At 11:41 30/05/2020 -0400, Vince Bonly wrote:
I have a Calc file that presently has telephone numbers existing 
within a column. They were previously imported from a source that 
used the following format: 800 555 1234, and some cells are blank. 
How can I reformat the column and all existing numbers within the 
column to be in the form: (800) 555-1234?


Let's say your values are in column A, starting in row 1.
o In row 1 of a spare column, enter:
=IF(A1="";"";"("(A1;3)&")"(A1;4;4)&"-"(A1;4))
o Fill that formula down the new column.
o If desired, select the new column, copy (or cut) it, and paste it 
back over the original data - but using Paste Special... (or 
Ctrl+Shift+V) instead of normal Paste and ensuring that Formulae is 
not ticked in the Paste Special dialogue.


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: Telephone Number Formatting

[David Belina]

I think this YouTube may answer most of your question:
youtube.com/watch?v=QzmAq-x2KM0

On May 30, 2020 at 9:41:34 AM, WA.TWORSX via AOL 
(wa.two...@verizon.net.invalid) wrote:


I have a Calc file that presently has telephone numbersexisting within a 
column. They were previously imported from a source that used the 
following format: 800 555 1234, and some cells are blank. 


How can I reformat the column and all existing numbers within the column 
to be in the form: (800) 555-1234? 


Be well; stay safe. 


VinceB. 



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

Telephone Number Formatting

[WA.TWORSX via AOL]

I have a Calc file that presently has telephone numbersexisting within a 
column. They were previously imported from a source that used the 
following format: 800 555 1234, and some cells are blank.



How can I reformat the column and all existing numbers within the column 
to be in the form: (800) 555-1234?



Be well; stay safe.


VinceB.



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

Re: Formatting cells

[David Robley]

On 7/12/18 2:46 pm, Brian Barker wrote:

At 03:50 07/12/2018 +, John van Barneveld wrote:
I use 4.1.5 on Win10. Is it possible to set numeric formatting so 
that 4 decimal places are displayed and if the value in a cell is 
zero then that cell displays as Blank.


Yes; enter
[=0]"";0.
into the "Format code" box.

I trust this helps.

Brian Barker


For more information on format options, search number format in the 
Help - F1 


Cheers
--
David Robley

"I'm building up my muscles," Tom insinuated.
 



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

Re: Formatting cells

[Brian Barker]

At 03:50 07/12/2018 +, John van Barneveld wrote:
I use 4.1.5 on Win10. Is it possible to set numeric formatting so 
that 4 decimal places are displayed and if the value in a cell is 
zero then that cell displays as Blank.


Yes; enter
[=0]"";0.
into the "Format code" box.

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

Formatting cells

[John van Barneveld]

I use 4.1.5 on Win10.

Is it possible to set numeric formatting so that 4 decimal places are
displayed and if the value in a cell is zero then that cell displays as
Blank.

Thanks
John van Barneveld


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

Re: formatting

[Rory O'Farrell]

On Mon, 30 Jul 2018 06:52:43 -1000
Joan Rawson  wrote:

> I would like instructions about formatting
> johnrawsonpharmac...@gmail.com
> 

You may find this document helpful:
https://wiki.openoffice.org/wiki/Documentation/Writer_for_Students

-- 
Rory O'Farrell 

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

Re: formatting

[Wade Smart]

Formatting what?
-- 
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005


On Mon, Jul 30, 2018 at 11:52 AM, Joan Rawson
 wrote:
> I would like instructions about formatting
> johnrawsonpharmac...@gmail.com
>
> -
> 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

formatting

[Joan Rawson]

I would like instructions about formatting
johnrawsonpharmac...@gmail.com

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

Re: missing formatting bar

[WA.TWORSX via AOL]

TNX !



On 9/16/2017 12:18 PM, Matthias Seidel wrote:

View - Toolbars - Formatting ?


Am 16.09.2017 um 18:11 schrieb WA.TWORSX via AOL:

AOO413m1(Build:9783)  -  Rev. 1761381
2016-09-29 02:39:19

Win10-64bit

After opening an existing Calc spreadsheet, the Formatting Bar is
missing.

How is the Formatting bar added back?


-
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: missing formatting bar

[Matthias Seidel]

View - Toolbars - Formatting ?


Am 16.09.2017 um 18:11 schrieb WA.TWORSX via AOL:
> AOO413m1(Build:9783)  -  Rev. 1761381
> 2016-09-29 02:39:19
>
> Win10-64bit
>
> After opening an existing Calc spreadsheet, the Formatting Bar is
> missing.
>
> How is the Formatting bar added back?
>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>




smime.p7s
Description: S/MIME Cryptographic Signature

Re: missing formatting bar

[Rory O'Farrell]

On Sat, 16 Sep 2017 12:11:39 -0400
"WA.TWORSX via AOL" <wa.two...@verizon.net> wrote:

> AOO413m1(Build:9783)  -  Rev. 1761381
> 2016-09-29 02:39:19
> 
> Win10-64bit
> 
> After opening an existing Calc spreadsheet, the Formatting Bar is missing.
> 
> How is the Formatting bar added back?
> 

Try Alt V followed by Alt F 

-- 
Rory O'Farrell <ofarr...@iol.ie>

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

missing formatting bar

[WA.TWORSX via AOL]

AOO413m1(Build:9783)  -  Rev. 1761381
2016-09-29 02:39:19

Win10-64bit

After opening an existing Calc spreadsheet, the Formatting Bar is missing.

How is the Formatting bar added back?


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

Re: Cannot get cells to accept "Date" formatting.

[paulranger]

Thank you, Martin. I followed your kind advice and the cell Date formatting 
seems to be resolved.

Sincerely, ranger1.
  
> On 12 Apr 2017, at 6:31 pm, Martin Groenescheij <mar...@groenescheij.com> 
> wrote:
> 
> 
> 
> On 12/04/17 6:07 PM, paulranger wrote:
>> Hello all,
>> 
>> I am running AOO 4.1.3 on iMac Yosemite 10.10.5. I keep several spreadsheets 
>> which detail orders, symbol keys etc. but cannot format cells to accept 
>> ‘Format/Cells…/Date’ with "31 Dec 1999” option.
>> 
>> When I press the keys “3”, “/“, “4” and “return”, the tabulation “3/4” 
>> (superscript subscript) as a fraction is displayed, not the desired date 3 
>> April 2017.  I have tried copying a formatted cell (above the blank cell) 
>> which is correctly formatted e.g. “17 Mar 2017” and pasted that into the 
>> cell I want to fill, assuming that the correct formatting of the ‘copy’ cell 
>> will transfer to the desired cell through the subsequent ‘paste’ action.  
>> Alas, the ‘3 / 4’ key entry still displays as a fraction, not a date.
>> 
>> Could someone please advise how I can achieve the Date formatting I need?
> 
> Under Tools (Preference) go to AutoCorrect Options go to the Options Tab and 
> deselect the "Use replacement table" box
> 
>> 
>> Sincerely, ranger1s.
>> 
>> 
>> -
>> 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: Cannot get cells to accept "Date" formatting.

[Martin Groenescheij]

On 12/04/17 6:07 PM, paulranger wrote:

Hello all,

I am running AOO 4.1.3 on iMac Yosemite 10.10.5. I keep several spreadsheets which 
detail orders, symbol keys etc. but cannot format cells to accept 
‘Format/Cells…/Date’ with "31 Dec 1999” option.

When I press the keys “3”, “/“, “4” and “return”, the tabulation “3/4” 
(superscript subscript) as a fraction is displayed, not the desired date 3 
April 2017.  I have tried copying a formatted cell (above the blank cell) which 
is correctly formatted e.g. “17 Mar 2017” and pasted that into the cell I want 
to fill, assuming that the correct formatting of the ‘copy’ cell will transfer 
to the desired cell through the subsequent ‘paste’ action.  Alas, the ‘3 / 4’ 
key entry still displays as a fraction, not a date.

Could someone please advise how I can achieve the Date formatting I need?


Under Tools (Preference) go to AutoCorrect Options go to the Options Tab 
and deselect the "Use replacement table" box




Sincerely, ranger1s.


-
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

Cannot get cells to accept "Date" formatting.

[paulranger]

Hello all,

I am running AOO 4.1.3 on iMac Yosemite 10.10.5. I keep several spreadsheets 
which detail orders, symbol keys etc. but cannot format cells to accept 
‘Format/Cells…/Date’ with "31 Dec 1999” option.  

When I press the keys “3”, “/“, “4” and “return”, the tabulation “3/4” 
(superscript subscript) as a fraction is displayed, not the desired date 3 
April 2017.  I have tried copying a formatted cell (above the blank cell) which 
is correctly formatted e.g. “17 Mar 2017” and pasted that into the cell I want 
to fill, assuming that the correct formatting of the ‘copy’ cell will transfer 
to the desired cell through the subsequent ‘paste’ action.  Alas, the ‘3 / 4’ 
key entry still displays as a fraction, not a date.

Could someone please advise how I can achieve the Date formatting I need?

Sincerely, ranger1s.


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

Re: Formatting Pages in Calc

[Brian Barker]

At 23:44 02/03/2017 +, John van Barneveld wrote:
I have a spreadsheet with four sheets, the third 
of which I want printed in landscape and the 
rest in portrait. It seems when I set in 
Format-Page it formats all four the same ...


Because you are modifying the page style which 
currently applies to all parts of your document.



... forcing me to print each page separately. This is fine for printing ...


Well, not exactly fine: it would be easier if you 
could set the third sheet to print in landscape 
automatically, of course - and you can.



... but I want to save a four page .pdf with the one page as landscape.


There are workarounds for this, but you don't need these.


Can anyone tell me how to go about this please.


Page orientation is a property of page styles. If 
you have not consciously set any page style, all 
your pages will probably have the Default page 
style. You can see this when you go to Format | 
Page...: the panel is headed Page Style: Default. 
So all you need is to use a different page style for the rogue sheet.


o Go to Format | Styles and Formatting... (or 
click the Styles and Formatting button in the 
Formatting toolbar, or press F11).

o Click the Page Styles button in the Styles and Formatting window.
o Click Default (or whatever your main style is called).
o Click the "New Style from Selection" button.
o Give your new style a name.
o Right-click the new style name in the list and select Modify... .
o Change the orientation of this style to Landscape.
o With the rogue sheet displayed, double-click 
the new style name to apply it to that sheet.

o Voilà!

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: Formatting Pages in CaLc

[Martin Groenescheij]

On 03/03/17 11:15 AM, Julian THOMAS wrote:


Sent from JT's iMini - using voice dictation!


On Mar 2, 2017, at 18:44, John van Barneveld <jvanbarnev...@bigpond.com> wrote:

This is fine for printing but I want to save a four page .pdf with the one page 
as landscape.  Can anyone tell me how to go about this please.

Brute force solution: print the landscape page as a separate PDF; Print the 
other three pages, and then glue the two PDF files together.


Better is to use existing functionalities.
Go to Format -> Styles and Formatting, the second icon at the top is 
Page Styles
Create a Landscape and a Portrait Style for each sheet select the 
desired style.

Happy printing.



-
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: Formatting Pages in CaLc

[Julian THOMAS]

Sent from JT's iMini - using voice dictation!

> On Mar 2, 2017, at 18:44, John van Barneveld  
> wrote:
> 
> This is fine for printing but I want to save a four page .pdf with the one 
> page as landscape.  Can anyone tell me how to go about this please.

Brute force solution: print the landscape page as a separate PDF; Print the 
other three pages, and then glue the two PDF files together.

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

Formatting Pages in CaLc

[John van Barneveld]

I have a spreadsheet with four sheets, the third of which I want printed
in landscape and the rest in portrait.  It seems when I set  in
Format-Page it formats all four the same forcing me to print each page
separately.  This is fine for printing but I want to save a four page
.pdf with the one page as landscape.  Can anyone tell me how to go about 
this please.


Thanks
John van Barneveld



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

Re: Conditional Formatting over Same Range of Cells

[VinceB.]

On 1/26/2017 2:02 AM, Brian Barker wrote:

At 21:46 25/01/2017 -0500, Vince Bonly wrote:
Using AOO 4.1.2 Calc on my WIN10 desktop, I have succeeded in 
detecting scores above a threshold (>174) and marking the cell for 
red font for a specified range of cells. That uses 1 of the 3 
available criteria settings. Next, I tried setting a criteria setting 
(condition 2 of 3) for the same range of cells to apply a bold font 
whenever scores are >199. Thus, for example, a score of 225 would 
have both red and bold applied to the cell. It seems that Calc is 
unable to set a 2nd or 3rd criteria over *the same range of cells*.


By experiment, I see that is not true: you can achieve what you want. 
Unfortunately, you don't explain exactly what you have done and what 
result you see, so anyone is left to guess.
OK; I can verify FYI that at the time of my OP I had the following 
settings at the Format*|*Conditional Formatting dialogue:


Condition 1:
Cell value isgreater than74
Cell StyleRed if >174

Condition 2:
Cell value isgreater than199
Cell StyleBOLD  if >199 Scored

Condition 3:
Cell value isgreater than199
Cell Style11 pt if >199 Scored



Conditional formatting works by applying cell styles. You talk about 
applying "both red and bold", but you cannot apply two styles 
simultaneously to the same cell or cell range, of course. So you would 
need one cell style for red and another for red-bold. (The criteria 
you wish to apply are such that you don't need bold without red.) Is 
that what you did?

No, I did not. (See above.)


All that's left is to notice the built-in help text, which says _inter 
alia_ "The conditions are evaluated from 1 to 3. If the condition 1 
matches the condition, the defined style will be used. Otherwise, 
condition 2 is evaluated, and its defined style used. If this style 
does not match, condition 3 is evaluated." (This doesn't appear to be 
explained in the Calc Guide.) Note those words "Otherwise" and "If ... 
not": if any condition is satisfied, later ones are disregarded. In 
your case, if you apply the >174 condition first, the >199 condition 
will be evaluated only if the value is not >174 - so can never be 
effective. The solution is just to set >199 with red-bold as Condition 
1 and >174 with red as Condition 2. 
Thank you, Brian. Indeed, very helpful, and key to grasping what is 
going on when using Format*|*Conditional Formatting feature in Calc.


Is a Boolean AND required/possible in the criteria settings?


Not if you are using "Cell value is", I think.


Is the 3-criteria a limit for each Calc sheet?


No: it's a limit for any individual cell, I think. However you 
construct your cell ranges, each cell has its own set of up to three 
conditions.


I trust this helps.

Brian Barker



_
FYI, I now have the following settings; they work satisfactorily for my 
needs:


Condition 1 cell style:
Cell valueis greater than199.
Cell Style*|*Font tab: I have selected Arial-Font; Bold-Typeface; and 11 
pt-Size as the Font cell style definitions.
Cell Style*|*Font Effects tab: I have selected Red-character color as 
the Font Effects cell style definition.


Condition 2 cell style:
Cell valueis greater than174.
Cell Style*|*Font Effects tab: I have selected Red as the Font Effects 
cell style definition.


Condition 3 cell style:
Cell valueis greater between1 and100.
Cell Style*|*Background tab: I have selected YELLOW fill-in color as the 
Background cell style definition.


I hope that my info is also helpful.

My TNX for your detailed discussion.

Regards,
VinceB.

Re: Conditional Formatting over Same Range of Cells

[Brian Barker]

At 21:46 25/01/2017 -0500, Vince Bonly wrote:
Using AOO 4.1.2 Calc on my WIN10 desktop, I have succeeded in 
detecting scores above a threshold (>174) and marking the cell for 
red font for a specified range of cells. That uses 1 of the 3 
available criteria settings. Next, I tried setting a criteria 
setting (condition 2 of 3) for the same range of cells to apply a 
bold font whenever scores are >199. Thus, for example, a score of 
225 would have both red and bold applied to the cell. It seems that 
Calc is unable to set a 2nd or 3rd criteria over *the same range of cells*.


By experiment, I see that is not true: you can achieve what you want. 
Unfortunately, you don't explain exactly what you have done and what 
result you see, so anyone is left to guess.


Conditional formatting works by applying cell styles. You talk about 
applying "both red and bold", but you cannot apply two styles 
simultaneously to the same cell or cell range, of course. So you 
would need one cell style for red and another for red-bold. (The 
criteria you wish to apply are such that you don't need bold without 
red.) Is that what you did?


All that's left is to notice the built-in help text, which says 
_inter alia_ "The conditions are evaluated from 1 to 3. If the 
condition 1 matches the condition, the defined style will be used. 
Otherwise, condition 2 is evaluated, and its defined style used. If 
this style does not match, condition 3 is evaluated." (This doesn't 
appear to be explained in the Calc Guide.) Note those words 
"Otherwise" and "If ... not": if any condition is satisfied, later 
ones are disregarded. In your case, if you apply the >174 condition 
first, the >199 condition will be evaluated only if the value is 
not >174 - so can never be effective. The solution is just to 
set >199 with red-bold as Condition 1 and >174 with red as Condition 2.



Is a Boolean AND required/possible in the criteria settings?


Not if you are using "Cell value is", I think.


Is the 3-criteria a limit for each Calc sheet?


No: it's a limit for any individual cell, I think. However you 
construct your cell ranges, each cell has its own set of up to three 
conditions.


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

Conditional Formatting over Same Range of Cells

[VinceB.]

Using AOO 4.1.2 Calc on my WIN10 desktop, I have succeeded in detecting 
scores above a threshold (>174) and marking the cell for red font for a 
specified range of cells. That uses 1 of the 3 available criteria 
settings. Next, I tried setting a criteria setting (condition 2 of 3) 
for the same range of cells to apply  a bold font whenever scores are 
>199.  Thus, for example, a score of 225 would have both red and bold 
applied to the cell.


It seems that Calc is unable to set a 2nd or 3rd criteria over *the same 
range of cells*.


1. Is that normal, or else I am doing something else incorrectly ?
2. Is a Boolean AND required/possible in the criteria settings?
3. Is the 3-criteria a limit for each Calc sheet?

Please advise.

Regards,

VinceB.

Re: Problems with File Formatting and Document Display on Open Office Writer

[Brian Barker]

At 15:35 19/07/2016 +0100, Matt Mills wrote:
I have been using OpenOffice Writer for a number of years and I have 
recently has problems with the program. A main concern is whenever i 
save a document in Word 97/2000/XP format, the program tells me that 
the document has been saved in the format I requested, but when I go 
to open the documents, they are displayed as an unknown file type 
with the unknown file icon (the white box with three squares). Every 
time I save a document now, even previous documents that have been 
saved as Word 97/00/XP documents, they are converted to unknown file 
types every time I go back into OpenOffice.


You may well imagine that the icon you see outside OpenOffice - 
provided by your operating system - shows the format in which any 
document file has been saved. But this is not true. Instead, the 
choice of icon will be based on the application that your operating 
system would use to open the file by default if you double-click it. 
In most cases this depends only on the extension to the file name, 
not on any property of the document file itself.


So what is likely is that your saved files are indeed in your chosen 
format but that they lack the .doc extension to indicate this to your 
operating system. You can test this by starting OpenOffice first and 
then using File | Open ... (or the Open... button in the start 
screen) to browse to and open the files - which you should find works 
normally, as this does not rely on your operating system's default settings.


OpenOffice has a strange option in the Save As... dialogue box. Near 
the bottom, you will see an "Automatic file name extension" tick box. 
Has this become unticked? If it has, you will be saving documents in 
the correct format, but the file names will not be getting the proper 
extension. So a document will be called just "name" rather than 
"name.doc". If you replace the tick, it will stick for further saves.


You can deal with existing rogue files either by opening them as 
above and then saving them with the appropriate extension (once you 
have replaced the tick) or else by using your operating system's 
facilities to rename the files, adding the extension manually.


I also had difficulty with the formatting of a Word document that I 
opened in OpenOffice. When I opened the file, the formatting had 
been thrown around and text boxes were moved and had a strange red 
arrow in the right-had corner. I have never known of this problem 
before - could it be due to a virus?


No. First, there will always be differences when you open documents 
in foreign formats or prepared by other application software. Indeed, 
there will be differences even without these changes if you have a 
different operating system, version of the application software, 
default printer, paper size, installed fonts, and so on. For best 
results, once you have formatted a document as you wish, save it in 
OpenOffice's native Open Document Format formats - .odt etc. - for 
later further use.


The red arrow just indicates that there is more text in the table 
cell than can be displayed at the current font, size, or other 
settings, I think. Enlarge the table cell or change the character 
formatting to see the rest of the contents.


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: Problems with File Formatting and Document Display on Open Office Writer

[Daniel Roma]

Hello.

Your windows may be faulty, or dll corrupt.

in My Documents or Windows Explorer, right click the mouse on the
file, and choose default program as wtitter.
openoffice and microsoft office word recognize features, writer your
ways .: may have to make some changes in your document parater same
formatting as the word.my sister had a similar problem when trying to
open documents in Word, and for some reason the windows put the
writter  as the default program

when I open or create word documents the writer, always saved in the
word standard, never on writter pattern.
try opening the same document on another computer, with openoffice,
and see if you have the same problem. but it may be your windows with
some corrupt dll.

I have helped

2016-07-19 11:35 GMT-03:00 e-mail rm004e0578 <rm004e0...@blueyonder.co.uk>:
> Hello, I have been using OpenOffice Writer for a number of years and I have
> recently has problems with the program.  A main concern is whenever i save a
> document in Word 97/2000/XP format, the program tells me that the document has
> been saved in the format I requested, but when I go to open the documents, 
> they
> are displayed as an unknown file type with the unknown file icon (the white 
> box
> with three squares).  Every time I save a document now, even previous 
> documents
> that have been saved as Word 97/00/XP documents, they are converted to unknown
> file types every time I go back into OpenOffice.
>
> I also had difficulty with the formatting of a Word document that I opened in
> OpenOffice.  When I opened the file, the formatting had been thrown around and
> text boxes were moved and had a strange red arrow in the right-had corner.  I
> have never known of this problem before - could it be due to a virus?
>
> Thanks
>
> Best wishes,
>
> Matt Mills
>
> -
> 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

Problems with File Formatting and Document Display on Open Office Writer

[e-mail rm004e0578]

Hello, I have been using OpenOffice Writer for a number of years and I have
recently has problems with the program.  A main concern is whenever i save a
document in Word 97/2000/XP format, the program tells me that the document has
been saved in the format I requested, but when I go to open the documents, they
are displayed as an unknown file type with the unknown file icon (the white box
with three squares).  Every time I save a document now, even previous documents
that have been saved as Word 97/00/XP documents, they are converted to unknown
file types every time I go back into OpenOffice.

I also had difficulty with the formatting of a Word document that I opened in
OpenOffice.  When I opened the file, the formatting had been thrown around and
text boxes were moved and had a strange red arrow in the right-had corner.  I
have never known of this problem before - could it be due to a virus?

Thanks

Best wishes,

Matt Mills

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

Re: Unwanted interference in text formatting.

[Martin Groenescheij]

On 27-Oct-15 10:57, Donald Miller wrote:

Unwanted interference in text formatting.

In plain text editors, I can manually control formatting, spacing, 
numbering, indent, et cetera.

For example, it is straightforward
1. to start a number list,
2. and continue
without any unwanted indents or font changes, like a typewriter.

LibreOffice Writer allows the same free control.
MS Office and Apache Open Office impose indents, spaces, often modify 
fonts.
I can paste from a text editor to AOO swriter and bypass that 
interference.


Nobody is imposing indents, spaces or fonts. You're in control.
Just change the Default Style and remove the indent, set the font you 
like and delete all other Styles.


Once you have changed it save it as your default template.
Or even better use notepad it has all the features you need.


Can AOO be made to stop this? My template should only set margins and 
fonts.

If not, I will move to Libre. I no longer collaborate with other authors.


Or is it that other authors don't collaborate with you?


AOO also, at least in spreadsheets, can paste URLs with dark gray cell 
backgrounds.
I understand blue, or auto-underline (which I prefer OFF), but not 
dark cell.


Again, you are in control go to Tools --> Options --> OpenOffice --> 
Appearance and set it according your needs.




LibreOffice is not perfect. The 'recent files' list is a space wasting 
series of images,
hidden extensions, whereas AOO can show simple list of files with full 
path names,

just like any good DOS or Win file manager.


There is no perfect application/software package there are only annoying 
and less annoying packages.

The question is can you master the software as you're still the boss.



Funny thing, as I tested this text and a spreadsheet in AOO and LO, I 
found that
'recent files' can drop the graphics for simple full path list. I'll 
try to learn why/how.


That's what it is all about "Keep Learning".



Regards / Don Miller

-
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

Unwanted interference in text formatting.

[Donald Miller]

Unwanted interference in text formatting.

In plain text editors, I can manually control formatting, spacing, 
numbering, indent, et cetera.

For example, it is straightforward
1. to start a number list,
2. and continue
without any unwanted indents or font changes, like a typewriter.

LibreOffice Writer allows the same free control.
MS Office and Apache Open Office impose indents, spaces, often modify fonts.
I can paste from a text editor to AOO swriter and bypass that interference.

Can AOO be made to stop this? My template should only set margins and fonts.
If not, I will move to Libre. I no longer collaborate with other authors.

AOO also, at least in spreadsheets, can paste URLs with dark gray cell 
backgrounds.
I understand blue, or auto-underline (which I prefer OFF), but not dark 
cell.


LibreOffice is not perfect. The 'recent files' list is a space wasting 
series of images,
hidden extensions, whereas AOO can show simple list of files with full 
path names,

just like any good DOS or Win file manager.

Funny thing, as I tested this text and a spreadsheet in AOO and LO, I 
found that
'recent files' can drop the graphics for simple full path list. I'll try 
to learn why/how.


Regards / Don Miller

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

Question about formatting

[Chuck Selvaggio]

When I have a new document and want to import a logo (from a jpeg), the whole 
format changes to something that looks like a power point presentation.  I just 
want to begin with a clear document, put our logo (Jpeg) at the top and 
continue typing text.  How do I do this?

Chuck
302-529-5661….here all day.

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

Re: Question about formatting

[Rory O'Farrell]

On Wed, 14 Oct 2015 08:51:47 -0400
Chuck Selvaggio  wrote:

> When I have a new document and want to import a logo (from a jpeg), the whole 
> format changes to something that looks like a power point presentation.  I 
> just want to begin with a clear document, put our logo (Jpeg) at the top and 
> continue typing text.  How do I do this?
> 
> Chuck

Try New Document, then /Insert /Picture: from File.  

-- 
Rory O'Farrell 

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

Re: Number Formatting

[Dale Erwin]

On 7/28/2015 5:12 PM, Dale Erwin wrote:

Environment: AOO 4.1.1 under Win 7.

I am using a table in Writer for as tabulation because I want some 
columns left-justified and some columns right-justified.  The 
right-justified columns contain dollars and cents.  Every time I enter 
an amount that ends in .00, it eliminates the two zeroes. For 
instance, if I enter 27.00, after I tab out of that column it changes 
to 27 (right-justified).  If I click on 'Undo Auto Format' the 27.00 
is restored, but the cursor is put back into the cell and getting out 
of the cell once again changes it to 27 (right justified).  I have 
searched the table properties, but cannot find the control for this.  
Can someone please tell me where to find it?


Dale Erwin



Never mind... I found it.

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

Conditional Formatting Issue

[Mobile App]

Hi,

I am using open office in fedora21 and I want to use conditional formatting
in my report. We want to apply more than 4 condition on a cell but
openoffice provides only 3 condition for conditional formatting.
Please provide solution for it.

Re: Conditional Formatting Issue

[Martin Groenescheij]

Sent from my mobile device.

 On 19 May 2015, at 10:02 pm, Mobile App mobapp010...@gmail.com wrote:
 
 Hi,
 
 I am using open office in fedora21 and I want to use conditional formatting
 in my report. We want to apply more than 4 condition on a cell but
 openoffice provides only 3 condition for conditional formatting.
 Please provide solution for it.

You have raised this question in the OpenOffice forum, where it was answered.

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

Re: try to clear/default formatting causes lock-ups

[Andrea Pescetti]

On 19/05/2014 John Deaton wrote:

you could put any text, etc., and clear formats, and get rid of fonts,
paging, paragraphing, and linksall at once. ...
But lately (and I've been using it in multiple computer types), it locks up.
I mean IT IS CRASHED.  No use waiting for it to solve anything.


If you can provide a 100% reproducible way to repeat the crash (e.g., 
open this specific web page with Firefox, copy from here to there, open 
a new document in Writer and paste) we can investigate the issue. 
Otherwise, we don't have enough elements to understand where your 
problems come from.


Regards,
  Andrea.

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

Re: try to clear/default formatting causes lock-ups

[Ariel Constenla-Haile]

Hello John,

On Mon, May 19, 2014 at 01:34:16PM -0500, John Deaton wrote:
 One of the many great things about OO, until now---and not sure if
 4.1.0 is worse (but pretty sure),
 
 Is you could put any text, etc., and clear formats, and get rid of
 fonts, paging, paragraphing, and linksall at once.
 
 I've tried default formatting, too, but same result.
 
  
 
 But lately (and I've been using it in multiple computer types), it
 locks up.  I mean IT IS CRASHED.  No use waiting for it to solve
 anything.
 
  
 
 I've searched online for such a thing, but I see nothing related, yet. 

This seems to be bug 124877
https://issues.apache.org/ooo/show_bug.cgi?id=124877
The fix for this bug will be available in the next release.


Regards
-- 
Ariel Constenla-Haile
La Plata, Argentina


signature.asc
Description: Digital signature

AOO writer cell formatting not sticky

[Greg Madden]

I  am using AOO v 4.0.1 , Debian Wheezy, Linux.

I create a table in writer, select a range of cells, apply number 
formating.  the 'currency' number format. The cells are empty , data 
gets entered later. Formatting  only works if there is a number in the 
cell.

Is this normal/desired by some, behavior?

thanks
-- 

Greg

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

Re: AOO writer cell formatting not sticky

[Brian Barker]

At 16:34 20/04/2014 -0800, Greg Madden wrote:
I am using AOO v 4.0.1, Debian Wheezy, Linux. I create a table in 
writer, select a range of cells, apply number formating.  the 
'currency' number format. The cells are empty, data gets entered 
later. Formatting only works if there is a number in the cell.


To achieve what you want, you need to tick Tools | Options... | 
OpenOffice Writer | Table | Input in tables | Number recognition. You 
may want to experiment with whether you also need to tick Tools | 
Options... | OpenOffice Writer | Table | Input in tables | Number 
format recognition: no-one can explain what this does - not the help 
text or even the manual.


I trust this helps.

Brian Barker


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

Re: AOO writer cell formatting not sticky

[Greg Madden]

On Sunday 20 April 2014 18:12:49 you wrote:
 At 16:34 20/04/2014 -0800, Greg Madden wrote:
 I am using AOO v 4.0.1, Debian Wheezy, Linux. I create a table in
 writer, select a range of cells, apply number formating.  the
 'currency' number format. The cells are empty, data gets entered
 later. Formatting only works if there is a number in the cell.

 To achieve what you want, you need to tick Tools | Options... |
 OpenOffice Writer | Table | Input in tables | Number recognition. You
 may want to experiment with whether you also need to tick Tools |
 Options... | OpenOffice Writer | Table | Input in tables | Number
 format recognition: no-one can explain what this does - not the help
 text or even the manual.

 I trust this helps.

 Brian Barker

Thank you, that works

-- 
Peace,

Greg

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

Re: AOO writer cell formatting not sticky

[Greg Madden]

On Sunday 20 April 2014 18:39:05 you wrote:
 On Sunday 20 April 2014 18:12:49 you wrote:
  At 16:34 20/04/2014 -0800, Greg Madden wrote:
  I am using AOO v 4.0.1, Debian Wheezy, Linux. I create a table in
  writer, select a range of cells, apply number formating.  the
  'currency' number format. The cells are empty, data gets entered
  later. Formatting only works if there is a number in the cell.
 
  To achieve what you want, you need to tick Tools | Options... |
  OpenOffice Writer | Table | Input in tables | Number recognition.
  You may want to experiment with whether you also need to tick Tools
  | Options... | OpenOffice Writer | Table | Input in tables | Number
  format recognition: no-one can explain what this does - not the
  help text or even the manual.
 
  I trust this helps.
 
  Brian Barker

 Thank you, that works

Another benifit, with number format recognition checked I no longer get  
dialog boxes when I  selectdelete cell contents. The default cell 
format is 'text' which produces a dialog box  when deleting contents, 
asking a number of questions on what formating needs to be deleted. 
Simplified work flow...yea.

-- 
Peace,

Greg

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

Re: email address formatting in Calc

[Don Daugherty]

On 3/31/2014 7:21 PM, phalbe henriksen wrote:

Hi.

I have a Calc spreadsheet that contain about 400 email addresses. They are
formatted as plain text, hyper-linked in blue and underlined, and
hyper-linked in blue, underlined with a gray background.

How can I change the special formatting and make them all plain text?
Nothing I've tried works.

Thanks.

Phalbe Henriksen
working on 50th class reunion


You might try using Paste Special, i.e.,
1.  Create a new sheet in the same spreadsheet file
2.  On the page containing the email addresses select the block of cells 
containing the addresses and press Ctrl+C.
3.  Then go to the new page and press Shift+Ctrl+V (or Click Edit  
Paste Special...).  This brings up the Paste Special dialog box.  Under 
Select, check Text, Numbers, and DateTime, and uncheck all other 
choices.  Under Options nothing should be checked; under Operations only 
None should be dotted, and under Shift Cells only Don't Shift should be 
dotted.  Click OK.


If this does what you want, you can replace step 3 with
3'.  Press Shift+Ctrl+V (or Click Edit  Paste Special...).  This brings 
up the Paste Special dialog box.  Under Select, check Text, Numbers, and 
DateTime, and uncheck all other choices.  Under Options nothing should 
be checked; under Operations only None should be dotted, and under Shift 
Cells only Don't Shift should be dotted. Click OK.  In other words, you 
can Paste Special back into the original cells, thus  converting them to 
the desired  format.



---
This email is free from viruses and malware because avast! Antivirus protection 
is active.
http://www.avast.com


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

email address formatting in Calc

[phalbe henriksen]

Hi.

I have a Calc spreadsheet that contain about 400 email addresses. They are
formatted as plain text, hyper-linked in blue and underlined, and
hyper-linked in blue, underlined with a gray background.

How can I change the special formatting and make them all plain text?
Nothing I've tried works.

Thanks.

Phalbe Henriksen
working on 50th class reunion

Re: Formatting a hyperlink in Calc

[Martin Groenescheij]

Tools -- Options -- Appearance ... Visited Links

On 3-3-2014 3:47, William K Helbig Jr wrote:
Can anyone please me how to format a hyperlink in a Calc cell to 
appear the way I want it to, not just the way Openoffice wants?


Skip H

strip formatting??

[Patricia Hickin]

Is there a way to remove all formatting?

I am copying some items from a website (worldcat.org) to include in a
report and I want to do my own formatting so I would like to strip the
current formatting (font style,
size, color; italics, etc.

Is there a way to remove all the current formatting?

Thanks,
Pat

Re: strip formatting??

[Michael Collins]

I copy/paste into Notepad.




--- On Sat, 6/1/13, Patricia Hickin pph...@gmail.com wrote:

 From: Patricia Hickin pph...@gmail.com
 Subject: strip formatting??
 To: users@openoffice.apache.org
 Date: Saturday, June 1, 2013, 10:49 PM
 Is there a way to remove all
 formatting?
 
 I am copying some items from a website (worldcat.org) to
 include in a
 report and I want to do my own formatting so I would like to
 strip the
 current formatting (font style,
 size, color; italics, etc.
 
 Is there a way to remove all the current formatting?
 
 Thanks,
 Pat
 

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

Re: strip formatting??

[Doug]

On 06/01/2013 11:49 PM, Patricia Hickin wrote:

Is there a way to remove all formatting?

I am copying some items from a website (worldcat.org) to include in a
report and I want to do my own formatting so I would like to strip the
current formatting (font style,
size, color; italics, etc.

Is there a way to remove all the current formatting?

Thanks,
Pat

I ran into a similar situation, and solved it this way. It is a little 
time-consuming,
I wouldn't want to do it for a whole book, but for a couple of pages 
it's OK.


Cut and paste the text into Kate. In Kate, select each paragraph, one at a
time. Stop the selection at the last period in the paragraph. Under Tools
select Join Lines or use CTRL+J. Now go back and select the next 
paragraph

and do likewise, until you have done them all.

Now select the entire Kate file (cut) and paste it into your word processor.
It will come in without its original formatting and conform to whatever
formatting the word processor is set up for. You can select the text in 
LO or
OO or whatever and reformat it as you wish--change font, font size, 
justification,

whatever you want. You may find that you have to manually fix apostrophes
and quote marks, I think it depends on the source, but otherwise your
search and replace functions will work OK--you can replace double spaces
with single, for instance.

Good luck with it--doug

--
Blessed are the peacemakers..for they shall be shot at from both sides. 
--A.M.Greeley


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

Re: strip formatting??

[Rory O'Farrell]

On Sat, 1 Jun 2013 23:49:39 -0400
Patricia Hickin pph...@gmail.com wrote:

 Is there a way to remove all formatting?
 
 I am copying some items from a website (worldcat.org) to include in a
 report and I want to do my own formatting so I would like to strip the
 current formatting (font style,
 size, color; italics, etc.
 
 Is there a way to remove all the current formatting?
 
 Thanks,
 Pat

/Edit /Paste Special and then choose textwhen offered.

-- 
Rory O'Farrell ofarr...@iol.ie

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