[libreoffice-users] Moderators, don't post my previous question to the list

2014-07-12 Thread .
Dear moderators reviewing posts,

My question has been answered, and I no longer require help. So there's no
need to release my previous message (dated today) and this follow-up
message to the list. Would you be so kind as to confirm this by sending a
message to my e-mail address?

Thank you for your timely effort and dedicated work!

-- 
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] Is version 4.1.6.2 insecure?

2014-07-12 Thread .
To whom it may concern:

LibreOffice 4.1.6.2 is detected as insecure by Secunia PSI. Advisory
SA57383 (Macro Vulnerability). Would you be so kind as to let me know why
this stable version is insecure, but the fresh version 4.2.5 is secure?
Thank you for your timely effort.

-- 
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] Is version 4.1.6.2 insecure?

2014-07-12 Thread Jay Lozier


On 07/12/2014 05:55 AM, . wrote:

To whom it may concern:

LibreOffice 4.1.6.2 is detected as insecure by Secunia PSI. Advisory
SA57383 (Macro Vulnerability). Would you be so kind as to let me know why
this stable version is insecure, but the fresh version 4.2.5 is secure?
Thank you for your timely effort.


Can you supply more details. Secunia has a paywall.

Macros are a well know security hole in all office suites. They 
potentially allow arbitrary code to be run on an end users computer when 
the file is opened. For older MS office suites, the default was to run 
all macros when the file is opened. Recent (after 2005 or so) the 
default behavior was changed to only allow trusted macros the 
privilege of being allowed to run.  I do not know how common this was 
with other office programs/suites of the same vintage.


I believe LO has always used the model of the trusted macro only being 
granted privileges by default.


Under TOOLSOPTIONSLibreOffice/Security click on Macro Security. Set 
the security level to high or very high. This will restrict macros from 
running unless they trusted. This setting works for any macros.


--
Jay Lozier
jsloz...@gmail.com


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


Re: [libreoffice-users] which version has the best legacy importing?

2014-07-12 Thread Kracked_P_P---webmaster


OK everyone, I received the USB floppy from China, today.

The files are .sig
which might be something like Printshop or other software that was out 
there in October 2005 when the files were made.  There is a cover.sig, 
p1 - p13.sig, and a toc.sig file names.


Right now I have them on my Linux desktop, but will need some conversion 
or viewer for Ubuntu/Mint or Windows 7.


Any ideas?


On 06/30/2014 10:31 AM, Tom Davies wrote:

Hi :)
Floppy drives were notoriously unstable and kept needing to be replaced or
just left in the machine in their broken state.

It's also kinda inevitable that people have ended up with files in formats
that can't be read anymore.  It's one of the main reasons for the need for
a big push for greater use of Open formats.

I find it hilarious that the Senate decided their library was going to be
all in Rtf format as the one that would finally allow all their files to be
readable by anyone on any machine with any relevant program forever.  It's
what MS promised for the format despite all the 'accidental' troubles that
format had.  The Senate is far from being the only organisation so easily
fooled by MS.

Regards from
Tom :)






On 29 June 2014 14:27, Kracked_P_P---webmaster webmas...@krackedpress.com
wrote:


On 06/29/2014 08:36 AM, Charles-H. Schulz wrote:


Hello Tim,

Le Sat, 28 Jun 2014 19:23:56 -0400,
Kracked_P_P---webmaster webmas...@krackedpress.com a écrit :

  On 06/28/2014 10:09 AM, Charles-H. Schulz wrote:

Le Sat, 28 Jun 2014 16:03:59 +0200,
Charles-H. Schulz charles.sch...@documentfoundation.org a
écrit :

  Hello Tim,

Le Sat, 28 Jun 2014 09:23:23 -0400,
Kracked_P_P---webmaster webmas...@krackedpress.com a écrit :

  I would like to know which of the older versions of LO has the

best ability to import really old word processor formats.

I remember that LO was reducing the number of import filters for
those old file formats, but I may need one of them.

I have been asked to copy files off a floppy drive and convert the
files to be able to work with the current tech.  Right now, I have
to find a working floppy drive to access the disc.  Right now, the
only system with a floppy drive has a non-working drive, I have to
replace it.  My main system does not even have a cable port for a
floppy drive, and it seems all of the others I have opened up are
the same.

So, as soon as I get a working floppy drive working, I will need
to get support for 1990's to early 2000's era word processing
formats. The way she remembers, she did not use Word, but may
have used Works or some other older package that are before
MSO .doc format became the standard format before FOSS office
packages came out.

Any idea which older version of LO would be the best to try?  As I
have stated, as soon as I get a working floppy drive installed,
then I will know which legacy format I need to work with.  It
would be nice to know which version of LO to install for the
conversion to the modern formats
- MSO's and ODF.

  I could actually point you to the latest version of LibreOffice

(the 4.2.5) as the project keeps on creating new filters for these
old formats.

As for recommending anything older than the currently supported
versions (4.1.6 and 4.2.5), it is just unwise to do this and we do
not do it anyway: there are some major security holes left
unpatched, and anyway the old versions are no longer supported.


To which I should add that the 4.3.0 will be released by the end of
July.

Best,

  I would be doing the work, then removing the older version in favor

of the newer ones.

Hope to download the current versions of LO, again, and all of the
info I was working on.  I lost my list of which versions supported
which formats, and will have to look into that again, with a drive
failure.


Interesting that I read a while back on the lists that some of the
older legacy formats were not going to be supported anymore.  I have
no problem with using the current version[s] of LO, if it would work
with the file format.  Once I get a working floppy drive setup to
read it.  I know that the drive is bad, since it cannot
read/write/format/etc. the blank floppies I have.

I may opt for a USB floppy drive, instead of trying to get the 12+
year old system to use a parts box floppy drive.  I had one for an
old laptop [XP era] but it dropped and stopped working.  Will work on
that. Just recovered from a 2-TB drive failure for a drive that was
10 months old.  Have backups for my large drives, but lost some work
between backups and had some backup file corrupted as the drive was
failing the night of the backup process.  New drive in and old drive
going to be replaced via warranty and used as another spare/backup
drive.  I tend to replace drives after 2 years of use and keep the
old ones offline for USB backups or system spares. Never had a new
one die in only 10 months.  I currently have three SATA 2-TB data
drives and one 250-GB IDE OS drive internal and three SATA 2-TB USB
backup drives with a spare IDE drive as 

Re: [libreoffice-users] which version has the best legacy importing?

2014-07-12 Thread Cley Faye
2014-07-12 20:10 GMT+02:00 Kracked_P_P---webmaster 
webmas...@krackedpress.com:

 The files are .sig
 which might be something like Printshop or other software that was out
 there in October 2005 when the files were made.  There is a cover.sig, p1 -
 p13.sig, and a toc.sig file names.

 Right now I have them on my Linux desktop, but will need some conversion
 or viewer for Ubuntu/Mint or Windows 7.

 Any ideas?


​You might have a hard time to get something out of them...
According to this (
http://whatis.techtarget.com/fileformat/SIG-PrintMaster-graphics-file), it
might be Printshop files, but ​there doesn't seem to exist much other
software that can open them. Even (paying) recent version of these software
are not guaranteed to be compatible with older formats (according to
wikipedia, http://en.wikipedia.org/wiki/The_Print_Shop).

​You can always try to feed them in imagemagick, to see if it can convert
them to something exploitable. But I don't think LO will be able to eat
that.​

-- 
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] which version has the best legacy importing?

2014-07-12 Thread Brian Barker

At 14:10 12/07/2014 -0400, Tim Lungstrom wrote:

Le Sat, 28 Jun 2014 09:23:23 -0400, Tim Lungstrom a écrit :
I have been asked to copy files off a floppy 
drive and convert the files to be able to work with the current tech.


The files are .sig which might be something like 
Printshop or other software that was out there 
in October 2005 when the files were made.  There 
is a cover.sig, p1 - p13.sig, and a toc.sig file names.


Try The Print Shop Essentials (free trial) from
http://download.cnet.com/The-Print-Shop-Essentials/3000-6675_4-10443717.html 
. This claims to convert .sig image files to PDF.


I trust this helps.

Brian Barker


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



[libreoffice-users] Question about viewing cell formulas in Writer

2014-07-12 Thread Tom Williams
Hi!  I'm using LibreOffice 4.2.4.2 on Ubuntu 14.04 Linux (64-bit) and I
created an OpenDocument with a table that has a few cells with
formulas.  The formulas are simple in nature (basic math) but I would
like to see the formula of any given cell at any given time.

I've found if I hover the mouse over a cell in the last row of the
table, the formula appears as a tool-tip.  However, if I hover over
another cell in a row in the middle of the table, the formula doesn't
appear.

Is there a way I can see the formula in any given cell in a table in Writer?

Thanks in advance!

Peace...

The Other Tom   :)

-- 
/When we dance, you have a way with me,
Stay with me... Sway with me.../

-- 
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] which version has the best legacy importing?

2014-07-12 Thread Robert Funnell
A quick Google search indicates that your suggestion of PrintShop may 
be close to the mark. It seems that the files are probably image files 
and not word-processing files. Apparently there are image-conversion 
programmes available out there that can handle these files.


On Sat, 12 Jul 2014, Kracked_P_P---webmaster wrote:



OK everyone, I received the USB floppy from China, today.

The files are .sig
which might be something like Printshop or other software that was out there 
in October 2005 when the files were made.  There is a cover.sig, p1 - 
p13.sig, and a toc.sig file names.


Right now I have them on my Linux desktop, but will need some conversion or 
viewer for Ubuntu/Mint or Windows 7.


Any ideas?



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



Re: [libreoffice-users] Question about viewing cell formulas in Writer

2014-07-12 Thread Rob Jasper
If you select a cel you should see the formula in the topin the line containing 
the selected cell, just after fx ∑ =

If you want to see ten all, go to preferences  LibreOffica Calc  View and 
tick Formulas

Success,
Rob.


Op 12 jul. 2014, om 20:59 heeft Tom Williams het volgende geschreven:

 Hi!  I'm using LibreOffice 4.2.4.2 on Ubuntu 14.04 Linux (64-bit) and I
 created an OpenDocument with a table that has a few cells with
 formulas.  The formulas are simple in nature (basic math) but I would
 like to see the formula of any given cell at any given time.
 
 I've found if I hover the mouse over a cell in the last row of the
 table, the formula appears as a tool-tip.  However, if I hover over
 another cell in a row in the middle of the table, the formula doesn't
 appear.
 
 Is there a way I can see the formula in any given cell in a table in Writer?
 
 Thanks in advance!
 
 Peace...
 
 The Other Tom   :)
 
 -- 
 /When we dance, you have a way with me,
 Stay with me... Sway with me.../
 
 -- 
 To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
 Problems? 
 http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 List archive: http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be publicly archived and cannot be deleted
 


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


Re: [libreoffice-users] which version has the best legacy importing?

2014-07-12 Thread Cley Faye
For my curiosity, if one of those file happen to not have any sensitive
information, would it be possible to have a copy of it? I'm curious about
this file format... It's supposed to be an editing format, but most
information indicate that there are only converters to flat image formats...

-- 
Cley Faye
http://cleyfaye.net


2014-07-12 20:55 GMT+02:00 Robert Funnell robert.funn...@mcgill.ca:

 A quick Google search indicates that your suggestion of PrintShop may be
 close to the mark. It seems that the files are probably image files and not
 word-processing files. Apparently there are image-conversion programmes
 available out there that can handle these files.


 On Sat, 12 Jul 2014, Kracked_P_P---webmaster wrote:


 OK everyone, I received the USB floppy from China, today.

 The files are .sig
 which might be something like Printshop or other software that was out
 there in October 2005 when the files were made.  There is a cover.sig, p1 -
 p13.sig, and a toc.sig file names.

 Right now I have them on my Linux desktop, but will need some conversion
 or viewer for Ubuntu/Mint or Windows 7.

 Any ideas?



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



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


Re: [libreoffice-users] Is version 4.1.6.2 insecure?

2014-07-12 Thread Cley Faye
It might be related to this:
https://www.libreoffice.org/about-us/security/advisories/cve-2014-0247/

In this regard, it might be insecure because a macro can get executed even
if the user settings should prevent it to happen.

Regarding the insecure aspect, well... macro are a programming language,
and as such can do nasty things by themselves, or expose other
vulnerabilities (that's why their use is usually discouraged). If you only
open documents from safe, known and reliable sources the impact should be
minimal, but it's better to be on the side safe of things by updating.

-- 
Cley Faye
http://cleyfaye.net


2014-07-12 19:38 GMT+02:00 Jay Lozier jsloz...@gmail.com:


 On 07/12/2014 05:55 AM, . wrote:

 To whom it may concern:

 LibreOffice 4.1.6.2 is detected as insecure by Secunia PSI. Advisory
 SA57383 (Macro Vulnerability). Would you be so kind as to let me know why
 this stable version is insecure, but the fresh version 4.2.5 is secure?
 Thank you for your timely effort.

  Can you supply more details. Secunia has a paywall.

 Macros are a well know security hole in all office suites. They
 potentially allow arbitrary code to be run on an end users computer when
 the file is opened. For older MS office suites, the default was to run all
 macros when the file is opened. Recent (after 2005 or so) the default
 behavior was changed to only allow trusted macros the privilege of being
 allowed to run.  I do not know how common this was with other office
 programs/suites of the same vintage.

 I believe LO has always used the model of the trusted macro only being
 granted privileges by default.

 Under TOOLSOPTIONSLibreOffice/Security click on Macro Security. Set
 the security level to high or very high. This will restrict macros from
 running unless they trusted. This setting works for any macros.

 --
 Jay Lozier
 jsloz...@gmail.com



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


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


[libreoffice-users] Re: different font size in different files

2014-07-12 Thread Robert Peirce

On 7/10/14, 2:33 AM, John R. Sowden wrote:

I have tried to standardize on freesans 10 point for most ss uses.  I
just came on a file with very small type size, yet when I selected the
cell and the format - font, I got freesans 10 point.  Not wanting to
diagnose myself as blind and/or crazy, I brought up another file with
the same freesans 10 point, and they are clearly different.

why?,


No idea, but I used to copy and paste from a terminal window (Mac) to a 
calc sheet with no problem, until the latest release.  Now, what I paste 
gets blown up to a much larger size.  I have to enter the numbers by 
hand and then they are okay.  I have no idea why this is happening or 
what to do about it.


This may or may not be a related problem.



--
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] Is version 4.1.6.2 insecure?

2014-07-12 Thread Italo Vignoli
 On 07/12/2014 05:55 AM, . wrote:

 LibreOffice 4.1.6.2 is detected as insecure by Secunia PSI. Advisory
 SA57383 (Macro Vulnerability). Would you be so kind as to let me know why
 this stable version is insecure, but the fresh version 4.2.5 is secure?
 Thank you for your timely effort.

Because the patch that solves the vulnerability has been introduced in
LibreOffice 4.2.5, which is the new stable version (although, I agree,
this is not yet reflected in the webpage).

LibreOffice 4.3.0 will be announced on July 28, and will be the new fresh.

LibreOffice 4.1.x has reached the end of life, as you can check from the
release plan: https://wiki.documentfoundation.org/ReleasePlan#4.1_release.

-- 
Italo Vignoli - italo.vign...@gmail.com
mob IT +39.348.5653829 - mob EU +39.392.7481795
sip it...@libreoffice.org - skype italovignoli
GPG Key ID - 0xAAB8D5C0
DB75 1534 3FD0 EA5F 56B5 FDA6 DE82 934C AAB8 D5C0

-- 
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: different font size in different files

2014-07-12 Thread Cley Faye
2014-07-12 21:56 GMT+02:00 Robert Peirce b...@peirce-family.com:

 No idea, but I used to copy and paste from a terminal window (Mac) to a
 calc sheet with no problem, until the latest release.  Now, what I paste
 gets blown up to a much larger size.  I have to enter the numbers by hand
 and then they are okay.  I have no idea why this is happening or what to do
 about it.


​Maybe your terminal now copy as rich text. Try paste special (it's in
the edit menu, or with ctrl+shift+v on a PC... probably something similar
on a mac). I don't know if it will help you with the weird size
discrepancies, but at least you won't have to input your data by hand...​

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


Re: [libreoffice-users] Question about viewing cell formulas in Writer

2014-07-12 Thread Brian Barker

At 21:20 12/07/2014 +0200, Rob Jasper wrote:

Op 12 jul. 2014, om 20:59 heeft Tom Williams het volgende geschreven:
I'm using LibreOffice 4.2.4.2 on Ubuntu 14.04 
Linux (64-bit) and I created an OpenDocument 
with a table that has a few cells with 
formulas. The formulas are simple in nature 
(basic math) but I would like to see the 
formula of any given cell at any given time. 
I've found if I hover the mouse over a cell in 
the last row of the table, the formula appears 
as a tool-tip. However, if I hover over another 
cell in a row in the middle of the table, the 
formula doesn't appear. Is there a way I can 
see the formula in any given cell in a table in Writer?


If you select a cell you should see the formula 
in the top in the line containing the selected cell, just after fx ∑ =
If you want to see ten all, go to preferences  
LibreOffice Calc  View and tick Formulas


Er, except that the questioner is asking about 
formulae in table cells in a text (Writer) document - not in a spreadsheet.


You can put the cursor into a table cell in a 
text document, but you then need to use Table | 
Formula or to press F2 to open the Input Line to display the formula.


And there appears to be no equivalent of that 
Options / Preferences setting for table formulae rather than spreadsheets.


I trust this helps.

Brian Barker


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



Re: [libreoffice-users] Question about viewing cell formulas in Writer

2014-07-12 Thread Tom Williams
On 07/12/2014 01:15 PM, Brian Barker wrote:
 At 21:20 12/07/2014 +0200, Rob Jasper wrote:
 Op 12 jul. 2014, om 20:59 heeft Tom Williams het volgende geschreven:
 I'm using LibreOffice 4.2.4.2 on Ubuntu 14.04 Linux (64-bit) and I
 created an OpenDocument with a table that has a few cells with
 formulas. The formulas are simple in nature (basic math) but I would
 like to see the formula of any given cell at any given time. I've
 found if I hover the mouse over a cell in the last row of the table,
 the formula appears as a tool-tip. However, if I hover over another
 cell in a row in the middle of the table, the formula doesn't
 appear. Is there a way I can see the formula in any given cell in a
 table in Writer?

 If you select a cell you should see the formula in the top in the
 line containing the selected cell, just after fx â^' =
 If you want to see ten all, go to preferences  LibreOffice Calc 
 View and tick Formulas

 Er, except that the questioner is asking about formulae in table cells
 in a text (Writer) document - not in a spreadsheet.

 You can put the cursor into a table cell in a text document, but you
 then need to use Table | Formula or to press F2 to open the Input Line
 to display the formula.

Perfect!  Thank You!!   :)

Peace...

The Other Tom


 And there appears to be no equivalent of that Options / Preferences
 setting for table formulae rather than spreadsheets.

 I trust this helps.

 Brian Barker




-- 
/When we dance, you have a way with me,
Stay with me... Sway with me.../

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



[libreoffice-users] Calc macro - selection by keyboard not recorded

2014-07-12 Thread david_lynch

Although reasonably experienced using calc, I haven't used macros much.

I am trying to write a macro to make the first character in a cell bold.
Enter abc into cell A1. Record the following keystrokes as a macro:
F2, home, shift-, control-B, enter.
This series of keystrokes does what I want, but running the resulting 
macro does nothing.

The code generated is:
sub djl1
rem --
rem define variables
dim document   as object
dim dispatcher as object
rem --
rem get access to the document
document   = ThisComponent.CurrentController.Frame
dispatcher = createUnoService(com.sun.star.frame.DispatchHelper)

rem --
dispatcher.executeDispatch(document, .uno:SetInputMode, , 0, Array())

rem --
dim args2(0) as new com.sun.star.beans.PropertyValue
args2(0).Name = Bold
args2(0).Value = true

dispatcher.executeDispatch(document, .uno:Bold, , 0, args2())


end sub

The keystrokes home and shift- appear not to have been recorded: this 
appears to contradict the explicit advice in Help-Recording a Macro 
Selections are recorded only if they are done by using the keyboard 
(cursor travelling), but not when the mouse is used


What am I doing wrong please?

David Lynch

4.2.4.2 on Windows 8

--
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] Is version 4.1.6.2 insecure?

2014-07-12 Thread Tom Davies
Hi :)
Probably a false-positive.  Anti-virus and security programs do have these
from time-to-time.  Perhaps contact the Secunia people and let them know?
Regards from
Tom :)



On 12 July 2014 10:55, . pons...@gmail.com wrote:

 To whom it may concern:

 LibreOffice 4.1.6.2 is detected as insecure by Secunia PSI. Advisory
 SA57383 (Macro Vulnerability). Would you be so kind as to let me know why
 this stable version is insecure, but the fresh version 4.2.5 is secure?
 Thank you for your timely effort.

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


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


Re: [libreoffice-users] Moderators, don't post my previous question to the list

2014-07-12 Thread Tom Davies
Hi :)
This link might help
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Regards from
Tom :)



On 12 July 2014 11:57, . pons...@gmail.com wrote:

 Dear moderators reviewing posts,

 My question has been answered, and I no longer require help. So there's no
 need to release my previous message (dated today) and this follow-up
 message to the list. Would you be so kind as to confirm this by sending a
 message to my e-mail address?

 Thank you for your timely effort and dedicated work!

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


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


Re: [libreoffice-users] Calc macro - selection by keyboard not recorded

2014-07-12 Thread Tom Davies
Hi :)
I only know that the best documentation appears to be Andrew Pitonyak's
guide;
https://wiki.documentfoundation.org/Documentation/Other_Documentation_and_Resources#Programmers

I am not sure if that will help for the specific issues you raise but it
might help you get to grips with macros faster or more easily or more
soundly or something.

Hopefully someone else on this list might be able to help with the specific
issues!
Good luck and regard from
Tom :)






On 12 July 2014 21:41, david_lynch david_ly...@blueyonder.co.uk wrote:

 Although reasonably experienced using calc, I haven't used macros much.

 I am trying to write a macro to make the first character in a cell bold.
 Enter abc into cell A1. Record the following keystrokes as a macro:
 F2, home, shift-, control-B, enter.
 This series of keystrokes does what I want, but running the resulting
 macro does nothing.
 The code generated is:
 sub djl1
 rem --
 rem define variables
 dim document   as object
 dim dispatcher as object
 rem --
 rem get access to the document
 document   = ThisComponent.CurrentController.Frame
 dispatcher = createUnoService(com.sun.star.frame.DispatchHelper)

 rem --
 dispatcher.executeDispatch(document, .uno:SetInputMode, , 0, Array())

 rem --
 dim args2(0) as new com.sun.star.beans.PropertyValue
 args2(0).Name = Bold
 args2(0).Value = true

 dispatcher.executeDispatch(document, .uno:Bold, , 0, args2())


 end sub

 The keystrokes home and shift- appear not to have been recorded: this
 appears to contradict the explicit advice in Help-Recording a Macro
 Selections are recorded only if they are done by using the keyboard
 (cursor travelling), but not when the mouse is used

 What am I doing wrong please?

 David Lynch

 4.2.4.2 on Windows 8

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



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


Re: [libreoffice-users] Adding fields to existing Base table

2014-07-12 Thread Tom Davies
Hi :)
Thanks! :)  I think it's definitely good to learn more about what back-ends
are available and what they are each best for.  Also good when FUD or just
misunderstandings can be cleared up.  Thanks for that :)

Regards from
Tom :)




On 12 July 2014 05:42, Marion  Noel Lodge lodg...@gmail.com wrote:

 Hi Tom,

 In relation to the H2 database you said -
  I   get the impression that H2 is also a small, fast one but could easily
 be wrong.

 All of my H2 databases would be classified as small, but a couple of years
 ago an H2 user posted on the Users Group that inserts to his data base
 slowed down significantly after it got to the 1 billion record mark!  See -

 https://groups.google.com/forum/?hl=en#!searchin/h2-database/billion/h2-database/tB6QP8MeDj8/6tyTZ4s5kf0J

 ​You will notice from the thread that he got several responses on how to
 overcome his problem​ and these enabled him to improve the response he was
 getting.

 So I think H2 should be included in the list of heavy duty databases.  But
 I must admit that it will probably be quite a while before I need a table
 with 1 billion rows in it!

 Noel


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