Re: [libreoffice-users] Writer form design grid

2024-02-20 Thread Mike Scott

On 16/02/2024 07:23, Robert Großkopf wrote:

Hi Mike,


Snap-to-grid doesn't seem to do a lot - but as the grid size isn't 
changeable, it would not be a whole lot of help.


I'm creating very much forms for databases (also for other people). I'm 
using grid only. Helps me very much. Points of the grid are small - 
right. But grid size could be changed to every distance I need.


Thanks for the reply.

I've had another look at this. The grid spacing options are in the main 
'Options' menu, although the forms stuff has a local facility to turn 
off grid.


I still find the grid unusably faint though, even with a colour change. 
It must be an optical illusion, but the grid seems fainter the more I 
expand the screen image to get better accuracy. It seems quite dark with 
small scales, all but invisible at expanded scales.


The other issue is that, yes, it does snap horizontally to the grid. 
Vertically however it seems to snap to positions between the grid 
points, taking two unequal steps to move between snap locations. Most odd.



--
Mike Scott
Harlow, Essex, England


--
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] Writer form design grid

2024-02-15 Thread Mike Scott

On 11/02/2024 18:25, Robert Großkopf wrote:

Hi Mike,

you could set something for the grid in
Tools → Options → LibreOffice Writer → Grid
Subdivisin will set more ore less grid points between the main points.

You could set the color for the grid in
Tools → Options → LibreOffice → Application Colors → Writer → Grid
but the problem will be: the grid points are only one pixel.

You could use helplines while moving a control:
View → Grid and Helplines → Helplines while moving

Regards

Robert


Thanks for the input.

I've tried changing the colour, which helps a little. But the dots are 
still unusably faint I'm afraid. Oddly they're actually quite visible 
when the image is scaled down - but the more I magnify to allow more 
accurate positioning the fainter they appear.


Snap-to-grid doesn't seem to do a lot - but as the grid size isn't 
changeable, it would not be a whole lot of help.


The helplines do help to get rough alignment.

--
Mike Scott
Harlow, Essex, England


--
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 form design grid

2024-02-11 Thread Mike Scott

Hi all.

I've tried turning on the grid for form design in Writer. There are some 
dots there, but so faint as to be virtually invisible. It's quite unusable.


Is there a way of making them more visible, and even of changing the 
spacing please? I hope I've just missed something obvious!


Thanks.

--
Mike Scott
Harlow, Essex, England

--
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] pdf forms (OT?)

2024-02-09 Thread Mike Scott

On 09/02/2024 08:17, Robert Großkopf wrote:

Hi Mike,



It still leaves the question of how to extract the data from the 
completed form. Perhaps I've not hit the right keyword, but I've found 
/nothing/ on the net. Surely if there's a way of filling in a form, 
there's one of reading it!!


I have tested (for German Base Handbuch) 
https://www.pdflabs.com/tools/pdftk-the-pdf-toolkit/


Works with Linux this way:

for i in *.pdf ; do pdftk "$i" dump_data_fields_utf8 >> auswertung.txt ; 
done

...

Many thanks, that will work nicely. The output looks very easily 
parseable by perl, ready to make a sql database.



--
Mike Scott
Harlow, Essex, England


--
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] pdf forms (OT?)

2024-02-08 Thread Mike Scott

On 08/02/2024 18:14, Fred James wrote:

Mike Scott wrote:
Hi all. I've just been looking at making pdf forms with Writer. Easier 
than I'd thought.


I've been able to create a sample form with text fields and open this 
with xreader, evince or firefox. Firefox is able to display, edit and 
save a form whatever the content.


However, evince and xreader refuse to even show data for radio buttons 
or a checkbox control and will not alter the settings. Similarly, 
pdftotext does not print the setting of such a control.

..
Oh, and is there any known way (CLI) of extracting the data fields 
from a pdf form? pdftotext seems rather ham-fisted: surely there's 
something better!



Apologies if this is too far OT; but any advice would be helpful, thanks.


Mike Scott


Sorry ... not much experienece with LO pdf forms, or LO forms in 
general, but should very much like to know how your forms might function 
under Okular.  I am willing to try testing that for you, if you could 
send one of your forms to me attached to an email, but if you have 
access to Okular, your results would do as well.





Thanks for replying and for the offer. I've now installed Okular, and it 
does (once forms are enabled) allow editing and saving of the form. 
Presumably, evince and xreader are both buggy.


As well as my own efforts to see how things tick, I've also used the 
examples at the foot of this useful instructional page:

<https://www.linuxuprising.com/2019/02/how-to-create-fillable-pdf-forms-with.html>


It still leaves the question of how to extract the data from the 
completed form. Perhaps I've not hit the right keyword, but I've found 
/nothing/ on the net. Surely if there's a way of filling in a form, 
there's one of reading it!!


--
Mike Scott
Harlow, Essex, England


--
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] pdf forms (OT?)

2024-02-08 Thread Mike Scott
Hi all. I've just been looking at making pdf forms with Writer. Easier 
than I'd thought.


I've been able to create a sample form with text fields and open this 
with xreader, evince or firefox. Firefox is able to display, edit and 
save a form whatever the content.


However, evince and xreader refuse to even show data for radio buttons 
or a checkbox control and will not alter the settings. Similarly, 
pdftotext does not print the setting of such a control.


I'm not sure this is strictly an LO issue, but has anyone met similar 
problems with LO-produced forms?


I'm working on Mint 21.2 (LO 7.3.7.2), but will need the resulting pdf's 
to be usable by Windows users too.



Oh, and is there any known way (CLI) of extracting the data fields from 
a pdf form? pdftotext seems rather ham-fisted: surely there's something 
better!



Apologies if this is too far OT; but any advice would be helpful, thanks.


--
Mike Scott
Harlow, Essex, England

--
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] font gone AWOL

2023-10-03 Thread Mike Scott

On 29/09/2023 09:43, Mike Scott wrote:
Hi all. I'm sure I've missed something obvious here, but LO doesn't pick 
up a font that looks as though it's known to the system.


This is on linux Mint 21, LO 7.3.7.2 from the repo.

The font file is my own creation and of somewhat venerable antiquity (25 
years! how time flies!!). The file is MIKE_H.TTF, and lives in ~/.fonts; 
the font name is "MikesHandwriting".


The system's font management software tells me it's installed (code 
points U+0021 to U+00BE with gaps, then some outliers); the system text 
editor can see it. Yet LO writer does not show it.




Turns out LO has got a wrong font name from somewhere. The font is 
simply called 'New' in the LO drop-down menu.


OTOH, Character Map shows the font OK, and shows the correct name, as 
does Font Viewer.


Hmmm.


--
Mike Scott
Harlow, Essex, England


--
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] font gone AWOL

2023-09-29 Thread Mike Scott
Hi all. I'm sure I've missed something obvious here, but LO doesn't pick 
up a font that looks as though it's known to the system.


This is on linux Mint 21, LO 7.3.7.2 from the repo.

The font file is my own creation and of somewhat venerable antiquity (25 
years! how time flies!!). The file is MIKE_H.TTF, and lives in ~/.fonts; 
the font name is "MikesHandwriting".


The system's font management software tells me it's installed (code 
points U+0021 to U+00BE with gaps, then some outliers); the system text 
editor can see it. Yet LO writer does not show it.


I've not tried to use it for years, but I'm (almost!) sure it used to be 
available.


Any thoughts please? Thanks.


--
Mike Scott
Harlow, Essex, England

--
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: (unresolved) Re: [libreoffice-users] weirdness in save dialogue box

2023-08-24 Thread Mike Scott

On 14/08/2023 12:11, Mike Scott wrote:

On 12/08/2023 19:19, Steve Edmonds wrote:

Hi, you could file a bug and post the number here.


156765

.


And there it has sat for 10 days, and remains unassigned and un-updated.

Oh well. Nice idea though. What's the usual timescale for someone to at 
least say it's not going to be addressed?




--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England



--
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: (unresolved) Re: [libreoffice-users] weirdness in save dialogue box

2023-08-14 Thread Mike Scott

On 12/08/2023 19:19, Steve Edmonds wrote:

Hi, you could file a bug and post the number here.


156765


(If I've steered through bugzilla correctly!)



--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.


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


(unresolved) Re: [libreoffice-users] weirdness in save dialogue box

2023-08-10 Thread Mike Scott
OK, I see this thread's died out, so I assume there's no-one with a 
magical cure. I guess I'll have to persuade my wife that LO's own 
dialogue's are the way to go, although I confess I dislike them myself 
intensely.  It won't put me off LO :-}


But thanks to all for commenting.


--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England


--
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] weirdness in save dialogue box

2023-08-02 Thread Mike Scott

On 01/08/2023 20:33, Steve Edmonds wrote:

I posed a question a few weeks ago about "Save As" not having a 
suggested file name in the "Name" field, I had no replies possibly 
because no one else saw this incorrect behaviour. I see issues in KDE 
Dolphin, are you seeing the issues in MATE Caja. Has the issue been 
observed in Gnome Nautilus.




I've just tried running this on my headless freebsd server, with the X11 
output on my Mint desktop. I've no idea what sort of environment that 
offers the application on the server. I can say the dialogue boxes shown 
for failing-on-mint and working-on-mint files are fine: very akin to the 
LO style, and show (with a brief test) no issues at all.


And a further test on Raspberry Pi OS(*) with the same files shows much 
the same style of dialogue box as freebsd, again without obvious issues.


But as the problems seem to pop up rather randomly, those comments may 
be mis-leading.




(*) Pi4: surprisingly snappy in use! I've not tried it before.

--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.


--
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] weirdness in save dialogue box

2023-08-01 Thread Mike Scott

On 01/08/2023 10:32, Steve Edmonds wrote:

Are the goings on with LO 7.5.5.2 from the LO website using the OS 
native file dialogue and the goings on stop when using the LO file 
dialogue. If so it would point to a bug in LO.




OS native fails; AFAICT the LO-peculiar dialogues work OK. Does look 
like an LO issue; but how come lots of others aren't seeing the same, 
and how come it's so seemingly random?


(Not that I'm changing which I use: sorry, but the LO dialogue boxes I 
find confusingly different.)


--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England



--
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] weirdness in save dialogue box

2023-08-01 Thread Mike Scott

On 01/08/2023 00:53, Peter Hillier-Brook wrote:

sudo dpkg -iR /Downloads/

I don't see that as any harder than using the system package manager and 
repositories.





Hmmm. My reply from an hour or so ago doesn't seem to have made it 
through the list. But it's superseded anyway.


I've pulled out a spare machine and checked that it too was failing (LO 
7.3.5.2 from the ub repo running on Mint Mate 21)


I've installed LO 7.5.5.2 from the LO website, which to my relief 
installed alongside the older version.


7.5.5.2 shows exactly the same symptoms. So whatever is going on is 
nothing to do with the ubuntu packaging.



--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England



--
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] weirdness in save dialogue box

2023-07-31 Thread Mike Scott

On 30/07/2023 21:17, Steve Edmonds wrote:
.


I just switched from the KDE file manager (Dolphin) to the LO file 
load/save dialogues, there is definitely an issue with LO when using 
Dolphin that is not evident with other apps using Dolphin.

Philip, are you using LO from their site or an Ubuntu packaged version.


Mike, you say both machines are Mint, MATE or Xfce? Did you install from 
a PPA or the LO website.


Mint Mate; versions 21 and (iirc) 20.2 on the lappy.

LO is installed from the relevant ubuntu PPA. This machine (mint 21) 
says (synaptic) 1:7.3.7-0ubuntu0.22.0.4.3, but I think the other machine 
is on LO 6.something (IMBW) from the ub PPA. They have the same issue.


I do find the unpredictability rather concerning. I've just had to hunt 
for a "failing" file, but did find one. 'Save As' consistently (well, 
for the moment anyway!) adds the file extension in the dialogue. I 
switched to LO style dialogue boxes, and they behave as expected (file 
name given, no extension) - switching back to system style dialogues 
restores the wrong behaviour.


BTW, of two files -- an original plus a copy made with Caja (^C and ^V) 
-- they consistently (for now) behave in the two different ways.


Thanks all for more comments. I hesitate to raise a bug report over 
this; for one thing the LO web bug page I found last time pretty 
incomprehensible, but for another it's really not repeatable enough. I'm 
not really sure where to go from here.



--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.


--
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] weirdness in save dialogue box

2023-07-29 Thread Mike Scott

On 25/07/2023 21:17, Steve Edmonds wrote:



On 25/07/2023 22:17, Mike Scott wrote:

On 24/07/2023 17:39, Paul D. Mirowsky wrote:
Just out of curiosity, at any time did you receive a "Confirm File 
Format" window and unchecked the "Ask when not saving in ODF or 
default format" dialog?


An error in this function might react oddly, even though unlikely.


The "Confirm File Format" window only (and always) pops up when a 
non-odf format is picked from the drop-down box in the 'Save As' 
dialogue. "Ask when not saving in ODF..." is set in the LO options and 
re-appears (set) in the "Confirm format" window.


The odd thing today is that on this machine at least, I can't provoke 
the erroneous behaviour... I must have just clicked "Save As" 30 or 
more times, and all works perfectly. Would fail regularly when I last 
posted. The machine has just been rebooted though... surely that can't 
affect things!


Thanks to you and to all for comments.


Yesterday I observed the behaviour you described, just once, first time 
in a few years since the bug saving with file names containing multiple 
'.'s (i.e. API12.578.PT100SB.odt) was fixed. This time also I had a file 
name suggested in the "Save As" Name field, no extension showing, file 
type .odt selected and LO saved the file without any extension.

I couldn't repeat it. I have no idea what logic is involved.



Hmm the gremlins persist - my last email seems not to have made it to 
the list.


First, in answer to a query, the dialogue box style is set to system not 
LO's own. But as, today, I can't provoke the behaviour at all, I can't 
say whether the choice of style affects matters.


And the text of my last email, telling of a very odd thing, was as 
follows (apologies if anyone's already seen this):


===

Thanks for the comment; similar I guess.

The craziest thing today though. Having tried and failed to make my 
desktop fail again, I've just tried my rather slower laptop. The 
dialogue box briefly flashed up something I couldn't make out, so I set 
a screen recorder running. Serious weirdness is evident.


When I do the 'Save As', the dialogue box comes up. At one point as I 
step through frame-by-frame, the main area (the panel with a list of 
file names on disk) is empty, and the save as file name box at the top 
contains the highlighted file name, no type.


At the next frame, the main area is populated, and the filename box now 
contains the name plus highlighted type - which is the bad behaviour I 
have noted.


I should add, it took a couple of tries to get it to happen.

I can't imagine what's going on internally to do this. And seemingly 
randomly at that.


Maybe the gremlins are getting restless? :}

===

--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.


--
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] weirdness in save dialogue box

2023-07-25 Thread Mike Scott

On 24/07/2023 17:39, Paul D. Mirowsky wrote:
Just out of curiosity, at any time did you receive a "Confirm File 
Format" window and unchecked the "Ask when not saving in ODF or default 
format" dialog?


An error in this function might react oddly, even though unlikely.


The "Confirm File Format" window only (and always) pops up when a 
non-odf format is picked from the drop-down box in the 'Save As' 
dialogue. "Ask when not saving in ODF..." is set in the LO options and 
re-appears (set) in the "Confirm format" window.


The odd thing today is that on this machine at least, I can't provoke 
the erroneous behaviour... I must have just clicked "Save As" 30 or more 
times, and all works perfectly. Would fail regularly when I last posted. 
The machine has just been rebooted though... surely that can't affect 
things!


Thanks to you and to all for comments.


--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England



--
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] weirdness in save dialogue box

2023-07-24 Thread Mike Scott

On 22/07/2023 19:03, Steve Edmonds wrote:
I have just opened an older file, sometimes the file Name field is not 
blank when I "Save As" with older files until I edit and re-save.
This time the full name with extension does show. If I open Writer to an 
Untitled document and "Save As" the Name field is pre-filled with 
"Untitled" (no extension).


In Tools>Options>LO>General there is an option Open/Save Dialogues, I 
don't know if this setting would affect Mike's result.


I don't think so.

I've just been playing again with the problem. First up, I deleted 
~/.config/libreoffice/ to try to get a clean(er) start. (Not that this 
seems to have affected anything.)


There's a file JUNK.odt in my home directory, and which behaviour I get 
actually seems to vary randomly. I've tried even opening this document 
just the once and doing repeated 'Save As' + Cancel, and the behaviour 
occasionally changes from one to the other, sticking there for a while 
before switching back. Sometimes the 'Name' box in the dialogue says 
"JUNK.odt" [with the odt selected) and sometimes just "JUNK" [selected].


Checking on my laptop, which seems to be running an older version 
6.something (I think it's runnjing the previous Mint version), the same 
sort of behaviour is observable.


This is seriously weird, and very confusing for my wife, who regularly 
needs to send out .docx files to her contacts; in the mode where 
"JUNK.odt" is the style, she has to manually change the odt to docx, 
which should not be necessary.



--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.


--
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] weirdness in save dialogue box

2023-07-22 Thread Mike Scott

On 20/07/2023 00:14, Steve Edmonds wrote:

Does this still happen if you update to LO7.4?
If I open yyy.odt, and  click 'Save As' the field "Name" for file name 
is always blank.


On 19/07/2023 05:38, Philip Jackson wrote:

Hi :

I'm using 7.3.7.2 on UbuntuStudio and I'm always using 'save as' but 
I've never had the problem you describe. Sorry.


Philip

On 18/07/2023 16:13, Mike Scott wrote:
Hi all; a very weird issue has been found by my wife, which I can 
repeat on a separate machine. Both use LO 7.3.7.2 on Mint 21.


What happens is this. Take an odt file, open it in Writer then go to 
'Save As'. The expected behaviour is that the filename in the 
dialogue box will be filled in and selected/highlighted and there'll 
be no file type appended. Eg, I open yyy.odt, and 'Save As' displays 
just 'yyy' (highlighted).


However, sometimes and for no apparent reason, the dialogue box 
instead displays filename and file type ('yyy.odt'), with the type 
(only) highlighted. This causes issues when trying to save as a 
different type (eg as .docx)


(TLDR: open question at end! The details of my testing results are too 
long; sorry.)



Thanks all for comments, including one off-list. Ap[ologies for not 
getting back sooner - family matters intervened.


To clarify, my made-up name yyy.odt was (previously) by way of 
indicating what happens, not that that was the literal file causing 
problems. Apologies for any mis-direction.


I'm still none the wiser as to what's happening. I've just checked again 
the environment for the files. I have a file in a directory /dhome/mike, 
and an identical copy (^C ^V in a file manager) in /dhome/mike/temp of a 
file called

Saturday  song sheet.odt
(yes - there are two spaces together there, but that's not the issue)

I close LO. Double-click on the one in the temp directory, head for 
File|Save As. The filename is filled in

Saturday  song sheet
and selected. No file type.

So, I close LO. Double-click on the one in the higher directory; again 
File|Save As. This time, the file name and type appear;

Saturday  song sheet.odt
the /type/ alone is selected.

I cannot for the life of me understand why the behaviour in the two 
cases should be different.


To add to my confusion, I've just tried the following sequence of 
operations, starting with the "failing" file in /dhome/mike:


make a copy and change name:
cp Saturday\ \ song\ sheet.odt yyy.odt
open yyy.odt and see that Save As prefills the file name box as 
"yyy.odt" with the odt selected.


Rename and do the same again:
mv yyy.odt yy.odt
Same issue - Save As shows the name and type.

Finally, do it again:
mv yy.odt y.odt
But now y.odt opens the same, but Save As simply shows a highlighted "y" 
in the file name box.


Oh, and if I rename y.odt back to yy.odt, the problem comes back. And, 
if I copy yy.odt (fails) to my temp directory, all is well with the copy.


The thing is, when trying to save as .doc having the file type pre-set 
in the box causes a problem - LO will try to save a .doc (or whatever) 
as the type shown, and it needs manually changing. That's hazardous for 
someone like my wife, and can potentially lose the original .odt file.


I've just tried a similar sequence with the same file in my "real" home 
directory (/home/mike) with identical results.



**?
Does LO perhaps treat "top-level" directories in some way specially? My 
current guess is that multi-character file names in a "top-level" 
directory are treated differently from others. That would be very odd 
though, so IMBW!



Thanks for reading. I find this sort of problem hard to describe 
concisely. Am I missing something obvious?




--
Mike Scott
Harlow, Essex, England


--
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] weirdness in save dialogue box

2023-07-18 Thread Mike Scott
Hi all; a very weird issue has been found by my wife, which I can repeat 
on a separate machine. Both use LO 7.3.7.2 on Mint 21.


What happens is this. Take an odt file, open it in Writer then go to 
'Save As'. The expected behaviour is that the filename in the dialogue 
box will be filled in and selected/highlighted and there'll be no file 
type appended. Eg, I open yyy.odt, and 'Save As' displays just 'yyy' 
(highlighted).


However, sometimes and for no apparent reason, the dialogue box instead 
displays filename and file type ('yyy.odt'), with the type (only) 
highlighted. This causes issues when trying to save as a different type 
(eg as .docx)


Even more odd is that simply copying  (^C, ^V in a file manager) a 
wrongly-behaving file to a different directory can change the behaviour.


I wondered if my wife had managed to include some weird character, but
the filename /looks/ kosher: 'ls -1 | od -cb' shows nothing untoward. 
And indeed, one or two of my own files show the same behaviour. (I 
rarely use 'Save As' anyway.)



I'm at a bit of a loss about where to check next. Has anyone else 
experienced this please and can say what's happening?


TIA.


--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England


--
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] Image Anchor Selection

2023-06-12 Thread Mike Scott

On 07/06/2023 22:28, Joe Conner wrote:


On 6/7/23 14:22, W. Robert J. Funnell, Prof. wrote:

Joe -

It may be worth reading the thread at 
https://ask.libreoffice.org/t/problem-with-anchor-picture-in-all-page/61556/6, perhaps especially the last message, by mikekaganski. As I understand it, the 'Anchor to page' feature is still available but has been made somewhat harder to get at because its use has caused a lot of confusion.


- Robert



Excellent article.

Thank you. Joe



A thought in passing - it would seem the OP's issue is that the UI has 
changed, but he had no (ready) way of knowing in what way. In this case 
a context menu item has been moved to the depths of a dialogue box.


Might it be a good idea, when this is done, to leave the original menu 
entry in place, but have it just show an information box saying where 
the item can be found and maybe give a pointer to [a web page with] some 
hints on the matter? And leave that in place for several releases.



--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.


--
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] Badly formatted document

2022-07-04 Thread Mike Scott

On 04/07/2022 17:59, Ian Bertram wrote:


-->
I have been sent a graphic heavy document in ODT format. However it looks as if 
it has been badly converted from a pdf file. The layout is scrambled, headers 
don’t align properly and there are a host of other issues. It is also in 
columns. Is there a simple way to strip out everything bar the words? I have 
tried saving it as a txt file, but this loses a lot of the paragraph numbering 
and introduces other layout issues. Saving in rtf format is even worse.


You might try this.

Open the odt with an archive manager - it's just a zip file. Extract 
content.xml, then run this perl program, which will extract the text 
from that:


#!/usr/bin/perl

use strict;
use warnings;

use XML::LibXML;

my $filename = 'content.xml';

binmode(STDOUT, ":utf8");
binmode(STDERR, ":utf8");

my $dom = XML::LibXML->load_xml(location => $filename) or die "open?\n";

foreach my $para 
($dom->findnodes('/office:document-content/office:body/office:text/text:p')) 
{

my $b = $para->to_literal;
print $b, "\n";
}


Works for me but YMMV. BEWARE email line wrap in the 'foreach' line. The 
single line should say foreach ... p')) {




--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

--
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] odt to text keeping formatting?

2022-05-02 Thread Mike Scott

On 02/05/2022 15:33, Brad Rogers wrote:

On Mon, 2 May 2022 14:47:39 +0100
Mike Scott  wrote:

Hello Mike,


Save as text file produces something left-aligned - presumably because
the indents seem to be a result of left-margin settings


I see.  My indents were as a result of tabs, so that would probably
account for the difference.

Nothing's ever easy.   :-(



Nope,that's too often true.

I've just worked through 500 pages of lyrics manually marking the 
choruses. Surprisingly fast, in fact. Basic problem solved, but it would 
be good to know for the future.


Thanks.



--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

--
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] odt to text keeping formatting?

2022-05-02 Thread Mike Scott

On 02/05/2022 11:54, Brad Rogers wrote:

On Mon, 2 May 2022 11:38:29 +0100
Mike Scott  wrote:

Hello Mike,


Is there any way of converting to a plain text file while keeping some
semblance of the layout please? odt2txt extracts the text, but of
course loses the indentation.


Simply using "Save As...", then selecting TXT type works, IME.  You'll
get a warning about losing formatting, but indents are preserved.  Of
course, any bold, italics, super/subscript and underline, etc. will be
lost.



Thanks for the reply; but that's not what I get.

Save as text file produces something left-aligned - presumably because 
the indents seem to be a result of left-margin settings in the paragraph 
styles. I was hoping odt2txt would fare better, but no.


The original is actually a .docx file; there's no overall common styling 
in the document to hunt for in the xml part of the odt file.



I've also looked at going via pdf and pdftotxt (gets garbage), and 
installing a pseudo line printer (can't figure out how to save-to-file). 
CUPS's own print-to-file creates postscript, which isn't useful in this 
context.



LO 6.4.7.2 on linux mint, btw.


--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

--
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] odt to text keeping formatting?

2022-05-02 Thread Mike Scott
Hi all; I've an odt file of song words, nicely laid out using paragraph 
styles to provide indents for choruses.


Is there any way of converting to a plain text file while keeping some 
semblance of the layout please? odt2txt extracts the text, but of course 
loses the indentation.


Thanks.


--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

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


(resolved) Re: [libreoffice-users] libreoffice grabs network port

2022-04-25 Thread Mike Scott

On 22/04/2022 15:38, Dave Howorth wrote:



What investigation have you done? Why do you think the problem is with
LO rather than with mojolicious or somewhere in between?

Also, what is runcmd()?


Sorry, should have said it's a wrapper for perl's open3() (itself a 
wrapper for system() ) which runs the given command. But see below.

.


Steps I would be thinking of trying:
(1) add debugging prints to the mojolicious code so you can see exactly
what arguments are passed on each occasion
(2) for some case where the problem occurs run LO directly from the
command line with the same arguments and see if the problem occurs



Thanks for the reply. I've been banging my head against a wall, because 
all of mojolicious, perl's IPC and LO are to varying degrees unfamiliar. 
I certainly mis-understood what I was seeing, processes running LO and 
with the web network port listening: it's actually correct and harmless.


The problem is now resolved, and at the root was related to running the 
program detached as a daemon. I had a web server running LO internally, 
which ran correctly from a terminal; ran correctly when detached with 
magic using () and shell redirects; but which failed when run "properly" 
with freebsd's 'daemon' command.


Obvious in hindsight, the issue was that the daemon, running as user 
www, didn't have access to a writeable home directory, so LO couldn't 
run because it needs a rather large file tree there. That was compounded 
with my misunderstanding of perl's open3() error handling.


I'm now using the -env:UserInstallation=XX option to give LO a 
temporary place to put its bits and bobs, and all - finally - seems to 
function. At least, LO runs and does the conversions. I do wonder why 
there's an oosplash process started when I'm using --nologo and 
--headless though! It also creates more soffice.bin processes than I'd 
expect, but they seem to tidy themselves away eventually.


I'm not sure why I had so much trouble here, compared to a couple of 
years ago, when I was running LO from apache/php without particular bother.


All's well that end's well, I guess. Mojolicious has a steep learning 
curve, but is much easier and cleaner to use than php for this job. LO 
works, albeit slowly -- ~20 seconds to do the .odt->.doc conversion on a 
pi4.


Again, thanks.




--
Mike Scott
Harlow, Essex, England

--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

--
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] libreoffice grabs network port

2022-04-22 Thread Mike Scott

Hi all. A bit of a saga for me.

I'm using LO headless from within a web server.

The server is the perl-based mojolicious, and calls LO do do some file 
conversions from .odt to .doc and pdf.


LO is called like:
runcmd( 'soffice', '--headless', '--convert-to', $filter, '--outdir', 
$outdir, $odtfile );


followed by a call to mojo's render() stuff to pass the file to the user.

Which often works.

But (with varying frequency) LO seems to grab the web server's port 
somehow and sets up its own listen on it. This somewhat damages the web 
link :-| I've seen multiple copies of soffice and oosplash listening on 
the same port (a high-numbered, obscure one). I can't even see how this 
is possible



The question is, why does it do this, and how do I stop it?

TIA.



Linux mint, btw, ooo 6.4.7.2


--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

--
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] corrupt files when using command line --print-to-file

2022-04-22 Thread Mike Scott

On 11/04/2022 17:17, Mike Scott wrote:

On 11/04/2022 15:16, Philip Jackson wrote:

Hi Mike,

I'm using LO 6.4.7.2 on UbuntuStudio 20.04 LTS and your --headless 
command line instruction works and produces a pdf file which passed 
the pdfinfo check with flying colours. I just rechecked to make 
sure.   So maybe your problem is distro related?


Thanks for your reply. Interesting to know it works for someone else 
I'll do a bit more checking on what's going on here.




The issue seems to come and go depending obscurely on the exact file: 
I'm currently using a workaround.


There are worse problems though. I'll start a new thread.


--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

--
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] corrupt files when using command line --print-to-file

2022-04-11 Thread Mike Scott

On 11/04/2022 15:16, Philip Jackson wrote:

Hi Mike,

I'm using LO 6.4.7.2 on UbuntuStudio 20.04 LTS and your --headless 
command line instruction works and produces a pdf file which passed the 
pdfinfo check with flying colours. I just rechecked to make sure.   So 
maybe your problem is distro related?


Thanks for your reply. Interesting to know it works for someone else 
I'll do a bit more checking on what's going on here.




But I don't use the --headless command very often because it breaks the 
links in my pdf output. So, I make use of the LO Writer gui to do   
file> export as>export as pdf  which gets me a workable pdf with working 
links (clickable table of contents etc). If I need to reassemble some 
pdf docs, I use pdftk utility because so many of the others break those 
links.


I can't use the gui at all. The target document odt is actually created 
by a perl web script that modifies a template odt file, then converted 
using LO to either doc or pdf for the end user all running in the cgi 
context.


IIRC simple pdf conversion loses brochure formatting when present in the 
document, hence use of --print-to-file.




Philip

On 11/04/2022 10:51, Mike Scott wrote:
I'm having a spot of bother trying to get a .ps or .pdf produced from 
a .odt using the command line.


I've revisited some code last used a few years ago, whose last step is 
just to use LO to do this conversion. It used to make a .ps file, but 
that now seems to have changed, and I get a .pdf instead - which is 
corrupt.



So I get for example


libreoffice --headless --print-to-file --outdir "./"  "./y.odt"
print /dhome/mike/homebrew software/service sheet production/web 
generator/y.odt -> /dhome/mike/homebrew software/service sheet 
production/web generator//y.pdf using 



pdfinfo y.pdf

Syntax Warning: May not be a PDF file (continuing anyway)
Syntax Error (2432): Illegal character '{'
Syntax Error: Couldn't find trailer dictionary
Syntax Error: Couldn't find trailer dictionary
Syntax Error: Couldn't read xref table

The resulting pdf won't load into a browser and upsets several of the 
pdf tools, although gimp or xreader can read it. Fortunately, pdf2ps 
accepts the file, so as a workaround, I do the LO --print-to-file and 
then run the result through pdf2ps and then back through ps2pdf; the 
result of that contortion seems OK.



Looking at the GUI instead, under the tools|options|print page, if I 
try to set options for print to file, the tick box for pdf is set and 
disabled. Yet if I select print to file in the normal print dialogue, 
I get a valid .ps file not a pdf.


I need to run this as a print job, since '--convert-to pdf' doesn't 
honour the brochure setting in place in the document. Using the GUI 
and printing works fine, but isn't useful for automated processing.


If anyone has a way better of doing a command line conversion to a pdf 
while honouring in particular the 'brochure' setting, I'd be grateful.




(This is with LO 6.4.7.2 under mint 20)





--
Mike Scott
Harlow, Essex, England

--
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] corrupt files when using command line --print-to-file

2022-04-11 Thread Mike Scott

Hi all.

I'm having a spot of bother trying to get a .ps or .pdf produced from a 
.odt using the command line.


I've revisited some code last used a few years ago, whose last step is 
just to use LO to do this conversion. It used to make a .ps file, but 
that now seems to have changed, and I get a .pdf instead - which is corrupt.



So I get for example


libreoffice --headless --print-to-file --outdir "./"  "./y.odt"
print /dhome/mike/homebrew software/service sheet production/web 
generator/y.odt -> /dhome/mike/homebrew software/service sheet 
production/web generator//y.pdf using 



pdfinfo y.pdf

Syntax Warning: May not be a PDF file (continuing anyway)
Syntax Error (2432): Illegal character '{'
Syntax Error: Couldn't find trailer dictionary
Syntax Error: Couldn't find trailer dictionary
Syntax Error: Couldn't read xref table

The resulting pdf won't load into a browser and upsets several of the 
pdf tools, although gimp or xreader can read it. Fortunately, pdf2ps 
accepts the file, so as a workaround, I do the LO --print-to-file and 
then run the result through pdf2ps and then back through ps2pdf; the 
result of that contortion seems OK.



Looking at the GUI instead, under the tools|options|print page, if I try 
to set options for print to file, the tick box for pdf is set and 
disabled. Yet if I select print to file in the normal print dialogue, I 
get a valid .ps file not a pdf.


I need to run this as a print job, since '--convert-to pdf' doesn't 
honour the brochure setting in place in the document. Using the GUI and 
printing works fine, but isn't useful for automated processing.


If anyone has a way better of doing a command line conversion to a pdf 
while honouring in particular the 'brochure' setting, I'd be grateful.




(This is with LO 6.4.7.2 under mint 20)

--
Mike Scott
Harlow, Essex, England

--
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] videos in impress

2021-05-26 Thread Mike Scott

On 20/05/2021 14:11, Italo Vignoli wrote:

On 5/20/21 12:15 PM, Mike Scott wrote:

On 20/05/2021 10:46, Italo Vignoli wrote:


I will check. I can sed the video back, and have the text on top of 
it, maybe is just the configuration of the text animation (as the 
text to be on top of the video has to be managed with an animation).


Thanks.

Not sure where you're going with text animation. I don't know whether 
you're referring to the 'text animation' tab on the graphic styles 
menu, or a custom transition. Either way, I can make nasty flickery 
effects, but not keep the video at the back.


A text animation is an action added to a text, which allows to determine 
how, where, when and for how long that text appears on the slide. I have 
always managed to have text over other objects without issues, I have 
not yet checked with the last version, but I can only work on it during 
the weekend.


Thanks to all for the input.

The problem persists, but I'm guessing there's no solution. To sum up:

(1) embedding or linking produce different results: linking shows a 
placeholder during slide transition, embedding shows a frame of video.


(2) The playing video is always on top of anything else; the placeholder 
however does obey the on-top/to-back directives. This is independent of 
video hardware and driver AFAICS.


(3) The flickering I noted in passing is driver-related: using the nv 
driver, some slide transitions flicker; using nouveau they behave 
properly. (Same sort of thing seems to happen with kdenlive's playback FWIW)



I sorted the weekend's presentation issue using OBS Studio. This even 
allows a video to play continuously across scene transitions, which was 
perfect for the job in hand. And, looking to the future, it allows 
embedding of other applications' windows into the 'show', which offers a 
lot of flexibility.



Probably best to close this thread now; thanks again.



--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

--
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] videos in impress

2021-05-20 Thread Mike Scott

On 13/05/2021 21:58, Dave Howorth wrote:

On Thu, 13 May 2021 17:14:26 +0200
Italo Vignoli  wrote:


On 5/13/21 4:59 PM, Mike Scott wrote:


Sorry for following up my own post, but the laptop results were
unexpected. Either drag-and-drop or using menu Insert gave the same
results - both produced an object showing the blue 'film' icon, in
the design mode, and at the video start when running a slide show.
It's a recent low-end Dell pentium laptop, Intel integrated
graphics. It's running the same version of LO/Mint as the desktop I
normally use.



Maybe it is worth posting a sample presentation that works for you
somewhere so that Mike could test it? And maybe Mike could do the same
so you could test his presentation to see whether it works or not for
you?



Maybe. Thanks for the input.

I've now looked in content.xml. The difference between getting the video 
in by drag and drop, and via the Insert menu seems to be purely that D 
links, while insert (by default) embeds the video. All other parameters 
seem the same:


svg:width="34cm" svg:height="19.125cm" svg:x="17.6cm" svg:y="21.4cm">
xlink:type="simple" xlink:show="embed" xlink:actuate="onLoad" 
draw:mime-type="application/vnd.sun.star.media">







and

svg:width="29.085cm" svg:height="16.36cm" svg:x="2.8cm" svg:y="2.2cm">
xlink:type="simple" xlink:show="embed" xlink:actuate="onLoad" 
draw:mime-type="application/vnd.sun.star.media">








If I do an insert, and ask for the video to be linked, I again get the 
poor fade-in  behaviour - the dummy placeholder shows (behind the text) 
as the slide fades in and is replaced by the playing video (on top of 
the text) when fade-in is complete.


Doesn't seem affected by switching between nv and nouveau graphics drivers.

I've no idea yet where the z ordering is saved. In all cases the video 
plays in front of everything else. Might this be a video hardware 
limitation of some sort?



--
Mike Scott
Harlow, Essex, England

--
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] videos in impress

2021-05-20 Thread Mike Scott

[resent]

On 13/05/2021 21:58, Dave Howorth wrote:

On Thu, 13 May 2021 17:14:26 +0200
Italo Vignoli  wrote:


On 5/13/21 4:59 PM, Mike Scott wrote:


Sorry for following up my own post, but the laptop results were
unexpected. Either drag-and-drop or using menu Insert gave the same
results - both produced an object showing the blue 'film' icon, in
the design mode, and at the video start when running a slide show.
It's a recent low-end Dell pentium laptop, Intel integrated
graphics. It's running the same version of LO/Mint as the desktop I
normally use.



Maybe it is worth posting a sample presentation that works for you
somewhere so that Mike could test it? And maybe Mike could do the same
so you could test his presentation to see whether it works or not for
you?



Maybe. Thanks for the input.

I've now looked in content.xml. The difference between getting the video 
in by drag and drop, and via the Insert menu seems to be purely that D 
links, while insert (by default) embeds the video. All other parameters 
seem the same:


svg:width="34cm" svg:height="19.125cm" svg:x="17.6cm" svg:y="21.4cm">
xlink:type="simple" xlink:show="embed" xlink:actuate="onLoad" 
draw:mime-type="application/vnd.sun.star.media">







and

svg:width="29.085cm" svg:height="16.36cm" svg:x="2.8cm" svg:y="2.2cm">
xlink:type="simple" xlink:show="embed" xlink:actuate="onLoad" 
draw:mime-type="application/vnd.sun.star.media">








If I do an insert, and ask for the video to be linked, I again get the 
poor fade-in  behaviour - the dummy placeholder shows (behind the text) 
as the slide fades in and is replaced by the playing video (on top of 
the text) when fade-in is complete.


Doesn't seem affected by switching between nv and nouveau graphics drivers.

I've no idea yet where the z ordering is saved. In all cases the video 
plays in front of everything else. Might this be a video hardware 
limitation of some sort?



--
Mike Scott
Harlow, Essex, England

--
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] videos in impress

2021-05-13 Thread Mike Scott

On 13/05/2021 12:11, Mike Scott wrote:

Thank you again.

Firstly, I was using drag-and-drop rather than using the menu & insert. 
It does seem the behaviour is unexpectedly different, and during design, 
d shows the icon, while 'insert' shows a frame from the video. As you 
say, the icon does not appear when playing under your conditions.



..
As it works for you I wonder if there's an issue with video drivers. I'm 
using nvidia-340, on some rather old hardware. There is some obscure 
bug(s) that seems to affect both LO and kdenlive, causing flashing 
during some fades (LO/Impress) or sometimes during video playback 
(kdenlive).



I'll try this on my laptop, and see if it works any better.



Sorry for following up my own post, but the laptop results were 
unexpected. Either drag-and-drop or using menu Insert gave the same 
results - both produced an object showing the blue 'film' icon, in the 
design mode, and at the video start when running a slide show. It's a 
recent low-end Dell pentium laptop, Intel integrated graphics. It's 
running the same version of LO/Mint as the desktop I normally use.


Weird.


--
Mike Scott
Harlow Essex England

--
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] videos in impress

2021-05-13 Thread Mike Scott

Thank you again.

Firstly, I was using drag-and-drop rather than using the menu & insert. 
It does seem the behaviour is unexpectedly different, and during design, 
d shows the icon, while 'insert' shows a frame from the video. As you 
say, the icon does not appear when playing under your conditions.


However, there's still a major problem. The slide fades in with the 
video at the bottom of the  stack, and the text visible. However, as 
soon as the fade is complete, the video pops to the top and remains there.


Under some conditions there also appears a background image that looks 
like a static frame from the video enlarged to cover the entire screen - 
not reproducibly though.


As it works for you I wonder if there's an issue with video drivers. I'm 
using nvidia-340, on some rather old hardware. There is some obscure 
bug(s) that seems to affect both LO and kdenlive, causing flashing 
during some fades (LO/Impress) or sometimes during video playback 
(kdenlive).



I'll try this on my laptop, and see if it works any better.

Thanks for your patience!


On 13/05/2021 09:25, Italo Vignoli wrote:
Using the process I have described, the video can be sent to back as any 
other object, and you can superimpose the text. Also, no icon shows at 
the start of the video.


Done in over 200 presentations during the last 10 years.

On 5/13/21 9:48 AM, Mike Scott wrote:

(resent)

Thank you for your reply.

However, the issue is not that I cannot insert a video into a slide. 
The problems are (a) that the inserted video is always "on top" of 
other objects, whereas I want text superimposed over the video, and 
(b) the annoying icon that always seems to show at the start of the 
video (and sometimes at the end).


My possible workaround is to use OBS Studio instead, which has other 
issues but at least gives an easy option to have changing text 
superimposed onto a video without artifacts. I'd rather use LO though!



On 12/05/2021 13:06, Italo Vignoli wrote:

Menu Insert > Audio or Video

Choose the video from the selection window, deselect "Insert as Link"




--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

--
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] videos in impress

2021-05-13 Thread Mike Scott

(resent)

Thank you for your reply.

However, the issue is not that I cannot insert a video into a slide. The 
problems are (a) that the inserted video is always "on top" of other 
objects, whereas I want text superimposed over the video, and (b) the 
annoying icon that always seems to show at the start of the video (and 
sometimes at the end).


My possible workaround is to use OBS Studio instead, which has other 
issues but at least gives an easy option to have changing text 
superimposed onto a video without artifacts. I'd rather use LO though!



On 12/05/2021 13:06, Italo Vignoli wrote:

Menu Insert > Audio or Video

Choose the video from the selection window, deselect "Insert as Link"

The video will be placed in the middle of the slide, as a normal object 
(which can be aligned or arranged)


Using the handles, reside the video to the expected size

Menu Insert > Text Box

Click to position the text box over the video, and then create the 
animation to manage the text box (please be careful, the mouse click can 
advance to the next slide because of the video, so you may have to use 
timings to show/hide text boxes)


Anyway, this is explained in the LibreOffice Impress Manual, with lot of 
details


On 5/12/21 12:19 PM, Mike Scott wrote:

Hi all.

I've steered clear for some years of trying to include a video in an 
impress presentation, as I've always had problems.


The need has re-arisen however, and I'm stuck on two points:

1. The video is always "on top" of other items, irrespective of any 
"send to back" setting. I need a video with superimposed text, and 
can't seem to manage this. What I'm trying to achieve is a video 
running in the background, with foreground text that changes on mouse 
click.


2. A video always seems to start with an icon (two frames of a film 
strip, in blue/white) rather than starting gracefully. It's the same 
icon used as placeholder when designing the slide. That gives a 
jarring loss of continuity when running the slide show. (Ironically, 
the icon obeys "send to back" where the video itself does not.)


Is there any work-round for these please?
Thanks.


LO 6.4.7.2 running on Mint 20.





--
Mike Scott
Harlow, Essex, England

--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

--
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] videos in impress

2021-05-12 Thread Mike Scott

Hi all.

I've steered clear for some years of trying to include a video in an 
impress presentation, as I've always had problems.


The need has re-arisen however, and I'm stuck on two points:

1. The video is always "on top" of other items, irrespective of any 
"send to back" setting. I need a video with superimposed text, and can't 
seem to manage this. What I'm trying to achieve is a video running in 
the background, with foreground text that changes on mouse click.


2. A video always seems to start with an icon (two frames of a film 
strip, in blue/white) rather than starting gracefully. It's the same 
icon used as placeholder when designing the slide. That gives a jarring 
loss of continuity when running the slide show. (Ironically, the icon 
obeys "send to back" where the video itself does not.)


Is there any work-round for these please?
Thanks.


LO 6.4.7.2 running on Mint 20.


--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

--
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] impress - slide transitions not working

2019-12-21 Thread Mike Scott

On 17/12/2019 01:59, Remy Gauthier wrote:

I tried the slide transitions you mention (dissolve - both fine and
standard, and fade - with both offered variants) and I cannot see the
effect you are describing. If it can help, this is my running
environment:


Thanks for the comment.

I'm quite bemused by what I observe.

On the spare Celeron, the appimage works fine. But the same appimage on 
my desktop box (now upgraded OS) fails with an even worse flicker than 
before.


I've tried both nouveau drivers and also the integrated video interface: 
the exact same problem. Yet booting off a live CD and running the exact 
same appimage with the exact same .odp file works perfectly (I've not 
tried the 'live'-provided packages).


I've also just found - only on my desktop box - that it won't recognise 
any audio file to use with a slide transition: this is fine on the spare 
machine and the laptop. Suggests there's something very amiss with the 
mint installation on my desktop; time to reinstall, perhaps.


Yet, it can't be all down to one bad installation: slides flicker on the 
spare with the mint-provided packages, and also on my wife's desktop 
(also mint 18.x). I'll have to think about this a bit.




--
Mike Scott
Harlow, Essex, England

--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

--
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] impress - slide transitions not working

2019-12-16 Thread Mike Scott

Apologies for following up my own post and for top-posting.

I've been struggling with this and the lack of response. I've now found 
it's a long-standing problem, back to 2014/2015 and the early 5.x 
versions. 4.x seems to have been OK. It seems poor that the dev's 
haven't addressed what is clearly, for some, a long-standing 
show-stopper regression :-{


I have found that 6.0.x on my 32 bit laptop works fine. I'm wondering if 
it's a specific 64-bit issue.


Does anyone have a fix that I've missed please?


On 13/12/2019 09:08, Mike Scott wrote:

Hi all.

I'm having a bit of trouble with some slide transitions.

I've got 3 computers that all behave differently. They all run linux 
mint, with varying versions of LO installed.


When fed the exact same slide show, with my chosen "dissolve" or "fine 
dissolve" I find that:


1. on my 64-bit desktop machine (LO 5.1.6.2 mint 18.3) the transition 
does the dissolve, but with a nasty flicker to a white screen. Other 
transitions are jerky. nvidia graphics


2. On my 32-bit lappy (LO version not to hand, but still mint 18.3) all 
works perfectly (intel graphics)


3. On a second 64-bit, freshly installed machine (LO 6.0.7.3/mint 19.2), 
the "fade" transition is simply a sharp cut. Intel graphics of some 
sort. Some transitions do work, eg dissolve, push; some fail, eg fade, 
iris, cube)


I'd originally put #1 down to the driver, but it's as bad with either 
nvidia's X driver, or nouveau. #3 is bad, as this was to be my backup 
machine for a presentation next weekend, in case the (elderly) laptop 
failed.



I'm going to try to downgrade the LO6 to see if that helps, but 
meanwhile, any thoughts please?


TIA.


(BTW the other working transitions aren't really appropriate for the 
particular environment. Otherwise they'd be a workround.)






--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

--
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] impress - slide transitions not working

2019-12-13 Thread Mike Scott

Hi all.

I'm having a bit of trouble with some slide transitions.

I've got 3 computers that all behave differently. They all run linux 
mint, with varying versions of LO installed.


When fed the exact same slide show, with my chosen "dissolve" or "fine 
dissolve" I find that:


1. on my 64-bit desktop machine (LO 5.1.6.2 mint 18.3) the transition 
does the dissolve, but with a nasty flicker to a white screen. Other 
transitions are jerky. nvidia graphics


2. On my 32-bit lappy (LO version not to hand, but still mint 18.3) all 
works perfectly (intel graphics)


3. On a second 64-bit, freshly installed machine (LO 6.0.7.3/mint 19.2), 
the "fade" transition is simply a sharp cut. Intel graphics of some 
sort. Some transitions do work, eg dissolve, push; some fail, eg fade, 
iris, cube)


I'd originally put #1 down to the driver, but it's as bad with either 
nvidia's X driver, or nouveau. #3 is bad, as this was to be my backup 
machine for a presentation next weekend, in case the (elderly) laptop 
failed.



I'm going to try to downgrade the LO6 to see if that helps, but 
meanwhile, any thoughts please?


TIA.


(BTW the other working transitions aren't really appropriate for the 
particular environment. Otherwise they'd be a workround.)



--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

--
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] Resize object symmetrically?

2019-09-14 Thread Mike Scott

On 12/09/2019 22:19, Johnny Rosenberg wrote:
.


Aaah! I think I got it.
It seems to be different depending on how you drew the original shape. If I
select a square and draw it, then uncheck the keep ratio check box in
"Position and Size", then I get those strange results in my previous post.
If I, on the other hand, draw a rectangle while holding the shift key to
create a square in the first place, then when I drag and release to change
its size, everything works as expected.
I'äm not sure why, though. So something might be wrong after all, but not
sure if it's a bug or a feature.

Johnny Rosenberg



Am I missing something in this discussion?

The OP asked:
"let's say I want to make it larger vertically and as click & hold 
and drag down I want it to not just get bigger vertically down but 
symmetrically up too;..."


It seems to me he's asking, not for proportions to be kept the same, but 
for resizing not to move the centre of the object.


So in Inkscape, I drag a handle on the right of the object: right edge 
moves. I shift-drag on the right, and both right and left edges move, 
keeping the centring the same.


Control-drag keeps proportions the same, moving right, top, bottom 
edges; control-shift drag keeps proportions and centring the same, 
moving all 4 edges.


OTOH in Draw, dragging a right edge moves the right edge; shift-dragging 
moves right, top and bottom, keeping proportions and shifting the centre 
horizontally. And that's all the choice you have.


It's been an annoying (mis-)feature as long as I remember.


--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

--
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] odt file contents - naming of files in Pictures/ directory

2019-07-26 Thread Mike Scott

Hi all; I've just come unstuck near the end of a project.

I'm creating an odt file pretty much from scratch. All works, but I need 
to embed an image within the odt file rather than just linking to an 
external image (the latter works OK).


Unfortunately, images within the Pictures/ directory seem to obey some 
naming convention that's currently outwitting me.


I've tried manually renaming an image inside an existing document and 
editing content.xml to correspond. LO complains the file is broken, 
suggesting the strings cannot be random.


Example names I see in Pictures/ are (the sole 2 pictures from the same 
document):-

10CE008999F5303D619DABFE.png
10CE00896E838079907CA15F.png

Changing DABFE to DABFF (and content.xml to match) causes LO to offer to 
repair a broken document -- regenerating the original name.


Can anyone say exactly how those names are generated please? (Or where 
it would be documented. I've seen the odf spec does not define this area.)


Thanks.

--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

--
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 6.2.x save dialog on Linux

2019-06-14 Thread Mike Scott

On 12/06/2019 19:12, aguador wrote:

Does anyone on the list, whether from the DF or a user, know if there
are plans to improve the save dialog?

As it stands, at least on Linux, separate partitions and connected
drives are no longer shown in the dialogue. Saving to such a partition
or drive means navigating there through the root directory. I know that
it is possible to save the location, but this does not help if you are
saving to a new or infrequently used external device.



Which dialogue box style have you selected?

Under Tools|Options|LibreOffice|general you get the option to choose 
LO-style dialogues.


If I pick 'LO-style' I see what you appear to be describing; clearing 
that checkbox gives a more sensible (IMO) dialogue box.


(LO 5.1.6.2 on Mint Sylvia)


--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

--
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] Re: FODT Write Error. The file could not be written.

2019-04-26 Thread Mike Scott

On 26/04/2019 11:02, Francesco Ongaro wrote:

Dear LibreOffice Community,

sorry to bother, do you think there is a better place to ask such
question?

I'm available to rebuild Libreoffice with symbols and debug it with
a little guidance (c++ sources are huge!).


You really do /not/ want to go there :-} :-}



Thanks,
Francesco

On 12/04/19 21:05, Francesco Ongaro wrote:

Dear LibreOffice Community,

I programmatically generate a FODT that opens without any problem and
can be edited.

When saving such FODT document I get "Write Error. The file could not be
written.".



You might get more help if you included information such as your OS and 
the LO version.


There are a couple of very obvious things to check meanwhile - are the 
file and directory permissions set to allow you to do the save?


As it's flat xml, try opening it in your choice of ordinary text editor 
and seeing if you can do the equivalent save operation from there (you 
don't say why you think it's an LO issue).




--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

--
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] Draw: page numbering [RESENT]

2019-01-07 Thread Mike Scott

On 05/01/2019 13:15, Albrecht Dreß wrote:

Hi all,

I want to create a rather huge document in LO Draw (actually a photo 
collection) with numbered pages.  Thus, I want to split the document 
into multiple parts, export them separately as PDF, and glue the 
resulting PDF together.


Adding the page/slide number in the master is of course simple, but it 
starts with "1" for each document.  Is it possible to change the start 
number somehow, i.e. to print e.g. "20" on the 1st page of the 2nd 
document part?


Thanks in advance,
Albrecht.


FWIW I use pdftk with the 'multistamp' option to do much the same - a 
set of disparate pdf files (not all from LO) that I glue into one volume 
using pdfunite.


You can create a file that contains just page numbers plus any other 
common information and superpose this on your combined pdf - just make 
sure to leave space for the numbers.


I can't offhand see any way of changing LO's own numbering.

--
Mike Scott
Harlow, Essex, England


--
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] centring text boxes

2018-09-25 Thread Mike Scott

Today's daft question.

Why can't you automatically centre up a text box on the page in Writer?

If I have an image, I do R-click, Alignment, and pick from a useful 
selection of options.


Try the same on a text box and I get "".

It makes laying out a page (and I've just started on an order of service 
for a funeral) decidedly frustrating.


(Nor for that matter do styles work in a text box. I fail to understand 
the issues here.)



(LO 5.1.6.2/Mint, BTW)



--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

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


[resent] Re: [libreoffice-users] report builder query - how to suppress output.

2018-09-03 Thread Mike Scott
(originally sent from non-subscribed address; that seems to have 
vanished. Trying again with my subscribed list address)


On 28/08/18 14:12, Robert Großkopf wrote:

Hi Mike,


I can do a simple-minded report using report builder, which looks at the
moment to fulfil the need, except for one problem. When a database field
is empty (eg, no email or no 2nd address line), is there any way of
completely suppressing that line of output? I don't want pointless blank
lines appearing.


You could only suppress the output for a complete section of the report.
So the whole data of one row could be suppressed, not a "row of fields"
in the section "Details".


Thanks for the reply.

I'm still 'all at sea', I'm afraid. I can't for the life of me see how 
to create a new section, never mind how to make it disappear conditionally.


The German translation you mention seems to be roughly what I've already 
seen; I've not found it helpful, I'm afraid.


Judging by the lack of other responses to my query, this must be a 
somewhat obscure part of LO. I think perhaps I'd better stick with my 
existing perl script I've been using to generate ODF documents from a 
spreadsheet -- seems easier to cut perl code than understand Report 
Builder. :-( :-(




--
Mike Scott
Harlow, Essex, England

--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

--
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] report builder query - how to suppress output.

2018-08-28 Thread Mike Scott
Hi. I've been trying to get my head round report builder (it seems a 
very steep learning curve, ill-documented), and there's one issue that's 
eluding me - how to conditionally completely suppress output.


I'm trying to format an address book from material in a database. As 
usual, there'll be fields for name, 1st and 2nd lines of address, town, 
email, phone, etc.


I can do a simple-minded report using report builder, which looks at the 
moment to fulfil the need, except for one problem. When a database field 
is empty (eg, no email or no 2nd address line), is there any way of 
completely suppressing that line of output? I don't want pointless blank 
lines appearing.


It's exactly the issue raised at
https://ask.libreoffice.org/en/question/21488/base-report-builder-suppress-blank-lines/
but the linked solution on an OO web page doesn't seem relevant to LO -- 
(I can't find Insert > Section in this context).


I'm hoping I'm just missing something obvious - I'd be grateful for any 
pointers please. Also, is there a good tutorial around with examples for 
report builder?


Thanks.


--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

--
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] LibreOffice - patches

2018-04-10 Thread Mike Scott

On 22/03/18 07:12, toki wrote:

On 03/21/2018 09:51 PM, Miss Lizzy wrote:


do you actually mean 'anyone' or are the patches development by your own team 
of software developers?


Anybody can submit patches.  ..



Theoretically true. But the learning curve for someone who's never done 
it before is tremendously steep.


I had a simple one-word patch to submit recently. I simply didn't have 
the time or energy to jump through the necessary hoops. It didn't get 
done: and I'm not exactly a  computer novice!


I do believe a fast-track, *simple* change suggestion alternative might 
be advantageous.





--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

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


(resent) Re: [libreoffice-users] Re: video issue -- thinking out loud and could do with help please

2017-11-11 Thread Mike Scott

On 09/11/17 17:34, Alexander Thurgood wrote:

Le 09/11/2017 à 15:36, Mike Scott a écrit :




I think the code is badly structured - the grabFrame method has no way
of specifying an offset. It should have, and whatever runs the slide
displaying should pick the first or last as appropriate.



Is it really so simple? And do the dev's lurk here at all, or do I need
to stick this on the dev list??




Contributions gratefully received :-) It may be that no one ever really
looked at the problem or found the time to go back to that part of the code.

Best bet would be to introduce yourself on the dev list. They will ask


OK; I've subscribed; I'd better just lurk for a bit.


you to contribute the code via gerrit, the code submission tool that the


gerrit?! something else to learn then :-{


project uses and send in a mail about your contributions being released
under the relevant licenses the project uses. It will undergo a review
and if deemed acceptable and advantageous, which it seems to be from


I have a sudden picture in my mind of a single-character change to the 
source generating vast swathes of review, comment, regression testing, 
etc etc. Hmmm.



what you relate, get accepted into the master source branch. If you're
up for introducing extra functionality to let the user choose where they
want to pick the frame from then even better :-)


I'd love to - but I'm so far out of date with code standards that I 
doubt it'd be practicable. The immediate problem is 
fixed^Wworked-around, and maybe the pointer to the trouble area will 
inspire someone more capable to do a proper job.



Oh, and thanks for the comments. A little encouragement goes a long way!

Mike.


--
Mike Scott
Harlow, Essex, England

--
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] Re: video issue -- thinking out loud and could do with help please

2017-11-09 Thread Mike Scott

On 09/11/17 10:12, Alexander Thurgood wrote:

Le 09/11/2017 à 10:02, Mike Scott a écrit :

Scott,

You might have better luck posting your question to the developer
mailing list, or directly on the dev IRC channel.

Alex




Maybe I'll go there, as I seem to have found a workable answer. Not that 
I understand fully why it works; nor is it a complete and proper solution.


It's all down to "magic numbers". Rule two of code writing - never, 
ever, embed literal numbers in the depths of your code.


Well, there's a file mediawindow.cxx that has a grabFrame method that (I 
assume) is what's called by whatever displays the static placeholder.


This has embedded within it a so-called default frame - which is at 3.0 
seconds or half the media length. With no way that the caller can 
request anything else.


So, on the basis that showing the first frame is better than a mid-media 
frame (make the video fade from/to black for example), I simply set the 
magic constant to 0 and recompiled.


Bingo.

The slide fades in to show the first frame, and the video starts from 
there. Exactly what the doctor ordered. What I don't understand is that 
when the video finishes, the last frame is now displayed. That too is 
exactly what's needed -- but I haven't a clue why: I expected it to jump 
back to the first.



I think the code is badly structured - the grabFrame method has no way 
of specifying an offset. It should have, and whatever runs the slide 
displaying should pick the first or last as appropriate.




Is it really so simple? And do the dev's lurk here at all, or do I need 
to stick this on the dev list??





--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

--
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] Re: resolved (Re: getting LO source)

2017-11-09 Thread Mike Scott

On 09/11/17 09:04, Alexander Thurgood wrote:

Le 08/11/2017 à 10:52, Mike Scott a écrit :

Hi Mike,


Having established it would build and run (with the same video problem,
incidentally), I finally looked at the sources. Now I begin to see why
changes take so long not a comment in sight for one thing, and a
spider's web of complexity. Sheesh! Nightmarish.



The lack of significant comments stems from the original source code of
OpenOffice.org when it was released, which itself came from StarOffice
(after Sun bought the code). Most of the existing comments at the time
were also in German, and particularly concise or absconse.

Unfortunately, at least for the occasional person wanting to dive into
the code, heavy commenting does not seem to be widely adopted amongst
the currently active open source developers contributing to the project.
One might also bear in mind that the LibreOffice code base is huge -
certainly larger in lines of code than any other current open source
project.

As a non-developer trying to read the code for bug hunting, it has given
me migraines on many an occasion.


Thanks. I'd forgotten the original would have been German (and 
StarOffice was actually my first foray into a 'proper' WP -- iirc Sun 
were giving it away at the time.)


Probably time this thread died off, the 'source' issue being resolved 
and purely down to my failure.


I've started another thread on the particular video issue I'm concerned 
with. If anyone can shed light there to help getting it resolved, I 
think not a few users would be grateful!


Thanks again to all who've replied here.



--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

--
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] video issue -- thinking out loud and could do with help please

2017-11-09 Thread Mike Scott
OK. I'm well out of my depth, but this problem has been around too long 
unfixed and it needs fixing. If I 'think out loud' here, maybe others 
could chip in? Sorry this is a bit lengthy.


The problem: a video on an Impress slide starts and finishes with an 
inappropriate frame displayed. I've made a series of test videos, the 
frames simply containing the frame number from 0N-1, and in a 
selection of formats (.mp4, .flv and ".avi") using avconv. I then embed 
that video into a slide using Insert|Audio or Video.


A placeholder frame from the video is displayed during editing. This is 
a frame from within the video, but it isn't always the same one. It 
depends on the length and format and frame-rate of the video. So, for 
example, using 15fps, a 50-frame flv video shows the frame #24 (the 25th 
frame, starting at #0), A 35-frame video shows #12, and a 25-framer 
shows #0. a long mp4 shows #30, a 10-frame mp4 shows #5, with a 
selection between. An avi just shows a question mark, presumably because 
something can't seek into the video (supposition!).


For comparison, a 1500-frame clip at 15fps starts on frame #30; at 
25fps, it starts on frame #75.


Much the same also applies to LO6's property page video preview - with 
the addition that when the seek slider is tweaked, the placeholder is 
also shown while the slider is being moved (it usually settles down to 
show a reasonable frame, not always.)




The big deal-breaker is that this placeholder frame is shown during the 
slide show when the slide appears and before the video plays (a long 
time if there's a slow transition), and also when the video has 
finished. This means at the very least an annoying flicker at the start, 
and a usually totally inappropriate ending.




Versions don't seem important - it's been there at least since LO3, and 
is still in LO6. (And, if I recall, even since OOo) FWIW I'm using 5.1.6.2


I'm using linux Mint; I can't check now, but from memory the same sort 
of issue used to arise on Windows. So presumably the issue lies 
somewhere in the LO source code, and not for example the gstreamer library.


So, I've been looking particularly at the avmedia directory; I have 
however failed miserably to find anything at all that might relate to 
the above observations. (Not helped by my decidedly dated experience of 
C++ :-{ ). If anyone has any experience/knowledge/insights into 
whereabouts to look, that would be great.


Sorry that's so long, but I think the symptoms need documenting 
somewhere. Any thoughts at all would be most welcome - thanks.




--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

--
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: resolved (Re: [libreoffice-users] getting LO source)

2017-11-08 Thread Mike Scott

On 07/11/17 05:51, Jean-Baptiste Faure wrote:

Le 06/11/2017 à 19:53, Mike Scott a écrit :

[...]
Problem fixed. But just how long should I expect for LO to build? I've 
seen estimates on the net of and hour or two on a less powerful 
processor than my own: but I've always had the impression it would be 
a seriously long time.


That does not depend only on your processor, but also on your mass 
storage device (HD or SSD), the use or not of ccache (for a second 
build) and the build options you have chosen (for example the number of 
parallel jobs). And probably on your OS too.


For me a complete build is about 2 hours with an i7 with 2 physical 
cores and an SSD, if I allow 2 parallel jobs to the build system. I use 
a Linux OS. On my previous PC it was about 4 hours with a HD and a i7 
from an older generation.


Be patient. :-)


Wise words. Thanks for your reply.

I left it running all evening; it took somewhere between 2.5 and 5.5 
hours to complete (which it did first time of asking). This was a 
first-time build on a VM - quad 3.1GHz i5-3450 processor, 2Gb memory 
allocated and running Mint (was swapping more than I'd have wished).


Having established it would build and run (with the same video problem, 
incidentally), I finally looked at the sources. Now I begin to see why 
changes take so long not a comment in sight for one thing, and a 
spider's web of complexity. Sheesh! Nightmarish.




--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

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


resolved (Re: [libreoffice-users] getting LO source)

2017-11-06 Thread Mike Scott
(resent - I think the 1st copy is stuck in moderation. Thanks to those 
who replied meanwhile)


On 06/11/17 15:02, Gilles Gravier wrote:

Mike,


For me, it's downloading... I'm at 25% and no specific issue. I copy
pasted your line directly.


Try again now? Maybe a network or a server error that has since been fixed?


Thanks for the reply. red face time here: coming back, I found a 
straightforward typo on my command line. Which, being in a virtual 
machine, I'd retyped (correctly) when posting from my real desktop. (In 
mitigation, I'd left out the 'o' in libreoffice, which was just about at 
the line-wrap. You always see what you expect to see!)


Problem fixed. But just how long should I expect for LO to build? I've 
seen estimates on the net of and hour or two on a less powerful 
processor than my own: but I've always had the impression it would be a 
seriously long time.



--
Mike Scott
Harlow, Essex, England

--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

--
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] getting LO source

2017-11-06 Thread Mike Scott
There being no answers to the long-standing issues with playing videos, 
I thought I'd take a look at the source for myself. Possibly a hopeless 
task, but anyway...


I fell at the first :-{ and couldn't even download the source. Not a 
promising start!


The page at
https://wiki.documentfoundation.org/Development/BuildingOnLinux
recommends using git, so I tried the suggested

git clone git://anongit.freedesktop.org/libreoffice/core libreoffice

only to be told

"Cloning into libreoffice'...
fatal: remote error: access denied or repository not exported: 
/libreoffice/core"


(I also tried git clone -n  with the same result. I suspect the web 
page should show the -n ???)


Help please?


--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

--
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] missing checkboxes and radio-buttons in all dialogues

2017-10-19 Thread Mike Scott

On 19/10/17 14:28, leleu wrote:

In Ubuntu 17.04 LO 5.3.1.2 no problem

Je la 19/10/2017 13:14, zahra a skribis :

hello.
in windows, i did not have such issue until now.
can you try repairing libreoffice or if does not fix the problem, you
can completely uninstall it with all fulders and settings and
reinstall it again.


I replied earlier, but I suspect it's stuck in the moderation q.

I noted that:


"I've now downgraded(*) to 5.1.6.2, which is the version in the 
mint/ubuntu PPA rather than using that from the LO PPA. The checkboxes 
are back; hurray."



So, problem fixed for now, but cause unknown and still presumably due to 
something breaking between 5.1.6.2 (or 5.3.1.2) and 5.4.1.2.




--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

--
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] missing checkboxes and radio-buttons in all dialogues

2017-10-19 Thread Mike Scott

Pretty much as the subject.

I have a machine running 5.1.6.2 (mint; version not to hand) that works 
correctly. My desktop box - 5.4.2.2 (mint 18.1) - shows no checkboxes in 
any (AFAICS) dialogue box. So I can't set any option anywhere, whether 
eg for printing or in the options.


I seem to suffer from long-standing bugs :-( I see from bugzilla from 
*2011* "[Bug 36345] Checkboxes missing from Options panel". Also 36263 - 
Zip file handling broken. OK, on windows, but I get /exactly/ the same 
symptoms: no checkbox and top of label text missing.


I also see "Debian Bug report logs - #870745
libreoffice-style-galaxy: Missing checkboxes and button icons" which 
says the issue is fixed by installing libreoffice-style-tango. This is 
available in synaptic, and I've installed it on the system. But I can't 
see how to tell LO to use it. For one thing, I don't have any checkboxes 
in the options dialogues. Catch-22 maybe :-{


Help please?


--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

--
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] video issues in Impress

2017-10-19 Thread Mike Scott

On 18/10/17 14:13, zahra a wrote:

hello.
if you can steps to reproduce the bug, you can report it in bugzilla
or participate in previous reported bugs that you mentioned.
since which version of libreoffice do you have this problem exactly?
in 5.3.6 and 5.3.7 i read some bug fixed in impress.


Thank you for your comment.

There seems little point in reporting on Bugzilla yet again something 
that has been raised multiple times in the past 4 or 5 years.


As I'm running 5.4.2.2, I would hope that fixes for 5.3.x would be 
included anyway.




i wish that your issue be resolved.


As do I. Does no-one else on the list use video within Impress at all? 
Do people not generally have this problem? Or do they just put up with it?




God bless you!

He does.

--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

--
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] video issues in Impress

2017-10-18 Thread Mike Scott


I've had an issue using video clips in Impress for a long time. I'm 
currently suffering the embarrassment of having to ask someone to 
prepare a PP presentation rather me doing it in Impress because of this.


Basically, I need a slide that, when it's displayed, immediately shows a 
video clip (of some minutes), and at the end of the clip transitions to 
a blank screen until the next slide is requested.


/Always/ I have glitches at the start and end of the video. The current 
attempt shows a full-screen "?" for a fraction of a second before the 
video starts (in previous LO versions, it's shown a random frame from 
near the start of the clip). I would dearly love just to have frame 1 of 
the video appear, and for the last frame to remain when done, without 
extraneous "stuff" inserted.



This looks to be the same issue as bug 69461, which dates back to 2013 
without a fix!! Also 112958 looks probably related, albeit appearing on 
windows, but commenting on the use of a placeholder video frame.


For me, it's a complete show-stopper, and obviously a number of people 
are having this problem but manage to somehow put up with it. I'm 
surprised it's not received attention yet.


Any thoughts on this please? Does a majority not suffer from it? (And if 
so, what's the difference in setup/usage?) Does anyone have a 
workaround? (I can't find one)



(I'm currently using LO 5.4.2.2 on Mint 18.1; but I'm almost sure this 
happened in days of yore under windows XP)


Thanks.


--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

--
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] Reading from a USB device.

2017-08-28 Thread Mike Scott

On 28/08/17 10:24, Cley Faye wrote:

2017-08-27 15:47 GMT+02:00 Marion & Noel Lodge <lodg...@gmail.com>:


I have a Studio Logic MIDI music keyboard which I have plugged into my PC
via a USB cable.  Windows has automatically installed the appropriate
driver/s.  I am attempting to read the MIDI input from the keyboard as I
want to see if I can use a Macro to modify the sound before it goes to the
speaker.   (Actually I want to try to programmatically mix sine waves like
a Hammond Organ does - it may not be possible, but I'd like to give it a
try!)

...

​Maybe I misunderstood something, but I don't see how this is related to
LibreOffice in any way. While it is true that it is possible to write


If all you have is a hammer, everything looks like a nail :-}

I think the OP sounds muddled. Recording midi signals isn't going to 
help (much) with a wish to "programmatically mix sine waves" -- chalk 
and cheese, I think. Which thinking is amplified by the bit about 
"modify the sound before it goes to the speaker". I doubt (nay, hope) LO 
will ever offer a full-blown synth!!


I /think/ the OP is looking at a midi synthesiser plus a mixer. A doddle 
on linux to sling something together -- I'd be looking at qsynth, jack 
and jack_mixer as a start point. Maybe they'll run on windows. I'd 
not know. I'd most certainly /not/ be looking to do any usb-level 
programming; that bit's already been done.


Or maybe I've totally mis-understood.

--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

--
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] writer table issues - lines that mis-behave

2017-08-22 Thread Mike Scott
I don't use tables much, and I've not noticed the following before 
today. This is with LO 5.4.0.3 (Build ID: 
1:5.4.0~rc3-0ubuntu0.16.04.1~lo1) on Mint 18.1 (64-bit).


I insert a table, R-click and select table properties, then try to 
change the line style/colour:


1. Set line style to 'none'. The lines disappear correctly, but it's 
impossible to get them back -- subsequent views of the properties 
dialogue show the lines to be solid style (they're not), and changes are 
ignored.



And it behaves inconsistently and not repeatably on occasion. I've had 
the following while testing the above


2. changing to dashed line affects all but the bottom line, which 
remains determinedly solid.


3. changing colour changes all the lines; but trying to return to black 
sets all but the bottom line to black.


But I can't reproduce these now :-{

All a bit weird. Anyone else had similar issues?



--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

--
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] Simple way to draw graphs ?

2017-08-15 Thread Mike Scott

On 14/08/17 16:15, Regina Henschel wrote:

Hi,

Gilles schrieb:

Hello

I'd like to use LO to redraw graphs scanned from a book, such at this 
one:


<http://nabble.documentfoundation.org/file/n4220553/test.png>

Is there a simple way in LO to do this, ideally without using maths 
(unless

it's a no-brainer)?



You mean, that you do not have the underlying data?

In that case, you can use the scan directly.

Or in case the scan is too ugly, you have to read the scan and enter the 
coordinates as data in the table. From the image I guess, that five 
points are sufficient. You need an XY-chart, because otherwise the years 
are not at the ticks but between the ticks.


Generate the chart in Calc. Uncheck the option to use "Source Format" in 
the Numbers tab of the axis properties dialog. That makes it easier to 
copy the chart to Writer.


Yes, you can redraw the graph, but you might learn a little bit about 
making a chart.


Kind regards
Regina



Can I also point out that LO isn't necessarily the correct tool? I've 
lately discovered the joys of gnuplot -- more flexible than LO, and an 
image created by it could of course be imported into an LO document.


As others have pointed out, beware copyright of the data.


--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

--
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] Libre Office saving spreadsheets as images when saving as Word docx!?

2017-04-17 Thread Mike Scott

On 15/04/17 21:19, Dave Howorth wrote:

On Sat, 15 Apr 2017 18:04:47 +0200
Johnny Rosenberg <gurus.knu...@gmail.com> wrote:


Since this is still the only mailing list that I'm on that requires
me to hit ”Reply to all” to reply to the group, I failed doing so
again, and all the crap ended up at the OP only… so this is my second
try…


Well that must be a problem with the crap mailer you use. A simple
reply works fine for me.



The list mails don't have a 'reply-to' header. So, eg, Thunderbird's 
simple 'message|reply' would go to the sender only; TB does however have 
a 'reply to list' option that does the necessary.


But to return to the OP's LO issue.

It looks as though he has a writer file with an embedded calc document. 
Exporting as docx indeed renders the embedded spreadsheet as an image. 
I'm not sure what he would expect to happen - embed an LO spreadsheet in 
a MS Word document!? Translate the spreadsheet to something Word 
supports in the same way (IIRC not in general possible but IANAE) Or what?


My thought though is his document is 'inside out'. If the important 
parts are the numbers, perhaps it would better be a Calc document with 
embedded text and images; I'd suggest this would export better to 
something MS might support.


He doesn't say why he needs to export to docx - I thought these days MS 
had some support for ODF documents. Could the recipient not cope with 
the odt file?




--
Mike Scott
Harlow, Essex, England

--
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] keeping styles up-to-date

2017-01-20 Thread Mike Scott
Hi all; I've a bit of an issue in keeping styles consistent across 
multiple documents. Maybe there's an easier way of achieving what I 
need... any thoughts would be appreciated.


I'm producing music booklets for a local choir. The sources for the 
material are varied: LO files for any words, plus laid-out music input 
from musescore and abcm2ps (as pdf files). One song per file. LO source 
is converted to pdf, and the whole lot is assembled with pdfunite into a 
booklet for printing - often the exact order of pieces won't be known 
until the last minute.


My problem is that although the LO files are derived from a common .ott 
template file, I find that I sometimes need to alter basic formatting 
after creating all the files, eg to change font face or size. At 
present, I change this in the .ott file, then have to go through all the 
individual documents reloading the styles from this file. It's tedious!


So, is there a way of making style information in an LO document a 
/reference/ to, rather than a copy of, that in a master file? 
Alternatively, is there a way from the command line of loading styles 
from one file into another (I have no doubt a macro could do this; I'm 
afraid I don't have the expertise to craft one though :-{ )


TIA for any advice!


--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

--
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] MS Anniversary upgrade warning - not LO issue

2016-12-07 Thread Mike Scott



On 06/12/16 16:32, Tanstaafl wrote:

Can't imagine why anyone would mess with dual boot these days with
something like Virtualbox available.


A windows licence might be tied to hardware, for example. So if I need 
occasional windows use (eg to update my satnav - g!) but otherwise 
use linux, dual-boot is a necessity. Such a licence probably wouldn't 
work in a virtual machine.




--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

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


removal of attachments on mailing list (was Re: [libreoffice-users] Problem with instalation)

2016-08-18 Thread Mike Scott

On 17/08/16 22:24, Tim Lloyd wrote:

Hi,

this list does not allow attachments so can you please post any
attachments to the web based interface



This issue keeps popping up.

I've just had a quick look at the web page 
(www.libreoffice.org/get-help/mailing-lists/) that describes the LO 
various lists. It gives enough information to know to subscribe to 
users@ to get help, but there's no warning about removal of attachments. 
Maybe this needs changing? ISTM a warning plus advice on how to submit 
attachments would do no harm.




--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

--
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] Date field in a spreadsheet

2016-07-27 Thread Mike Scott

On 27/07/16 15:13, Brian Barker wrote:

At 07:23 27/07/2016 -0400, William Drescher wrote:

I have version Version: 5.0.5.2
In writer I can insert a field that shows the current date whenever
the document is opened. I can't figure out how to do that in a
spreadsheet. Help please.


As has already been noted, you can add date and time to the header or
footer at Format | Page... | Header (or Footer) | Edit... .

If you want to put the date into a cell, use the formula
=TODAY()
- which returns the current date. You can format the cell to display the
date in your chosen format, of course.

Alternatively,
=NOW()
 returns the current date and time.

I trust this helps.

Brian Barker




You can also double-click to edit the cell, then R-click on it and 
select 'Insert Fields...', which offers a small submenu of Date, Sheet 
Name, and Title. Not that I've found a way of then specifying the date 
format :-{


Is there any (good) reason Calc doesn't have the same "Insert|Field" 
menu as Writer? I do dislike inconsistencies like this.




--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

--
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] Data Range in Calc

2016-07-08 Thread Mike Scott

On 08/07/16 02:01, Pat Brown wrote:

Mike, the problem is that when I double click on the chart and I right
click, none of the options is "Data Ranges". The closest I can come is
"Data Table.." This is what has been frustrating me. I wonder if it
would help to re-install LO as there may have been some sort of
corruption during my last install. I am using version 5.1.3.2 on Win 7 Pro.


5.1.4.2/mint here. But it's behaved the same for as long as I remember.

OTOH, I'm charting a set of cells within the spreadsheet. If I 
double-click the chart, and select "View" from the menu bar, then "Data 
Table" is a greyed-out option. I have not the foggiest idea what it does 
-- the help system unhelpfully tells me:


  "Opens the Data Table dialog where you can edit the chart data.

  The Data Table dialog is not available if you insert a chart that is
  based on a Calc sheet or on a Writer table."

But if I double-click the chart and then R-click somewhere on it, I get 
different menus depending on what's been clicked (background, grid, 
point, trend line), but they /all/ finish with chart type, data ranges, 
copy, paste.


Do you have/can you borrow another machine you can run this on? IMO if 
you seriously think the installation is corrupted, reinstalling might be 
a good plan; but try moving your profile to one side first - I gather 
resetting that can cure a number of ills.


(BTW, it's almost always best to follow up to the list, rather than to 
any individual. At the very least, you get the benefit of the collected 
wisdom, while others may benefit from any discussion.)





On 7 July 2016 at 16:15, Mike Scott <v...@scottsonline.org.uk
<mailto:v...@scottsonline.org.uk>> wrote:

On 07/07/16 14:37, Pat Brown wrote:

Every year I open a new sheet in Calc to record data from a new
year. The
layout remains exactly the same each year, only the data
changes. The
simplest is to copy the whole of the previous year's sheet and
past it into
a new sheet. Then delete all the previous year's data and fill
in the new
data. I have two graphs on this page and this is where my
problem comes in.
The simplest method would be to select the graph and then change
the Data
Range to read from the new sheet, BUT, once a graph has been
created I
cannot find any way to edit the data range. Am I missing
something or is
this just not possible? Is it really necessary to re-create each
graph from
scratch?


No.

Double-click on the chart background to select it. Right-click on
    any point (or a trend line) and select "Data Ranges"





--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

--
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] Data Range in Calc

2016-07-07 Thread Mike Scott

On 07/07/16 14:37, Pat Brown wrote:

Every year I open a new sheet in Calc to record data from a new year. The
layout remains exactly the same each year, only the data changes. The
simplest is to copy the whole of the previous year's sheet and past it into
a new sheet. Then delete all the previous year's data and fill in the new
data. I have two graphs on this page and this is where my problem comes in.
The simplest method would be to select the graph and then change the Data
Range to read from the new sheet, BUT, once a graph has been created I
cannot find any way to edit the data range. Am I missing something or is
this just not possible? Is it really necessary to re-create each graph from
scratch?


No.

Double-click on the chart background to select it. Right-click on any 
point (or a trend line) and select "Data Ranges"




--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

--
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] Creating a thick line in Libre Draw and Writer

2016-07-03 Thread Mike Scott

On 03/07/16 14:38, Kruno wrote:


It doesn't work how we conceptualize it, but then again - it working as
designed (it's not broken or a bug).


The code isn't broken. The design is.



I guess it's just the way it is...


No. Water is wet. That really is "just the way it is". I would hope 
software designers are not so fatalistic.


In this case, simply changing the menu function to add a new paragraph 
with the appropriate style and line (and a 1pt font probably) would seem 
a "better design". Hardly more than a few minutes work if you're into 
the internals.


But it's by no means the only, nor the worst, craziness in LO's 
(inherited) design.




--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

--
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: Calc: background color in cells invisible

2016-06-10 Thread Mike Scott

On 10/06/16 11:14, JaquesJaquesLiverot wrote:
...

Our users have a mixture of versions of Excel and LibreOffice, and I wanted
to use the Excel file format because I want to password-protect the sheet
(and Calc told me that I can't do that with an ODS file).


Are you sure about that? 5.1.3.2 (linux) has two protection options 
under the Tools menu. IIRC it used to be in a different place though.



--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

--
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: Calc - Count a "similar sequence"

2016-06-07 Thread Mike Scott
[resent; for some reason the first copy's not appeared on the list. 
Apologies if it appears twice.]


On 06/06/16 16:06, hsikkema wrote:

I often do counting in a secondary column.

See the attached file for a possible solution:
length_of_longest_run.ods
<http://nabble.documentfoundation.org/file/n4185405/length_of_longest_run.ods>



A lot depends on the OP's needs.

If it's a once in a blue moon computation, there's a lot to said for 
keeping things simple: export the salesman name column to a flat text 
file, and run it through 'uniq -c' (OK, 'nix-specific, but nevertheless 
available for windows).


But the OP did actually specify "similar", not "identical", in which 
case one is entering very murky waters, and a precise definition of 
'similar' is needed.



--
Mike Scott
Harlow, Essex
"The only way is Brexit" -- anon.

--
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: justification issues

2016-04-30 Thread Mike Scott

On 30/04/16 01:20, Brian Barker wrote:



Oh, and if you insert a line break (not a paragraph break) after "XXX",
you will see exactly the improvement he would like to see happen by
default.



Brian, thanks for clarifying my intent, and verifying my observation.

I'm still wondering if it's worth putting this in formally as an 
enhancement request -- or would it be so unlikely to get looked at that 
it'd not be worth the effort?



--
Mike Scott
Harlow, Essex, England

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



justification issues (was: [libreoffice-users] Libre Writer 5.1.1.3 - space correction between text words)

2016-04-29 Thread Mike Scott

On 29/04/16 05:45, Brian Barker wrote:
.

Text can be distributed within lines in various ways: left aligned,
centred, right aligned, or justified. The first three modes will
maintain constant, standard spacing between words, but the last
intentionally expands spaces between words in order to fill all lines
with text between the margins. If you don't want your text justified,
don't use that mode. The mode is specified on the Alignment tabs of the
Paragraph and Paragraph Style dialogues.



Can I interject a long-standing issue here, in which LO is by no means 
the sole offender?


It seems that full justification is always done linewise with no 
look-ahead. What's done seems something "gather words on a line until 
the next one won't fit; add spaces to this line to justify".


In pathological cases, this results in well-justified text for some 
lines, plus atrocious spacing on the next line. (sample random text 
below). This happens particularly in newspapers, where narrow columns 
exacerbate the effect, even with hyphenation.


The cure would be to look ahead (I've seen this done using DP) and 
optimise a whole paragraph at a time, rather than a line at a time. You 
can simulate this with a manually-inserted line-end near the "XXX" in 
the sample below (although LO will leave the unneeded space, it shows 
the general effect.) The overall presentation can be much improved, but 
clearly the code would be more complex and slower than now.


If anyone's doing a major overhaul of LO, this may perhaps be worth 
considering.


Thoughts?



Sample: try putting this into an A4 page, 2cm margins, TNR 12pt, fully 
justified). You should get 4 lines, of which the third has 3 long words 
with large spacing.


F ads dfg sdfg sdffg sdfg sdfg sdf gsd fgs dfg sdfg sdf gsd fgsdf F ads 
dfg sdfg sdffg sdfg sdfg sdf gsd fgs dfg sdfg sdf gsd fgsdf F ads dfg 
sdfg sdffg sdfg sdfg sdf gsd fgs dfg sdfg XXX gsd fgsdf 
ddd sss 
    dfg sdfg sdf 
gsd fgs dfg sdfg sdf gsd fgsdf




--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England

--
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] Awkward behaviour of LO Calc

2016-03-30 Thread Mike Scott

On 30/03/16 14:37, Mike Scott wrote:



Excel is documented as Calc's order, ie the opposite.


And MS are inconsistent - VB puts exponentiation above unary -
(https://msdn.microsoft.com/en-us/library/fw84t893.aspx)
opposite to Excel. Oh well :-)




--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England

--
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] Awkward behaviour of LO Calc

2016-03-30 Thread Mike Scott

On 30/03/16 13:52, Alex McMurchy wrote:

Unless I'm misremembering my maths  -2² would be +4 and -(2²) would be -4

So in my mind no bug.


Just a matter of convention. Unfortunately where there's one, there's 
another...


It seems that perl, python and php differ. Perl and python I've tried 
and it's so, php's manual puts exponentiation at higher precedence than 
unary - (http://php.net/manual/en/language.operators.precedence.php) 
although the ** operator is new in php 5.6 so I can't check offhand.


eg
mike@spock> python
Python 2.7.6 (default, Jun 22 2015, 17:58:13)
[GCC 4.8.2] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> print -3 ** 2
-9


Excel is documented as Calc's order, ie the opposite.

Javascript seems to agree with Excel.
(https://developer.mozilla.org/en/docs/Web/JavaScript/Reference/Operators/Operator_Precedence)

Fortran (remember that?) puts - below **
(https://www.fortran.com/F77_std/rjcnf0001-sh-6.html)
that page says explicitly
"For example, in the expression

- A ** 2

the exponentiation operator (**) has precedence over the negation 
operator (-)  The interpretation of the above expression is the same 
as the interpretation of the expression


- (A ** 2)
"


Oddly, I can't find any strictly /mathematical/ guideline! Anyone have 
the maths students' guide to operator precedence?



It looks as though opinion is divided.


I'd suggest always using brackets to be sure and clear. In any case, it 
really needs documenting for Calc.




--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England

--
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] Awkward behaviour of LO Calc

2016-03-29 Thread Mike Scott

On 29/03/16 11:45, Regina Henschel wrote:
...

To force a result of -4 you need to tell Calc, that the minus is a
binary operator. The formula "=0-2^2" would do that.



Of course changing such behavior will cause a hell lot of trouble in
existing documents… but perhaps the operator precedence should be
explicitly specified on the wiki ?


The precedence is defined in ODF
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#Operators


Doubtless so.

But of little comfort to the hapless user, expecting a more mathematical 
convention:


mike@spock> perl -e 'print -3**2, "\n"'
-9


Oh well. Caveat programmer, I suppose.



--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England

--
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] Awkward behaviour of LO Calc

2016-03-29 Thread Mike Scott

On 29/03/16 09:38, lorieul wrote:

Hello to all,

I have found a fancy behavior of Calc but I cannot decide whether it is
a bug or a "feature". Hence I was looking for your advice before posting
a bug report (if required).

   1. Open LO Calc
   2. In A1 enter formula "=1-2^2" and press enter key
  The result shown is -3 which is ok since
  1-2² = 1-(2²) = 1-4 = -3
   3. In A2 enter formula "=-2^2" and press enter key
  I would expect this to be treated as -2² = -(2²) = -4
  But Calc considers it as (-2)² = +4
  Quite obviously, a work around is to define the formula as
  "=-(2^2)" which indeed returns -4

I've checked the wiki page dedicated to operators [1] but it does not
give much information on operator precedence.


From my standpoint, both examples show an inconsistent behavior of Calc.

For me, either we should have both 1-2^2 = 1+4 = 5 and -2^2 = +4
Or we should have both 1-2^2 = 1-4 = -3 and -2^2 = -4

However, perhaps some of you have a different view point on the matter ?
In other words, is that a bug or is it perfectly normal ?


It looks as though someone has been following a bad example.

A quick search brings up
https://en.wikipedia.org/wiki/Order_of_operations

which says

"There exist differing conventions concerning the unary operator − 
(usually read "minus"). In written or printed mathematics, the 
expression −3^2 is interpreted to mean 0 − (3^2) = −9  but in  
Microsoft Office Excel (and other spreadsheet applications) and the 
programming language bc, unary operators have a higher priority than 
binary operators"


Contrary to, eg, perl.

Ouch! Quite contrary to expectation. Here lie monsters :-)


--
Mike Scott
Harlow, Essex, England

--
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: No indent in footnotes

2016-03-24 Thread Mike Scott

On 23/03/16 13:54, Urmas wrote:

"anne-ology":


How can this be the fault of the USofA ???


In Europe, footnotes have the same indent as the text body, and their
markers are superscripted.
It was LO behavior too, until some American changed it into the mess we
have today.



Without commenting on either PoV, does this not suggest that footnote 
formatting (and probably other similar issues) should have a default 
controlled by the locale?



--
Mike Scott
Harlow, Essex, England

--
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 ver. 5.1.0.3 calc - missing menu functions

2016-03-09 Thread Mike Scott

On 09/03/16 07:29, Graham Luffrum wrote:

Tom

You will find all these items under "Sheet".  The built-in help seems to be
out-of-date.

Graham

On 8 March 2016 at 23:31, Tom Cloyd <tomcloydm...@gmail.com> wrote:


This upgrade has destroyed the functionality of a spreadsheet I utterly
depend upon throughout my day.

So far, here is what I've discovered, in a mere few minutes working with
it, and this is just on the main menu ("file, edit", etc.):

* INSERT: missing - "Cells, Rows, Columns, Sheet" - LO Help says they are
there. Look at "Inserting rows", etc. But they are not.
* EDIT: missing - the "Fill > Series" function. Again, LO help says it's
there - Look at "filling;cells, automatically". But it's not.

This is a disaster for me. I'm reverting to previous version, just so I can
get my work done.



Graham's right of course. In fact, it takes less than a minute to find 
the information in the online release notes.


BUT - I do have to sympathise with the OP's situation; things really 
shouldn't move around like this without warning the hapless user. 
Zero-order solution: how about a simple link from the 'Help' menu to the 
release notes, plus a popup on first running a new version to remind the 
user?



--
Mike Scott
Harlow, Essex, England

--
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] 5.1.1 breaks anchored-as-character frames

2016-03-03 Thread Mike Scott

On 03/03/16 13:41, Regina Henschel wrote:

Hi Mike,

Mike Scott schrieb:
[..]


Is there a way of reverting to an earlier 5.x? Synaptic doesn't offer
these, and makes switching versions something close to agonizingly hard.

Thanks.


I can easily make an administrative installation of any version I want
on Windows, which do not influence each other. Is that not possible on
Linux?


Probably yes, but not by using the PPAs which are supposed to keep life 
simple and consistent. Or at least I don't know how which isn't 
quite the same thing :-)


Looking at the LO downloads page, 'still' seems to be 5.0.5, and 'fresh' 
older than what the LO PPA is serving up. But synaptic lists a good 
dozen or twenty installed packages to do with LO, and no doubt getting 
packages out of sync could be "interesting".


If no-one else has seen this, I guess I'll have to deinstall the lot, 
and try (probably) 'fresh' to see what happens. And then log a bug 
report, although my experience with bugzilla from the OOo days was far 
from happy :-(


Thanks.



--
Mike Scott
Harlow, Essex, England

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


(resolved) Re: [libreoffice-users] Re: 5.1.1 breaks anchored-as-character frames

2016-03-03 Thread Mike Scott

On 03/03/16 14:57, Peter Maunder wrote:

If you really want to install older versions of LibO,
https://downloadarchive.documentfoundation.org/libreoffice/old/4.2.8.2/ will
point you to 4.2.8, although I would not commender going back to these older
versions. The normal download site currently gives the options of 5.04,
5.0.5 and 5.1.0. Remember that all of these versions will use the same
.config/libreoffice file with Ubuntu/Mint.

Are you sure your problems are with the version of LibO and not the
installation itself or problems with the config file?...Peter



I think things have been changing even as I've been working, because I 
tried just a few minutes ago to download the 5.1.1 development version, 
and got 'target not found'. I've just checked again, and it's now there 
for download.


But anyway, I've tried the following:

5.1.0.3 (downloaded) works (and is where I'll stick for now)

5.1.1.1~rc2 (LO PPA reinstated) now works although the line spacings 
look subtly different. I'm not sure if this was exactly the version I 
was using before though when it failed so badly - as I've noted above, 
things have been changing as I work.


4.x (ubuntu PPA) works, but line spacing is different from 5.1.0.3


I'm not sure pushing out development versions in a PPA is such a 
brilliant idea. Having had my fingers burnt, I've removed the LO PPAs 
from synaptic, and will upgrade manually from now on.



Thanks all; sorry it's been a bit of a time waster. If nothing else, 
I've learned a bit more about dpkg and friends!



--
Mike Scott
Harlow, Essex, England

--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England

--
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] 5.1.1 breaks anchored-as-character frames

2016-03-03 Thread Mike Scott

On 03/03/16 14:47, Robert Funnell wrote:


​As can be seen here, using Linux Mint and the Swedish language as an
example, there's no problem selecting earlier versions of *LO* to
download
(scroll to the bottom of the page to select the desired version) : ​

https://www.libreoffice.org/download/libreoffice-fresh/?type=deb-x86_64==sv

​



I don't know how to install an old version using Synaptic and the
standard package-management system, which Mike referred to, but it is
possible to install software directly, as Henri describes.


Quite quick to do. The only problem is that I can't see how to have two 
versions installed at once, so logging a bug against 5.1.1 would be a 
problem.


FWIW 5.1.0 does behave correctly though.


--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England

--
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] 5.1.1 breaks anchored-as-character frames

2016-03-03 Thread Mike Scott

On 03/03/16 14:47, Robert Funnell wrote:


​As can be seen here, using Linux Mint and the Swedish language as an
example, there's no problem selecting earlier versions of *LO* to
download
(scroll to the bottom of the page to select the desired version) : ​

https://www.libreoffice.org/download/libreoffice-fresh/?type=deb-x86_64==sv

​



I don't know how to install an old version using Synaptic and the
standard package-management system, which Mike referred to, but it is
possible to install software directly, as Henri describes.


Yes, I've seen that, thanks (I replied to Regina to this effect, but 
that seems to have been delayed). A potential issue is that synaptic has 
LO split across a lot of packages, and there seems some risk of 
conflicts but if no-one has seen my (original) problem I'll have to 
go the manual downgrade route.



(OT)
BTW, Synaptic seems to have its own problems: the 5.1.1 version I had 
from the LO PPA was flagged as "broken" (which I see a lot, not just for 
LO, and means upgrading will be a problem until I've fiddled with apt 
directly). Sometimes synaptic offers a downgrade option - but not for 
the LO PPA: I had to disable that PPA, revert to ubuntu's own (4.x), 
completely deinstall LO, then reinstall to downgrade. Very messy, but 
not an LO issue!



--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England

--
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] (OT-ish) gmane web access oddity

2016-03-03 Thread Mike Scott
Hmmm. Within minutes of my posting an item to this list, I saw that 
lo.gmane.org was accessing my webserver:


lo.gmane.org(80.91.229.12) - - [03/Mar/2016:13:18:07 +] "GET / 
HTTP/1.1" 200 430
lo.gmane.org(80.91.229.12) - - [03/Mar/2016:13:18:07 +] "GET 
/favicon.ico HTTP/1.1" 404 310
lo.gmane.org(80.91.229.12) - - [03/Mar/2016:13:18:07 +] "GET 
/robots.txt HTTP/1.1" 200 27


Can't be a coincidence, I think.

Normal behaviour? New? Reasonable? I'm surprised, because it means gmane 
is guessing a url from an email address. At least it honours robots.


--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England

--
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] 5.1.1 breaks anchored-as-character frames

2016-03-03 Thread Mike Scott

Spot of bother here.

I'm creating .odt files from a home-brew application, and using LO to 
'polish up' the formatting. The files contain a lot of frames anchored 
as characters - each has text (a chord symbol) that appears above the 
line of lyrics.


This used to work reasonably well; the last document I had prepared is 
dated February 8th, and there was no issue (the was version 5.something 
- possibly 5.0.x, possibly 5.1.0; but I can't be sure). Today, for the 
same document, the frames are pretty well all positioned in the same 
wrong place, the text is invisible, and they have a box (the style says 
no box).


With some effort, I've reverted back from 5.1.1 (from the LO PPA) to 
4.2.8.2 (from the ubuntu PPA) and now things are more or less working as 
they used to. So something's broken since mid-Feb - presumably LO as my 
files haven't changed.


Anyone else having problems, or can shed light please?

Is there a way of reverting to an earlier 5.x? Synaptic doesn't offer 
these, and makes switching versions something close to agonizingly hard.


Thanks.

(Mint 17, btw, in case it's relevant)

--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England

--
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] unwanted 'document recovery' dialogue (was: Re: Cannot delete horizontal red line)

2016-01-19 Thread Mike Scott

On 19/01/16 16:24, R. Diez wrote:
...

Not unheard of. 8-) In fact, when closing Writer, both on Linux and
Windows, I often get a "LibreOffice Document Recovery" dialog. "Due to
an unexpected error, LibreOffice crashed.". "The following files will be
recovered", and then an empty list of files. If then leaves the lock
file ".~lock.CannotSelectRedLine.odt#" behind. If happens if I change
the document and then undo the changes and don't save it to disk, then
close LibreOffice Writer.



That's been happening to me ever since I moved to 5 (5.0.4.2 to be 
precise). Using Mint 17. Never an issue with 4.whatever-it-was.


I use Writer, save and exit, and am occasionally immediately greeted by 
the recovery dialogue followed (IIRC) by the generic LO startup window. 
Anyone else noticed this? It's not repeatable to order, and is quite 
unpredictable.



--
Mike Scott
Harlow, Essex, England

--
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] precision of Draw dimensions - 3 place

2015-11-19 Thread Mike Scott

On 18/11/15 21:52, dave boland wrote:



On Wed, Nov 18, 2015, at 02:13 PM, Brian Barker wrote:

At 13:48 18/11/2015 -0500, Dave Boland wrote:

I want to locate a line 1/8-inch (0.125") from the margin. LOD
truncates that to 0.13". Is there a way to get 3-places?


Is that LOD as distinct from LOW, LOC, LOI, LOB, etc.?

o Go to Tools | Options... | LibreOffice Draw | General | Scale.
o Set "Drawing scale" to 1:10.
o Locate your line at 1.25".

I trust this helps.


Nope.  The line is set to 0.13" from the margin.


Looks like this is a long-standing unfixed issue:

https://forum.openoffice.org/en/forum/viewtopic.php?f=11=9688
(from 2008)

If you work in mm, the 2 decimal places the GUI so unreasonably forces 
will give a precision of 10μm. Not altogether convenient for the 
"traditionally minded" among us though :-)



--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England

--
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: precision of Draw dimensions - 3 place

2015-11-19 Thread Mike Scott

On 19/11/15 15:39, V Stuart Foote wrote:

No, the all measurements in the StarOffice -> OpenOffice Draw/Impress legacy
are derived from raster screen bitmap graphics which has maintained the text
"print" centric practice and uses a smallest "Field_Unit" of twips for
calculations of placement onto the canvas.

A twip  (1/1440") --from Postscript 1/72" point-- is a screen independent
value converted (and rounded)  in calculating vertex placements as pixel
dimensions.  There are routines to convert measurement from twip to mm or
inch--but they are equally imprecise for use in CAD.

Meaning there is no history for vector based measurements (vertex, angles,
radius, and distances) needed for CAD. What is provided is all geared to
rendering bitmap onto a raster canvas--for  resample to screen pixels.

So, the "arbitrary" lack of precision is a function of the resampling to
"fit" bitmap elements to pixels of a raster screen. wo Floating point
precision of measurements remains much less significant than performance for
rendering the twip derived document canvas. Yes there was a tradeoff, but an
easy one to make.

If you need the precision for CAD you want a program designed to handle
vectors under the hood, not bitmaps--period!



Whatever the internals within LO, the present behaviour is irrational. 
Yes, obviously everything /eventually/ has to be adjusted some arbitrary 
grid size. However, there's no reason at all for arbitrary roundings 
before printing.


In particular, I've just experimented to see what's stored. I draw a 
single line and position it (or try to!) at 1.234cm from the margin 
(itself set at 1cm). I do this twice, with units set to cm (which forces 
a rounding to 2.34cm) and them mm (retains 2 dp's in/mm/ this time).


The generated contents.xml has a draw:line element, whose position is in 
the first case svg:x1="2.23cm" and in the second svg:x1="2.234cm". So the


They really, really ought to be the same. If the user chooses to work in 
cm, mm, or cubits, the available physical precision should nevertheless 
be ultimately defined by what the printing system can do.


OTOH, if the stored measurements are rounded to some arbitrary grid, 
then my two files should have the same rounded content.


Final experiment. Set the units to feet - and see how the precision 
drops to about 3mm because the entries are rounded by the GUI to 2 dp in 
feet. Rational behaviour? Not from a user's POV.




--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England

--
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] precision of Draw dimensions - 3 place

2015-11-19 Thread Mike Scott

On 19/11/15 13:20, dave boland wrote:

Thanks all.  If I make a suggestion to LO - add some more CAD abilities
to Draw such as higher precision.  LOD is a very useful program, and
could be even more useful.


Agreed.

The problem's all in the GUI - the generated xml seems able to use 
arbitrary precision - so should be easily enough fixable.


The truly galling thing (to me) is that someone, somewhen, made a 
concious decision /and put effort into the code/ to do the rounding. 
Unwarranted work with an unwanted result. No doubt the same one who also 
provided the option of units of miles or km, and "Lines" - whatever they 
are.


--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England

--
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 v text boxes

2015-11-10 Thread Mike Scott

On 10/11/15 04:52, Brian Barker wrote:

At 13:41 09/11/2015 +, Malcolm Moore wrote:

Is there a guide ( or knowledgeable person ) that can show the pros
and cons of frames v text boxes.



.

A knowledgeable person? That's probably not me, but I'd suggest that
text objects may be useful for the odd piece of disconnected, displayed
text, whereas frames are a much more flexible way to handle blocks of
text. In particular:

o Text objects can be rotated, whereas frames appear not to have this
facility.


The interesting thing is that internally text boxes and frames appear to 
be pretty well identical in structure. Each appears implemented in the 
xml as a "" item within a "" item.


However, the frame's frame has a style derived from the "Frame" style; 
the text box's frame's style has no parent. A quick bit of editing on 
content.xml to graft in the text box's style name (gr1 in my case) 
instead of the frame's style (fr1) converts the frame into a text box -- 
no outside border, and rotations allowed. I have no idea what it might 
be about the "Frame" style that disallows rotation. (Or, indeed, why 
anyone would wish to disallow this in the first place.)


I'm sure this must be documented somewhere. All I've done is look at 
content.xml, and potter a bit for a few minutes, so may well be missing 
something important.



--
Mike Scott
Harlow, Essex, England

--
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] Tooo many messages on this mailing list?? How to avoid being swamped ...

2015-10-15 Thread Mike Scott

On 15/10/15 16:00, Tom Davies wrote:

Hi :)
+1
to everyone so far :))  Thanks Anne-ology! :)

I get the impression that some email-clients, maybe Thunderbird, ignores
the words in the subject line and uses something from the coding in the
headers (which are usually hidden).


Using subject (and presumably date and possibly any "re" prefix) will 
always break.


I believe the proper way is to use the message-id and in-reply-to 
headers to reconstruct the thread.


Thunderbird does this for me - except on emails from this list, which 
leads me to suspect the LO list processor is tinkering with something it 
shouldn't. Irritating.


IMBW.



I know that Forwarding an email "breaks it out" into a new thread but i've
not tried breaking it out in this way but then using the same
subject-line.  I imagine that differnt email-clients would handle that very
differently from each other.




--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England

--
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: file dialogue choice

2015-10-10 Thread Mike Scott

On 10/10/15 14:30, Graham Luffrum wrote:

Under my version of LO 5.0.2.2 (under Linux Mint 17.2 32 bit) I still have
the choice between LO's dialogues and the system dialogues.


Curious. I've got "Version: 5.0.2.2
Build ID: 00m0(Build:2)
Locale: en-GB (en_GB.UTF-8)"
running on Qiana 64 bit.

I used to have system-style dialogues set; since upgrading from (iirc) 
5.0.1.x it's switched itself to LO dialogues.


At help.libreoffice.org/Common/Open_1, I'm told
"To activate the LibreOffice Open and Save dialog boxes, choose Tools - 
Options - LibreOffice- General, and then select the Use LibreOffice 
dialogs in the Open/Save dialogs area"
which roughly corresponds with my recollection about how I switched away 
from LO dialogues in the first place.


The problem I have, is that that tab (nor any other) simply does not 
have that setting available on it. I see only areas labelled "Load", 
"Save" and "Default File Format and ODF Settings" each with a number of 
checkboxes. Nothing anywhere to restore my preferred dialogue box style.


Anyone any idea how to switch back please?


--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England

--
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: file dialogue choice

2015-10-10 Thread Mike Scott

On 10/10/15 15:02, Mike Scott wrote:

On 10/10/15 14:30, Graham Luffrum wrote:

Under my version of LO 5.0.2.2 (under Linux Mint 17.2 32 bit) I still
have
the choice between LO's dialogues and the system dialogues.


Curious. I've got "Version: 5.0.2.2
Build ID: 00m0(Build:2)
Locale: en-GB (en_GB.UTF-8)"
running on Qiana 64 bit.

I used to have system-style dialogues set; since upgrading from (iirc)
5.0.1.x it's switched itself to LO dialogues.

...

Anyone any idea how to switch back please?




OK. I see what's happened. Seems the upgrade didn't for whatever reason 
provide a compatible version of libreoffice-gnome. Installing that 
fixers the issue. And (for the sharp-eyed) there are two options tabs 
titled "General". I did look at both (honest!), although I specifically 
referred to the wrong one on my posting.


I wonder if a warning in the help file might be in order that the extra 
package is needed.



(I see that LO-presenter-console, LO-avmedia-backend-gst and a handful 
of other LO extras are also not upgraded. Time to do some fixing...)



--
Mike Scott
Harlow, Essex, England

--
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] Printing in Impress and file dialogue choice

2015-10-10 Thread Mike Scott

On 09/10/15 20:24, libreoffice-ml.mbou...@spamgourmet.com wrote:

Mike Scott wrote:

On 09/10/15 12:43, Malcolm Moore wrote:
...

This is outstandingly horrible !


Yes.


My summary for anyone in the same boat suffering from brain failure at
the end of the week:

.


It will then work for the duration of the session as A3 and Landscape
are now selected ( but greyed out again )
Once you save it and open it again you have to start from the beginning.


Not correct AFAICS. Unfortunately, changing print properties doesn't
seem to mark the file as needs-to-be-saved, so ^S does nothing (and
File|Save is greyed out).


That depends on the settings:
- Tools > Options > LibreOffice > General > Printing sets "document
modified" status
and:
- Tools > Options > LibreOffice > General > Allow to save document even
when the document is not modified

Tools > Options > Load/Save > General > Load printer settings with the
document probably also affects whether previously saved printer settings
are actually used next time the document is opened.

Mark.




Hmmm.

I think the problem here is one of obscurity. Too many options spread 
over too many dialogues/tabs all affecting results, no obvious way to 
find what's happening unless you "just know" to look there, and the help 
file isn't very helpful.


There's even inconsistency between programs. Try the following in each 
of Writer and Impress. Create a new document and save it. Change the 
printer via File|Print setting. Now look at menu choice File|Save. In 
Impress, it's greyed out. In Writer, it's available.


(Both options you mention above are unset in my system, btw.)


To add more annoyance, as part of trying to get my own brochure issue 
sorted, I upgraded to 5.0.2.2. A minor upgrade, yet it's changed the 
file load/save dialogues to LO's own. The option to revert to (my 
preference) the system dialogues has apparently gone. The information at

https://help.libreoffice.org/Common/Opening_Documents#System_File_Dialogs_or_LibreOffice_Dialogs
is clearly now wrong. It's not helpful to do this to the poor user!!!


--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England

--
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] Printing in Impress

2015-10-09 Thread Mike Scott

On 09/10/15 09:31, Malcolm Moore wrote:

Hi,


Yes the printer does A3 and borderless


Creating an A3 presentation ( Format page / Page )
will not print as A3 it always comes out as A4.
Using 'Use only paper tray from printer preferences'
means it prints landscape but it is still on A4


As Regina said, you also need to set 'use only paper /size/ from...' as 
well. Otherwise I see the same symptom (landscape, and size locked to A4).


BTW, Impress seems to pick its size differently from Draw, which chooses 
a more useful default of A3 for an A3 drawing.


Haven't we only just been here? :-) :-) :-)  I suggest again that the 
Print dialogue could use some improvement in this area.






An A3 Writer document prints as expected


Ta


Mal



  From:   Regina Henschel <rb.hensc...@t-online.de>

.


For to enable the printer settings you need to check the options "Use
only paper tray from printer preferences" and "Use only size form
printer preferences" in the tab "Options".

Kind regards
Regina




--
Mike Scott
Harlow, Essex, England

--
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] Printing in Impress

2015-10-09 Thread Mike Scott

On 09/10/15 12:43, Malcolm Moore wrote:
...

This is outstandingly horrible !


Yes.


My summary for anyone in the same boat suffering from brain failure at the end 
of the week:

.


It will then work for the duration of the session as A3 and Landscape are now 
selected ( but greyed out again )
Once you save it and open it again you have to start from the beginning.


Not correct AFAICS. Unfortunately, changing print properties doesn't 
seem to mark the file as needs-to-be-saved, so ^S does nothing (and 
File|Save is greyed out). However, if the print stuff is set up, and 
then a substantive change is made followed by a save, the print info is 
saved as well. But if you need to change it again, you have to go 
through the whole procedure again.


At least it seems that way after a quick experiment.


--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England

--
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] brochure printing RESOLVED

2015-10-08 Thread Mike Scott

On 07/10/15 19:57, Regina Henschel wrote:


Have you really checked both options "Use only paper tray from printer
preferences" and "Use only size form printer preferences" in the tab
"Options"? After this options are enabled, the settings in the printer
properties should be enabled.


Duhh!  I've just looked back, and that's exactly what you said 
originally. And I didn't. Sorry - and yes, that fixes it; thank you (twice!)



But - isn't this a bit of an odd user interface? You set the brochure 
option on /this/ tab, enable setting the paper size on /that/ tab, then 
click a button on yet another tab to open the dialogue to actually set 
the size. Could this not be tidied up? (And the defaults must have 
changed - I'm sure I've never had to worry about this before) Nor, 
AFAICS, is this mentioned anywhere in the help file (which I did read!)



Incidentally, I notice that the 'brochure' setting now is stored with 
the document (it used not to be), as is 'Use only paper tray' 
whereas "Use only size from printer preferences" isn't saved and needs 
resetting every time the document is opened. But thankfully the paper 
size and orientation are saved. Curious design.



Anyway, problem solved; apologies again, and thanks for your patience.



--
Mike Scott
Harlow, Essex, England

--
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] brochure printing

2015-10-07 Thread Mike Scott
Can someone settle my mind please here? Has the page size setup changed 
at some point for doing brochure printing from Writer?


I don't do this too often, so my memory may be wrong. However, I find 
this week that to make an A5-size booklet, I need to create A4 pages 
with scaled up contents, that are then scaled down [factor sqrt(2)] by 
LO and printed 2-up on A4 paper when 'brochure' is selected. Paper size 
and orientation is greyed out in the print dialogue.


I'm pretty certain (and the one example I can find from OOo days in 2006 
seems to bear this out) that once upon a time, I'd have had to create an 
A5 document, specify A4 landscape paper, and brochure mode would then 
print my A5 pages unscaled, 2-up.


Is my memory wrong? If things have changed, what was the rationale? - 
the latter way seem IMO much more convenient.


Thanks!!

--
Mike Scott (unet2  [deletethis] scottsonline.org.uk)
Harlow Essex England

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


  1   2   >