Re: Using Open office

[Moderator]

You are subscribed to the users@openoffice.apache.org mailing list so
you receive a copy of all posts, just like all other subscribers.

According to the mailing list records the reply to David Hunt's post
came from your email address luce...@lucetta.ca.

On 22/02/2020 13:28, Lucetta wrote:
> This has been just been sent to me and I don’t understand it
> 
> Does anyone have any thoughts?
> 
>> On Feb 22, 2020, at 12:29 AM, Lucetta  wrote:
>>
>> Can’t speak for you situation. However something has changed  with the base 
>> code in some operating systems. It technical & outside of my computer 
>> understanding. I don’t understand it, something to do with base code and 
>> macros or executables, but far outside of my depth of knowledge. 
>>
>> My Open Office spreadsheets created on my 2009 MacBookPros can no longer can 
>> be opened with Excel. If they open it is text only & can’t be manipulated.
>>
>> I am redoing all my OpenOffice spreadsheets from scratch for our accountant 
>> in an old Excel which I’m hoping will work. Just don’t have time to get & 
>> learn new equipment & software. 
>>
>> Also my Norton went very buggy & replacement security was even worse. Not 
>> sure how or if that fits in but happened at the same time. 
>>
>> I’m having to replace all my computers and software. Something happened with 
>> a recent update to my Mac OS but apparently it was only a matter of time. 
>>
>> If anyone has any suggestion they would be much appreciated. But I’ve run 
>> out of time to play around & am just heads down redoing everything. 
>>
>> Lucetta
>>
>>> On Feb 20, 2020, at 7:05 AM, David Hunt  wrote:
>>>
>>> I have started using Open Office on my HP PC, with Windows 10.
>>> Sadly any document I send out can be read by other windows users, but I 
>>> phone and some I pads complain that all documents are scrambled or Zipped.?
>>>
>>> Any suggestions please.
>>> I do not have Microsoft Office any more, corrupted and Microsoft support 
>>> totally unhelpful.
>>>
>>> Dave  Thanks in hope.
>>>
>>> Sent from Mail for Windows 
>>> 10



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

RE: Using Open office

[Geoffrey Hartwell]

That is NOT repeat NOT my email address

 

With kind regards, 

Geoffrey Hartwell

Eur Ing Professor Geoffrey M. Beresford Hartwell CEng

FIMechE FIET SenMIEEE(USA) FCIArb(retired) FICArb(India)

hartw...@blueyonder.co.uk

http://www.arbitrator-engineer-gbh.co.uk/

Consulting Engineer  and FIDIC Accredited Adjudicator

 

 

 

-Original Message-
From: Moderator [mailto:b...@apache.org] 
Sent: 22 February 2020 13:48
To: users@openoffice.apache.org
Subject: Re: Using Open office

 

You are subscribed to the   
users@openoffice.apache.org mailing list so you receive a copy of all posts, 
just like all other subscribers.

 

According to the mailing list records the reply to David Hunt's post came from 
your email address   luce...@lucetta.ca.

 

On 22/02/2020 13:28, Lucetta wrote:

> This has been just been sent to me and I don’t understand it

> 

> Does anyone have any thoughts?

> 

>> On Feb 22, 2020, at 12:29 AM, Lucetta <  
>> luce...@lucetta.ca> wrote:

>> 

>> Can’t speak for you situation. However something has changed  with the base 
>> code in some operating systems. It technical & outside of my computer 
>> understanding. I don’t understand it, something to do with base code and 
>> macros or executables, but far outside of my depth of knowledge. 

>> 

>> My Open Office spreadsheets created on my 2009 MacBookPros can no longer can 
>> be opened with Excel. If they open it is text only & can’t be manipulated.

>> 

>> I am redoing all my OpenOffice spreadsheets from scratch for our accountant 
>> in an old Excel which I’m hoping will work. Just don’t have time to get & 
>> learn new equipment & software. 

>> 

>> Also my Norton went very buggy & replacement security was even worse. Not 
>> sure how or if that fits in but happened at the same time. 

>> 

>> I’m having to replace all my computers and software. Something happened with 
>> a recent update to my Mac OS but apparently it was only a matter of time. 

>> 

>> If anyone has any suggestion they would be much appreciated. But I’ve run 
>> out of time to play around & am just heads down redoing everything. 

>> 

>> Lucetta

>> 

>>> On Feb 20, 2020, at 7:05 AM, David Hunt <  
>>> davidze...@live.co.uk> wrote:

>>> 

>>> I have started using Open Office on my HP PC, with Windows 10.

>>> Sadly any document I send out can be read by other windows users, but I 
>>> phone and some I pads complain that all documents are scrambled or Zipped.?

>>> 

>>> Any suggestions please.

>>> I do not have Microsoft Office any more, corrupted and Microsoft support 
>>> totally unhelpful.

>>> 

>>> Dave  Thanks in hope.

>>> 

>>> Sent from Mail<  
>>> https://go.microsoft.com/fwlink/?LinkId=550986> for 

>>> Windows 10

 

 

 

-

To unsubscribe, e-mail:   
users-unsubscr...@openoffice.apache.org

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

cannot insert fields

[Felmon Davis]

greetings!

I'm trying to help someone out on formatting their document; they 
posted earlier to the list.


it's the strangest thing. any attempt to insert 'page number' or 'page 
count' yields a blank space.


well, not completely blank. there is some kind of char but it appears 
only as a grey area.


I have tried changing fonts and I also have made a template of the doc 
and then generated a new one. no change. I have changed the language 
from Canadian English to American.


the other major fields such as 'date' and so on work.

I would guess some kind of corruption somewhere but maybe someone has 
a better notion. I'd hate to have to reconstruct the document from 
ground up. I'm willing to fool around with xml or whatever if needed.


I'm on OpenOffice 4.1.6.

f.

--
Felmon Davis

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

Re: cannot insert fields

[Felmon Davis]

On Sat, 22 Feb 2020, Rory O'Farrell wrote:


On Sat, 22 Feb 2020 14:33:46 -0500 (EST)
Felmon Davis  wrote:


greetings!

I'm trying to help someone out on formatting their document; they
posted earlier to the list.

it's the strangest thing. any attempt to insert 'page number' or 'page
count' yields a blank space.

well, not completely blank. there is some kind of char but it appears
only as a grey area.

I have tried changing fonts and I also have made a template of the doc
and then generated a new one. no change. I have changed the language
from Canadian English to American.

the other major fields such as 'date' and so on work.

I would guess some kind of corruption somewhere but maybe someone has
a better notion. I'd hate to have to reconstruct the document from
ground up. I'm willing to fool around with xml or whatever if needed.

I'm on OpenOffice 4.1.6.

f.

--
Felmon Davis



Do the other fields appear on a grey background?  If so, this is 
non-printing, but can be suppressed by toggling /View /Field 
Shadings.  If you turn on /View /Field names, does the page number 
field show "Page Numbers"?


this worked but you may have seen my reply to Brian Barker; one of his 
methods solved the present problem.


If you turn on the Stylist (F11), and enable "All Styles" in the 
dropdown on Stylist's bottom bar, are there many styles WW... and 
Convert..., which indicate that the file has been Saved in MS 
document formats and or edited by MS Word.


just btw this is all OpenOffice, no touch of Word.

f.

--
Felmon Davis

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

more field fun.

[Felmon Davis]

great help!

through some trickery with 'manual breaks' and 'page styles' I have 
almost everything in shape.


however -

imagine you have ten consecutive pages all without footer and 
unnumbered except for pages 3, 5 and 7; on those pages you want a 
footer and you want a roman numeral, for instance ix on page 3, xi on 
page 5 and xiii on page 7.


inserting a number generates the same numeral on each page.

ah, I guess the trick is to do a different page style for 3, 5 and 7.

need a break; will pursue this strategy later unless there's a better 
idea.


f.

--
Felmon Davis

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

Re: cannot insert fields

[Brian Barker]

At 14:33 22/02/2020 -0500, Felmon Davis wrote:
I'm trying to help someone out on formatting their document; they 
posted earlier to the list.


Is this Teresa Brown?

it's the strangest thing. any attempt to insert 'page number' or 
'page count' yields a blank space. well, not completely blank. there 
is some kind of char but it appears only as a grey area.


The grey area is the required field, of course. So you have the field 
but it is failing to display the required value. You could confirm 
this by toggling the display to field names at View | Field Names (or Ctrl+F9).



the other major fields such as 'date' and so on work.


Good.


I would guess some kind of corruption somewhere ...


I think not.


... but maybe someone has a better notion.


I'm guessing the document has sections that need to be numbered other 
than naturally, so that - perhaps? - the main body of a document is 
paginated starting at page 1 despite its following title pages and 
front matter, i.e not being the real first page of the document. 
There appear to be two ways of achieving this:


Method I:
o Go to Insert | Manual Break... .
o In the Insert Break dialogue, select "Page break".
o Select an appropriate style (even if it does not change).
o Select "Change page number" and choose the starting page number.

Method II:
o Either select the relevant field or position the cursor just to the 
left of it.

o Go to Edit | Fields... (or right-click | Fields...).
o For Page numbers, set a suitable value for Offset.

Now Method I seems to work for me, but Method II not always. In 
particular, if the page number is greater than the actual number of 
pages in the document it will not display. And negative page numbers 
will not display. In those cases the field will show as a grey bock 
but with no number - exactly what you describe.


I'm not sure about page count, but I suspect the problem is similar.

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: cannot insert fields

[Rory O'Farrell]

On Sat, 22 Feb 2020 14:33:46 -0500 (EST)
Felmon Davis  wrote:

> greetings!
> 
> I'm trying to help someone out on formatting their document; they 
> posted earlier to the list.
> 
> it's the strangest thing. any attempt to insert 'page number' or 'page 
> count' yields a blank space.
> 
> well, not completely blank. there is some kind of char but it appears 
> only as a grey area.
> 
> I have tried changing fonts and I also have made a template of the doc 
> and then generated a new one. no change. I have changed the language 
> from Canadian English to American.
> 
> the other major fields such as 'date' and so on work.
> 
> I would guess some kind of corruption somewhere but maybe someone has 
> a better notion. I'd hate to have to reconstruct the document from 
> ground up. I'm willing to fool around with xml or whatever if needed.
> 
> I'm on OpenOffice 4.1.6.
> 
> f.
> 
> -- 
> Felmon Davis
> 

Do the other fields appear on a grey background?  If so, this is non-printing, 
but can be suppressed by toggling /View /Field Shadings.  If you turn on /View 
/Field names, does the page number field show "Page Numbers"?

If you turn on the Stylist (F11), and enable "All Styles" in the dropdown on 
Stylist's bottom bar, are there many styles WW... and Convert..., which 
indicate that the file has been Saved in MS document formats and or edited by 
MS Word.



-- 
Rory O'Farrell 

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

Re: more field fun.

[Andrew Pitonyak]

I do not have time to look deeply into this, but, I do believe that you can 
have differnet behavior for left / right pages for a page style. I think they 
talk about it here: 

https://wiki.openoffice.org/wiki/Documentation/FAQ/Writer/FormattingPagesAndDocuments/How_do_I_make_page_numbers_alternate%3F

I do notice, however, tha tyou say "page 3" is numbered as xi (11), so you 
would need to make sure that the real page number is correct if you rely on 
that to generate the number. 

On Saturday, February 22, 2020 17:33 EST, Felmon Davis  wrote:
 great help!

through some trickery with 'manual breaks' and 'page styles' I have
almost everything in shape.

however -

imagine you have ten consecutive pages all without footer and
unnumbered except for pages 3, 5 and 7; on those pages you want a
footer and you want a roman numeral, for instance ix on page 3, xi on
page 5 and xiii on page 7.

inserting a number generates the same numeral on each page.

ah, I guess the trick is to do a different page style for 3, 5 and 7.

need a break; will pursue this strategy later unless there's a better
idea.

f.

--
Felmon Davis

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


 

Re: more field fun.

[Felmon Davis]

On Sat, 22 Feb 2020, Andrew Pitonyak wrote:



I do not have time to look deeply into this, but, I do believe that 
you can have differnet behavior for left / right pages for a page 
style. I think they talk about it here: 


https://wiki.openoffice.org/wiki/Documentation/FAQ/Writer/FormattingPagesAndDocuments/How_do_I_make_page_numbers_alternate%3F


I will have a look later but note the pages were random, I should have 
used a different set of numbers, page 2, page 5 and page 10 say.


I do notice, however, tha tyou say "page 3" is numbered as xi (11), 
so you would need to make sure that the real page number is correct 
if you rely on that to generate the number. 


it's the automatic generation of a number I need to avoid. I need to 
insert the numbers somehow by hand.


f.



On Saturday, February 22, 2020 17:33 EST, Felmon Davis  wrote:
 great help!

through some trickery with 'manual breaks' and 'page styles' I have
almost everything in shape.

however -

imagine you have ten consecutive pages all without footer and
unnumbered except for pages 3, 5 and 7; on those pages you want a
footer and you want a roman numeral, for instance ix on page 3, xi on
page 5 and xiii on page 7.

inserting a number generates the same numeral on each page.

ah, I guess the trick is to do a different page style for 3, 5 and 7.

need a break; will pursue this strategy later unless there's a better
idea.

f.

--
Felmon Davis

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


 



--
Felmon Davis

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

Re: cannot insert fields [SOLVED]

[Felmon Davis]

On Sat, 22 Feb 2020, Brian Barker wrote:


At 14:33 22/02/2020 -0500, Felmon Davis wrote:
I'm trying to help someone out on formatting their document; they posted 
earlier to the list.


Is this Teresa Brown?


yes.

now deleting some text to get to your solutions; the second solution 
worked! you wrote:


The grey area is the required field, of course. So you have the field but it 
is failing to display the required value. You could confirm this by toggling 
the display to field names at View | Field Names (or Ctrl+F9).


yeah, I found that this is true: the field names appear.


Method I:
o Go to Insert | Manual Break... .
o In the Insert Break dialogue, select "Page break".
o Select an appropriate style (even if it does not change).
o Select "Change page number" and choose the starting page number.

Method II:
o Either select the relevant field or position the cursor just to the left of 
it.

o Go to Edit | Fields... (or right-click | Fields...).
o For Page numbers, set a suitable value for Offset.


Method I had no effect but but Method II did the job!

Now Method I seems to work for me, but Method II not always. In particular, 
if the page number is greater than the actual number of pages in the document 
it will not display. And negative page numbers will not display. In those 
cases the field will show as a grey bock but with no number - exactly what 
you describe.


I'm not sure about page count, but I suspect the problem is similar.


it worked for page count also.


I trust this helps.


very much so! thank you!

but we are not out of the woods yet. page count for arabic numerals is 
to start at page 17, ok fine.


however now the preceding pages have numbers. I will have to remove 
them. maybe sections will work or page styles; there are no section 
now.


in addition some of them will a (one) roman numeral, non-consecutive, 
the rest will be unnumbered, I'll finesse that by just typing in the 
numerals.


will see how it goes but may be back for more advice.

f.

--
Felmon Davis

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

Re: cannot insert fields

[Rory O'Farrell]

On Sat, 22 Feb 2020 16:11:36 -0500 (EST)
Felmon Davis  wrote:

> On Sat, 22 Feb 2020, Rory O'Farrell wrote:
> 
> > On Sat, 22 Feb 2020 14:33:46 -0500 (EST)
> > Felmon Davis  wrote:
> >
> >> greetings!
> >>
> >> I'm trying to help someone out on formatting their document; they
> >> posted earlier to the list.
> >>
> >> it's the strangest thing. any attempt to insert 'page number' or 'page
> >> count' yields a blank space.
> >>
> >> well, not completely blank. there is some kind of char but it appears
> >> only as a grey area.
> >>
> >> I have tried changing fonts and I also have made a template of the doc
> >> and then generated a new one. no change. I have changed the language
> >> from Canadian English to American.
> >>
> >> the other major fields such as 'date' and so on work.
> >>
> >> I would guess some kind of corruption somewhere but maybe someone has
> >> a better notion. I'd hate to have to reconstruct the document from
> >> ground up. I'm willing to fool around with xml or whatever if needed.
> >>
> >> I'm on OpenOffice 4.1.6.
> >>
> >> f.
> >>
> >> --
> >> Felmon Davis
> >>
> >
> > Do the other fields appear on a grey background?  If so, this is 
> > non-printing, but can be suppressed by toggling /View /Field 
> > Shadings.  If you turn on /View /Field names, does the page number 
> > field show "Page Numbers"?
> 
> this worked but you may have seen my reply to Brian Barker; one of his 
> methods solved the present problem.
> 
> > If you turn on the Stylist (F11), and enable "All Styles" in the 
> > dropdown on Stylist's bottom bar, are there many styles WW... and 
> > Convert..., which indicate that the file has been Saved in MS 
> > document formats and or edited by MS Word.
> 
> just btw this is all OpenOffice, no touch of Word.
> 
> f.

Files which have been saved in MS Word formats, or edited by MS Word, can show 
peculiarities when brought back to OpenOffice; that is why I asked.  For help 
with pagenumbering read
https://forum.openoffice.org/en/forum/viewtopic.php?f=71=1221

Use the methods set out in that Tutorial to restart numbering after a Page 
Style change; do not use Page Offset.

-- 
Rory O'Farrell 

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

Re: cannot insert fields

[Felmon Davis]

On Sat, 22 Feb 2020, Rory O'Farrell wrote:


On Sat, 22 Feb 2020 16:11:36 -0500 (EST)
Felmon Davis  wrote:

[...]


just btw this is all OpenOffice, no touch of Word.

f.


Files which have been saved in MS Word formats, or edited by MS 
Word, can show peculiarities when brought back to OpenOffice; that 
is why I asked.


right, I have experienced this.

For help with pagenumbering read 
https://forum.openoffice.org/en/forum/viewtopic.php?f=71=1221


Use the methods set out in that Tutorial to restart numbering after 
a Page Style change; do not use Page Offset.


good reference!

--
Felmon Davis

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

Re: more field fun.

[Felmon Davis]

On Sun, 23 Feb 2020, Brian Barker wrote:


At 17:33 22/02/2020 -0500, Felmon Davis wrote:
imagine you have ten consecutive pages all without footer and unnumbered 
except for pages 3, 5 and 7; on those pages you want a footer and you want 
a roman numeral, for instance ix on page 3, xi on page 5 and xiii on page 
7. inserting a number generates the same numeral on each page. ah, I guess 
the trick is to do a different page style for 3, 5 and 7.


The usefulness of automatic page numbering, of course, is that you can modify 
the text or layout of the document with the page numbers being preserved and 
updating appropriately and not being displaced. If you need such a random 
collection of numbers and the document is at a late stage of preparation - 
when changes to the text are less likely - it may be simpler just to position 
manual page numbers where the footer would be, without having any footer.


If you need a footer for other information on such pages but want page 
numbers only on some, you can still do this. Create a Frame to contain the 
required page number (it doesn't need to have any border) and ensure that it 
is anchored To Page. Position the frame in the footer where is needs to 
appear. Because it is anchored to the page, not to anything within the 
footer, it will not be repeated within the footer on other pages.


The second technique is also more robust to changes in paper size, margins, 
and so on, as well as to font substitution on a foreign system.


I trust this helps.


very much so! I will try out some of this when I return to the task 
tonight or tomorrow. I think I favor the 'frame' approach, basically 
just sort of 'paint' the footer in. these numerals do not need to be 
automatically updated; quite the contrary, they must be static.


(perhaps I should ask them why. maybe there's a better way to achieve 
their goals but I don't have time to dig too deep.)


again, thank you. I'll report back.

f.

--
Felmon Davis

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

Re: more field fun.

[Brian Barker]

At 17:33 22/02/2020 -0500, Felmon Davis wrote:
imagine you have ten consecutive pages all without footer and 
unnumbered except for pages 3, 5 and 7; on those pages you want a 
footer and you want a roman numeral, for instance ix on page 3, xi 
on page 5 and xiii on page 7. inserting a number generates the same 
numeral on each page. ah, I guess the trick is to do a different 
page style for 3, 5 and 7.


The usefulness of automatic page numbering, of course, is that you 
can modify the text or layout of the document with the page numbers 
being preserved and updating appropriately and not being displaced. 
If you need such a random collection of numbers and the document is 
at a late stage of preparation - when changes to the text are less 
likely - it may be simpler just to position manual page numbers where 
the footer would be, without having any footer.


If you need a footer for other information on such pages but want 
page numbers only on some, you can still do this. Create a Frame to 
contain the required page number (it doesn't need to have any border) 
and ensure that it is anchored To Page. Position the frame in the 
footer where is needs to appear. Because it is anchored to the page, 
not to anything within the footer, it will not be repeated within the 
footer on other pages.


The second technique is also more robust to changes in paper size, 
margins, and so on, as well as to font substitution on a foreign system.


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