[libreoffice-users] Limit or stop scrolling

[Gary Collins]

HiIs it possible to limit, or stop altogether,  the automatic scrolling, 
usually nigh on uncontrollable, that happens when content is dragged from one 
document window to another? I dont think this problem is specific to LO but its 
probably most frustrating with LO and someone here may well have the answer. 
ThanksGaryLO 6.0.7.3Ubuntu 18.0.4
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Multiple references to footnote?

[Gary Collins]

HiI have a document in writer in whicj itvwould be helpful to refer to the same 
footnote from different parts of the text (to avoid multiple copies of the 
footnote) but i cant seem to find how to do it. Is it even possible?Lo 
6.0.7.3Ubuntu 0.18.04.8ThanksGary
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Cant add tabs in writer

[Gary Collins]

Update: ive found that i can add tabs if i double click the ruler which brings 
up the paragraph menu, but these tabs dont show up on the ruler and so cant be 
moved by dragging, which is not very satisfactory. What's going on here? How 
can i restore normal ruler begaviour with tabs?Gary
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Cant add tabs in writer

[Gary Collins]

HiIm editing a document in writer and i cant seem to add any tabs to a 
paragraph. The ruler bar at the top seems to be greyed out and editing the 
paragraph style doesnt seem to work either. I dont normally have this problem - 
what have i done?GaryLo 6.0.7.3 ubuntu 18.04.8
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Diacritics with macron

[Gary Collins]

 Hi Im writing a document including classical Greek and im having trouble 
finding how to get some of the diacritics with macron. Most accented charshave 
their own unicode but macron with accent etc requires combined diacritics. Ive 
found out how to get acute / grave accent with macron by combining macron 
character with u+0x301 / u+0x300 respectively but i cant locate unicode to 
combine breathings with macron, or combined  breathing and accent with macron. 
Can anyone help me out? Im using lo 6.0.7.3 with ubuntu 18.04.8.ThanksGary
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] calc table reduce to list?

[Gary Collins]

Hi 
I have a table m×n in calc that i would like to reduce to a single column with 
col. B's data below column A's, column C below that and so forth. Is it 
possible to do this automatically or do i have to do it "by hand?"

Thanks
Gary

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] A tab bar would be highly useful.

[Gary Collins]

I disagree. I often like to view documents simultaneously and it would be a 
real pain to have to keep tabbing between them. So if suck a feature is on the 
cards i would very strongly suggest that it be made optional (as is the case 
e.g. with gimp).
Best
Gary

On Fri, 22/2/19, Owen-Kaelan  wrote:

 Subject: [libreoffice-users] A tab bar would be highly useful.
 To: users@global.libreoffice.org
 Date: Friday, 22 February, 2019, 2:44
 
 So, the previous version of LibreOffice had
 tabs, allegedly only because I
 run it on a Mac. Well, in the new
 version, the tabs are gone! Woe! I'd like
 to see them again! It was very useful
 to be able to switch from document to
 document by clicking on a tab, rather
 than having all of the documents in
 separate windows.
 
 Is it possible to implement this
 feature in a future instance of
 LibreOffice?
 
 Thanks.
 
    Owen Kaelan.
 
 
 
 --
 Sent from: 
http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html
 
 -- 
 To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
 Problems? 
https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
 List archive: https://listarchives.libreoffice.org/global/users/
 Privacy Policy: https://www.documentfoundation.org/privacy
 
 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] spaces inserted or not when pasting

[Gary Collins]

Hi,
Im having difficulty understanding how writer handles soaces when 
copying/pasting. Sometimes i can select a word by mouse click, when no spaces 
are in the selection, but on pasting a space - leading ivthink but maybe its 
trailing- is also inserted. Yet if the same word is selected in the same way 
and deleted,a space is not deleted with it -which would be useful ss it would 
avoid introduction of double spaces in the document. Other times i make a 
selection which includes a leading  or trailing space, but this space is 
stripped on pasting. 
Im still using an oldish version: 5.2.2.2 on ubuntu ;
But it would be good if someone could either confirm that this was an issue 
that has been fixed in a later version; or explain why, and under what 
circumstances, spaces are included / added to / removed from a selection on the 
clipboard, as its mystifying and often irritating to me.
Thanks,
Gary

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] lo writer image in table border issue

[Gary Collins]

Hi Robert
Thanks for reply. Yes,,that's solved it! 
I guess what looks like an empty cell isnt really empty but it must contain an 
automatic newline character.
Thanks, 
 /G.

On Sun, 2/12/18, Robert Großkopf  wrote:

 Subject: Re: [libreoffice-users] lo writer image in table border issue
 To: users@global.libreoffice.org
 Date: Sunday, 2 December, 2018, 18:25
 
 Hi Gary,
 
 the image has "Anchor > To
 Paragraph". There will no possibility for the
 following text to wrap around the image.
 Mark the image with right mousebutton, open the
 kontextmenu and look for
 "Anchor >
 As Character".
 
 Regards
 
 Robert
 -- 
 Homepage: http://robert.familiegrosskopf.de
 LibreOffice Community: http://robert.familiegrosskopf.de/map_3
 
 
 -- 
 To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
 Problems? 
https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
 List archive: https://listarchives.libreoffice.org/global/users/
 Privacy Policy: https://www.documentfoundation.org/privacy
 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] lo writer image in table border issue

[Gary Collins]

Hi
Ive discovered that a great way to position an image in writer is to drag it 
into an empty table cell. There's only onevthing i' m not liking and that is, 
writer seems always to add a 'border' underneath the image. This is NOT spacing 
to contents, which is 0, nor is it down to the image dimensions as it seems to 
be a constant height for various images. What i'd like is a way to make the 
lower border of the cell coincide at least more or less with the bottom of the 
image. If i try to do this by dragging the border up to the bottom of the image 
it jumps back down when i release the mouse button. Is there a way to achieve 
this?
Lo 5.2.2.2 0ubuntu 2.1. 
If its possible in a later version but not in mine i'd be interested to know 
that too.
Thanks
 /Gary

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] lo writer image in table border issue

[Gary Collins]

Hi
Ive discovered that a great way to position an image in writer is to drag it 
into an empty table cell. There's only onevthing i' m not liking and that is, 
writer seems always to add a 'border' underneath the image. This is NOT spacing 
to contents, which is 0, nor is it down to the image dimensions as it seems to 
be a constant height for various images. What i'd like is a way to make the 
lower border of the cell coincide at least more or less with the bottom of the 
image. If i try to do this by dragging the border up to the bottom of the image 
it jumps back down when i release the mouse button. Is there a way to achieve 
this?
Lo 5.2.2.2 0ubuntu 2.1. 
If its possible in a later version but not in mine i'd be interested to know 
that too.
Thanks
 /Gary

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] lo writer image in table border issue

[Gary Collins]

Hi
Ive discovered that a great way to position an image in writer is to drag it 
into an empty table cell. There's only onevthing i' m not liking and that is, 
writer seems always to add a 'border' underneath the image. This is NOT spacing 
to contents, which is 0, nor is it down to the image dimensions as it seems to 
be a constant height for various images. What i'd like is a way to make the 
lower border of the cell coincide at least more or less with the bottom of the 
image. If i try to do this by dragging the border up to the bottom of the image 
it jumps back down when i release the mouse button. Is there a way to achieve 
this?
Lo 5.2.2.2 0ubuntu 2.1. 
If its possible in a later version but not in mine i'd be interested to know 
that too.
Thanks
 /Gary

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] writer autocomplete

[Gary Collins]

Hi
Is there a way to restrict the suggestions offered by autocomplete to words in 
the current document? Or a way of clearing all entries to start over? It can be 
a bit inconvenient when spelling mistakes are offered, and especially if they 
are not in the current document as then search and replace can't be used (or 
can it??)
Thanks
 /Gary

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] calc functionality question

[Gary Collins]

Hi
Ive just been using calc, i had a few cells in a column selected intending to 
fill down but unintentionally did something else, dragging somehow with the 
mouse as if moving the cells vertically. The text in the cells did not move, 
instead it vanished and i was left with a bold double outline around the cells 
that would have been the destination if the drag had moved the cell contents. 
Ctrl-z restored  the cell contents in their original position, but the heavy 
black outline temained around the 'destination' cells and did not disappear 
even when selecting a completely different cell. It remains even after i 
perform the fill down with the cells that i had originally intended.
I have a number of related questions:
a) what does this heavy outline signify, what is its purpose? It doesnt seem to 
be involved with input in any way as it remains when a new cell is selected and 
that new cell appears to have the focus as normal.
b) what did i do to get it - if i acctually want this at some future date, how 
do i go about getting it?
c) how do i cancel it, and get rid of the heavy outline?

Im using 1:5.2.2-0ubuntu2.1 (which i realise is a bit old but updating will 
have to wait until i have internet access on my computer to upgrade)

Thanks
/Gary

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] paste from calc to writer table

[Gary Collins]

Hi
What i'd like to do now is select part of a row of cells in calc and copy the 
contents to  a corresponding part of a row of cells in a writer table. Can i do 
this?
It seems paste (= paste calc) inserts a text box, paste unformatted inserts all 
the format marks as characters, paste rtf enters all the text into every 
selected writer cell.
Build 1;5.2.2-0ubuntu2.1

Thanks
Gary

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] insert before table at start of doc

[Gary Collins]

Yes this works in my version as well. I cant understand how i didnt find this 
before. I guess i assumed that the first cell wouldnt behave any differently 
from the other cells. Goes to show how wrong it is to assume 
Thanks,
/G.

On Fri, 28/9/18, Regina Henschel  wrote:

 Subject: Re: [libreoffice-users] insert before table at start of doc
 To: users@global.libreoffice.org
 Date: Friday, 28 September, 2018, 19:29
 
 Hi Robert,
 
 Robert Funnell schrieb am 28-Sep-18 um
 14:53:
 > On Fri, 28 Sep 2018, Regina
 Henschel wrote:
 >>
 >> Set cursor at the start of top left
 cell. Press Alt+Enter.
 >
 > Why not just press Enter? I just tried it
 in LO 6.0.4.2 and it wasn't
 >
 necessary to use Alt.
 
 You
 are right. For tables Enter is enough. You need Alt+Enter
 for sections.
 
 Kind
 regards
 Regina
 
 -- 
 To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
 Problems? 
https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
 List archive: https://listarchives.libreoffice.org/global/users/
 Privacy Policy: https://www.documentfoundation.org/privacy
 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] table spacing default?

[Gary Collins]

Thanks for reply, i'll look into that. The tables i am using dont all have the 
same dimensions, it's only the spacing below that is (nearly always) the same, 
to adequately space the following text from the bottom of the table. I can 
always add an extra row at the bottom since my tables are borderless; but if 
they weren't this wouldn't be possible. With other rows i can change row height 
to alter the spacing but this won't work on the bottom row.
/G.

On Fri, 28/9/18, Regina Henschel  wrote:

 Subject: Re: [libreoffice-users] table spacing default?
 To: users@global.libreoffice.org
 Date: Friday, 28 September, 2018, 12:30
 
 Hi Gary,
 
 Gary
 Collins schrieb am 27-Sep-18 um 12:56:
 >
 Hi
 > For nearly all my tables i set the
 spacing below the table to 0.5 cm. It would be nice if i
 could have this as a default rather than have to set it
 individually for each new table, but i haven't found a
 way to do this. Is it possible?
 
 I think, it is not possible.
 
 If you use the same kind of
 table often, then you should try to use a 
 workflow with table as AutoText.
 
 Kind regards
 Regina
 
 -- 
 To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
 Problems? 
https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
 List archive: https://listarchives.libreoffice.org/global/users/
 Privacy Policy: https://www.documentfoundation.org/privacy
 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] insert before table at start of doc

[Gary Collins]

Thanks for reply, that's perfect
/G.

On Fri, 28/9/18, Regina Henschel  wrote:

 Subject: Re: [libreoffice-users] insert before table at start of doc
 To: users@global.libreoffice.org
 Date: Friday, 28 September, 2018, 12:00
 
 hi Gary,
 
 Gary
 Collins schrieb am 28-Sep-18 um 10:41:
 >
 Hi
 > If i have a writer doc with a table
 inserted right at the start before any text, but later i
 want to insert some lines of text before that table, ive
 found i can do this by converting the table to text,
 inserting the lines and then converting the text back to
 table; but is there a less tiresome way?
 
 Set cursor at the start of top
 left cell. Press Alt+Enter.
 
 Kind regards
 Regina
 
 
 -- 
 To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
 Problems? 
https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
 List archive: https://listarchives.libreoffice.org/global/users/
 Privacy Policy: https://www.documentfoundation.org/privacy
 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] insert unicode char in writer

[Gary Collins]

Thanks for reply,  alt+X is exactly what i need. The font in question 
(liberation sans/serif) as i say  *does* have the characters but i still cant 
seem to get them in the special chars dialog.
Thanks
/G.

On Fri, 28/9/18, Regina Henschel  wrote:

 Subject: Re: [libreoffice-users] insert unicode char in writer
 To: users@global.libreoffice.org
 Date: Friday, 28 September, 2018, 11:52
 
 Hi Gary,
 
 Gary Collins schrieb am 28-Sep-18 um 11:51:
 > Hi
 > I would like to be
 able to insert some unicode characters into writer doc but
 cant find a way to do this directly.
 
 Type U+0161 and then press Alt+X, for example.
 Alt+X is a toggle. You 
 can use it also to
 look, which code a character has.
 
 Insert special char doesnt seem to be able to
 find the chars i want, but 
 maybe i'm
 not doing something right.
 
 The special character dialog works, but you
 need to know which font has 
 a glyph for the
 character. Otherwise the character will not be shown in 
 the selection pane.
 
   I have
 a workaround using calc; i can enter the hex codes as text
 (row 
 1) and (row 2) use a formula
 =UNICHAR(HEX2DEC(A1)) filled acrosd 
 adjacent column and finally copy row 2 and
 paste as unformatted text 
 into writer. This
 works but is rather longwinded to say the least. It 
 does show that its not a problem with the font
 or with writer's ability 
 to display the
 required chars; its just that i'd like a way to enter
 
 them directly into the writer documext.
 > The chars in question were hex A723, A725,
 1E25, 1E2B, 1E96, 0161 (this one i *could* use insert
 special char), 1E6F, 1E0F.
 > Build
 1:5.2.2-0ubuntu2.1
 
 Have you looked, whether Ubuntu has a direct
 input method? On Windows it 
 is possible to
 use the numpad for direct input, although I prefer the 
 U+hexnumber method of LibreOffice.
 
 Kind regards
 Regina
 
 -- 
 To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
 Problems? 
https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
 List archive: https://listarchives.libreoffice.org/global/users/
 Privacy Policy: https://www.documentfoundation.org/privacy
 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] insert unicode char in writer

[Gary Collins]

Hi
I would like to be able to insert some unicode characters into writer doc but 
cant find a way to do this directly. Insert special char doesnt seem to be able 
to find the chars i want, but maybe i'm not doing something right. I have a 
workaround using calc; i can enter the hex codes as text (row 1) and (row 2) 
use a formula =UNICHAR(HEX2DEC(A1)) filled acrosd adjacent column and finally 
copy row 2 and paste as unformatted text into writer. This works but is rather 
longwinded to say the least. It does show that its not a problem with the font 
or with writer's ability to display the required chars; its just that i'd like 
a way to enter them directly into the writer documext.
The chars in question were hex A723, A725, 1E25, 1E2B, 1E96, 0161 (this one i 
*could* use insert special char), 1E6F, 1E0F.
Build 1:5.2.2-0ubuntu2.1

Thanks
/Gary

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] insert before table at start of doc

[Gary Collins]

Hi
If i have a writer doc with a table inserted right at the start before any 
text, but later i want to insert some lines of text before that table, ive 
found i can do this by converting the table to text, inserting the lines and 
then converting the text back to table; but is there a less tiresome way? Can i 
for example somehow just move the table down, or set the insert point before 
the table, or cut and paste the table itself? (it seems that the cut operation 
leaves an empty table behind, although subsequent  paste *will* paste a new 
table and not just the cut table data).
Thanks
/Gary

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] table spacing default?

[Gary Collins]

Hi
For nearly all my tables i set the spacing below the table to 0.5 cm. It would 
be nice if i could have this as a default rather than have to set it 
individually for each new table, but i haven't found a way to do this. Is it 
possible?
Thanks
/Gary

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] side by side tables

[Gary Collins]

Thanks for reply; i have indeed used cell mreging to achieve tewuired 
formatting, but as for sections, that's given me something new to play around 
with.

On Wed, 26/9/18, Brian Barker  wrote:

 Subject: [libreoffice-users] side by side tables
 To: users@global.libreoffice.org
 Cc: "Gary Collins" 
 Date: Wednesday, 26 September, 2018, 14:50
 
 At 05:42 26/09/2018 +0000, Gary Collins
 wrote:
 >Ive found out how to resize tables
 so they don't take up the full 
 >page width (though to be honest i
 usually find it easier and more 
 >flexible to simply include an
 additional empty column to right and 
 >left and adjust widths as required)
 but what i would really like to 
 >be able to do is to have two (or
 perhaps more) tables juxtaposed 
 >horizontally. Is there a way to
 align tables horizontally (without 
 >resorting to frames, which i tend
 to find are a right pain in the proverbials)?
 
 Yup.
 o Insert a Section.
 o In the section, choose the
 appropriate number of columns. This 
 applies with your section only, not the
 whole page or document.
 o Insert your table in the first
 section.
 o Insert a column break in order to
 move the insertion point to the 
 next column.
 o Insert your second table.
 o Etc.
 
 At 05:47 26/09/2018 +, Gary Collins
 wrote:
 >PS to previous post
 >I know i could do this by having
 one "giant" table and just leaving 
 >some empty columns &/or rows
 but it would be more flexible to have 
 >two tables as then they could for
 example have different row heights 
 >if necessary.
 
 You can achieve some of this by
 judicial merging of table cells - in 
 this case cells within the one column
 of the table but not others, or 
 differently in different columns.
 
 I trust this helps.
 
 Brian Barker
 
 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] table spacing

[Gary Collins]

Hi,
I can now answer my own question about spacing to contents in a writer table. 
Ive found 2 ways to achieve this. One is to use a custom number format, which 
has to be done on an individual cell basis; the other is to update the style 
applied to the table contents, this will affect the whole table, or of course a 
separate style could be used where required, this would be back to a per-cell 
basis
G.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] tables: spacing

[Gary Collins]

Hi,
I have a writer table in which one column contains numbers and the next 
contains text. The numbers are of course aligned right and the text aligned 
left; but they run into each other. Is there a way to adjust spacing to 
contents (as in calc) or do i have to introduce an empty column between them ( 
possible, as my table is borderless).
Build 1:5.2.2-0ubuntu2.1
Thanks
Gary

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] strange problem with text flow

[Gary Collins]

Hi
Ive got a strange problem which i havent encountered before. Im in writer and 
have cut and pasted some text from one doc to another. The problem is that a 
page break has appeared between two of the pasted lines which wasnt in the 
original document and which i cant remove by positioning the cursor and hiting 
delete. There is plenty of space on the page in the target doc for the pasted 
text. The problem appears to be in the target document as if i undo the paste 
and just type some text and hit enter, i get a page break before the new line 
(and no, the ctrl key hasnt got jammed down).
Any ideas what might cause this?
Thanks
/Gary
 
 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] strange problem with text flow

[Gary Collins]

Hi
Ive got a strange problem which i havent encountered before. Im in writer and 
have cut and pasted some text from one doc to another. The problem is that a 
page break has appeared between two of the pasted lines which wasnt in the 
original document and which i cant remove by positioning the cursor and hiting 
delete. There is plenty of space on the page in the target doc for the pasted 
text. The problem appears to be in the target document as if i undo the paste 
and just type some text and hit enter, i get a page break before the new line 
(and no, the ctrl key hasnt got jammed down).
Any ideas what might cause this?
Thanks
/Gary
 
 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] side by side tables

[Gary Collins]

PS to previous post
I know i could do this by having one "giant" table and just leaving some empty 
columns &/or rows but it would be more flexible to have two tables as then they 
could for example have different row heights if necessary.
Thanks
G.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] side by side tables

[Gary Collins]

Hi
Ive found out how to resize tables so they dont take up the full page width 
(though to be honest i usually find it easier and more flexible to simply 
include an additional  empty column to right and left and adjust widths as 
required) but what i would really like to be able to do is to have two (or 
perhaps more) tables juxtaposed horizontally. Is there a way to align tables 
horizontally (without resorting to frames, which i tend to find are a right 
pain in the proverbials)? 
Im currently using version 5.2.2.2 build 1:5.2.2-0ubuntu2.1
Thanks
Gary

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Autocomplete can be but...

[Gary Collins]

I often find autocomplete extremely useful so i don't like to turn it off; but 
it comes complete with its own set of frustrations. I don' t know if developers 
read this list so this could well fall onto stoney ground, but IMO - and i 
stress that, IMO - it would be nice if:
1) LO  could make a distinction between backspace and delete. It is often 
inconvenient if, when typing but not looking at the screen, and realising i 
have entered a wrong character, to press backspace, enter the character i 
should have entered, continue typing, and some time later to spot that the 
backspace hasn't worked because it merely cancelled autotype suggestion. I 
would suggest that rejecting autotype should be seen as a delete forward 
operation (after all, the characters in the suggestion have not been typed yet) 
and so delete key should work as it does; but backspace should actually work as 
it would without autocomplete and should delete the last character typed (as 
well as cancelling the autotype).

2) Hitting enter did NOT accept the autotype, but some other  key or 
combination of keys was necessary to accept the suggestion;  It is just too 
easy when entering text to forget to press delete and so end up with a word you 
didn't intend, again especially when not looking at the screen, in which case 
you wouldn't be aware that autocomplete had kicked in. I'm not sure *what* 
exactly i would suggest for this, but it should be something that is not 
regularly used to terminate a word or a line to explicitly accept the 
suggestion (maybe shift-space??) Having enter accept the suggestion is 
particularly tedious when entering text in calc, as it advances to the next 
cell and you then have to double click to 'correct' the text.

Just some thoughts, that maybe will set someone else thinking.

Gary

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] autocomplete of selection

[Gary Collins]

Hi,
I've noticed that LO has a nasty tendency to try to second-guess what i want 
(almost always incorrectly) when trying to select text,  automatically 
extending my carefully selected start/end point to the beginning/end of a word. 
Is there a way to turn off this "festure"? It's extremely irritating. If it's 
significant, ive got lo 5.2.2.2 under ubuntu.
Thanks,
Gary

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Accessing cells in macro

[Gary Collins]

I am resending this as i didnt get it in my inbox and havent seen any replies 
so i assume it didnt get through the first time. 
G.

On Sat, 25/11/17, Gary Collins <gcatl...@yahoo.co.uk> wrote:

 Subject: Accessing cells in macro
 To: "users@global.libreoffice.org" <users@global.libreoffice.org>
 Date: Saturday, 25 November, 2017, 12:10
 
 Hi,I
 have a column in calc which contains strings of characters
 (actually representations of words in an ancient script) and
 in another column I will need to create a cipher for those
 words (in which each of the characters in a string is mapped
 to a specific different character) so that I can sort the
 rows into the customary "alphabetical" order for
 the script. I can write a macro to do this, but in order to
 do so I need to know how to access specific cells and cell
 ranges in the spreadsheet, and I'm not sure how to do
 this in calc (I've done it in excel, so the procedure
 should be similar). Can anyone help me out here, perhaps
 pointing me to some appropriate code snippets that address
 the issue?
 thanks,/Gary
 
 
 
 
 
 
  
 
   
  
 
 

 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Accessing cells in macro

[Gary Collins]

Hi,I have a column in calc which contains strings of characters (actually 
representations of words in an ancient script) and in another column I will 
need to create a cipher for those words (in which each of the characters in a 
string is mapped to a specific different character) so that I can sort the rows 
into the customary "alphabetical" order for the script. I can write a macro to 
do this, but in order to do so I need to know how to access specific cells and 
cell ranges in the spreadsheet, and I'm not sure how to do this in calc (I've 
done it in excel, so the procedure should be similar). Can anyone help me out 
here, perhaps pointing me to some appropriate code snippets that address the 
issue?
thanks,/Gary






 



   
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] table from calc to writer?

[Gary Collins]

Thank you, yes, that does seem to do it for now. I could've sworn I'd tried 
that before, but apparently not. Or maybe I was doing something wrong I'll 
play around with it.

/G,
  From: Jean-Baptiste Faure <jbfa...@libreoffice.org>
 To: users@global.libreoffice.org 
 Sent: Friday, 24 November 2017, 18:08
 Subject: Re: [libreoffice-users] table from calc to writer?
   
Bonjour,

Le 24/11/2017 à 15:35, Gary Collins a écrit :
> Hi,my intuition tells me that it ought to be possible to copy a block of 
> cells from calc and paste as (or into) a table in writer; but I haven't been 
> able thus far to do it. Is it possible? I'm using LO 5.2.2.2 on Ubuntu.
> thanks,
> /Gary
> 

Use Paste Special and choose Formatted text [RTF]

Best regards.
JBF

-- 
Seuls des formats ouverts peuvent assurer la pérennité de vos documents.
Disclaimer: my Internet Provider being located in France, each of our
exchanges over Internet will be scanned by French spying services.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


   
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] table from calc to writer?

[Gary Collins]

Hi,my intuition tells me that it ought to be possible to copy a block of cells 
from calc and paste as (or into) a table in writer; but I haven't been able 
thus far to do it. Is it possible? I'm using LO 5.2.2.2 on Ubuntu.
thanks, 
/Gary

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] automatic fractions

[Gary Collins]

Correction. I dont need the double click. But i *do* need to follow the 
fraction with a space before pressing CtrlZ..

G.

On Mon, 30/10/17, Regina Henschel <rb.hensc...@t-online.de> wrote:

 Subject: Re: [libreoffice-users] automatic fractions
 To: "Gary Collins" <gcatl...@yahoo.co.uk>
 Date: Monday, 30 October, 2017, 11:53
 
 Hi Gary,
 
 please do not replay to a single person but to
 the mailing list.
 
 Gary
 Collins schrieb:
 > Thanks for reply. It
 doesnt seem to work ctrlZ in calc 5.2.2.2 ubuntu 16.10
 returns to the cell where the fraction was entered but
 leaves it as a single character
 
 You have to use Ctrl+Z really _immediately_
 after 1/2 was replaced by ½. 
 If you have
 already written further characters or have exit edit mode,
 
 it will not work.
 
 Kind regards
 Regina
 
 >
 > G.
 >
 >
 
 > On Mon, 30/10/17, Regina Henschel <rb.hensc...@t-online.de>
 wrote:
 >
 >  Subject:
 Re: [libreoffice-users] automatic fractions
 >  To: users@global.libreoffice.org
 >  Date: Monday, 30 October, 2017, 11:30
 >
 >  Hi Gary,
 >
 >  Gary
 >  Collins schrieb:
 > 
 > Hi
 >  > Usually its a useful
 thing to have
 >  fractions like 1/2
 converted to a single character but
 > 
 sometimes its better if the characters are kept separate,
 eg
 >  if used along with other fractions
 that dont have a single
 >  character
 representation, eg 5/7.
 >  >
 >  > Is it possible to cancel the
 conversion on
 >  a one-off basis, ie
 without having to alter preferences,
 > 
 conversion tables or whatever?
 >
 >  Yes. Press Ctrl+Z immediately after
 the
 >  conversion happens.
 >
 >  Kind
 >  regards
 >  Regina
 >
 >
 >  --
 >  To
 >  unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
 >  Problems? 
 >https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 >  Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
 >  List archive: https://listarchives.libreoffice.org/global/users/
 >  All messages sent to this list will be
 publicly
 >  archived and cannot be
 deleted
 >
 >
 
 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] automatic fractions

[Gary Collins]

Sorry i thought i had replied to list but it seems i was mistaken. Ive got it 
sussed now, i have to *double click* in the cell and then *add a space* after 
the fraction before pressing ctrlZ (as the fraction was the only text in the 
cell, i didn't think to do either of these). Then it works just as i need it 
to. Thanks for your help.

G.

On Mon, 30/10/17, Regina Henschel <rb.hensc...@t-online.de> wrote:

 Subject: Re: [libreoffice-users] automatic fractions
 To: "Gary Collins" <gcatl...@yahoo.co.uk>
 Date: Monday, 30 October, 2017, 11:53
 
 Hi Gary,
 
 please do not replay to a single person but to
 the mailing list.
 
 Gary
 Collins schrieb:
 > Thanks for reply. It
 doesnt seem to work ctrlZ in calc 5.2.2.2 ubuntu 16.10
 returns to the cell where the fraction was entered but
 leaves it as a single character
 
 You have to use Ctrl+Z really _immediately_
 after 1/2 was replaced by ½. 
 If you have
 already written further characters or have exit edit mode,
 
 it will not work.
 
 Kind regards
 Regina
 
 >
 > G.
 >
 >
 
 > On Mon, 30/10/17, Regina Henschel <rb.hensc...@t-online.de>
 wrote:
 >
 >  Subject:
 Re: [libreoffice-users] automatic fractions
 >  To: users@global.libreoffice.org
 >  Date: Monday, 30 October, 2017, 11:30
 >
 >  Hi Gary,
 >
 >  Gary
 >  Collins schrieb:
 > 
 > Hi
 >  > Usually its a useful
 thing to have
 >  fractions like 1/2
 converted to a single character but
 > 
 sometimes its better if the characters are kept separate,
 eg
 >  if used along with other fractions
 that dont have a single
 >  character
 representation, eg 5/7.
 >  >
 >  > Is it possible to cancel the
 conversion on
 >  a one-off basis, ie
 without having to alter preferences,
 > 
 conversion tables or whatever?
 >
 >  Yes. Press Ctrl+Z immediately after
 the
 >  conversion happens.
 >
 >  Kind
 >  regards
 >  Regina
 >
 >
 >  --
 >  To
 >  unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
 >  Problems? 
 >https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 >  Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
 >  List archive: https://listarchives.libreoffice.org/global/users/
 >  All messages sent to this list will be
 publicly
 >  archived and cannot be
 deleted
 >
 >
 
 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] automatic fractions

[Gary Collins]

Hi
Usually its a useful thing to have fractions like 1/2 converted to a single 
character but sometimes its better if the characters are kept separate, eg if 
used along with other fractions that dont have a single character 
representation, eg 5/7.

Is it possible to cancel the conversion on a one-off basis, ie without having 
to alter preferences, conversion tables or whatever?

Thanks
Gary

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] frames

[Gary Collins]

It seems using teplace doesnt achieve what i want because if the replacement 
image has different proportions from the original it is distorted when it is 
inserted and that is exactly what must NOT happen. I want the height of the 
images to match but the width to vary as necessary to keep the image ratio 
correct.

G.

On Wed, 20/9/17, Brian Barker <b.m.bar...@btinternet.com> wrote:

 Subject: Re: [libreoffice-users] frames
 To: users@global.libreoffice.org
 Cc: "Gary Collins" <gcatl...@yahoo.co.uk>
 Date: Wednesday, 20 September, 2017, 12:42
 
 At 18:29 19/09/2017 +, Gary Collins
 wrote:
 >I have an arrangement of frames on
 a page which i would like to 
 >exactly replicate on all successive
 pages of the document. How do i 
 >go about this?
 
 You can do this - by anchoring the
 frames in a header or footer. Note 
 that the frames themselves do not need
 to be physically at the top or 
 bottom of the page to achieve this:
 they can appear anywhere, as long 
 as the anchors are in the header or
 footer. Unfortunately, this means 
 that the contents of your frames will
 also be identical on each page 
 - which is clearly not what you want.
 
 >As an aside i want to use the
 frames to help arrange a multitude of 
 >smallish images which must be
 aligned in rows and _stay_ that way. I 
 >think this *might* be a fairly good
 way to achieve this but i'm 
 >definitely open to better ideas.
 
 I suspect this problem cries out for
 using a drawing (Draw) document, 
 not a text (Writer) one.
 o Set up a single page with your images
 for that page.
 o Select the page in the Pages panel.
 o Copy.
 o Paste the page - with identical
 images - as necessary.
 o In subsequent pages, select each
 image in turn and use Insert | 
 Picture... to replace it with the image
 you need there. The new image 
 will occupy the same space.
 
 I trust this helps.
 
 Brian Barker
 
 
 -- 
 To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
 Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 List archive: http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be
 publicly archived and cannot be deleted
 
 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] frames

[Gary Collins]

Preliminary experiments show thst this could be just what i need, but im having 
one msjor difficulty. Is it possible to replace an image within s group without 
ungrouping first? I try selecting the image in the group, right click and 
replace - which *seems* to do what i want until i try to move e group. Ths 
shows me thatt what has actually happened is that the replacement image has 
been inserted in the same screen position but is not psrt of the group, it just 
overlays the image in the group, which remains the same. Am i doing something 
wrong? Or does it not work in the way i thought it would?

G.

On Wed, 20/9/17, Brian Barker <b.m.bar...@btinternet.com> wrote:

 Subject: Re: [libreoffice-users] frames
 To: users@global.libreoffice.org
 Cc: "Gary Collins" <gcatl...@yahoo.co.uk>
 Date: Wednesday, 20 September, 2017, 12:42
 
 At 18:29 19/09/2017 +, Gary Collins
 wrote:
 >I have an arrangement of frames on
 a page which i would like to 
 >exactly replicate on all successive
 pages of the document. How do i 
 >go about this?
 
 You can do this - by anchoring the
 frames in a header or footer. Note 
 that the frames themselves do not need
 to be physically at the top or 
 bottom of the page to achieve this:
 they can appear anywhere, as long 
 as the anchors are in the header or
 footer. Unfortunately, this means 
 that the contents of your frames will
 also be identical on each page 
 - which is clearly not what you want.
 
 >As an aside i want to use the
 frames to help arrange a multitude of 
 >smallish images which must be
 aligned in rows and _stay_ that way. I 
 >think this *might* be a fairly good
 way to achieve this but i'm 
 >definitely open to better ideas.
 
 I suspect this problem cries out for
 using a drawing (Draw) document, 
 not a text (Writer) one.
 o Set up a single page with your images
 for that page.
 o Select the page in the Pages panel.
 o Copy.
 o Paste the page - with identical
 images - as necessary.
 o In subsequent pages, select each
 image in turn and use Insert | 
 Picture... to replace it with the image
 you need there. The new image 
 will occupy the same space.
 
 I trust this helps.
 
 Brian Barker
 
 
 -- 
 To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
 Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 List archive: http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be
 publicly archived and cannot be deleted
 
 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] frames

[Gary Collins]

Thanks Brian. I will play with Draw, havent usedit much before, to see if i can 
fairly easily get what i need. Basically for images to be in a 'table' 
formation, with text comments on each row. I want each image to have the same 
height, but the length of comments,and hence possibly the height of each row 
will not necessarily be the same. The ability to easily insert a new row would 
be nice, but probably not essential.

G.

On Wed, 20/9/17, Brian Barker <b.m.bar...@btinternet.com> wrote:

 Subject: Re: [libreoffice-users] frames
 To: users@global.libreoffice.org
 Cc: "Gary Collins" <gcatl...@yahoo.co.uk>
 Date: Wednesday, 20 September, 2017, 12:42
 
 At 18:29 19/09/2017 +, Gary Collins
 wrote:
 >I have an arrangement of frames on
 a page which i would like to 
 >exactly replicate on all successive
 pages of the document. How do i 
 >go about this?
 
 You can do this - by anchoring the
 frames in a header or footer. Note 
 that the frames themselves do not need
 to be physically at the top or 
 bottom of the page to achieve this:
 they can appear anywhere, as long 
 as the anchors are in the header or
 footer. Unfortunately, this means 
 that the contents of your frames will
 also be identical on each page 
 - which is clearly not what you want.
 
 >As an aside i want to use the
 frames to help arrange a multitude of 
 >smallish images which must be
 aligned in rows and _stay_ that way. I 
 >think this *might* be a fairly good
 way to achieve this but i'm 
 >definitely open to better ideas.
 
 I suspect this problem cries out for
 using a drawing (Draw) document, 
 not a text (Writer) one.
 o Set up a single page with your images
 for that page.
 o Select the page in the Pages panel.
 o Copy.
 o Paste the page - with identical
 images - as necessary.
 o In subsequent pages, select each
 image in turn and use Insert | 
 Picture... to replace it with the image
 you need there. The new image 
 will occupy the same space.
 
 I trust this helps.
 
 Brian Barker
 
 
 -- 
 To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
 Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 List archive: http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be
 publicly archived and cannot be deleted
 
 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] frames

[Gary Collins]

LO 5.2.2.2 ubuntu 16.10

Hello
I have an arrangement of frames on a page which i would like to exactly 
replicate on all successive pages of the document. How do i go about this? Ive 
tried saving as a template but a) i dont know if thats right for this and b)  
even if it is i dont knoe how to get it to repest on every new page. Simply 
loading the ott file doesnt seen to do it.

Is it possible to group frames and move/copy them ss a unit? Ive tried shift 
click as per manual and ctrl click and combinations but cant seem to select 
more than one frame at a time. And its S tedious moving individual frames. 
When i try i find the document suddenly scrolls and the frame ends up in the 
wrong place or (more often) disappears completely out of sight and i am forced 
to undo and try again. There simply HAS to be a way to do this without pulling 
all my hair out???

Thanks
Gary

As an aside i want to use the frames to help arrange a multitude of smallish 
images which must be aligned in rows and _ stay_ that way. I think this *might* 
be a fairly good way to achieve this but im definitely open to better ideas.

G.


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] calc macro selected range

[Gary Collins]

Hi
Im writing a macro to replace a number of characters with corresponding 
alternative chars wherever they occur  in strings in a selected cell range. To 
accomplish this im currently calling uno:executeSearch multiple times - once 
for each character that needs to be changed. Problem is, when the first 
character is changed the selected range changes to just those cells that have 
been updated. So what i need is either a way to execute the search and replace 
that leaves the selected range intact OR a way to read the initial selection 
and reset to that selection after search and replace has executed (OR a better 
way to go about this altogether). Can anyone help me out?

Thanks,
Gary

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] calc autofill

[Gary Collins]

Hi
Ive noticed what appears to be an anomaly when using autofill (hope thats the 
right word) in calc 5.2.2.2 in ubuntu 16.10

To illustrate, open a new spreadsheet and enter 1 in A1 and in C1, and "A1" in 
D1 and F1.

Select range A1:F1 and fill down to row 2.

Then A2, C2 contain 2 and D2, F2 contain "A2"; note the strings have been 
"incremented" as well as the numbers.


Undo the fill, hide columns B and E, select range A1:F1 and fill down to row 2.

Now A2, C2 contain 2 as expected but D2, F2 contain "A1"; the strings have not 
been "incremented.

Does anyone else experience this? It seems véry strange to me but perhaps there 
is a good reason for it?

(I have often noted inconsistent behaviour when cells contain strings having 
some digit characters. Personally im not sure that "iincrementing" strings is 
such a good idea anyway. Sometimes it is a help, often i find it a hindrance. 
But in any case it would be good to know if precise behaviour is documented 
somewhere)

Best
Gary

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] calc autofill

[Gary Collins]

Hi
Ive noticed what appears to be an anomaly when using autofill (hope thats the 
right word) in calc 5.2.2.2 in ubuntu 16.10

To illustrate, open a new spreadsheet and enter 1 in A1 and in C1, and "A1" in 
D1 and F1.

Select range A1:F1 and fill down to row 2.

Then A2, C2 contain 2 and D2, F2 contain "A2"; note the strings have been 
"incremented" as well as the numbers.


Undo the fill, hide columns B and E, select range A1:F1 and fill down to row 2.

Now A2, C2 contain 2 as expected but D2, F2 contain "A1"; the strings have not 
been "incremented.

Does anyone else experience this? It seems véry strange to me but perhaps there 
is a good reason for it?

(I have often noted inconsistent behaviour when cells contain strings having 
some digit characters. Personally im not sure that "iincrementing" strings is 
such a good idea anyway. Sometimes it is a help, often i find it a hindrance. 
But in any case it would be good to know if precise behaviour is documented 
somewhere)

Best
Gary

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] cant find main menu in ubuntu window

[Gary Collins]

Hi,
Thanks for the replies. Ive located my problem. As i said i'm new to ubnuntu 
and i hadn't realised that the main menu is "migrated" from the LO window to 
the main ubuntu header bar at the top of the screen. I did spend some time 
installing updates and things so i dont know if  that was also part of the 
solution. As i said ive got quite a bit to learn over the next few weeks 
especially and will have to get used to new ways of doing things.
G.



On Tue, 29/8/17, Tim Lloyd <tim.ll...@gmx.com> wrote:

 Subject: Re: [libreoffice-users] cant find main menu in ubuntu window
 To: users@global.libreoffice.org
 Date: Tuesday, 29 August, 2017, 9:37
 
 Hi,
 
 it looks like you are not on your own. I found
 a link
 
 https://askubuntu.com/questions/219491/why-no-menu-bar-in-libreoffice
 
 There is a suggestion that you
 get updates. I have seen this shown as a 
 solution elsewhere if you feel confident.
 
 HTH
 
 
 On 28/08/17 23:40, Gary Collins wrote:
 > Hi
 > Ive just installed
 ubuntu 16.10 from magazine disc. It comes of course with LO
 bundled  (or parts of it anyhow)
 > But
 ive just found when i wanted to change properties that it
 doesnt have the main menu across the top of the window and i
 cant seem to find it anywhere. This is the first time ive
 used linux, i had to install it as my windows 7 installation
 seems to have broken, so ive got quite a learning curve
 ahead. Can anyone help?
 > Thanks
 > Gary
 >
 
 
 -- 
 To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
 Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 List archive: http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be publicly
 archived and cannot be deleted
 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] cant find main menu in ubuntu 16.10

[Gary Collins]

Hi
Apologies if this is a repeat but it seems something may have gone wrong last 
time i tried to send.

Ive just installed ubuntu 16.10 from magazine disc. It comes of course with LO 
bundled  (or parts of it anyhow)

But ive just found when i wanted to change properties that it doesnt have the 
main menu across the top of the window and i cant seem to find it anywhere. 
This is the first time ive used linux, i had to install it as my windows 7 
installation seems to have broken, so ive got quite a learning curve ahead. Can 
anyone help?

Thanks

Gary


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] cant find main menu in ubuntu window

[Gary Collins]

Hi
Ive just installed ubuntu 16.10 from magazine disc. It comes of course with LO 
bundled  (or parts of it anyhow)
But ive just found when i wanted to change properties that it doesnt have the 
main menu across the top of the window and i cant seem to find it anywhere. 
This is the first time ive used linux, i had to install it as my windows 7 
installation seems to have broken, so ive got quite a learning curve ahead. Can 
anyone help?
Thanks
Gary

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] sort order

[Gary Collins]

Got them! Thank you so much for these, will take me a bit of time to absorb but 
i'm sure they'll be useful.

/Gary


On Mon, 13/3/17, Michael D. Setzer II <mi...@kuentos.guam.net> wrote:

 Subject: Re: [libreoffice-users] sort order
 To: users@global.libreoffice.org, "leleu" <robert.le...@ovh.fr>, "Gary 
Collins" <gcatl...@yahoo.co.uk>
 Date: Monday, 13 March, 2017, 5:00
 
 ftp://fedora9gcc.dyndns.org/gary.zip
 
 Has 3 little spreadsheets.
    8969  03-12-2017
 03:27   FINDCODE.ods
    
 14959  03-12-2017 05:04   casematch.ods
     12025  03-13-2017
 03:38   sortissue.ods
 
 That address some solutions I came up with
 playing with how I understood 
 the issues,
 which might be wrong, but these seem to work as I see it.
 
 Tried pasting the cells, and
 they look fine in the email I sent, but were totally 
 screwed up by the list? Then tried taken a
 screen shot, but those emails 
 never seemed
 to show up, and no message that they were rejected?
 
 Put this file on one of my
 college ftp servers, so if someone takes a look and 
 sees if it works or not, otherwise. I'll
 just stop messing with it. 
 
 
 
 On 12 Mar
 2017 at 18:20, Gary Collins wrote:
 
 Date sent:          Sun, 12 Mar 2017
 18:20:29 + (UTC)
 From:       
    Gary Collins <gcatl...@yahoo.co.uk>
 Send reply to:      Gary Collins <gcatl...@yahoo.co.uk>
 To:             <users@global.libreoffice.org>,
 leleu 
 <robert.le...@ovh.fr>
 Subject:            Re:
 [libreoffice-users] sort order
 
 > Wow, yes, that sounds the sort of thing.
 It would need to be customisable, I'm not sure that the
 sequence used for the transliteration of hieroglyphs would
 necesarily be catered for 
 > Gary
 >
 
 > On Sun, 12/3/17, leleu <robert.le...@ovh.fr>
 wrote:
 > 
 >  Subject:
 Re: [libreoffice-users] sort order
 > 
 To: users@global.libreoffice.org
 >  Date: Sunday, 12 March, 2017, 18:07
 >  
 >  see
 >  https://en.wikipedia.org/wiki/Unicode_collation_algorithm
 >  now the problem is "where is the
 >  "collation algorithm" of calc
 ? An 
 >  algorithm which obviously has
 to change
 >  according to the
 language.
 >  
 > 
 Je la 12/03/2017 18:50, Gary Collins skribis
 >  :
 >  > Thank you,
 yes it does. I got it to
 >  work with
 Greek iota which is about the least obtrusive.
 >  Strangely (to my mind) some less
 obtrusive characters with
 >  higher
 unicode *dont* work. Its a bit of a mystery whats
 >  going on, i can only surmise that there
 is somewhere a table
 >  of
 'blacklisted' characters which are not taken into
 >  account for sorting purposes. This new
 (ish) sort order lark
 >  has been a
 right pain in the proverbials for me, generally
 >  speaking. I'll now just scour the
 table in the hope of
 >  finding
 something even better but at least there is
 >  *something* that'll work
 >  >
 >  >
 Thanks,
 >  > G.
 >  >
 > 
 
 >  > On Sun, 12/3/17, Brian Barker
 <b.m.bar...@btinternet.com>
 >  wrote:
 >  >
 >  >   Subject: Re:
 >  [libreoffice-users] sort order
 >  >   To: users@global.libreoffice.org
 >  >   Date: Sunday, 12 March,
 2017,
 >  5:51
 > 
 >   
 >  >   At 17:58
 11/03/2017 +,
 >  Gary
 >  >   Collins wrote:
 >  >   >I'd like to know if
 >  there is a character, preferably
 >  >   some sort of
 >  >   >discrete punctuation
 >  mark, that will come *after* z in
 >  >   the sort
 >  >   >order when using
 natural
 >  sort. My problem is that i
 have
 >  >   some codes
 >  >   >beginning Aa which
 really
 >  speaking should come after
 Z.
 >  >   As a number
 >  >   >of up to 3 digits
 follows
 >  the letter(s) in each case,
 im
 >  >   getting A#
 >  >   >followed by Aa# then B#
 >  which really wont do. I have to
 >  >   use natural
 >  >   >sort as i need eg A12
 to
 >  come after A3. Ive tried a few
 >  >   punctuation
 >  >   >characters and some
 >  special characters but i cant find
 >  >   one that
 >  >   >works. Any light that
 can
 >  be shed on this would be very
 >  >   welcome
 > 
 >   >indeed. I really dont
 > 
 want to have to precede Aa with a
 > 
 >   z if that
 >  >   >can
 possibly be
 >  avoided.
 >  >   
 > 
 >   These are not punctuation
 > 
 marks, but a bit of
 > 
 >   experimentation
 > 
 >   suggests that any Greek
 > 
 character, upper or lower case, will
 > 
 >   serve.
 >  >   
 >  >   I trust this helps.
 >  >   
 > 
 >   Brian Barker
 >  >  

Re: [libreoffice-users] regular expression for calc

[Gary Collins]

Hi Regina,
Thank you, yes, that's cracked it. (*so* many pitfalls for the unwary!)

Best
Gary

On Sun, 12/3/17, Regina Henschel <rb.hensc...@t-online.de> wrote:

 Subject: Re: [libreoffice-users] regular expression for calc
 To: users@global.libreoffice.org
 Date: Sunday, 12 March, 2017, 17:50
 
 Hi Gary,
 
 find the option "Search
 criteria = and <> must apply to whole cells" in
 
 Tools > Options > Calc >
 Calculate. Try it with disabled option.
 
 Kind regards
 Regina
 
 Gary Collins schrieb:
 > Hi
 Brian
 > I wish i could say it did help
 but unfortunately not. It works with the whole cell contents
 but doesnt seem to pick out a word within the cell. For
 instance, one of my list has contents "X1 G43".
 Now if I have "X1 G43" in the cell Xn (using your
 example) i get count 1 returned which is correct; but if i
 have "X1" in cell Xn it returns 0, which is
 clearly wrong (at least as far as my requirements are
 concerned). And yes, i do have regular expressions enabled
 in Calc >  Calculate. My version is 5.2.2.2 x64 and im
 using 64bit windows 7.
 >
 > G.
 
 
 -- 
 To unsubscribe e-mail to:
 users+unsubscr...@global.libreoffice.org
 Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 List archive: http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be publicly
 archived and cannot be deleted
 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] sort order

[Gary Collins]

Wow, yes, that sounds the sort of thing. It would need to be customisable, I'm 
not sure that the sequence used for the transliteration of hieroglyphs would 
necesarily be catered for 
Gary

On Sun, 12/3/17, leleu <robert.le...@ovh.fr> wrote:

 Subject: Re: [libreoffice-users] sort order
 To: users@global.libreoffice.org
 Date: Sunday, 12 March, 2017, 18:07
 
 see
 https://en.wikipedia.org/wiki/Unicode_collation_algorithm
 now the problem is "where is the
 "collation algorithm" of calc ? An 
 algorithm which obviously has to change
 according to the language.
 
 Je la 12/03/2017 18:50, Gary Collins skribis
 :
 > Thank you, yes it does. I got it to
 work with Greek iota which is about the least obtrusive.
 Strangely (to my mind) some less obtrusive characters with
 higher unicode *dont* work. Its a bit of a mystery whats
 going on, i can only surmise that there is somewhere a table
 of 'blacklisted' characters which are not taken into
 account for sorting purposes. This new (ish) sort order lark
 has been a right pain in the proverbials for me, generally
 speaking. I'll now just scour the table in the hope of
 finding something even better but at least there is
 *something* that'll work
 >
 > Thanks,
 > G.
 >
 
 > On Sun, 12/3/17, Brian Barker <b.m.bar...@btinternet.com>
 wrote:
 >
 >   Subject: Re:
 [libreoffice-users] sort order
 >   To: users@global.libreoffice.org
 >   Date: Sunday, 12 March, 2017,
 5:51
 >   
 >   At 17:58 11/03/2017 +,
 Gary
 >   Collins wrote:
 >   >I'd like to know if
 there is a character, preferably
 >   some sort of
 >   >discrete punctuation
 mark, that will come *after* z in
 >   the sort
 >   >order when using natural
 sort. My problem is that i have
 >   some codes
 >   >beginning Aa which really
 speaking should come after Z.
 >   As a number
 >   >of up to 3 digits follows
 the letter(s) in each case, im
 >   getting A#
 >   >followed by Aa# then B#
 which really wont do. I have to
 >   use natural
 >   >sort as i need eg A12 to
 come after A3. Ive tried a few
 >   punctuation
 >   >characters and some
 special characters but i cant find
 >   one that
 >   >works. Any light that can
 be shed on this would be very
 >   welcome
 >   >indeed. I really dont
 want to have to precede Aa with a
 >   z if that
 >   >can possibly be
 avoided.
 >   
 >   These are not punctuation
 marks, but a bit of
 >   experimentation
 >   suggests that any Greek
 character, upper or lower case, will
 >   serve.
 >   
 >   I trust this helps.
 >   
 >   Brian Barker
 >   
 >   
 >   --
 >   To unsubscribe e-mail to:
 users+unsubscr...@global.libreoffice.org
 >   Problems? 
 >http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 >   Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 >   List archive: http://listarchives.libreoffice.org/global/users/
 >   All messages sent to this
 list will be publicly archived and
 >   cannot be deleted
 >   
 >   
 >
 
 -- 
 To
 unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
 Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 List archive: http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be publicly
 archived and cannot be deleted
 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] sort order

[Gary Collins]

Wow, yes, that sounds the sort of thing. It would need to be customisable, I'm 
not sure that the sequence used for the transliteration of hieroglyphs would 
necesarily be catered for 
Gary

On Sun, 12/3/17, leleu <robert.le...@ovh.fr> wrote:

 Subject: Re: [libreoffice-users] sort order
 To: users@global.libreoffice.org
 Date: Sunday, 12 March, 2017, 18:07
 
 see
 https://en.wikipedia.org/wiki/Unicode_collation_algorithm
 now the problem is "where is the
 "collation algorithm" of calc ? An 
 algorithm which obviously has to change
 according to the language.
 
 Je la 12/03/2017 18:50, Gary Collins skribis
 :
 > Thank you, yes it does. I got it to
 work with Greek iota which is about the least obtrusive.
 Strangely (to my mind) some less obtrusive characters with
 higher unicode *dont* work. Its a bit of a mystery whats
 going on, i can only surmise that there is somewhere a table
 of 'blacklisted' characters which are not taken into
 account for sorting purposes. This new (ish) sort order lark
 has been a right pain in the proverbials for me, generally
 speaking. I'll now just scour the table in the hope of
 finding something even better but at least there is
 *something* that'll work
 >
 > Thanks,
 > G.
 >
 
 > On Sun, 12/3/17, Brian Barker <b.m.bar...@btinternet.com>
 wrote:
 >
 >   Subject: Re:
 [libreoffice-users] sort order
 >   To: users@global.libreoffice.org
 >   Date: Sunday, 12 March, 2017,
 5:51
 >   
 >   At 17:58 11/03/2017 +,
 Gary
 >   Collins wrote:
 >   >I'd like to know if
 there is a character, preferably
 >   some sort of
 >   >discrete punctuation
 mark, that will come *after* z in
 >   the sort
 >   >order when using natural
 sort. My problem is that i have
 >   some codes
 >   >beginning Aa which really
 speaking should come after Z.
 >   As a number
 >   >of up to 3 digits follows
 the letter(s) in each case, im
 >   getting A#
 >   >followed by Aa# then B#
 which really wont do. I have to
 >   use natural
 >   >sort as i need eg A12 to
 come after A3. Ive tried a few
 >   punctuation
 >   >characters and some
 special characters but i cant find
 >   one that
 >   >works. Any light that can
 be shed on this would be very
 >   welcome
 >   >indeed. I really dont
 want to have to precede Aa with a
 >   z if that
 >   >can possibly be
 avoided.
 >   
 >   These are not punctuation
 marks, but a bit of
 >   experimentation
 >   suggests that any Greek
 character, upper or lower case, will
 >   serve.
 >   
 >   I trust this helps.
 >   
 >   Brian Barker
 >   
 >   
 >   --
 >   To unsubscribe e-mail to:
 users+unsubscr...@global.libreoffice.org
 >   Problems? 
 >http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 >   Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 >   List archive: http://listarchives.libreoffice.org/global/users/
 >   All messages sent to this
 list will be publicly archived and
 >   cannot be deleted
 >   
 >   
 >
 
 -- 
 To
 unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
 Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 List archive: http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be publicly
 archived and cannot be deleted
 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] sort order

[Gary Collins]

Got it! I can replace the ''A" in my "Aa" with Greek alpha (or with Russian 
'A') and it works perfectly, with the minor exception that the non English 
characters look as if they have come from a different font. But I can live with 
that, I think it's the best solution possible.

Thanks
Gary

On Sun, 12/3/17, Brian Barker <b.m.bar...@btinternet.com> wrote:

 Subject: Re: [libreoffice-users] sort order
 To: users@global.libreoffice.org
 Date: Sunday, 12 March, 2017, 5:51
 
 At 17:58 11/03/2017 +, Gary
 Collins wrote:
 >I'd like to know if there is a character, preferably
 some sort of 
 >discrete punctuation mark, that will come *after* z in
 the sort 
 >order when using natural sort. My problem is that i have
 some codes 
 >beginning Aa which really speaking should come after Z.
 As a number 
 >of up to 3 digits follows the letter(s) in each case, im
 getting A# 
 >followed by Aa# then B# which really wont do. I have to
 use natural 
 >sort as i need eg A12 to come after A3. Ive tried a few
 punctuation 
 >characters and some special characters but i cant find
 one that 
 >works. Any light that can be shed on this would be very
 welcome 
 >indeed. I really dont want to have to precede Aa with a
 z if that 
 >can possibly be avoided.
 
 These are not punctuation marks, but a bit of
 experimentation 
 suggests that any Greek character, upper or lower case, will
 serve.
 
 I trust this helps.
 
 Brian Barker
 
 
 -- 
 To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
 Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 List archive: http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be publicly archived and
 cannot be deleted
 
 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] sort order

[Gary Collins]

Thank you, yes it does. I got it to work with Greek iota which is about the 
least obtrusive. Strangely (to my mind) some less obtrusive characters with 
higher unicode *dont* work. Its a bit of a mystery whats going on, i can only 
surmise that there is somewhere a table of 'blacklisted' characters which are 
not taken into account for sorting purposes. This new (ish) sort order lark has 
been a right pain in the proverbials for me, generally speaking. I'll now just 
scour the table in the hope of finding something even better but at least there 
is *something* that'll work

Thanks,
G.

On Sun, 12/3/17, Brian Barker <b.m.bar...@btinternet.com> wrote:

 Subject: Re: [libreoffice-users] sort order
 To: users@global.libreoffice.org
 Date: Sunday, 12 March, 2017, 5:51
 
 At 17:58 11/03/2017 +, Gary
 Collins wrote:
 >I'd like to know if there is a character, preferably
 some sort of 
 >discrete punctuation mark, that will come *after* z in
 the sort 
 >order when using natural sort. My problem is that i have
 some codes 
 >beginning Aa which really speaking should come after Z.
 As a number 
 >of up to 3 digits follows the letter(s) in each case, im
 getting A# 
 >followed by Aa# then B# which really wont do. I have to
 use natural 
 >sort as i need eg A12 to come after A3. Ive tried a few
 punctuation 
 >characters and some special characters but i cant find
 one that 
 >works. Any light that can be shed on this would be very
 welcome 
 >indeed. I really dont want to have to precede Aa with a
 z if that 
 >can possibly be avoided.
 
 These are not punctuation marks, but a bit of
 experimentation 
 suggests that any Greek character, upper or lower case, will
 serve.
 
 I trust this helps.
 
 Brian Barker
 
 
 -- 
 To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
 Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 List archive: http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be publicly archived and
 cannot be deleted
 
 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] regular expression for calc

[Gary Collins]

Hi Brian
I wish i could say it did help but unfortunately not. It works with the whole 
cell contents but doesnt seem to pick out a word within the cell. For instance, 
one of my list has contents "X1 G43". Now if I have "X1 G43" in the cell Xn 
(using your example) i get count 1 returned which is correct; but if i have 
"X1" in cell Xn it returns 0, which is clearly wrong (at least as far as my 
requirements are concerned). And yes, i do have regular expressions enabled in 
Calc >  Calculate. My version is 5.2.2.2 x64 and im using 64bit windows 7.

G.

On Sun, 12/3/17, Brian Barker <b.m.bar...@btinternet.com> wrote:

 Subject: Re: [libreoffice-users] regular expression for calc
 To: users@global.libreoffice.org
 Date: Sunday, 12 March, 2017, 5:51
 
 At 15:45 11/03/2017 +, Gary
 Collins wrote:
 >I have a column each row of which contains a sequence of
 one or more 
 >codes separated by a space. In case it will make a
 difference each 
 >code consists of a letter (occasionally 2 letters)
 followed by a 
 >number of up to 3 digits (and occasionally ends with a
 letter) eg X1 
 >Aa12 D7a etc.
 >
 >I want to obtain a regular expression for COUNTIF that
 will enable 
 >me to find out how many times a particular code,
 contained in 
 >another cell, occurs in the column. I was thinking that
 \b to detect 
 >the word boundaries should help but i cant quite get it
 to work; im 
 >not sure if this is because it is assuming a word
 boundary between 
 >the letter and the number or if it is simply my
 incompetence as 
 >usual. Does anyone have an idea what may be the best way
 to achieve this?
 
 Try
 =COUNTIF(range;"\b"&"\b")
 - where "range" represents the column of data and Xn
 represents the 
 cell containing the code to be counted. Remember that you
 need to 
 have Tools | Options... | LibreOffice Calc | Calculate |
 Enable 
 regular expressions in formulae ticked (which is the case by
 default).
 
 I trust this helps.
 
 Brian Barker
 
 
 -- 
 To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
 Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 List archive: http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be publicly archived and
 cannot be deleted
 
 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] vlookup case

[Gary Collins]

Wow! Thanks i'll look into that and maybe try to adapt it.  The strings are of 
variable length from 1 to 3 characters. What i came up with (bypassing VLOOKUP 
altogether) was
=CONCATENATE (MID ($J$2, FIND(LEFT (A2,1), $J $3),1),IFERROR(MID($J$2, FIND 
(MID (A2,2,1), $J $3),1," "),IFERROR (MID ($J $2,FIND (MID (A2,3,1), $J 
$3,1),1," "))

(I think); which takes each character from the string in A2, gets the position 
of that character in the string held in J2, then extracts the corresponding 
character from the string held in J3 and concatenates it to the result. In the 
case of the string being less than 3 characters, MID () will return an error 
which will result in " " concatenated instead. Null string would have been 
better but in my case space works just as well.

Its very cumbersome (and more so because in my actual file the strings J2 and 
J3 are in fact located on a different sheet); but it does what i need and thats 
all i demand of it!

Best
Gary

On Fri, 10/3/17, Michael D. Setzer II <mi...@kuentos.guam.net> wrote:

 Subject: Re: [libreoffice-users] vlookup case
 To: "Gary Collins" <gcatl...@yahoo.co.uk>, users@global.libreoffice.org, 
"Brian Barker" <b.m.bar...@btinternet.com>
 Date: Friday, 10 March, 2017, 11:25
 
 I was doing some testing
 with single characters, but then saw it was three
 characters. Originally, just used the code of
 the character, changed code to
 ascii, but
 with 3 multiple each value to get a number that matched.
 In both put the row number in next column.
 
 Put the match field in C15
 both the formulas work, both formulas give the
 row.
 
 
 abc
                  
                                        
          1
            
                                        
         97098099
                
                                        
            1
 
 
 
 aBc
                                
                                
    2
                  
                                        
   97066099
                      
                                        
      2
 
 
 
 aBC
      
                                        
                      3
                                
                             97066067
                                
                                
    3
 
 
 
 Abc
      
                                        
                      4
                                
                             65098099
                                
                                
    4
 
 
 
 AbC
      
                                        
                      5
                                
                             65098067
                                
                                
    5
 
 
 
 Abc
      
                                        
                      6
                                
                             65098099
                                
                                
    6
 
 
 
 Ab
        
                                        
                    7
  
                                        
                   65098000
      
                                        
                      7
 
 
 
 aCb
                  
                                        
          8
            
                                        
         97067098
                
                                        
            8
 
 
 
 AcB
                                
                                
    9
                  
                                        
   65099066
                      
                                        
      9
 
 
 
 aBC
      
                                        
                     10
        
                                        
             97066067
            
                                        
               10
 
 
 
 AAC
      
                                        
                     11
        
                                        
             65065067
            
                                        
               11
 
 
 
 ss
        
                                        
                   12
          
                                        
          115115000
        
                                        
                   12
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 aBC
 
                                
                             97066067
 
 
 
 
 
 
 
 
 
 
 
        
                                        
                    3
 “=VLOOKUP($C$15,C1:D12,2,0)
 
                    
                                        
        3
 “{=INDEX(B1:B12,MATCH(1,EXACT($C$15,A1:A12),0))}
 
 
 
 
 
 
 
 
 Formula in
 C
 
 
 
 
 
 
 “=CODE(MID(A15,1,1))*100+CODE(MID(A15,2,1))*1000+CODE(MID(A15,3,1))
 
 
 On 10 Mar
 2017 at 9:46, Gary Collins wrote:
 
 Date sent:          Fri, 10 Mar 

[libreoffice-users] sort order

[Gary Collins]

Hello
Id like to know if there is a character, preferably some sort of discreet 
punctuation mark, that will come *after* z in the sort order when using natural 
sort. My problem is that i have some codes beginning Aa which really speaking 
should come after Z. As a number of up to 3 digits follows the letter(s) in 
each case, im getting A# followed by Aa# then B# which really wont do. I have 
to use natural sort as i need eg A12 to come after A3. Ive tried a few 
punctuation characters and some special characters but i cant find one that 
works. Any light that can be shed on this would be very   welcome indeed. I 
really dont want to have to precede Aa with a z if that can possibly be avoided.
Thanks
Gary

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] regular expression for calc

[Gary Collins]

Apologies if this appears twice; im not sure if there was a problem with 
sending...

Hello,
I have a column each row of which contains a sequence of one or more codes 
separated by a space. In case it will make a difference each code consists of a 
letter (ooccasionally 2 letters) followed by a number of up to 3 digits (and 
occasionally ends with a letter) eg X1 Aa12 D7a etc.

I  want to obtain a regular expression for COUNTIF that will enable me to find 
out how many times a particular code, contained in another cell, occurs in the 
column. I was thinking that \b to detect the word boundaries should help but i 
cant quite get it to work; im not sure if this is because it is assuming a word 
boundary between the letter and the number or if it is simply my incompetence 
as usual.

Does anyone have an idea what may be the best way to achieve this?

Thanks
Gary

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] regular expression for calc

[Gary Collins]

Hello,
I have a column each row of which contains a sequence of one or more codes 
separated by a space. In case it will make a difference each code consists of a 
letter (ooccasionally 2 letters) followed by a number of up to 3 digits (and 
occasionally ends with a letter) eg X1 Aa12 D7a etc.

I  want to obtain a regular expression for COUNTIF that will enable me to find 
out how many times a particular code, contained in another cell, occurs in the 
column. I was thinking that \b to detect the word boundaries should help but i 
cant quite get it to work; im not sure if this is because it is assuming a word 
boundary between the letter and the number or if it is simply my incompetence 
as usual.

Does anyone have an idea what may be the best way to achieve this?

Thanks
Gary

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: sorting in calc

[Gary Collins]

Thanks, yes, theres some really helpful info in this reply. I had thought of 
using a lower value but it hadnt occurred to me to hide it using formatting 
(and of course i didnt want it to show). The methods of converting to text are 
very useful to know. In the end i did indeed use the TEXT function in a 
formula, and conditionally substituted a blank where the string was shorter. 
Again not exactly elegant but it works and thats the main thing. It would be 
helpful to be able to define a nonstandard sort order but i dont think thats 
easily possible in a case like this (?: but im very willing to be proved wrong 
on that ) Again i think i'd be into the realm of macros!

Thanks
G.

On Thu, 9/3/17, Brian Barker <b.m.bar...@btinternet.com> wrote:

 Subject: Re: [libreoffice-users] Re: sorting in calc
 To: users@global.libreoffice.org
 Cc: "Gary Collins" <gcatl...@yahoo.co.uk>
 Date: Thursday, 9 March, 2017, 23:17
 
 At 18:59 08/03/2017
 +, Gary Collins wrote:
 >Is there a
 character i can enter into a cell 
 >that
 will come *before* numbers in the sort 
 >order? I mean, before other cells that
 actually 
 >contain numbers rather than
 numerical strings
 
 What
 about some value less than any of your real 
 data are (or can be)? What is the range of your
 
 numerical values? In practice, this is
 unlikely 
 to span the entire range that Calc
 can handle. If 
 your values are all positive
 and non-zero, for 
 example, then zero will
 do. Otherwise a sentinel 
 value such as -999
 might suffice.
 
 If you
 don't want this number to appear in your 
 list, you can hide it using Conditional 
 Formatting with a cell style having its font
 
 colour set to white (or whatever is your
 cell 
 background colour). Alternatively, you
 can set 
 the cell format of your range
 itself to something like [WHITE][<=0]0;0 .
 
 But the number would still be
 there, of course, 
 so you'd have to take
 care if you did any 
 calculations on the
 range such as AVERAGE().
 
 At
 09:12 09/03/2017 +, Gary Collins wrote:
 >Maybe it might work if i can convert all
 the 
 >relevant  numbers i have entered
 to text but im 
 >still looking for a way
 to do that. 
 >Format>cells>numbers
 and selecting text doesn't do it, ...
 
 No: changing format of cells
 already containing 
 values never changes the
 stored values 
 themselves. But there are two
 alternative easy ways to do this:
 
 o In another column, enter
 =TEXT(Xn;"0") (or 
 whatever is a
 suitable format string).
 o Fill down the
 column.
 o Select the new values and cut.
 o Paste them over the originals, but using Edit
 | 
 Paste Special... (or Ctrl+Shift+V),
 selecting 
 Numbers but not Formulae in the
 Paste Special dialogue.
 
 o
 Select the range of values.
 o Go to Data |
 Text to Columns... .
 o In the Text to
 Columns dialogue, under Fields, 
 click on
 the column header (probably currently Standard).
 o In the "Column type" drop-down,
 select Text.
 o OK.
 Voilà!
 
 At
 10:15 09/03/2017 +, Gary Collins wrote:
 >Ive managed to solve my problem in a
 roundabout 
 >way. To give the context, i
 have a column 
 >containing strings of
 length 1 to 3 which may 
 >contain
 nonstandard characters and which i must 
 >sort in a specific order (not the usual 
 >alphabetic order). To achieve this i have a
 
 >table assigning a number (col B) to
 each char 
 >(col A) in sheet 2, defined
 as a range 'xlit'.
 
 So this table must indeed have a small, finite
 
 range of values (presumably integers) in
 column 
 B. Surely your lookup formula just
 needs to 
 ascribe some numeric value outside
 and below this 
 range instead of the blank
 character or empty 
 cell that you may have
 at present?
 
 I trust this
 helps.
 
 Brian Barker
 
 
 -- 
 To
 unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
 Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 List archive: http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be publicly
 archived and cannot be deleted
 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] vlookup case

[Gary Collins]

Thanks for very helpful reply. It does seem to be a big drawback with these 
functions. I'll certainly try it but ive found a workaround that im using at 
the mo: ive defined two strings in adjacent cells and using string functions to 
find the position of a character in one string then extract the corresponding 
character from the other. Much less elegant and it was quite tiresome to 
implement but ive at least got it to work, in the limited cases that im using 
it so far. If i extend it to transliterate strings of arbitrary length (for now 
the max length ive needed is 3 chars) then i guess i'll probably have to get 
into macros.
Thanks
G.

On Thu, 9/3/17, Brian Barker <b.m.bar...@btinternet.com> wrote:

 Subject: Re: [libreoffice-users] vlookup case
 To: users@global.libreoffice.org
 Cc: "Gary Collins" <gcatl...@yahoo.co.uk>
 Date: Thursday, 9 March, 2017, 23:17
 
 At 11:50 09/03/2017 +, Gary
 Collins wrote:
 >Is it possible to make the search performed by vlookup
 to be case sensitive?
 
 Apparently not!
 
 >I need to be able to distinguish between eg 'd' and 'D'
 but at the 
 >moment i cant work out how to do it (if it's possible)
 
 Suppose your array has the values to be searched in column A
 and the 
 values to be returned in column B. Then try:
 =INDEX(B1:Bn;MATCH(1;EXACT("text";A1:An);0))
 Note that this is an array formula, so when you have entered
 it you 
 must complete the process by pressing Ctrl+Shift+Enter. If
 you do 
 this successfully, the entire formula will appear in the
 Input line 
 surrounded by braces, but you cannot simply type these
 braces yourself.
 
 This relies on EXACT() being the one function that *is*
 case-sensitive.
 
 I trust this helps.
 
 Brian Barker
 
 
 -- 
 To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
 Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 List archive: http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be publicly archived and
 cannot be deleted
 
 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] vlookup case

[Gary Collins]

Hello,
Is it possible to make the search performed by vlookup to be case sensitive? I 
need to be able to distinguish between eg 'd' and 'D' but at the moment i cant 
work out how to do it (if its possible)
Thanks
Gary

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] named data ranges

[Gary Collins]

Hello again
I appear to be experiencing a problem with named data ranges lo 5.2.2.2 x64 win 
7.

Q. Is it possible and permissible to define overlapping data ranges? I want a 
range named mdec which will be A1:B25 and another xlit B1:C25 (the col B values 
are common) to use in lookups. 

I have set them up and they appear ok in the Define Database Range dialog. 
However, when i try to enter xlit as the range in a formula i find that it 
automatically gets changed to mdec.

Im going now to try with the ranges defined explicitly instead of using the 
names, but i wonder if this problem sounds at all familiar to anyone, and if 
theres anything i can do about it?

Thanks
Gary

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] sorting in calc

[Gary Collins]

Hello all,
Ive managed to solve my problem in a roundabout way. To give the context, i 
have a column containing strings of length 1 to 3 which may contain nonstandard 
characters and which i must sort in a specific order (not the usual alphabetic 
order). To achieve this i have a table assigning a number (col B) to each char 
(col A) in sheet 2, defined as a range 'xlit'. On sheet 1 column A has strings 
to be sorted, columns B-D contain number to represent char 1,2,3 of the string. 
I obtain these numbers as text, using a formula of the form 
=IFERROR(TEXT(VLOOKUP(MID (Ax,y,1),xlit,2,0),"General"")," ")
where x is the row containing the string and y is 1,2 or 3 for the appropriate 
char of the string, returning the number as a string or " "if the character 
doesnt exist (string is of shorter length). I can now order my strings by 
sorting on columns B,C,D in that order. Perhaps there might have been an easier 
way to do it, but it works and thats what counts
Gary
--------
On Thu, 9/3/17, Gary Collins <gcatl...@yahoo.co.uk> wrote:

 Subject: Re: [libreoffice-users] sorting in calc
 To: "Gary Collins" <gcatl...@yahoo.co.uk>, "Dries Feys" <dries.f...@tvh.com>
 Cc: "users@global.libreoffice.org" <users@global.libreoffice.org>
 Date: Thursday, 9 March, 2017, 9:12
 
 Hello Dries
 Thank you for your reply. Yes i am aware of the ascii code
 but it doesnt seem to apply when some cells contain numbers
 rather than text. For example # comes before "1"  in
 the table but it sorts after numbers. I want something i can
 put in a cell which will sort before any number. I suspect
 there isnt anything. Maybe it might work if i can convert
 all the relevant  numbers i have entered to text but im
 still looking for a way to do that.
 Format>cells>numbers and selecting text doesnt do it,
 at least not in 5.2.2.2 under windows7. The format *appears*
 to change in that the numbers become left justified like
 strings but istext (cell) still returns false
 /G.
 
 On Thu, 9/3/17, Dries Feys <dries.f...@tvh.com>
 wrote:
 
  Subject: Re: [libreoffice-users] sorting in calc
  To: "Gary Collins" <gcatl...@yahoo.co.uk>
  Cc: "users@global.libreoffice.org"
 <users@global.libreoffice.org>
  Date: Thursday, 9 March, 2017, 8:32
  
  Gary,
  
  You could check http://www.asciitable.com/ to see the
  order.
  
  Met vriendelijke
  groeten, Salutations distinguées, Kind Regards,
  
  DRIES FEYS
  CORPORATE SERVICES • Specialist Software
  Developer
  
  TVH GROUP NV
  Brabantstraat 15 • BE-8790 WAREGEM
  T +32 56 43 42 11 • F +32 56 43 44 88 •
  www.tvh.com
  View our company movies via
  downloads on our website.
  
  
  On 8 March 2017 at 19:59, Gary Collins <gcatl...@yahoo.co.uk>
  wrote:
  > Hello,
  > Is
  there a character i can enter into a cell that will come
  *before* numbers in the sort order?
  > I
  mean, before other cells that actually contain numbers
  rather than numerical strings
  >
  > Thanks
  > Gary
  >
  > --
  > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
  > Problems? 
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
  > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
  > List archive: http://listarchives.libreoffice.org/global/users/
  > All messages sent to this list will be
  publicly archived and cannot be deleted
  
  -- 
  
  
   DISCLAIMER 
  
  http://www.tvh.com/glob/en/email-disclaimer
  
  "This message is
  delivered to all addressees subject to the conditions
  set forth in the attached disclaimer, which is
  an integral part of this
  message."
  
  -- 
  To
  unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
  Problems? 
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
  Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
  List archive: http://listarchives.libreoffice.org/global/users/
  All messages sent to this list will be publicly
  archived and cannot be deleted
  

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] sorting in calc

[Gary Collins]

Hello Dries
Thank you for your reply. Yes i am aware of the ascii code but it doesnt seem 
to apply when some cells contain numbers rather than text. For example # comes 
before "1"  in the table but it sorts after numbers. I want something i can put 
in a cell which will sort before any number. I suspect there isnt anything. 
Maybe it might work if i can convert all the relevant  numbers i have entered 
to text but im still looking for a way to do that. Format>cells>numbers and 
selecting text doesnt do it, at least not in 5.2.2.2 under windows7. The format 
*appears* to change in that the numbers become left justified like strings but 
istext (cell) still returns false
/G.

On Thu, 9/3/17, Dries Feys <dries.f...@tvh.com> wrote:

 Subject: Re: [libreoffice-users] sorting in calc
 To: "Gary Collins" <gcatl...@yahoo.co.uk>
 Cc: "users@global.libreoffice.org" <users@global.libreoffice.org>
 Date: Thursday, 9 March, 2017, 8:32
 
 Gary,
 
 You could check http://www.asciitable.com/ to see the
 order.
 
 Met vriendelijke
 groeten, Salutations distinguées, Kind Regards,
 
 DRIES FEYS
 CORPORATE SERVICES • Specialist Software
 Developer
 
 TVH GROUP NV
 Brabantstraat 15 • BE-8790 WAREGEM
 T +32 56 43 42 11 • F +32 56 43 44 88 •
 www.tvh.com
 View our company movies via
 downloads on our website.
 
 
 On 8 March 2017 at 19:59, Gary Collins <gcatl...@yahoo.co.uk>
 wrote:
 > Hello,
 > Is
 there a character i can enter into a cell that will come
 *before* numbers in the sort order?
 > I
 mean, before other cells that actually contain numbers
 rather than numerical strings
 >
 > Thanks
 > Gary
 >
 > --
 > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
 > Problems? 
 > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 > List archive: http://listarchives.libreoffice.org/global/users/
 > All messages sent to this list will be
 publicly archived and cannot be deleted
 
 -- 
 
 
  DISCLAIMER 
 
 http://www.tvh.com/glob/en/email-disclaimer
 
 "This message is
 delivered to all addressees subject to the conditions
 set forth in the attached disclaimer, which is
 an integral part of this
 message."
 
 -- 
 To
 unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
 Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 List archive: http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be publicly
 archived and cannot be deleted
 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] sorting in calc

[Gary Collins]

Hello,
Is there a character i can enter into a cell that will come *before* numbers in 
the sort order?
I mean, before other cells that actually contain numbers rather than numerical 
strings

Thanks
Gary

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] strip footnotes

[Gary Collins]

Hello,
I would like to either
1)  copy text without the footnotes but retaining formatting
Or 2) strip all footnotes from text after pasting. 
Is this possible in writer?
Thanks
Gary

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] 'Accumulating' styles

[Gary Collins]

Hi,
Is it possible to accumulate character styles? By which i mean, i have, eg a 
char style for a coloured background, applied to certain text selections. I 
have another char style for small caps, applied to  certain words in the text. 
Now if one of those words also occurs in one of the coloured background 
sections, is it possible to apply the small caps style without losing the 
coloured background style that is already there? Or is it necessary to create a 
unique style for each possible combination of features that may be required in 
a text?
Thanks
Gary
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Style from selection

[Gary Collins]

Update
It is working now. I guess i must have been doing something wrong before, 
though goodness knows what, its a simple enough procedure.
Thanks for your help,
G.
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Style from selection

[Gary Collins]

Thanks for reply, Dave. I just tried this and it doesnt seem to work for 
me. A new style with the name is created but it doesnt have the attributes 
of the selected text, in particular font size, font colour. These attributes 
were apparently set as direct formatting in the original doc, which i think was 
got by cut and paste from a pdf original. I now want to convert properly to 
styles but i dont seem to be able to.
G.
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Style from selection

[Gary Collins]

Hi,
A rather basic question: how do i create a new style from selection (lo 5.2.2.2 
x64)? The guide i have says to click the new style from selection icon in the 
styles and formatting window. Trouble is, i can't seem to find it. I have a new 
style icon with a dropdown but  that doesn't have a from selection option. And 
it doesn't seem to be an option in the styles menu. I've tried looking for a 
button in the modify toolbar window, but no joy there either. But it *must* be 
somewhere?
Thanks,
Gary
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Remove applied character style

[Gary Collins]

Thanks Ricardo, ill try that the next time the situation arises
G.
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Strange things happening with page count

[Gary Collins]

Hi,
I have a long document (writer 5.2.2.2, x64; win7) which was fine until i 
changed some of the defined colours (tools>options>color ; changed rgb settings 
for some colours with modify). After OK the document went 'jittery;' i saved 
and quit. When i reopened,  all my footnotes seem to have been displaced and 
the page count at bottom left began at around 999 (which i think is too low) 
and gradually started decreasing; currently at 27 where it seems to have 
stabilised. Scrolling through the document shows page boundaries seem to have 
disappeared. Any idea what's going on?
Thanks
Gary
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Remove applied character style

[Gary Collins]

Hi,
My question: is it possible to remove an applied character style from a text 
selection without changing anything else?
Situation: i have a character style which i apply to individual words and 
phrases in footnotes. If i apply this style to the last word in the footnote 
(quite frequent), then make edits in the main text , possibly adding further 
footnotes, then decide to add some words to the end of that footnote, the added 
words will also have that character style applied. That is not usually what i 
want. Can i remove the style from the added words only? 

Thanks,
Gary
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Marginal references

[Gary Collins]

Thanks for your replies; I think youve hit the nail on the head, Brian - 
helpful as ever. Seems so obvious now, shouldve thought of it myself - 
duh!!
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Marginal references

[Gary Collins]

Hi,
I'm wanting to prepare a document in writer with a main text body(justified) 
and marginal references on the right (and possibly also different ones on the 
left). Each paragraph will have at least one reference. The references need to 
be tied to their relevant paragraphs. If a subsequent reference is added and 
this makes the references exceed the height of the paragraph, following 
paragraphs must shift down to accommodate. Is there a way to achieve this?
Thanks
Gary
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: How to find out which fonts are used in an Open Document?

[Gary Collins]

I have a vague recollection of this, or something very like it, cropping up 
before. If it is not already an area marked for development, I think it should 
certainly be. I think that if a font is being replaced, the reader of the 
document should be given the ability to easily ascertain that this is the case. 
Perhaps somewhere in document properties there should be a tab or something to 
list the names of each font used in the document, giving original name together 
with associated replacements, if a replacement font has been used; and/or an 
option to open a dialog box for any font not found, and the replacement that 
will be used, at the time of opening a document. 
/Gary
  From: Pedro 
 To: users@global.libreoffice.org 
 Sent: Saturday, 6 February 2016, 0:06
 Subject: [libreoffice-users] Re: How to find out which fonts are used in an 
Open Document?
   
Hi Tom


TomD wrote
> I thought the font-box (on one of the toolbars) shows the correct
> font-name
> despite the document displaying the substitution?  It'd be a pain to move
> the cursor through the whole document and doing so is quite error-prone,
> but if it works it might usable for an odd one or two documents.

Indeed it does show the original font but it is not efficient to have to
click on every text box on every slide to check the font (especially because
several fonts can be used in a single text box).

I'm really hoping that someone has a magical extension that does this :P



--
View this message in context: 
http://nabble.documentfoundation.org/How-to-find-out-which-fonts-are-used-in-an-Open-Document-tp4174339p4174402.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



  
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: question about the best version of libreoffice - MY God is better!

[Gary Collins]

Phil,you wrote:


Just observation - you believe in sky fairies 
- Albert Einstein, Erwin Schrodinger, Paul Dirac, Antony Flew, all believed in 
a God; as do Richard Swinburne, Francis Collins, William Lane Craig, to name 
just a few.

you also wrote.
Well if you weren't clueless (which is not consistent with you believing 
in fairy stories) you would have realised by now that I don't have any 
and that I don't approve of others proselytising on this list . .

I hope you would not refer to any of those I've listed above as 'clueless.'
Posts like yours could easily be seen as being offensive. 
/Gary








  
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Inconveniences of time format

[Gary Collins]

Hi


I've got a column in calc 4.3.2.2 to contain the length of video clips; it's 
formatted to Time>876613:37:46. 
  

The first inconvenience is that, when using autoincrement the times are 
incremented not by 1 second but by 24 hours. 
 

Whilst i understand that this is due to the way date/time is stored, with the 
date as integer and the time as fraction, i think it is not exactly intuitive. 
I feel that it might be much more convenient if LO would take the formatting 
into account and increment by 1 second (or, to be more precise, by 1 LSD  to 
the chosen format).


Similarly, when entering such times i think it would be more helpful to give 
precedence to the LSD, so entering 8, for example, would be interpreted as 8 
seconds (rather than 8 hours as is cuŕrently the case) and 8:40 as 8m40s. 
Again, this interpretation should be format dependent.
 

What does anyone else think?


Best
 
 
/Gary
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] copying text with formatting from a web page

[Gary Collins]

I've just tried this in firefox. A couple of things:

1) access to the file save option seems to be indirect - but maybe there is a 
way to customise this, I haven't got time to check at the moment; but

2) much more importantly - it does indeed save as a single file, but the 
formatting is *awful* nothing like the original page, and pictures, graphics, 
etc are not there - just links. That's not what I want to see when  I open a 
webpage file, I want to see the page (more or less) the same as it was 
originally when I opened it online.

Which raises another issue: I save pages for later viewing on a machine that 
doesn't have an internet connection. I'm assuming that an internet connection 
will be essential to follow any of the hyperlinks in the file, which would 
render the format useless for my purposes.

best,/G.
   From: Tom Davies <tomc...@gmail.com>
 To: jorge <jrodrigue...@cpcecr.com> 
Cc: Gary Collins <gcatl...@yahoo.co.uk>; "users@global.libreoffice.org" 
<users@global.libreoffice.org> 
 Sent: Friday, 16 October 2015, 21:51
 Subject: Re: [libreoffice-users] copying text with formatting from a web page
   
Hi :)  I've just seen that option in Chrome too.  It's a little more awkward.  
From the icon with 3 horizontal lines go down to "More Tools".  Then "Save 
page" gives a dialogue with options at the bottom to save as a single file or 
as proper html.  
Thanks Jorge!  It's nice to find or be told about these things :)  Regards from 
Tom :)  


On 16 October 2015 at 17:35, jorge <jrodrigue...@cpcecr.com> wrote:

Hi:

        As I see in Firefox, we can save as Web page complete-by default (As I
understand Tom comment), and .html format (A single file to save the web
page as I suggest). I'm sorry if I am wrong.

Regards,

Jorge Rodríguez


El vie, 16-10-2015 a las 16:47 +0100, Tom Davies escribió:
> Hi :)
> I thought saving in html format tends to create an extra sub-folder
> for images and snippets of code and stuff.  The links in the html file
> pick-up on the stuff that's in that new sub-folder.
> Regards from
> Tom :)
>
>
>
> On 16 October 2015 at 16:36, jorge <jrodrigue...@cpcecr.com> wrote:
>         Good morning Gary and all:
>
>                 I'm not sure if this following words are of
>         topic...excuse me if
>         yes ! :
>
>                 I don't remember knowing about .mht file format to
>         save web site pages.
>         But when I need to do that I use .html file format that give
>         us a only
>         one file of the web page with all sourse of it as links for
>         example.
>
>         Regards,
>
>         Jorge Rodríguez
>
>         El vie, 16-10-2015 a las 08:42 +, Gary Collins escribió:
>         > Tom,
>         > That's a good suggestion, perhaps I should have thought of
>         it. I will give it a go. In general, I use MS because it has
>         been the only one I know capable of handling .mht files, and I
>         save web pages using that format because I find it *much* more
>         convenient to have the page saved in a single file, rather
>         than as a file plus a folder. Perhaps other browsers can now
>         open these files now? I don't know, I haven't got around to
>         checking recently. You know how it is, you find something that
>         works for you and just stick with it - kind of inertia.
>         > I had a reply privately from Brian, though, which suggested
>         that it might be due to the type of formatting used in
>         the .css - using "vertical-align", and if so, that LO probably
>         wouldn't recognise it. I checked the file in a text editor and
>         that is indeed how the superscripting is generated in these
>         pages.
>         > I have since found a workaround which is not the most
>         convenient but will at least allow me to get done what I need
>         to get done.
>         > best,/Gary
>         >        From: Tom Davies <tomc...@gmail.com>
>         >  To: Gary Collins <gcatl...@yahoo.co.uk>
>         > Cc: "users@global.libreoffice.org"
>         <users@global.libreoffice.org>
>         >  Sent: Friday, 9 October 2015, 18:25
>         >  Subject: Re: [libreoffice-users] copying text with
>         formatting from a web page
>         >
>         > Hi :)  So Microsoft's Internet Explorer only plays well with
>         Microsoft Office?  Err, is there any surprise there?
>         > Have you tried with other web-browsers?  Internet Explorer
>         often seems to be a pos imo and ime.  Each release of it seems
>         to have a load of different 'issues' handling internationally
>         agreed standards (yes, Microsoft AR

Re: [libreoffice-users] copying text with formatting from a web page

[Gary Collins]

Tom, 
That's a good suggestion, perhaps I should have thought of it. I will give it a 
go. In general, I use MS because it has been the only one I know capable of 
handling .mht files, and I save web pages using that format because I find it 
*much* more convenient to have the page saved in a single file, rather than as 
a file plus a folder. Perhaps other browsers can now open these files now? I 
don't know, I haven't got around to checking recently. You know how it is, you 
find something that works for you and just stick with it - kind of inertia.
I had a reply privately from Brian, though, which suggested that it might be 
due to the type of formatting used in the .css - using "vertical-align", and if 
so, that LO probably wouldn't recognise it. I checked the file in a text editor 
and that is indeed how the superscripting is generated in these pages. 
I have since found a workaround which is not the most convenient but will at 
least allow me to get done what I need to get done.
best,/Gary
   From: Tom Davies <tomc...@gmail.com>
 To: Gary Collins <gcatl...@yahoo.co.uk> 
Cc: "users@global.libreoffice.org" <users@global.libreoffice.org> 
 Sent: Friday, 9 October 2015, 18:25
 Subject: Re: [libreoffice-users] copying text with formatting from a web page
   
Hi :)  So Microsoft's Internet Explorer only plays well with Microsoft Office?  
Err, is there any surprise there?  
Have you tried with other web-browsers?  Internet Explorer often seems to be a 
pos imo and ime.  Each release of it seems to have a load of different 'issues' 
handling internationally agreed standards (yes, Microsoft ARE involved in 
setting those standards!).  So websites sometimes have to write extra code 
specifically aimed at certain versions of IE.  At best IE seems to behave more 
like a trojan as it's so often found to have remarkable security issues.  MS 
usually put out at least 1 or more security patch per fortnight to deal with 
some critical problem or other.  
Please, please, please try Chrome, Safari, Opera, or anything else.  Even 
Firefox's worst releases appear to be better than IE.  There are a huge range 
of web-browsers available for free and quite easy to download and install.  
Personally i would probably paste anything off a website as plain-text and then 
add back the formatting myself.  There are a few websites i kinda trust but in 
general i'd try to avoid risking pulling dodgy formatting and what-ever else 
across into another program/app.  
Sorry for the tone here!  Good luck with all this! Many apols sand regards from 
Tom :)  


 


On 9 October 2015 at 15:54, Gary Collins <gcatl...@yahoo.co.uk> wrote:

Should've said, I'm using 4.4.3.2/G.
       From: Gary Collins <gcatl...@yahoo.co.uk>
 To: "users@global.libreoffice.org" <users@global.libreoffice.org>
 Sent: Friday, 9 October 2015, 15:33
 Subject: [libreoffice-users] copying text with formatting from a web page

Hi,
I'm copying some text from a web page (windows explorer) into a Writer doc; the 
text copies OK, but I can't seem to preserve superscripting. I've tried normal, 
HTML format and formatted text [RTF] as paste options; I can get attributes 
such as colour pasted, but can't seem to get that superscript. MS Word OTOH 
does preserve the superscript attribute, so it must be there on the clipboard. 
Is there a way of coaxing this information into Writer?
Thanks,/Gary


    
 
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted




  
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] copying text with formatting from a web page

[Gary Collins]

Hi, 
I'm copying some text from a web page (windows explorer) into a Writer doc; the 
text copies OK, but I can't seem to preserve superscripting. I've tried normal, 
HTML format and formatted text [RTF] as paste options; I can get attributes 
such as colour pasted, but can't seem to get that superscript. MS Word OTOH 
does preserve the superscript attribute, so it must be there on the clipboard. 
Is there a way of coaxing this information into Writer?
Thanks,/Gary
 
  
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] copying text with formatting from a web page

[Gary Collins]

Should've said, I'm using 4.4.3.2/G.
   From: Gary Collins <gcatl...@yahoo.co.uk>
 To: "users@global.libreoffice.org" <users@global.libreoffice.org> 
 Sent: Friday, 9 October 2015, 15:33
 Subject: [libreoffice-users] copying text with formatting from a web page
   
Hi, 
I'm copying some text from a web page (windows explorer) into a Writer doc; the 
text copies OK, but I can't seem to preserve superscripting. I've tried normal, 
HTML format and formatted text [RTF] as paste options; I can get attributes 
such as colour pasted, but can't seem to get that superscript. MS Word OTOH 
does preserve the superscript attribute, so it must be there on the clipboard. 
Is there a way of coaxing this information into Writer?
Thanks,/Gary


     
  
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


  
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] copy cell format

[Gary Collins]

I think the problem being experienced is that the column widths are not copied 
or adjusted to fit the contents. The best I can think of is to paste the data, 
then select it and use Format>Column>optimal width. This may not be quite what 
is required, but it may at least help a bit. /Gary
  From: Jim Quinn 
 To: users@global.libreoffice.org; Thomas  
 Sent: Friday, 18 September 2015, 12:17
 Subject: Re: [libreoffice-users] copy cell format
   
Sorry for just replying to email vs getting into LO and answering.  Just too 
busy with huge biking event this weekend and am new using LO forums.

That said, if I understand that you want to copy the data from 1 spread 
sheet file (1 or more rows/columns) and paste just the data into a file with 
different column/row formatting, then use the "Paste Special" option and 
only check the items in the "Paste Special" pop-up menu that you want.  Do 
not check "Format" and the column/row format will remain unchanged.

Of course, the number of rows/columns you paste into should equal what you 
copied.

-Original Message- 
From: Thomas
Sent: Friday, September 18, 2015 4:02 AM
To: users@global.libreoffice.org
Subject: [libreoffice-users] copy cell format

Good evening
I have been trying to find hints in the documentation, but had no
success so far.

I have (naturally) a number of sheets / files.
Sometimes I want to copy let's say the first row, which contains all the
names of the columns etc., to create a new document.
(not ALL documents use the same format)
Imagine there are 20-25 columns, most of which have different widths.

But when I copy row No.1 from file A to a new file, no matter HOW I
paste it there,
it ALWAYS comes out with equal column width (+ the default height of the
new document).
That means, I have to reformat the whole thing EVERY time I do this.
(not frequently, but also not a rare operation)

In an ancient but VERY useful software = Lotus123 that requires only
checking one box.

If I understand the page:
https://help.libreoffice.org/Common/Copying_Attributes_With_the_Format_Paintbrush
correctly,
"Form control is selected    Not supported"
means that Calc is not able to do what Lotus could do 20 years ago.
Is that right? Or am I missing something?
I am also under the impression, that the "paint brush" works ONLY within
one file, but not across different files.

Styles do not help either (as far as I can tell), since I could not find
any tab there, where I can specify column width + height.

Is there a trick?
Is so, I would really like to know.

Thank you.
Thomas



-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? 
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be 
deleted 




-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


  
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Can't start up LO5 any more

[Gary Collins]

Hi,
I'm experiencing some problems; installed LO5 yesterday (windows) and it was 
working fine; earlier this morning I had some docs open and it still seemed 
fine. All documents have now been closed, but I can't seem to start up LO5 any 
more.I've tried: double clicking a file in windows explorer
double-clicking a file saved to desktop (I suspect thi is exactly the same 
thing)
double-clicking LO5 startup icon on desktop
selecting LO5 from start menu

- all to no avail. I checked the task manager in case it was somehow running in 
an invisible mode (such things do happen - but no, it's not running at all 
and I can't get it to run.
I will try a reboot at some stage - can't do that just yet - but does anyone 
have any idea what might be preventing LO from running? Anyone else experienced 
anything similar?
thanks,/Gary
   
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Can't start up LO5 any more

[Gary Collins]

Just checked task manager again. Although LO was not listed under the 
applications tag, it seems there were *dozens* of soffice.bin and soffice.exe 
entries under the processes tag. deleting on of them suddenly opened up a 
whole load of document windows on my desktop - and also terminated the majority 
of those processes in the TM. I suspect this is something that shouldn't 
happen, but I'm not sure how I arrived at this state.
/Gary
   From: Gary Collins gcatl...@yahoo.co.uk
 To: users@global.libreoffice.org users@global.libreoffice.org 
 Sent: Friday, 7 August 2015, 11:00
 Subject: Can't start up LO5 any more
   
Hi,
I'm experiencing some problems; installed LO5 yesterday (windows) and it was 
working fine; earlier this morning I had some docs open and it still seemed 
fine. All documents have now been closed, but I can't seem to start up LO5 any 
more.I've tried: double clicking a file in windows explorer
double-clicking a file saved to desktop (I suspect thi is exactly the same 
thing)
double-clicking LO5 startup icon on desktop
selecting LO5 from start menu

- all to no avail. I checked the task manager in case it was somehow running in 
an invisible mode (such things do happen - but no, it's not running at all 
and I can't get it to run.
I will try a reboot at some stage - can't do that just yet - but does anyone 
have any idea what might be preventing LO from running? Anyone else experienced 
anything similar?
thanks,/Gary


   

  
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Can't start up LO5 any more

[Gary Collins]

Thanks for the tip, I'll remember that!
/G.
   From: Tanstaafl tansta...@libertytrek.org
 To: users@global.libreoffice.org 
 Sent: Friday, 7 August 2015, 12:58
 Subject: Re: [libreoffice-users] Re: Can't start up LO5 any more
   
Yeah, this happens sometimes, it is not new to 5...

You got a 'zombie' process for each time you tried to launch it without
success.

So, the first time you try to launch it and nothing happens, don't keep
doing it, check for the zombie process right away, it will save you some
time.

This happens with other windows apps too, dunno why...




  
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] table with offset between rows

[Gary Collins]

Thanks, that seems to work well!
/Gary
   From: Piet van Oostrum pie...@pietvanoostrum.com
 To: Gary Collins gcatl...@yahoo.co.uk 
Cc: users@global.libreoffice.org users@global.libreoffice.org 
 Sent: Thursday, 30 July 2015, 20:07
 Subject: Re: [libreoffice-users] table with offset between rows
   
Gary Collins wrote:

  Ah, I think I didn't state my problem clearly, as usual!
  What I mean is, I want the cells of the bottom row to be offset by half a 
  cell horizontally from those in the top row, so that the vertical borders of 
  the top row come halfway across the cells of the bottom row.
[...]
  I've tried importing a selected row of cells from calc into draw to do this, 
  in theory I think this ought to work well, but the problem I'm experiencing 
  there is that cell size and formatting don't seem to be preserved when 
  pasting the row.

I have tried that and it worked. What I did:

Select a large numer of columns in Calc, and set the columns to the required 
width.
You can then merge pairs of cells. Actually you don't have to do all of them. 
If you have 4 or 5 merged cells, just copy these a number of times to the other 
columns.
And then you copy this to another row starting at the second cell, so that it 
gets indented.

Now if you copy/paste these to Writer they seem to keep their widths. But you 
have to use Edit  Paste Special  Formatted Text. For me the column widths are 
preserved. O, yes, if you do something with the column widths in Writer, with 
Table Properties  Columns, select 'Adapt table width'. This causes the table 
width to follow the sum of the column widths instead of being fixed.



-- 
Piet van Oostrum p...@vanoostrum.org
WWW: http://pietvanoostrum.com/
PGP key: [8DAE142BE17999C4]


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


  
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Question about LO Writer and complex documents

[Gary Collins]

I think that register is an important consideration. Colloquial language tends 
to be in a state of flux and dictionaries will always lag behind. Formal 
language tends to be far more conservative, and that, I think, is where 
proper is likely to be a more important consideration. 

Is either more correct than the other? Not really. It depends on the nature 
and purpose of the communication. But improper use of words and grammar will, 
of course, give the impression that the communicator has been poorly 
educated. (Again, that could be considered a loaded concept.) Where making 
a good impression is important, dictionaries are very useful tools indeed.

/Gary
   From: Felmon Davis dav...@union.edu
 To: users@global.libreoffice.org 
 Sent: Thursday, 30 July 2015, 21:48
 Subject: Re: [libreoffice-users] Question about LO Writer and complex 
documents
   
On Wed, 29 Jul 2015, anne-ology wrote:

      grammar skillfully employed procures meaningful communication,
          [see below for comments to your comments]

yes, 'skillful' is not the same as 'proper'.

or let's put it this way, 'proper' is ambiguous. it could mean 
'according to some accepted standard' or it could be 'adept'.

an act of communication can be 'improper' but apt or 'proper' but 
inept.

some think 'the King and me' is 'improper' and should be 'the King and 
I'. aside from reasons of gentility they are equally fit to purpose.

[pardon the deletions]

      Without good communication skills, then how can anyone be a part of
 any community  ???

 I doubt 'good communication skills' require 'proper' grammar.

      [well, how would you punctuate this sentence? -
          Woman without her man is helpless
        (yes, it's an old time example used by probably every English
 instructor since ... )

      It could be 'Woman, without her man, is helpless.' or 'Woman:
 without her, man is helpless.']

the spoken sentences would be unambiguous.

here are some other punctuations:

Woman! without her man is helpless.
Woman - without her, man is helpless.

some grammar 'authority' will favor one, some another. it is pointless 
to dispute such religious questions.

speaking of which: to me it's anathema how Brits sprinkle commas all 
over their sentences; after all they aren't Germans!

f.

-- 
Felmon Davis

Fashions have done more harm than revolutions.
                -- Victor Hugo




-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



  
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] table with offset between rows

[Gary Collins]

Ah, I think I didn't state my problem clearly, as usual!
What I mean is, I want the cells of the bottom row to be offset by half a cell 
horizontally from those in the top row, so that the vertical borders of the top 
row come halfway across the cells of the bottom row.

(I'm doing a comparison of chronologies. Each cell width is to represent one 
year, but the starting point of the year for the bottom row is shifted by six 
months from the year start in the top row.)

Technically, it should be possible to merge cells alternately, but there'll be 
a heck of a lot of cells (as many as I can reasonably get on a landscape page 
and still have room for a few characters in each cell; I'll have to experiment, 
but I reckon at least 40 - 50 in a row) so unless there's a way of automating 
that, it's out of the question.
I'm guessing I'll have to have a separate table for each row; in principle 
that's not a problem; but I haven't worked out how to align the two tables (in 
writer); they seem always to expand to fill the page width and are quite 
difficult to resize afterwards. I'm guessing there must be a way to do this, I 
just haven't found it yet. If possible, I'd like to make the first cell of the 
row wider and have the rest adjust to a common width to the end of the table, 
but at the moment, at least, that's icing on the cake.

I've tried importing a selected row of cells from calc into draw to do this, in 
theory I think this ought to work well, but the problem I'm experiencing there 
is that cell size and formatting don't seem to be preserved when pasting the 
row.

I don't really mind how  I achieve it, as long as it's not too tedious!

Thanks,
/Gary
   From: Piet van Oostrum pie...@pietvanoostrum.com
 To: Gary Collins gcatl...@yahoo.co.uk 
Cc: users@global.libreoffice.org users@global.libreoffice.org 
 Sent: Thursday, 30 July 2015, 11:55
 Subject: Re: [libreoffice-users] table with offset between rows
   
Gary Collins wrote:

  Hi,
  I'm needing to create a kind of table, consisting of two rows, where the 
  bottom row is offset by half a cell from the top row. I'm not sure what 
  would be the best way to achieve this - any suggestions would be most 
  welcome!
  
  /Gary

Make a table with 3 rows. 
Select the middle row and with Table Properties  Borders select only the top 
and bottom borders.
With the same row selected: Format  Paragraph  Indents  Spacing, select Line 
Spacing  Fixed and enter a small size, for example 5pt.

With kind regards,
-- 
Piet van Oostrum p...@vanoostrum.org
WWW: http://pietvanoostrum.com/
PGP key: [8DAE142BE17999C4]




-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



  
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] LO Draw to PS shapes

[Gary Collins]

Hi Tomyes, PS can handle formats like that, but I want to actually add the 
shapes into the custom shape tool, which requires the .csh format. Full-blown 
photoshop can handle creation of new shapes, but I use an early version of 
Elements which doesn't have that functionality; hence my need to find some 
alternative if at all possible.
I checked inkscape, but that doesn't give the .csh format either.
/G.
   From: Tom Davies tomc...@gmail.com
 To: Gary Collins gcatl...@yahoo.co.uk 
Cc: users@global.libreoffice.org users@global.libreoffice.org 
 Sent: Tuesday, 28 July 2015, 14:28
 Subject: Re: [libreoffice-users] LO Draw to PS shapes
   
Hi :)
Inkscape has a lot of formats by default but i don't remember noticing
.csh.  Perhaps an add-on / Extension / plug-in?

Interesting to hear Photoshop is so limited.  Can it not handle standard
formats such as .Svg or .Eps?

It's not hugely surprising to hear it can't cope with Open Formats such
.Odg.  This is a typical problem of proprietary programs.  By limiting
their ability to use non-proprietary formats it can force people into
vendor lock-ins.  The problem is created by the proprietary tools but
somehow it's the OpenSource ones that get the blame and 'have to' solve it.


Open Source tools open things up to freely available formats that anyone
can use in any suitable program and in the future it will be relatively
simple to create tools that can read files saved in such open formats.
Proprietary formats keep changing and so it becomes increasingly difficult
to read older files.
Regards from
Tom :)






On 28 July 2015 at 11:28, Gary Collins gcatl...@yahoo.co.uk wrote:

 Hi,Does anyone know of a free app that can convert vector graphics from
 Draw into Photoshop Custom Shape format (.csh)? Draw doesn't export .csh
 directly; I did a quick web search but couldn't find anything useful.
 /Gary

 --
 To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
 Problems?
 http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 List archive: http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be publicly archived and cannot be
 deleted




-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


  
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] table with offset between rows

[Gary Collins]

Hi,
I'm needing to create a kind of table, consisting of two rows, where the bottom 
row is offset by half a cell from the top row. I'm not sure what would be the 
best way to achieve this - any suggestions would be most welcome!

/Gary
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] LO Draw to PS shapes

[Gary Collins]

Hi,Does anyone know of a free app that can convert vector graphics from Draw 
into Photoshop Custom Shape format (.csh)? Draw doesn't export .csh directly; I 
did a quick web search but couldn't find anything useful.
/Gary
   
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] [OT] Operating Environment Survey

[Gary Collins]

Ah. We didn't even have computers on the curriculum. there weren't many 
schools that did. 
   From: James Knott james.kn...@rogers.com
 To: users@global.libreoffice.org 
 Sent: Thursday, 23 July 2015, 12:16
 Subject: Re: [libreoffice-users] [OT] Operating Environment Survey
   
On 07/23/2015 04:40 AM, Gary Collins wrote:
 We didn't have computers at all at school

We didn't either.  I had a FORTRAN class in grade 12 and filled in
pencil mark cards, which the teacher took to the board office, to run on
the computer there.




-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


  
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] [OT] Operating Environment Survey

[Gary Collins]

Sorry, that should have been The Four Yorkshiremen (I must have miscounted 
:-) )
   From: Gary Collins gcatl...@yahoo.co.uk
 To: Gordon Burgess-Parker gordo...@mail.com; users@global.libreoffice.org 
users@global.libreoffice.org 
 Sent: Thursday, 23 July 2015, 12:45
 Subject: Re: [libreoffice-users] [OT] Operating Environment Survey
   
 Yes, I remember those (this is getting a bit like The Three Yorkshire 
Men!)
 

 From: Gordon Burgess-Parker gordo...@mail.com
 To: users@global.libreoffice.org 
 Sent: Thursday, 23 July 2015, 12:37
 Subject: Re: [libreoffice-users] [OT] Operating Environment Survey
   


On 23/07/15 09:40, Gary Collins wrote:
 We didn't have computers at all at school,
neither did welog tables and slide rule!



-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


   

  
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] [OT] Operating Environment Survey

[Gary Collins]

 Yes, I remember those (this is getting a bit like The Three Yorkshire 
Men!)
  From: Gordon Burgess-Parker gordo...@mail.com
 To: users@global.libreoffice.org 
 Sent: Thursday, 23 July 2015, 12:37
 Subject: Re: [libreoffice-users] [OT] Operating Environment Survey
   


On 23/07/15 09:40, Gary Collins wrote:
 We didn't have computers at all at school,
neither did welog tables and slide rule!



-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


  
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] [OT] Operating Environment Survey

[Gary Collins]

  From: James Knott james.kn...@rogers.com
 To: users@global.libreoffice.org 
 Sent: Tuesday, 21 July 2015, 22:38
 Subject: Re: [libreoffice-users] [OT] Operating Environment Survey
   
On 07/21/2015 07:15 AM, Gary Collins wrote:
 My first home computer was a BBC micro (anyone remember those?) That was back 
 in the days when programming had to be really tight, only had 32Kb (yes, Kb) 
 of RAM; long term storage was all external on cassette tapes

My first computer was an IMSAI 8080, which I built up from bare boards
and a bag of parts.  I also had to buy a memory card and some I/O for
it.  I initially loaded in software via switches on the front panel and
then saved to cassette.  Back in those days, you knew your computer
inside out.

https://en.wikipedia.org/wiki/IMSAI_8080
Awesome! 

We didn't have computers at all at school, and I didn't really start getting 
into them until some time later. At that time I had no particular desire or 
intention to use computers except for a bit of fun programming, but eventually 
the twists and turns of life led me into a job programming the things. I was 
never any good at building hardware, though I did gain considerable knowledge 
(mostly long since forgotten) of how the circuitry works
/Gary
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


  
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] [OT] Operating Environment Survey

[Gary Collins]

The company I used to work for manufactured mass spectrometers and we used PDP 
11s with software written in PASCAL to control the instruments and gather and 
present the data they generated. The biggest pain in the neck was having to use 
overlays to swap parts of the program code into and out of memory as required. 
These days, that sort of thing happens quite transparently, and unless you're 
into writing operating systems, it's not the sort of thing you're likely to 
come across.
/Gary
   From: Tom Davies tomc...@gmail.com
 To: Tim---Kracked_P_P---webmaster webmas...@krackedpress.com; Gary Collins 
gcatl...@yahoo.co.uk 
Cc: users@global.libreoffice.org users@global.libreoffice.org 
 Sent: Wednesday, 22 July 2015, 5:19
 Subject: Re: [libreoffice-users] [OT] Operating Environment Survey
   
Hi :)  
PDP11s look interesting!  

A short article that claims the default OS was Multics;  
http://whatis.techtarget.com/definition/PDP-11-Programmed-Data-Processor-11
but that many put Unix on it.  Wikipedia gives a great long list of OSes that 
ran on or could run on PDP11s; 
https://en.wikipedia.org/wiki/PDP-11#Operating_systems

As you can see in the url below Nuclear Power Plants are apparently still using 
and plan to continue using PDP11's until 2050 !
http://www.theregister.co.uk/2013/06/19/nuke_plants_to_keep_pdp11_until_2050/

Regards from 
Tom :)  





On 22 July 2015 at 03:21, Tim---Kracked_P_P---webmaster 
webmas...@krackedpress.com wrote:


My first real computer job was data entry typing punched cards for an IBM 
system.

Then I started working at several colleges with those ghastly PDP/11 systems. 
 One was the core for a large computer center with large tape units, and one 
was just a stand alone system with a drive platter and all of those dump 
terminals.  That stand alone PDP/11 system is where I had to write/code/etc. 
a full general ledger accounting system using COBOL.  Have you even tried to 
write a data entry system for an accounting system, so people could not type in 
the wrong info/data - like Feb 29th for a non-leap year or an account number 
that is not created, or other values that are not within the proper any of the 
data ranges. That was 3 time the coding size than all of the rest of the 
system, including the account query/search system and report generating systems.

Yes, I remember those data cassette tape drive computers, before you could 
afford a dual floppy IBM PC/AT/XT clone.  Then there were those 10 MEG hard 
drives.

I saw the introduction of the PC based
Hard Drive
CD ROM drive, then burner

Real Graphics above 640 by 480

I saw the introduction of the Bulletin board system that was interconnected so 
you had a primitive email address - mine was almost 80 characters long.

I saw the start of the WWW part of the Internet, which is what is now THE 
Internet, since most of the other parts [terminal based mostly] have either 
died or been converted to use a browser.  Of course there are still parts 
that run via the terminal which I still use from time to time - mostly local to 
server communications.

The domain I use for this email address - I own -  was first created in the 
early '90, when you only had 14.4 dialup for most areas of the US, and has gone 
from one domain service to another, and my hosting service from one to another, 
till I finally settled on the one[s] I have been using for many years now.

Yes I have seen the wireless phone go from the big brick technology through 
to the introduction of the smart phone technology.  I now use a LG base model 
Android phone, since I do not need all of the wow-wee stuff.  I do not need to 
use it for my every computer need, like some are touted.

I have bought 3 Android tablets over the years.  I still use 2 of them.  And 
no, I do not like the hype of not needing a larger system - laptop or desktop - 
since a Android, IOSx, or MS OS claims it will do everything you will need.  My 
desktop I am typing this from is an old 4 core running Linux Mint 16 with 4 
hard drives internal, 1 OS and 3 data drives - adding up to 6.25 TB - with 3 
external 2 TB drives for backup.  I use to have 4 backup, till an internal 2TB 
drive failed and I needed my spare to replace it.

I really wonder how you could get a tablet to have 6 TB of data storage.  I 
also like to see these tablets find printer drivers to run the USB or network 
printing.  I have enough trouble tryng to find a working Linux [.deb] printer 
driver for my newer printers, and I have not been able to get any of my android 
tablets to access any of my colored printers - just a older HP laser printer. 
 I now look for Linux drivers BEFORE I decide to buy the printers.


I have gone from punched card data entry to web-based data entry screens.
I have gone from cassette tapes, through to floppies, internal/external hard 
drives, USB flash drives and SD cards.
I have seen mainframe computers the size of a bedroom, down to a refrigerator.
I have seen the IBM PC come out

Re: [libreoffice-users] [OT] Operating Environment Survey

[Gary Collins]

   
   
On 07/18/2015 09:25 PM, James E Lang wrote:
 The big discussion of Linux over the past 24+ hours has me wondering: What 
 operating environment(s) do other members of this list use at home and at 
 work? What factors influence the choice?


My first home computer was a BBC micro (anyone remember those?) That was back 
in the days when programming had to be really tight, only had 32Kb (yes, Kb) of 
RAM; long term storage was all external on cassette tapes, eventually upgraded 
to floppy disk drive (and the disks really were floppy). I've still got that 
computer and AFAIK it still works!
My next machine was Acorn Archimedes, followed by RISC PC. It's a great shame 
that the marketing for those machines was so poor, leading to collapse of the 
company. The ARM chips had a great architecture and instruction set.
After that, I got my first laptop, a Sony Vaio running windows XP. When I 
upgraded, which I was forced to do due to a machine failure, I got a laptop 
running Windows 7 - which is still my current machine. A better Windows, once 
I'd got used to it, but it had a real downer - couldn't get driver for my 
flatbed scanner - Canon didn't produce one.
At work, in my first job I used a computer called a PDP 11 (ghastly thing); 
can't remember what the OS was called.
In my second job I think we started off with some sort of mainframe, the 
details of which are hazy now. Later we migrated to Sun Spark workstations.
In my last real job, used PCs running windows, I think it was XP at that time.
Now in my office based voluntary work I use PCs with Windows 7. Did have a play 
with Win 8 on a laptop, but hated it. It might be OK for tablets, I don't know, 
but it was horrible to use with normal PC input devices.
I have thought about upgrading to Linux but have never got around to it. This 
is mainly because of familiarity with certain software packages, especially 
Photoshop. I know there is GIMP for Linux, but it's not a patch - for one 
thing, it doesn't have the concept of adjustment layers; and that means that 
all my working files, which tend to be saved as TIFF with layer compression, 
can't be properly loaded and edited in GIMP.I also make use of a video editor 
(not free but fairly inexpensive) which can edit MPEG2 files without reencoding 
unchanged parts of the video, which makes it quite fast and doesn't lose 
quality. Something like that probably does exist for Linux but I haven't got 
around to looking, and familiarity is a big part of the story.Another thing is 
the convenience of plug and play when it comes to hardware - I don't think I've 
ever had to manually load a driver, everything seems to work out of the box 
and that's a very good thing, saves a lot of time and effort. I'm not sure what 
Linux is like in that respect, as I've had no experience.
On my phone I have android and I tend to get on reasonably well with that.
I'm not sure what I will do if I ever need to change computer again.
/Gary
  
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] One more question on Drawing Object styles

[Gary Collins]

I use this to obscure parts of other objects. It's been extremely useful./Gary
   From: Kevin O'Brien zwiln...@gmail.com
 To: users@global.libreoffice.org users@global.libreoffice.org 
 Sent: Sunday, 28 June 2015, 17:20
 Subject: [libreoffice-users] One more question on Drawing Object styles
   
There is a style for an object with no line and no fill, but that
seems to make everything disappear. I can tell that the object is
still there if I work at clicking around the blank screen to select
it, but I am at a loos to understand what a use case is for this
style. Can anyone enlighten me?

Thanks,

-- 
Kevin B. O'Brien
zwiln...@gmail.com
http://google.me/+kevinobrien
“If there are no dogs in Heaven, then when I die I want to go where they went.”
- Will Rogers

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


  
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted