[libreoffice-users] LibreOffice Calc issue

[David Cash]

Hi

I really like LibreOffice and have had no problems until I tried to reopen
a spreadsheet and I got this message:


*Read Error.Format error discovered in the file in sub-document content.xml
at 2,109276(row,col).*

I have opened, edited and resaved this spreadsheet many times before and
it's been fine, but now, all of a sudden, it isn't.

If I sent you the file, would you be able to look into it and find out why
this happened?

Many thanks

David

-- 
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] New user trying to create an account but 'invalid username'?

[David Deeks]

Hi there

I have just moved to Libre from Apache and want to set up an account for 
support but unable to do so as keep being told usernames invalid - have tried 
several? Does it have to be unique/long/complicated`?!

Thanks

David D
-- 
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] XLOOKUP in LibreOffice 24.8

[David Lynch]

The help for this function 
<https://help.libreoffice.org/master/en-US/text/scalc/01/func_xlookup.html> 
states "XLOOKUP function is a modern and flexible replacement for older 
functions like VLOOKUP, HLOOKUP, and LOOKUP."
However, it states merely that it supports "wildcards (* ?) for partial 
matches", whereas the older functions support (the full set of) regular 
expressions.
Please can XLOOKUP (and similar new functions) support the full set of 
regular expressions?


David Lynch


--
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] I paid for my Libre Office

[Jose David Alcantara]

Thanks for the advice. I use windows 10. When I open a blank LO is gives me
the said message when I try to save it.

I tried and tried. SWitched to OpenOffice and I can do the changes without
the said Message. LOL. I like LO (dont know why exactly, perhaps its more
intuitive for me) but OO is good enough for now. Thanks.

JDA

On Mon, Nov 13, 2023 at 7:37 PM Rob Jasper  wrote:

> Jose,
>
> You don’t specify what OS your are using.
> This is not a problem of LO, but rather a file permission issue.
>
> I myself use a Mac and I assume it is the same on Linux.
> I see this if I try to edit a file that is sent to me through email if I
> open the file directly from mail (open the file by dubbelclick the
> attachment). This due to the security of mail attachments. If I copy the
> attachment out, or save it in a different location LO works flawlessly.
>
> Hope this helps for you too,
>
> Best,
> Rob
>
> > Op 14 nov. 2023, om 00:57 heeft Jose David Alcantara 
> het volgende geschreven:
> >
> > Dear LO,11 13 23
> >
> > I am getting this message and cannot really use my LO Writer:
> >
> > The lock file could not be created for exclusive access by LibreOffice,
> due
> > to missing permission to create a lock file on that file location or lack
> > of free disk space.
> >
> > Do you have an easy way to 1) understand this  2) get around this ?
> >
> > It is important.
> >
> > Cordially,
> >
> > Jose D. Alcantara, ESq.
> > Attorney
> > Tel. 609-782-2494
> >
> > --
> > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> > Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > Posting guidelines + more:
> https://wiki.documentfoundation.org/Netiquette
> > List archive: https://listarchives.libreoffice.org/global/users/
> > Privacy Policy: https://www.documentfoundation.org/privacy
>
>

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

[libreoffice-users] I paid for my Libre Office

[Jose David Alcantara]

Dear LO,11 13 23

I am getting this message and cannot really use my LO Writer:

The lock file could not be created for exclusive access by LibreOffice, due
to missing permission to create a lock file on that file location or lack
of free disk space.

Do you have an easy way to 1) understand this  2) get around this ?

It is important.

Cordially,

Jose D. Alcantara, ESq.
Attorney
Tel. 609-782-2494

-- 
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] Accessing character formats in calc

[David Lynch]

 I have data in a spreadsheet from an external source. Some characters
within a word are formatted differently from others (for example by size of
font). Is there a way to find out how each character is formatted (I
presume by a macro call)?

I have tried copying each character into a separate cell, but that destroys
the distinctive formatting.

David Lynch

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

[libreoffice-users] Calc - Can't highlight a column and set background shading

[David Carter]

Been using Open Office and then LibreOffice since 1993.  Used to use 
Bugzilla occasionally in the past.
. . . This is my first post to this mailing list, to seek support from 
the community.


I have a spreadsheet I've been using for 3 years.  I modify it occasionally.

I have previously selected a column and clicked the "background 
highlight" icon with color of yellow selected - that would turn the 
entire column yellow - it no longer works!


I suspect I "thrashed around" and changed something about the Toolbars 
that has caused this problem.


I just uninstalled and re-installed Libre Office on my Windows 7 
Professional desktop computer - LibreOffice 7.5.4.2.  I did this to get 
away from any "unintended" changes I may have made.  It did not fix any 
of the problems noted in the next paragraph.


I also seem to have changed how the toolbars display:  They have the 
"system blue" background color, the icons seem larger or different, and 
the "background highlight" tool seems to be different - has black "ab" 
over yellow line.  See attached screen shot.
*_. . . I can no longer highlight a cell or column of cells and change 
the background to yellow._**_

_**_
_**_This is the problem I am reporting and for which I am asking for 
help._**_

_*
Urgency:  I am "dead in the water" on my number one priority task.

Best wishes,

David Carter
Temple, Texas
409-718-2268

--
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] Limits in Calc

[David Lynch]

I have tried, and failed, to find an authoritative statement on the 
limits on cell contents in Calc. I realise that going beyond any ODF 
standard imperils portability of a spreadsheet, and that any limit may 
depend on Calc version and operating system.


In particular, what is the longest string that can be stored in a cell 
and used by functions such as REGEX


David Lynch




--
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] Exploiting ScriptForge in Calc

[David Lynch]

I wonder if the capability in the new ScriptForge libraries could be 
exploited. Several routines in there look useful, such as:


ReplaceChar  Replaces all occurrences of the characters specified in the 
Before parameter by the corresponding characters specified in After.


ReplaceStr   Replaces in a string some or all occurrences of an array of 
strings by an array of new strings.


Reverse Returns the input string in reversed order.

Sort Sort a one dimension array in ascending or descending order. Text 
comparisons can be case-sensitive or not.


All of the above I do currently using existing Calc capability (without 
use of macros). However, if the ScriptForge functions above were Calc 
functions, the result would be easier to develop and less error prone. 
(This is what happened when new functions such as REGEX and CONCAT were 
introduced.)


I probably have enough coding skills to embed these ScriptForge routines 
into User-Defined Calc functions. However, I am wary of doing this, 
because some such code I have previously developed did what I wanted but 
was too slow to be usable. And my spreadsheets already are sluggish, see 
<https://bugs.documentfoundation.org/show_bug.cgi?id=144205> or 
<https://bugs.documentfoundation.org/show_bug.cgi?id=144257>


Can I have  feedback please on whether requests for new Calc functions 
such as those above are likely to be feasible and implemented?


Please, any tips on how I should write code to exploit these ScriptForge 
routines in a manner that makes them speedy?


David Lynch


--
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] Defaults in Find dialogue and toolbar for Calc

[David Lynch]

On 24/10/2021 03:29, John Kaufmann wrote:

On 2021-10-23 18:14, Johnny Rosenberg wrote:
Den tors 7 okt. 2021 kl 00:28 skrev T. R. Valentine 
:
On Tue, 5 Oct 2021 at 07:07, David Lynch  
wrote:


The defaults in the Find toolbar and the Find dialog are:

Direction: Rows Search in: Formulae

I normally want the opposite: Search in columns (because columns 
usually

consist of more homogeneous data than columns) and search in Data
(because usually I'm usually looking at the finished spreadsheet 
rather

than constructing it, and even when constructing a spreadsheet, search
for a formula is infrequent).

You cannot change the default from the toolbar and, if you change the
default from the dialog then move to another sheet, it changes back to
the unwelcome default.

Is there a way to change the default permanently?


Not that I've been able to find. I also prefer to search columns
before rows and wish there were a way to make that the default.


+1

I think it would be even nicer if it remembered the settings from 
last time.


+2


Enhancement request submitted:

<https://bugs.documentfoundation.org/show_bug.cgi?id=145292>

David Lynch


--
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] Defaults in Find dialogue and toolbar for Calc

[David Lynch]

The defaults in the Find toolbar and the Find dialog are:

Direction: Rows Search in: Formulae

I normally want the opposite: Search in columns (because columns usually 
consist of more homogeneous data than columns) and search in Data 
(because usually I'm usually looking at the finished spreadsheet rather 
than constructing it, and even when constructing a spreadsheet, search 
for a formula is infrequent).


You cannot change the default from the toolbar and, if you change the 
default from the dialog then move to another sheet, it changes back to 
the unwelcome default.


Is there a way to change the default permanently?

Is there a reason for the current behaviour? If not, I propose to ask 
for a change.


David Lynch


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

[libreoffice-users] Calc: Adapting row height is slow

[David Lynch]

I have a large (10 by 100) but simple spreadsheet.

When loading and, sometimes, editing it appears to take longer "Adapting 
row height" than the rest of the processing put together. I am happy 
with the existing row height and do not want it adapted.


Is there anything I can do to eliminate or speed up this part of the 
processing?


David Lynch

Version: 7.1.4.2 (x64) / LibreOffice Community
Build ID: a529a4fab45b75fefc5b6226684193eb000654f6
CPU threads: 4; OS: Windows 10.0 Build 19041; UI render: Skia/Raster; 
VCL: win

Locale: en-GB (en_GB); UI: en-GB
Calc: threaded



--
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] Regular expressions

[David Lynch]

The documentation 


for COUNTIF gives the following examples, among others:

=COUNTIF(A1:A10;">=2006")
=COUNTIF(A1:A10;"<"&B1)
=COUNTIF(A1:A10;C2)
=COUNTIF(A1:A10;"<0")
 and these do indeed work.

 However the list of regular expressions linked from the COUNTIF page 


does not include the use of > and < as operators.

Neither does the "full list of supported metacharacters and syntax" 
<https://unicode-org.github.io/icu/userguide/strings/regexp.html> linked 
from the help page in the previous paragraph.


Neither does the page <http://userguide.icu-project.org/strings/regexp> 
linked from the REGEX help page 



Please, is there anywhere that tells me what regular expressions are 
supported?


David Lynch

Version: 7.1.4.2 (x64) / LibreOffice Community
Build ID: a529a4fab45b75fefc5b6226684193eb000654f6
CPU threads: 4; OS: Windows 10.0 Build 19041; UI render: Skia/Raster; 
VCL: win

Locale: en-GB (en_GB); UI: en-GB
Calc: threaded


--
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] REGEX difficulty

[David Lynch]

If I use the REGEX tester <https://regex101.com/>

with regular expression (?=(29|79|97))

and test string 29791

I get 3 matches 29, 97,79, as I expect.

On the other hand, if I enter =REGEX("29791","(?=(29|79|97))",,1)

I get a zero length string.

Can anyone help please?

David Lynch

Version: 7.1.3.2 (x64) / LibreOffice Community
Build ID: 47f78053abe362b9384784d31a6e56f8511eb1c1
CPU threads: 4; OS: Windows 10.0 Build 19041; UI render: Skia/Raster; 
VCL: win

Locale: en-GB (en_GB); UI: en-GB
Calc: threaded


--
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] Unable to record macros

[David Lynch]

I already use LO macros which I have written using Basic. I tried to 
record a macro using keystrokes:


>>>> From help file

LibreOffice can record commands executed with the keyboard and mouse in 
Writer and Calc


1.

   Open the document for which you want to record a macro.

2.

   Choose Tools - Macros - Record Macro.

   If Tools - Macros - Record Macro menu item is missing, make sure
   that macro recording feature is enabled in Tools - Options-
   LibreOffice - Advanced.


   You will see the small Recording dialogue box with just one button
   called Stop Recording.

3.

   Perform the actions you want to be recorded in the document.

   Press the Escape key to deselect an object, as the macro recorder
   currently does not record this action by mouse click.

4.

   Click Stop Recording.

   The Macro dialogue box appears, in which you can save and run the macro

5.  >>>>>>>>>

The macro recording feature is enabled and all goes as in the help file 
until I click stop recording, when I get no dialogue box. I have tried 
restarting without success.


What am I doing wrong, please?

Version: 7.0.4.2 (x64)
Build ID: dcf040e67528d9187c66b2379df5ea4407429775
CPU threads: 4; OS: Windows 10.0 Build 19041; UI render: Skia/Raster; 
VCL: win

Locale: en-GB (en_GB); UI: en-GB
Calc: threaded

David Lynch


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

[libreoffice-users] Calc - Find and Replace options

[David Lynch]

Using Calc Find and Replace [cntl-H], I use the options Direction 
"Columns" and Search in "Values". I keep the Find and Replace window open.


Often, after editing the spreadsheet, but not always, the Find and 
Replace window reverts to the default Direction "Rows" and Search in 
"Formulae".  I can't deduce why it does this.


Why does it do this?

Can I stop it reverting to the default?

David Lynch

Version: 7.0.3.1 (x64)
Build ID: d7547858d014d4cf69878db179d326fc3483e082
CPU threads: 4; OS: Windows 10.0 Build 19041; UI render: Skia/Raster; 
VCL: win

Locale: en-GB (en_GB); UI: en-GB
Calc: threaded





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

[libreoffice-users] Calc - Find and Replace options

[David Lynch]

Using Calc Find and Replace [cntl-H], I use the options Direction 
"Columns" and Search in "Values". I keep the Find and Replace window open.


Often, after editing the spreadsheet, but not always, the Find and 
Replace window reverts to the default Direction "Rows" and Search in 
"Formulae".  I can't deduce why it does this.


Why does it do this?

Can I stop it reverting to the default?

David Lynch

Version: 7.0.3.1 (x64)
Build ID: d7547858d014d4cf69878db179d326fc3483e082
CPU threads: 4; OS: Windows 10.0 Build 19041; UI render: Skia/Raster; 
VCL: win

Locale: en-GB (en_GB); UI: en-GB
Calc: threaded




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

[libreoffice-users] Calc - Find and Replace options

[David Lynch]

Using Calc Find and Replace [cntl-H], I use the options Direction 
"Columns" and Search in "Values". I keep the Find and Replace window open.


Often, after editing the spreadsheet, but not always, the Find and 
Replace window reverts to the default Direction "Rows" and Search in 
"Formulae".  I can't deduce why it does this.


Why does it do this?

Can I stop it reverting to the default?

David Lynch

Version: 7.0.3.1 (x64)
Build ID: d7547858d014d4cf69878db179d326fc3483e082
CPU threads: 4; OS: Windows 10.0 Build 19041; UI render: Skia/Raster; 
VCL: win

Locale: en-GB (en_GB); UI: en-GB
Calc: threaded



--
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] [Gramps-devel] Crash report (unable to report via Bugzilla)

[David Lynch]

Crash in: 
mdds::multi_type_vector,mdds::mtv::noncopyable_managed_element_block<53,EditTextObject>,mdds::mtv::noncopyable_managed_element_block<54,ScFormulaCell> 
>,sc::CellStoreEven


I have just added a new sheet and I tried to paste some cells into it. I 
cannot attach the calc file because LO didn't offer me the chance to 
recover it.


 If I try and report this via Bugzilla I get the error message:

 The text you entered in the Crash report or crash signature field is 
too long (259 characters, above the maximum length allowed of 255 
characters).


 David Lynch

Version: 7.0.0.3 (x64)
Build ID: 8061b3e9204bef6b321a21033174034a5e2ea88e
CPU threads: 4; OS: Windows 10.0 Build 19041; UI render: Skia/Raster; 
VCL: win

Locale: en-GB (en_GB); UI: en-GB
Calc: threaded




___
Gramps-devel mailing list
gramps-de...@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gramps-devel


--
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] Re: Calc: suppress header/footer from page 15 onwards

[David S. Crampton]

Brian and all,

I expect that the technique of creating a Style for each sheet will work. As
it was this afternoon I didn't have the moxo to work through the Edit Styles
dialogs.  

You asked what my clumsy workaround was: OK, with some shyness... but it got
the job done by 3 pm!

Select Sheet1 with an already defined Print Area.  Check or make the Format
Page | Footer specify .  Print! In my case I printed to PDF.  PDF
looks good; save it as Sheet1.PDF

Now, the dufus: Return to the ODS; select Sheet2. Go to Format Page | Footer
and change the text to . Now again print to PDF. This will create
Sheet2.PDF.  Looks good.

Now, paying the monthly Adobe "Cloud" subscription I have available the
"Combine Pages" functionality.  Specify "Combine"; navigate and select the 2
PDF from above. Combine and it creates a "Binder1.PDF".  Examine, close,
rename as desired.

Next month I will be asked to again update and publish this contact list.  I
will work with page styles first.

David



-
--
David S. Crampton
--
Sent from: 
http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html

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

[libreoffice-users] Re: Calc: suppress header/footer from page 15 onwards

[David S. Crampton]

Here it is 9 years later. I just encountered a need to have Sheet1 use
Footer1 (Sheet1 prints in 3 pages). Then Sheet2 use Footer2 (another 3
pages).  With focus on either Sheet1 or Sheet2 to set 'Format | Page |
Footer ... ' changes the Footer to be the same in both Sheets. I worked
around it but clumsy and error prone.

Using v 6.2.8.2




-
--
David S. Crampton
--
Sent from: 
http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html

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

[libreoffice-users] Can I stop Calc altering the formulas I enter?

[David Lynch]

In my spreadsheet I have several cells named with a single letter (using 
Sheet -> Named Ranges and Expressions ->), for example "I" and "A".


If I enter a formula ending in "I" and hit the enter key, it changes the 
"I" to "IF()", if ending in "A" to "ACCRINT()", I have to click the tick 
button in the formula bar rather than hit [enter] to retain the "I" and 
"A" as I entered them.


Is there any way to stop this behaviour and make [enter] act in the same 
way as clicking the tick button. I have Tools - Options- LibreOffice - 
General - Extended tips unchecked.


David Lynch



--
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 size in Formula bar

[David Lynch]

I have just updated to 6.3.04. The font size  in the formula bar has got 
bigger. Is there a way I can reduce the size?


Version: 6.3.0.4 (x64)
Build ID: 057fc023c990d676a43019934386b85b21a9ee99
CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win;
Locale: en-GB (en_GB); UI-Language: en-GB
Calc: threaded

Windows 10

David Lynch



--
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] Ask help about recent directories

[David MartinezRamirez]

Hi!

I would like to ask for a change in programming: "Open File menu item"

I need to be able to open a recent file by frequency of use (of
files), instead of (last used).

I have many directories and files to open and each time I need to open
a file, the directory is not the last one I used, and I have to search
for it manually, and it is too slow to find.

And also configure the program to remember the image directory (Insert
Image menu), because it changes also (Was it working good before?,
perhaps is my own computer...).

I hope this could be solved by an automatic program and improve the
user experience.

Thank you

-- 
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] I have been using open office, libre office and open everything since 1985

[David B Teague sr]

I started using StarOffice a ways back, then OpenOffice.org, then 
Libreoffice since Oracle bought Sun.
I do not now have, nor have I ever had, stability problems, except 
_sometimes_ when I install a new release over the old one.  Now, I 
_always_ remove the old version before installing a new version. Never a 
problem since.


I note that I need to install a new version.

-- David

Version: 6.2.1.2 (x64)
Build ID: 7bcb35dc3024a62dea0caee87020152d1ee96e71
CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win;
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded

On 1/11/2019 5:58 AM, fudmier wrote:



but I can tell you what has happened to libre office over the past two 
years has turned me off..

nothing about it is stable.. it stinks.



--
nil significat nisi oscillat
do wop, do wop, do wop! -- Duke Ellington



--
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] Poor preformance MacOS

[David]

Hi there,

has this issue been fixed already? See: 
https://www.reddit.com/r/libreoffice/comments/94n2e3/libreoffice_so_slow_its_almost_unusable_on_mac/
No matter if I use LO 6.1 or the latest 6.2, performance in MacOS is
sluggish to the point that LO is virtually unusable. Scrolling is
sluggish even in small Calc spreadsheets as well as in Writer. Not the
mention in more complex spreadsheets.

I'm on the latest MacOS 10.14.4 and LO 6.2.3. Also tried 6.1.5 all x64.

Thanks a lot.

David


-- 
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] Question about Installation glitch upgrading from LO 5.x to LO 6.0.6.2

[David B Teague sr]

Hi LibreOffice Users:

My system:
64 bit Windows 7 Home Premium
LibreOffice 6.0.6.2
off line help for LO 6.0.6

Installation glitch upgrading from LO 5.x to LO 6.0.6.2

Started Installer, process displayed UAC dialog.  I answered "Yes"

Installer proceeded up to a point, then failed, stating the installer 
did not have sufficient privilege to access C:\Program Files\LibreOffice


I clicked "retry" several times to no avail, then backed out. A retry 
also failed. In casting about for a solution, I happened to reboot.


Then I recalled that inaccessible files are sometimes removed or made 
accessible after a reboot. I retried installation, LO 6.0.6.2 installed 
quickly along with off line help


My Question: Should I have known this might or would occur?  And could 
this glitch have been predicted and users warned?


Warmest Regard
David Teague

--
nil significat nisi oscillat
do wop, do wop, do wop! -- Duke Ellington



--
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] Unable to access offline help in 6.1

[David Lynch]

On 08/08/2018 20:37, Dave Barton wrote:

Same here:
Version: 6.1.0.3 (x64)
Build ID: efb621ed25068d70781dc026f7e9c5187a4decd1
CPU threads: 8; OS: Windows 6.1; UI render: GL;
Locale: en-GB (en_GB); Calc: group threaded

C:\Program Files\LibreOffice\help\Index.html
Opens:
file:///C:/Program%20Files/LibreOffice/help/en-US/text/shared/main0108.html?&DbPAR=WRITER&System=WIN

Do you want to submit the bug report or shall I?

Dave


You go ahead. Thanks.

David


On 08.08.2018 19:33, David Lynch wrote:

I cannot access the offline help in:

Version: 6.1.0.3 (x64)
Build ID: efb621ed25068d70781dc026f7e9c5187a4decd1
CPU threads: 4; OS: Windows 10.0; UI render: default;
Locale: en-GB (en_GB); Calc: group threaded

C:\Program Files\LibreOffice\help\en-GB

exists and appears to have the correct contents.

In Tools>Options>Language Settings>Language Of

User interface English(UK)

Locale setting English(UK)

Locale setting Default - English(UK) does not work either.

Installation files downloaded:

LibreOffice_6.1.0_Win_x64_helppack_en-GB

LibreOffice_6.1.0_Win_x64

All worked well in 6.0.5.


David Lynch








--
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] Unable to access offline help in 6.1

[David Lynch]

I cannot access the offline help in:

Version: 6.1.0.3 (x64)
Build ID: efb621ed25068d70781dc026f7e9c5187a4decd1
CPU threads: 4; OS: Windows 10.0; UI render: default;
Locale: en-GB (en_GB); Calc: group threaded

C:\Program Files\LibreOffice\help\en-GB

exists and appears to have the correct contents.

In Tools>Options>Language Settings>Language Of

User interface English(UK)

Locale setting English(UK)

Locale setting Default - English(UK) does not work either.

Installation files downloaded:

LibreOffice_6.1.0_Win_x64_helppack_en-GB

LibreOffice_6.1.0_Win_x64

All worked well in 6.0.5.


David Lynch



--
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] SOLVED was Re: Installation failure of LibreOffice 6.0.5

[David B Teague sr]

SOLVED: Installation "failure" for 64 bit LO 6.0.5

This Window 7 computer blocks some installer files. You find that in 
file "Properties." Your mileage may vary with other Windows versions.


A fix for this:
Right click LO .msi installer
At the bottom find properties.
Click Properties
At the bottom of the General tab find Security, and this information:
"This file came from another computer and might be blocked to help 
protect this computer."  There is a button "Unblock"

Click "Unblock"
This will enable the installer to start.

Notes:
6.0.5 took about 5 minutes on my machine to produce the UAC dialog. Wait 
for it.
Total install time, about 20 minutes, including to install the 6.0.5 
local help files.


Thanks to Brian Barker who promptly answered. He pointed out that I 
fetched the x86 version from the mirror and that accounted for the 
difference in file size.  I should have realized that. My lapse.


With Warmest Regard
David Teague

On 7/24/2018 11:20 AM, David B Teague sr wrote:

Subject: Installation failure of LibreOffice 6.0.5
64 bit W7, Firefox 52.9

I fetched LibreOffice_6.0.5_x64.msi from www.libreoffice.org/download/

I removed the old version prior to installing a 6.0.5.  The installer 
started, offered the usual questions, then failed before the progress 
bar had moved at all. No UAC dialog offered. I fetched a second copy 
which failed in the same way.


Next different mirror:
http://mirror2.layerjet.com/tdf/libreoffice/stable/6.0.5/win/x86/LibreOffice_6.0.5_Win_x86.msi 
(us, prio 100)


This was substantially slower (15 min.) than the utexas mirror (5 
min.) This file is only 246 MB compared to the utexas copy 262 MB.


This copy also fails, same mode.

'Net search results suggest the .msi file must be run as 
administrator. I have administrator priv, but the UAC dialog isn't 
offered when I attempt to run, as it does with every other .exe or 
.msi file I have tried.


Shift - right click  offers option of  "run as another user" which 
requires an id and password, but neither the administrator nor  my 
account have password(s) set. The dialog refuses to accept 
administrator as the user and a blank password isn't allowed.


But for the fact that a UAC dialog isn't offered when I attempt to run 
the installer, I'd say this is a Windows problem.


In any event, you all know more about LO & Windows than I (at 81) am 
likely to learn in my time left on this Earth.


Help, please.

Meanwhile, I'll reinstall the old version.

Please copy me with your responses.

Warmest Regard
David Teague

-- nil significat nisi oscillat
do wop, do wop, do wop! -- Duke Ellington



--
nil significat nisi oscillat
do wop, do wop, do wop! -- Duke Ellington



--
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] Installation failure of LibreOffice 6.0.5

[David B Teague sr]

Subject: Installation failure of LibreOffice 6.0.5
64 bit W7, Firefox 52.9

I fetched LibreOffice_6.0.5_x64.msi from www.libreoffice.org/download/

I removed the old version prior to installing a 6.0.5.  The installer 
started, offered the usual questions, then failed before the progress 
bar had moved at all. No UAC dialog offered. I fetched a second copy 
which failed in the same way.


Next different mirror:
http://mirror2.layerjet.com/tdf/libreoffice/stable/6.0.5/win/x86/LibreOffice_6.0.5_Win_x86.msi 
(us, prio 100)


This was substantially slower (15 min.) than the utexas mirror (5 min.) 
This file is only 246 MB compared to the utexas copy 262 MB.


This copy also fails, same mode.

'Net search results suggest the .msi file must be run as administrator. 
I have administrator priv, but the UAC dialog isn't offered when I 
attempt to run, as it does with every other .exe or .msi file I have tried.


Shift - right click  offers option of  "run as another user" which 
requires an id and password, but neither the administrator nor  my 
account have password(s) set. The dialog refuses to accept administrator 
as the user and a blank password isn't allowed.


But for the fact that a UAC dialog isn't offered when I attempt to run 
the installer, I'd say this is a Windows problem.


In any event, you all know more about LO & Windows than I (at 81) am 
likely to learn in my time left on this Earth.


Help, please.

Meanwhile, I'll reinstall the old version.

Please copy me with your responses.

Warmest Regard
David Teague

-- nil significat nisi oscillat
do wop, do wop, do wop! -- Duke Ellington



--
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] Long comments in calc?

[David Rakidzija]

Hi,

what's the best way to insert long comments into calc? A floating window that 
does not interfere with the spreadsheet itself would be best.
1. the built in commentary for cells seems to be buggy, sometimes wound't 
display corretly, cannot be resized... unusable for me if it's more than a 
couple of words
2. merging cells is not what I want. Cannot really edit the box as if it were 
a text box and resizing seems difficult
3. Supposedly there is a text box function, but whenever I click it nothing 
happens (insert -> text box)

I'm using LO 6.0.4.

Thanks for your help.



-- 
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] what version of LO would work on a really old system?

[David Burleigh]

It's interesting to hear of Kubuntu working well on an old machine.
When I last tried using it a few years ago, Nepumuk and Aconadi bogged
it down so much that it became unusable. 
On Fri, 2018-02-23 at 16:42 +, Tom Davies wrote:
> Hi :)
> Would Gnome Office (ie Abiword and Gnumeric) be better?
> 
> Also last time i tried distro-hopping on 'old' machines i found that
> Kubuntu was much faster and lighter-weight than even Lubuntu and
> Xubuntu.
> There was a ton of stuff to figure out and apps etc to add o really
> get the
> most out of it but the default set-up looks really swish and is very
> usable.  Perhaps best to let the new owner enjoy their own voyage of
> discovery.  Kubuntu uses a different office suite and i found that
> so light
> and fast that i didn't bother to try out LibreOffice on it.
> KOffice/Calligra uses the same file-formats as LibreOffice.
> 
> Regards from
> a Tom :)
> 
> 
> 
> 
> On 23 February 2018 at 14:43, M Henri Day 
> wrote:
> 
> > 2018-02-23 3:02 GMT+01:00 Tim-L :
> > 
> > > I am getting an old HP desktop, that originally WinXP, ready to
> > > give
> > 
> > away.
> > > It has 64-bit AMD 3300+ CPU, 512MB ram, and only 160GB
> > > drive.  It was an
> > > original Windows XP 32-bit OS system on a 64-bit hardware. Since
> > > it needs
> > > ALL of the old user's info removed, and XP OS "damaged", It was
> > > better to
> > > just make it a Linux system - for security reasons.
> > > 
> > > I just installed Ubuntu MATE 16.04 64-bit on it.  Their specs
> > > stated
> > > 32-bit would be best but the system keeps failing due a SIS630
> > > "module
> > > missing".
> > > 
> > > So with these specs, what is the newest version of LO you would
> > > install?
> > > With this low RAM, it may not be able to handle the newest
> > > versions. As I
> > > type this, the old system is now in the "software updating"
> > > cycle.  So,
> > 
> > it
> > > is installing the newest LO that is in Ubuntu 16.04's
> > > repository.
> > > 
> > > To be honest, this system is a little old for my needs, but for
> > > a free
> > > giveaway system [HP desktop, keyboard, mouse, and a HP "square"
> > > 15 inch
> > > monitor], I do not have any parts to upgrade it and do not want
> > > to buy
> > 
> > any
> > > hardware for it.
> > > 
> > > So, what is the newest version I can install without and
> > > problems?.
> > > 
> > 
> > Tim, if you've managed to successfully install 64-bit Ubuntu MATE
> > 16.04 on
> > this system, you should be able to install and run any version of
> > LO - why
> > not take the latest, 6.0.1 (or 6.0.2 to which LO just updated
> > itself via
> > the PPA om my Linux box) ? The only thing I'd recommend beyond
> > this would
> > be installing a bit more RAM. Even if you've made clear that you
> > don't wish
> > to buy any hardware for it, you should be able to obtain some used
> > DDR-2
> > sticks, which the motherboard is almost certain to support, for
> > next to
> > nothing, which would make a great deal of difference in how you
> > experience
> > the computer (the system requirements for 64-bit LO 6.0.1 are
> > listed as 256
> > MB RAM, with 512 MB recommended)
> > 
> > Henri
> > 
> > --
> > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> > Problems? https://www.libreoffice.org/get-help/mailing-lists/how-t
> > o-
> > unsubscribe/
> > Posting guidelines + more: https://wiki.documentfoundation.org/Net
> > iquette
> > List archive: https://listarchives.libreoffice.org/global/users/
> > All messages sent to this list will be publicly archived and
> > cannot be
> > deleted
> > 
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Underlinng? easy. How do I overline?

[David B Teague sr]

Libreoffice community:

Underlining is a common task in LO, and it is easy. Control U. But I 
need to overline (also called overscore or overbar), some text, in my 
case digits. Overlining is common in scientific fields, and I use it to 
indicate a shift, a motion of the hand, on double bass music.


How do I do this? I'd like to have a font, not unlike the underline 
font. (I hope I'm not missing something here.)


With Warmest Regaard
David Teague

--

nil significat nisi oscillat
do wop, do wop, do wop! -- Duke Ellington



--
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] Unable to install off-line help for 5.4.0.3

[David Lynch]

Version: 5.4.0.3 (x64)
Build ID: 7556cbc6811c9d992f4064ab9287069087d7f62c
CPU threads: 4; OS: Windows 6.19; UI render: default;
Locale: en-GB (en_GB); Calc: group

Windows 10

download url for help:

<https://www.libreoffice.org/download/download/?type=win-x86_64&version=5.4.0&lang=en-GB>

 Both main program and help are x64 versions.


After installing, I get the error message:

The LibreOffice built-in help is not installed on your computer.

Any ideas, please?

David Lynch




--
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] Distorted text when scrolling in Writer

[David Burleigh]

There is already at least one bug report about this issue dating back
to 2012, yet still unresolved:
https://bugs.documentfoundation.org/show_bug.cgi?id=58358
and I'm perplexed as to how something so fundamental and so annoying
can seem to have such low priority. I'm running Linux Mint 18.2
(Cinnamon), and the latest LibreOffice 5.4.0.3, and the distorted text 
while scrolling (using Ctrl-downarrow) from paragraph to paragraph is a
very tiresome distraction to getting work done. So I'm wondering
whether other users of the same platform are experiencing the same
thing, and if not, whether there is a work-around -- a setting
somewhere that causes the text to be rendered correctly while
scrolling.
-- 
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] installing 64 bit Libreoffice

[David B Teague sr]

Hi Gentlefolk:

I have 64 bit Windows 7 Home Premium on a Gigabyte MoBo with AMD Phenom 
II X4 840 processor and 4 GB Ram.


I wanted to upgrade my 32 bit LibreOffice to 64 bit 5.3.4 "fresh". For 
32 bit upgrades, I have always (successfully) installed over the 
previous version, but I was concerned about installing a 64 bit version 
where the current one is 32 bits. So I removed local help then the 32 
bit program. I then successfully installed the 64 bit version and help.


My question is, was it necessary to remove the 32 bit version? I found 
no cautions about  upgrading a 32 bit version with a 64 bit version in 
the notes.


Thank you all for a wonderful piece of software.

Warmest Regard
David Teague



--
nil significat nisi oscillat
do wop, do wop, do wop! -- Duke Ellington



--
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 Scolling problems under Windows.

[David Lynch]

On 23/07/2017 10:07, Dave wrote:

I am encountering an increasing number of scroll rendering issues, with
ODF documents (.odt) opened in LO 5.3.4 and 5.4.0.2 under Windows 7, 8.1
& 10 The issue is that some (not all) documents take several seconds to
scroll single lines and up to a minute to scroll a few pages.

The issue does not manifest itself in LO 5.3.4 under Linux, AOO 4.3.1 or
LO 3.3 under Windows.

Is anyone else experiencing a similar issue, or is there a known
rendering problem in recent versions of LO?

Regards
Dave


I have reported this

<https://bugs.documentfoundation.org/show_bug.cgi?id=107770>

Please add clarification, comment or support.

David Lynch



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

[David Lynch]

On 30/05/2017 22:00, charles meyer wrote:

There seems to be quite a few posts re: tech glitches with the latest LO.

Is that just with the Linux version or are others finding issues with the
Windows version as well?

I have reverted to 5.3.1.2 because of 
<https://bugs.documentfoundation.org/show_bug.cgi?id=107770> on Windows 10.


David Lynch

--
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: Sluggish response from version 5.3.2.2

[David Lynch]

On 11/05/2017 11:52, David Lynch wrote:

I installed

Version: 5.3.2.2 (x64)
Build ID: 6cd4f1ef626f15116896b1d8e1398b56da0d0ee1

Windows 10

yesterday. It seems to be running slowly, particularly scrolling and 
altering column widths (you can see the latter proceeding in jumps).


I am editing the same spreadsheet as I was under 5.3.1 (installed 28 
March).


Has anyone else noticed a change in responsiveness?

David Lynch

I have had to revert to 5.3.1: the spreadsheet works fine there.

I have opened a bug 
<https://bugs.documentfoundation.org/show_bug.cgi?id=107770>


David Lynch

--
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: Sluggish response from version 5.3.2.2

[David Lynch]

I installed

Version: 5.3.2.2 (x64)
Build ID: 6cd4f1ef626f15116896b1d8e1398b56da0d0ee1

Windows 10

yesterday. It seems to be running slowly, particularly scrolling and 
altering column widths (you can see the latter proceeding in jumps).


I am editing the same spreadsheet as I was under 5.3.1 (installed 28 March).

Has anyone else noticed a change in responsiveness?

David Lynch






--
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] Enhancements to Calc functions

[David Lynch]

The new functions, TEXTJOIN and CONCAT, have been a great help, allowing 
me to simplify some spreadsheets.


Partly motivated by this success, I have asked for enhancements to some 
existing Calc functions that I would find useful:





Comments (and support) would be welcome.

All these enhancements are such that existing spreadsheets would 
continue to work without needing modification.


The enhancements are highlighted below (*** ... ***).

SUBSTITUTE("Text"; "SearchText"; "NewText"; Occurrence)

Text is the text string in which text segments are to be exchanged.
SearchText is the text segment that is to be replaced (a number of 
times).

NewText is the text string that is to replace the text segment.
Occurrence (optional) indicates which occurrence of the search text 
is to be replaced. If this parameter is omitted the search text is 
replaced throughout.
*** If SearchText and NewText are both arrays, they must be the same 
length: then each array element of NewText replaces the corresponding 
element of SearchText. If only SearchText is an array, NewText replaces 
each element of SearchText. ***


REPLACE("Text"; Position; Length; "NewText")
Text refers to text of which a part will be replaced.
Position refers to the position within the text where the 
replacement will begin.

Length is the number of characters in Text to be replaced.
NewText refers to the text which replaces Text.
*** Text and NewText can be regular expressions. ***

MATCH(SearchCriterion; LookupArray; Type)
SearchCriterion is the value which is to be searched for in the 
single-row or single-column array.
LookupArray is the reference searched. A lookup array can be a 
single row or column, or part of a single row or column.
Type may take the values 1, 0, or -1. If Type = 1 or if this 
optional parameter is omitted, it is assumed that the first column of 
the search array is sorted in ascending order. If Type = -1 it is 
assumed that the column is sorted in descending order. This corresponds 
to the same function in Microsoft Excel.
If Type = 0, only exact matches are found. If the search criterion 
is found more than once, the function returns the index of the first 
matching value. Only if Type = 0 *** or Type > 1 *** can you search for 
regular expressions (if enabled in calculation options) or wildcards (if 
enabled in calculation options).
If Type = 1 or the third parameter is omitted, the index of the 
last value that is smaller than or equal to the search criterion is 
returned. This applies even when the search array is not sorted. For 
Type = -1, the index of the first value that is larger than or equal is 
returned.
*** If Type > 1, only exact matches are found. If the search criterion 
is found more than once, the function returns the index of the Type'th 
matching value.


VLOOKUP(SearchCriterion; Array; Index; Sorted)
HLOOKUP(SearchCriterion; Array; Index; Sorted)
*** Sorted does the same as the Type parameter in function MATCH. ***


--
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] Titles not centered in Master Document

[David Burleigh]

Paragraph margins? I don't see that setting anywhere. There are only
the indents in the style settings.

On Mon, 26 Dec 2016 03:23:29 +
toki  wrote:

> On 12/25/2016 08:26 AM, David Burleigh wrote:
> 
>  [...]  
> 
> Paragraph margins.
> 
>  [...]  
> 
> Are you looking at the styles, as set in the master document, or in
> the sub documents?
> 
> jonathon
> 
> 




-- 
David Burleigh
828-475-5126

-- 
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] Titles not centered in Master Document

[David Burleigh]

On Sun, 25 Dec 2016 04:29:12 +
toki  wrote:

> On 12/20/2016 10:53 AM, David Burleigh wrote:
> 
>  [...]  
> 
> Look at the settings for:
> * Page Margins;
> * Style Margins;
> 
> jonathon

The page margins are the same for all styles on the page, so I don't
see how those would independently affect the centering of the Title
relative to the other text on the page. 

I don't know what you mean by Style Margins. When I edit the Title
style, there is no Margins attribute. There are "Indents & Spacing"
which have zero indents relative to either margin.

-- 
David Burleigh
828-475-5126

-- 
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] Titles not centered in Master Document

[David Burleigh]

I have a master document in which the titles in the subdocuments do not
center properly. When opening the subdocuments directly (not within the
master document), the titles center just fine, but the titles are
displayed off-center when they are imported into the master document.
The Title style in both the subdocument and the master document are the
same, using center alignment. The only thing that is different in the
master document format is that it uses a 2-column page format, while
in the subdocument the page format is single column. But I tried
switching to 2-column format in the subdocument when opened
independently from the master document, and the titles center just
fine. It is only when imported into the master document that the titles
are off center. What is going on?

-- 
David Burleigh
828-475-5126

-- 
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 a field to TOC entries

[David Burleigh]

Thank you for the ideas. I'll fiddle around with it. 

On Fri, 16 Dec 2016 16:50:20 +0100
Kruno  wrote:

> 16.12.2016 u 15:49, David Burleigh je napisao/la:
>  [...]  
> 
> You can make new paragraph style and write some content with it at
> top or bottom of every sub-document. You can even make such paragraph 
> invisible if you don't want it to show in sub-documents pages. When 
> inserting table of contents, after Insert → Table of contents and 
> Indexes → Table of content, Index, Bibliography -- check 'Additional 
> styles' and choose style in which you used for unique identifier.
> 
> You also might want to play with Outlines and Numberings (Tools → 
> Outline and numberings) so you can set Heading 1 style to be at level 
> two in table of contents and unique identifier at level one (in table
> of contents' dialog box), if that's what you want.
> 
>  [...]  
> 
> I don't know other method but using indexes. What you can do is mark 
> every chapter and sub-chapter (including unique identifier) as index 
> entry so you can have it all but not quite structured as it would be
> in table of contents.
> 
> I can't do better, sorry
> 
> Kruno
> 
> 




-- 
David Burleigh
828-475-5126

-- 
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] Adding a field to TOC entries

[David Burleigh]

Is there any way to add a field to entries in a Table of Contents? For
each chapter in a master document, I want to include in the Table of
Contents, along with the title of that chapter, a unique identifier for
the sub-document that contains that chapter. 

Also, is it possible to have a Table of Contents sorted alphabetically,
rather than by consecutive page number? I know I can make an
alphabetical index, but I think it would be cumbersome to limit that
index only have the chapter titles as its entries. 
-- 
David Burleigh
828-475-5126

-- 
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-activating the Recent Documents Function in LibreOffice 5

[David Dorman]

For most of the time I was using LibreOffice 4, the system kept track 
the most recent documents and I was able to click on "Recent Documents" 
to quickly go to a document I was working on.  At some point in the last 
year, the function ceased to work.  When I upgraded to LibreOffice 5 I 
thought the function might return, but it did not.  I tried to 
re-activate the "Recent Documents" function by clicking on "Customize" 
in the drop down menu under "Tools" and then clicking on "Recent 
Documents" in the "Menu Content" box of the "Menus" tab, but from there 
I could not figure out what to do to re-activate the "Recent Documents" 
function.  I would appreciate help if anyone out there knows how I can 
get the "Recent Documents" function to work again.


David Dorman

--
David Dorman
Chicago, Illinois
david.dor...@kwasu.edu.ng
ddor...@marlboro.edu
US Mobile Number: +1 860-389-1568



--
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] LibreOffice 5.1.1.3 Writer new bug?

[David Gressett]

I get the same thing with 5.1.0.3 (was 5.1.1.3 a typo?)

I tried again, and did only the first space addition. I found that 
if I go to a new line  and enter any text, such as 

asdfgh

and then add a space and the two-piece arrow -> so that I get

asdfgh ->

when I press space after adding the arrow, I again get the extra semplificazione

-Original Message-
From: Carlo Strata [mailto:carlo.str...@tiscali.it] 
Sent: Friday, March 04, 2016 9:47 AM
To: LibreOffice, users 
Subject: [libreoffice-users] LibreOffice 5.1.1.3 Writer new bug?

Hi Everyone,

I get a strange behaviour with the new 5.1.1.3 LibreOffice Win_x64 on Microsoft 
Windows 10, x64, daily updated build 1511, ita gui.

... snip ...

Am I the only one?

Have a nice evening,

Carlo



-- 
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] Default column width in Calc

[David Lynch]

I want to change the default column width so that when I double click 
the divider on an empty column, the width of the column is this new 
default value. Is this possible?


Here is what happens now.

Open a new spreadsheet, the default column width is 2.26 cm.
[cntl-a] Format->Column->Width... change to 0.5 cm (doesn't matter when 
Default value is ticked or not)

Enter aaa in a1, ccc in c1.
Select columns A, B and C.
Double click divider.
Column B is 2.26 cm wide. I want it to be 0.5 cm wide.

David Lynch

Version: 5.1.0.3
Build ID: 5e3e00a007d9b3b6efb6797a8b8e57b51ab1f737
Widows 10


--
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] Need help To convert Excel Sheet to Libre sheet

[David Johnson]

Dear Joel,
It is a paid processional, we need to recreate the same excel in Libre 
office, we need this at the earliest.

--
Thanks &Regards,
*|David Johnson|***|***H**O* - Technology & Process*|**|**Janalakshmi 
Financial Services Limited**|***|**No.34/1 Andree Road, Shantinagar, 
Bangalore - 560027*|***|***www.janalakshmi.com**|*
*|**Phone :* +91 080-42595100/700*|**|**Ext*-242*|**|**Mobile*: +91 
95-38-455118*||**E-Mail *: david.john...@janalakshmi.com*|*

On 11-09-2015 10:40, Joel Madero wrote:
You mean a paid professional? I could ask one or two people - if 
you're instead asking for a volunteer to assist, best bet is to just 
asked around on the email thread and maybe the OOo forum (there are a 
few great macro people over there).


Best,
Joel

On 09/10/2015 09:39 PM, David Johnson wrote:

Dear Joel & Tim,
Thanks for your valuable inputs, appreciate it. Is there any 
professional, whom you know, could help me to redevelop the same in 
Libre Calc.

--
Thanks &Regards,
*|David Johnson|***|***H**O* - Technology & Process*|**|**Janalakshmi 
Financial Services Limited**|***|**No.34/1 Andree Road, Shantinagar, 
Bangalore - 560027*|***|***www.janalakshmi.com**|*
*|**Phone :* +91 080-42595100/700*|**|**Ext*-242*|**|**Mobile*: +91 
95-38-455118*||**E-Mail *: david.john...@janalakshmi.com*|*

On 11-09-2015 04:20, Joel Madero wrote:
That is a true statement - LibreOffice does not support the 
proprietary Microsoft VBA (it may in a very very limited way but not 
enough for most test cases that I've seen) - you'll have to rewrite 
it in Basic.


Best,
Joel

On Thu, Sep 10, 2015 at 2:04 PM, Tim Lloyd <mailto:tim.ll...@gmx.com>> wrote:


Hi David,

my understanding is that macros in excel and calc are written in
different languages so need to be rewritten.

Maybe one of the more learned members of the forum can confirm
or otherwise.

Cheers


On 10/09/15 19:48, David Johnson wrote:


Dear Gabriele and Tim,
PFA; This is the Excel Macro sheet we are trying to convert.
Could you please help me.

-- 
Thanks &Regards,

*|David Johnson|***|***H**O* - Technology &
Process*|**|**Janalakshmi Financial Services
Limited**|***|**No.34/1 Andree Road, Shantinagar, Bangalore
- 560027*|***|***www.janalakshmi.com
<http://www.janalakshmi.com>**|*
*|**Phone :* +91 080-42595100
/700*|**|**Ext*-242*|**|**Mobile*:
+91 95-38-455118 *||**E-Mail *:
david.john...@janalakshmi.com
<mailto:david.john...@janalakshmi.com>*|*
    On 10-09-2015 12:17, Tim Lloyd wrote:

Hi David,

as noted below. It could just work! Which version were
you think of using? I think there is some consensus that
5.0 may be a little too "fresh" for an enterprise
environment. So the still version of 4.4.5 may be a good
base. Download this version and give it a go:

http://www.libreoffice.org/download/libreoffice-still/

There may also be some value having a hunt around the
bugzilla to see if any issues are relevant to yourselves.

https://bugs.documentfoundation.org/

Cheers

On 10/09/15 16:24, Gabriele Ponzo wrote:

What's your problem specifically?

Unless there are macros, usually it's enough to open
LibreOffice Calc and
let it open the excel file. Then save it in odf
(.ods) format.

Let is know of there are troubles with these steps,
and please report
specific problems.

All the best.
Il 10/set/2015 07:16, "David Johnson"
 ha
scritto:

Dear Users,
I'm David Johnson, from the Technology team from
Janalakshmi Financial
Services, Bangalore based NDFC. Currently we are
migrating our excel based
application to Libre office; hence I need Help
on the same. We have been
using a survey kind of tool which is developed
in Excel to be converted in
to Libre office. Can anybody advice us how we go
about it. It has to work
on all the platforms. Please advice.

If there is anybody (a consultant) in around
Bangalore. Who can support us
are welcomed. Look forward for your support at
the earliest.

    -- 
-- 
Thanks &Regards,

*|David Johnson|***|***H**O* - Technology &
Process*|**|*

Re: [libreoffice-users] Need help To convert Excel Sheet to Libre sheet

[David Johnson]

Dear Joel & Tim,
Thanks for your valuable inputs, appreciate it. Is there any 
professional, whom you know, could help me to redevelop the same in 
Libre Calc.

--
Thanks &Regards,
*|David Johnson|***|***H**O* - Technology & Process*|**|**Janalakshmi 
Financial Services Limited**|***|**No.34/1 Andree Road, Shantinagar, 
Bangalore - 560027*|***|***www.janalakshmi.com**|*
*|**Phone :* +91 080-42595100/700*|**|**Ext*-242*|**|**Mobile*: +91 
95-38-455118*||**E-Mail *: david.john...@janalakshmi.com*|*

On 11-09-2015 04:20, Joel Madero wrote:
That is a true statement - LibreOffice does not support the 
proprietary Microsoft VBA (it may in a very very limited way but not 
enough for most test cases that I've seen) - you'll have to rewrite it 
in Basic.


Best,
Joel

On Thu, Sep 10, 2015 at 2:04 PM, Tim Lloyd <mailto:tim.ll...@gmx.com>> wrote:


Hi David,

my understanding is that macros in excel and calc are written in
different languages so need to be rewritten.

Maybe one of the more learned members of the forum can confirm or
otherwise.

Cheers


On 10/09/15 19:48, David Johnson wrote:


Dear Gabriele and Tim,
PFA; This is the Excel Macro sheet we are trying to convert.
Could you please help me.

-- 
    Thanks &Regards,

*|David Johnson|***|***H**O* - Technology &
Process*|**|**Janalakshmi Financial Services
Limited**|***|**No.34/1 Andree Road, Shantinagar, Bangalore -
560027*|***|***www.janalakshmi.com
<http://www.janalakshmi.com>**|*
*|**Phone :* +91 080-42595100
/700*|**|**Ext*-242*|**|**Mobile*:
+91 95-38-455118 *||**E-Mail *:
david.john...@janalakshmi.com
<mailto:david.john...@janalakshmi.com>*|*
On 10-09-2015 12:17, Tim Lloyd wrote:

Hi David,

as noted below. It could just work! Which version were you
think of using? I think there is some consensus that 5.0
may be a little too "fresh" for an enterprise environment.
So the still version of 4.4.5 may be a good base. Download
this version and give it a go:

http://www.libreoffice.org/download/libreoffice-still/

There may also be some value having a hunt around the
bugzilla to see if any issues are relevant to yourselves.

https://bugs.documentfoundation.org/

Cheers

On 10/09/15 16:24, Gabriele Ponzo wrote:

What's your problem specifically?

Unless there are macros, usually it's enough to open
LibreOffice Calc and
let it open the excel file. Then save it in odf (.ods)
format.

Let is know of there are troubles with these steps,
and please report
specific problems.

    All the best.
Il 10/set/2015 07:16, "David Johnson"
mailto:david.john...@janalakshmi.com>> ha
scritto:

Dear Users,
I'm David Johnson, from the Technology team from
Janalakshmi Financial
Services, Bangalore based NDFC. Currently we are
migrating our excel based
application to Libre office; hence I need Help on
the same. We have been
using a survey kind of tool which is developed in
Excel to be converted in
to Libre office. Can anybody advice us how we go
about it. It has to work
on all the platforms. Please advice.

If there is anybody (a consultant) in around
Bangalore. Who can support us
are welcomed. Look forward for your support at the
earliest.

-- 
-- 
Thanks &Regards,

*|David Johnson|***|***H**O* - Technology &
Process*|**|**Janalakshmi
Financial Services Limited**|***|**No.34/1 Andree
Road, Shantinagar,
Bangalore - 560027*|***|***www.janalakshmi.com
<http://www.janalakshmi.com>**|*
*|**Phone :* +91 080-42595100
/700*|**|**Ext*-242*|**|**Mobile*:
+91
95-38-455118*||**E-Mail *:
david.john...@janalakshmi.com
<mailto:david.john...@janalakshmi.com>*|*

-- 
To unsubscribe e-mail to:

users+unsubscr...@global.libreoffice.org
<mailto:users%2bunsubscr...@global.libreoffice.org>
Problems?

Re: [libreoffice-users] Need help To convert Excel Sheet to Libre sheet

[David Johnson]

Dear Gabriele and Tim,
PFA; This is the Excel Macro sheet we are trying to convert. Could you 
please help me.


--
Thanks &Regards,
*|David Johnson|***|***H**O* - Technology & Process*|**|**Janalakshmi 
Financial Services Limited**|***|**No.34/1 Andree Road, Shantinagar, 
Bangalore - 560027*|***|***www.janalakshmi.com**|*
*|**Phone :* +91 080-42595100/700*|**|**Ext*-242*|**|**Mobile*: +91 
95-38-455118*||**E-Mail *: david.john...@janalakshmi.com*|*

On 10-09-2015 12:17, Tim Lloyd wrote:

Hi David,

as noted below. It could just work! Which version were you think of 
using? I think there is some consensus that 5.0 may be a little too 
"fresh" for an enterprise environment. So the still version of 4.4.5 
may be a good base. Download this version and give it a go:


http://www.libreoffice.org/download/libreoffice-still/

There may also be some value having a hunt around the bugzilla to see 
if any issues are relevant to yourselves.


https://bugs.documentfoundation.org/

Cheers

On 10/09/15 16:24, Gabriele Ponzo wrote:

What's your problem specifically?

Unless there are macros, usually it's enough to open LibreOffice Calc 
and

let it open the excel file. Then save it in odf (.ods) format.

Let is know of there are troubles with these steps, and please report
specific problems.

All the best.
Il 10/set/2015 07:16, "David Johnson"  ha
scritto:


Dear Users,
I'm David Johnson, from the Technology team from Janalakshmi Financial
Services, Bangalore based NDFC. Currently we are migrating our excel 
based
application to Libre office; hence I need Help on the same. We have 
been
using a survey kind of tool which is developed in Excel to be 
converted in
to Libre office. Can anybody advice us how we go about it. It has to 
work

on all the platforms. Please advice.

If there is anybody (a consultant) in around Bangalore. Who can 
support us

are welcomed. Look forward for your support at the earliest.

--
--
Thanks &Regards,
*|David Johnson|***|***H**O* - Technology & Process*|**|**Janalakshmi
Financial Services Limited**|***|**No.34/1 Andree Road, Shantinagar,
Bangalore - 560027*|***|***www.janalakshmi.com**|*
*|**Phone :* +91 080-42595100/700*|**|**Ext*-242*|**|**Mobile*: +91
95-38-455118*||**E-Mail *: david.john...@janalakshmi.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] Need help To convert Excel Sheet to Libre sheet

[David Johnson]

Dear Users,
I'm David Johnson, from the Technology team from Janalakshmi Financial 
Services, Bangalore based NDFC. Currently we are migrating our excel 
based application to Libre office; hence I need Help on the same. We 
have been using a survey kind of tool which is developed in Excel to be 
converted in to Libre office. Can anybody advice us how we go about it. 
It has to work on all the platforms. Please advice.


If there is anybody (a consultant) in around Bangalore. Who can support 
us are welcomed. Look forward for your support at the earliest.


--
--
Thanks &Regards,
*|David Johnson|***|***H**O* - Technology & Process*|**|**Janalakshmi 
Financial Services Limited**|***|**No.34/1 Andree Road, Shantinagar, 
Bangalore - 560027*|***|***www.janalakshmi.com**|*
*|**Phone :* +91 080-42595100/700*|**|**Ext*-242*|**|**Mobile*: +91 
95-38-455118*||**E-Mail *: david.john...@janalakshmi.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

[libreoffice-users] How to use LibreOffice to blur and save a PNG?

[KARR, DAVID]

I have a PNG image.  I need to edit the image to blur out some portions that I 
don't want other people to see, and then save that modified PNG image.

Is this something that LibreOffice can do?  I tried running Draw and then 
opening the PNG.  I believe the "Smooth" operation is what I need.  I can see 
this in the "Filter" dropdown when I click on the image, but I'm not sure what 
to do with that.

I'm guessing if I can figure out how to properly modify the image, I would use 
the "Save Image ..." menu item in the context menu to save the modified PNG.  
Is this correct?

-- 
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] LibreOffice's documentation (pdf and online)

[David Allen]

Hi All,

 Sorry, but this is a rather long email. It's a loose compilation of
answers to the following four questions:

 1) Does anyone EVER look at the pdf documentation? If not, why not?

2) Does anyone EVER click the F1 key for help? If not, why not?

3) Do you see any overall issues concerning the documentation?

4) If the presentation of the documentation were to change to make it more
useful, what would it look like?

 I've compiled them in a more easily readable format (rather than being
spread out over many emails) so that anyone can read through them quickly,
more easily see if anything is missing, and, as I said before, even repeat
what is already there. Again, I don't mind the repetition. Repetition only
adds weight to the answers. In other words, if you have something to say,
please say it.

 Thanks for all the responses already given.

 The following is compiled in no particular order.

(If you're going to respond, could you do so in a manner so that your
responses are easy to distinguish from other text. Email can look so
muddled here sometimes. Not sure how you can do that. Just a thought.
Thanks.)

Thanks,

Davidaa

 1) Does anyone EVER look at the pdf documentation? If not, why not?

 I've been ignoring PDFs as much as possible; I dislike the way these make
it next to impossible to add responses, save in some usable form …

 1. I seldom look at the PDF documentation. Mostly I find what I need
through the F1 key, and also because I forget it's there until I go
searching for an answer online. I'll also go to the PDF when I'm trying to
understand an entire concept (like styles, which still are winning the
battle).

 What PDF documentation?

I can only speak for myself, I don't know what others do, but for programs
or devices that require documentation, I download the pdf file and print it
out, and put the document into a 3-ring binder dedicated to that
application. I would sincerely hope that the file would have an excellent
index. I am much more comfortable with paper documentation that I can have
in front of me while I am looking at the program on screen, or the physical
device.

1) Yes, I have used the pdf documentation from time to time, but don't
often have need to. Normally, only if I have a problem, which might occur
when I'm trying something new and unfamiliar; but most of the time I am
just using LO for the old and familiar! My first action in such a case
would be to check the menus; if I can't find what I need there, I try
searching more widely. It's not always easy to find what I want in a large
document, though; but it's definitely comforting to know it's there, in
case, and it has at times been useful.

 I do use the Pdfs from the "Published Guides" pages. The main advantage is
that the index and chapter headings and such are all "clickable" to get me
to the correct topic very quickly.

I take Anne-ology's point about them being troublesome to add notes to (or
to copy chunks from) but the Pdfs are also in Odt format.

 PDF? I'm not sure I know where to look for LO documentation in this
format?

F1? I use it often. It needs to be compartmenalized (Calc, Writer, Math,
Macro interface [UNO], ...) Its installation also needs to be better
integrated into the LO installation process.

HTML? I occasionally wander into this maze though I'm not sure how I get
there. I guess it's via a link someone posts on this list.


2) Does anyone EVER click the F1 key for help? If not, why not?

 yes, but nary receive a response which answers my question(s)

 Depending upon various factors, when pressing F1, one of five things
will happen:

1) Nothing happens;
# This happens when the help file is not installed;
# This happens when the program can not connect to the Internet;
2) A webpage somewhere on the Internet gets opened, and displayed;
# This happens when the help file is not installed;
3) The Index Page of the built-in help opens;
# When the help file in the appropriate language is installed, this is the
usual, and expected responose;
4) A random page from the built-in help is displayed;
# This does not occur frequently enough to me, to guess as to what is
causing this effect; 5) A page in an "unknown" language is displayed;
# This occurs when the help file in the language that LibO is configured
for, is not installed, but the help file in a different language is
installed;

 A separate issue is the contents of the built in help file.

For some things, the help is current, and accurate.
For other things, the information is not just out of date, but will have
the opposite effect of what one intended.

I use the F1 key all the time. I came to LO after using Windows since it
was created and F1 is the first thing I do to get help on any program. It's
nice when it's context-sensitive, but just going to the built-in help is
sufficient.

 It seems to me, the easiest way to get to help for Calc (for example) is
to google my problem and add "libre office calc" to the query.

If I had to guess, my guess i

Re: [libreoffice-users] Re: how to make formulas permanently case sensitive?

[David Lynch]

On 12/05/2015 21:39, Andreas Säger wrote:

Am 12.05.2015 um 12:55 schrieb hw:


Am 12.05.2015 um 12:45 schrieb hw:

Hi,

I need, of course, formulars to be case sensitive.  This can be set in
the options for calc.  The option is not saved permanently and every
time I open a spreadsheet, I need to set the option again.

How can I save this option permanently so I don't need to set it over
and over again?


To clarify:  I need the string comparisons of IF() to be case sensitive:
  'if(a1 = "x"; ...) is, of course, different from 'if(a1 = "X"; ...)'.


Why would anyone make them not case sensitive unless explicitly
specified, and how do I specify case sensitiveness per formula?



All spreadsheets had been case insensitive ever since.
Use the EXACT function for case sensitive comparison.

The calculation options do not apply to Excel files which is why you
have to reset this option every time you load the file. The Excel file
format has no place where this setting can be stored.

"All spreadsheets had been case insensitive ever since. " - I don't 
understand this.


The OpenFormula specification says that comparisons are case sensitive 
unless HOST-CASE-SENSITIVEisfalse.


>>>


 6.4.7Infix Operator "="

Summary:Report if two values are equal

Syntax:ScalarLeft =ScalarRight

Returns:Logical

Constraints:None

Semantics:Returns TRUE if two values are equal. If the values differ in 
type, return FALSE. If the values are both Number, return TRUE if they 
are considered equal, else return FALSE. If they are both Text, return 
TRUE if the two values match, else return FALSE. For Text values, if the 
calculation settingHOST-CASE-SENSITIVEisfalse, text is compared but 
characters differencing only in case are considered equal. If they are 
both Logicals, return TRUE if they are identical, else return FALSE. 
Error valuescannotbe compared to a constant Error value to determine if 
that is the same Error value.



>>>

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

[David Love]

Brian Barker  wrote:

> At 10:28 11/03/2015 +1300, David Love wrote:
> > What I want, in simple terms, is to determine the average number of
> > steps I am taking every week. Hopefully, this explanation will answer
> > the questions reaided.
> 
> Not really!
> 
> I think you've confirmed that the 1 figure is irrelevant in the
> calculation. But your earlier statements that "if day 1 reaches a
> production of 10,000 units I want this figure entered" and "If days
> 1+2+3+4 total, say, 42,500 I want ... to show the average of 10,265"
> both indicate that the required result does not depend on other daily
> values. These contradict the idea that you simply want the true average
> of all seven values.
> 
> Unsurprisingly, you can calculate averages using the AVERAGE() function.
> 
> Incidentally, doesn't all this cry out for a table instead of a list?
> Put a week date (or date range) in column A, as you suggest. Enter your
> data for the days of that week in columns B to H of the same row. It's
> then particularly simple to calculate averages in column I. At the
> bottom of the columns, you could calculate averages for each weekday -
> and perhaps discover that you need to be more active on Thursdays!

Ha!  I constructed a table, as you suggested and, yes, it does meet my
requirements.

Thanks for the suggestion, Brian.

David

-- 
David Love
Dogs wag their tail with their whole heart. 

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

[David Love]

David Love  wrote:

> Using LinuxMint v17.1 Rebecca with MATE DE and LibreOffic v4.2.7.2 Build
> ID 420M0(Build2)
> 
> I have a three column spreadsheet.
> 
> Column A. Date - The dates are consecutive
> 
> Column B. Production - The Production has a daily target of 10,000 units
> and each production period is of seven days.
> 
> Column C. a formula every seventh cell.
> 
> Is it possible to construct a formula which will show in the seventh
> cell of column C the average for the number of days  of production i.e.
> if day 1 reaches a production of 10,000 units I want this figure entered
> into the seventh cell in column C.  If days 1+2+3+4 total, say, 42,500 I
> want the seventh cell in column C to show the average of 10,265.  In
> other words I want the average shown for the actual days of production
> each seven day period.

Thank you Steve, Brian and Johnny for your prompt replies.  I will work
through the suggestions and report back.

I should, however, make a confession :-)  I used the word "Production" as
I wanted members to see this as a "business" rather than a "personal"
question.

In reality, Column A is the numbers of steps I take each day. Ten thousand
is considered to be the number necessary to keep healthy.

What I want, in simple terms, is to determine the average number of steps
I am taking every week.

Hopefully, this explanation will answer the questions reaided.

DL
-- 
David Love
Bachelor: A guy who has cheated a woman out of a divorce.  

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

[David Love]

Using LinuxMint v17.1 Rebecca with MATE DE and LibreOffic v4.2.7.2 Build
ID 420M0(Build2)

I have a three column spreadsheet.

Column A. Date - The dates are consecutive

Column B. Production - The Production has a daily target of 10,000 units
and each production period is of seven days.

Column C. a formula every seventh cell.

Is it possible to construct a formula which will show in the seventh cell
of column C the average for the number of days  of production i.e. if day
1 reaches a production of 10,000 units I want this figure entered into the
seventh cell in column C.  If days 1+2+3+4 total, say, 42,500 I want the
seventh cell in column C to show the average of 10,265.  In other words I
want the average shown for the actual days of production each seven day
period.

DL

-- 
David Love
Can atheists get insurance for acts of God?

-- 
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: Split "Move/Copy Sheet" item in sheet tab menu

[David Lynch]

On 18/02/2015 15:04, Kaj wrote:
It is that the *default* behaviour is to overwrite the target (and no 
warning is given).


David Lynch


The change might be ok, but in which way does that solve your problem? 
The target is overwritten in any case. Well yes, if you think you 
still are keeping the source and overwrite the target once more, then 
there is a difference. I have not seen it being a problem, but am not 
against the change. /Kaj


Den 2015-02-18 14:00, skrev David Lynch:
Reasonably, I have been asked by the developers to gain support from 
a wider body of users for a change in the user interface to Calc.


My request is *bug 68582 
<https://bugs.documentfoundation.org/show_bug.cgi?id=68582>*

*
>>>>>>>>>>>>>*

When you right-click a sheet tab in Calc you get a menu:

Insert Sheet...
Rename Sheet...
Move/Copy Sheet...
Tab Colour...
etc

I would like this menu to be replaced by:
Insert Sheet...
Rename Sheet...
Move Sheet...
Copy Sheet...
Tab Colour...
etc

Currently when copying a sheet, you must remember to click the copy 
button on the next menu to copy rather than move the sheet. I have 
just overwritten data I needed by forgetting to click this button."


*>>>>>>>>>>>>>>

*The most important reason is that the default behaviour of the 
command is to move the sheet, and this can destroy valuable data 
*without warning*. If, as I have done, you forget to click the "copy" 
button, you overwrite and destroy your existing sheet.

*
*A less important reason is that the interface is inconsistent: in 
other menus and toolbars, the choice of move or copy is at the top 
level, not hidden a level lower.**There are 12 commands in the menu: 
adding a thirteenth would not make it over long.*


*Please may I have support for this request.*

*David Lynch*
*







--
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] Split "Move/Copy Sheet" item in sheet tab menu

[David Lynch]

Reasonably, I have been asked by the developers to gain support from a 
wider body of users for a change in the user interface to Calc.


My request is *bug 68582 
<https://bugs.documentfoundation.org/show_bug.cgi?id=68582>*

*
>>>>>>>>>>>>>*

When you right-click a sheet tab in Calc you get a menu:

Insert Sheet...
Rename Sheet...
Move/Copy Sheet...
Tab Colour...
etc

I would like this menu to be replaced by:
Insert Sheet...
Rename Sheet...
Move Sheet...
Copy Sheet...
Tab Colour...
etc

Currently when copying a sheet, you must remember to click the copy button on the 
next menu to copy rather than move the sheet. I have just overwritten data I needed 
by forgetting to click this button."

*>>>>>>>>>>>>>>

*The most important reason is that the default behaviour of the command 
is to move the sheet, and this can destroy valuable data *without 
warning*. If, as I have done, you forget to click the "copy" button, you 
overwrite and destroy your existing sheet.

*
*A less important reason is that the interface is inconsistent: in other 
menus and toolbars, the choice of move or copy is at the top level, not 
hidden a level lower.**There are 12 commands in the menu: adding a 
thirteenth would not make it over long.*


*Please may I have support for this request.*

*David Lynch*
*

--
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] Emailing documents...

[David Love]

Tom Davies  wrote:

> On 23 October 2014 05:12, David Love  wrote:

> Using LO v4.2.6.3 on LinuxMint v17 Qiana MATE.

 > I have two email clients on the computer.  Thunderbird, which is set
 > up for my wife's  use, and MessengerPro which I use.
 > LO has been set up to point to MessengerPro
 >  for sending documents by email but does
 > not honour that path, inasmuch as it opens Thunderbird each time.
 >
 > My wife does not have a user account on the computer and I have not
 > set one up as it would confuse her.  She only uses the computer for
 > email, browsing the internet and playing card games.
 >
 > LinuxMint Control Panel contains a Preferred Applications facility but
 > the only choices in Email are Thunderbird and KMail.

> Is anyone able to suggest how I may solve the problem, please?


>> Hi :) Does Chapter 10 in the "Getting Started" guide help at all?
>> https://wiki.documentfoundation.org/Documentation/Publications

Unfortunately. no!

> Hopefully someone else can give a more tailored answer or maybe just ask
> the right questions in order to incover the answer. Good luck and
> regards from Tom :)

I hope so, too.  I have put this problem to the LionuxMint Forum, too, but
as it appears to be a LO probable,m in not heeding the correct path, I
thought this mailing list was the more appropriate place.

David
-- 
David Love
Do more than anyone expects, and pretty soon everyone will expect more   

-- 
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] Emailing documents...

[David Love]

Using LO v4.2.6.3 on LinuxMint v17 Qiana MATE.

I have two email clients on the computer.  Thunderbird, which is set up
for my wife's  use, and MessengerPro which I use.

LO has been set up to point to MessengerPro 
for sending documents by email but does not honour that path, inasmuch as
it opens Thunderbird each time.

My wife does not have a user account on the computer and I have not set
one up as it would confuse her.  She only uses the computer for email,
browsing the internet and playing card games.

LinuxMint Control Panel contains a Preferred Applications facility but the
only choices in Email are Thunderbird and KMail.

Is anyone able to suggest how I may solve the problem, please?

David
-- 
David Love
Divorce, n. The past tense of marriage 

-- 
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] LibreOffice - Base...

[David Love]

David Love  wrote:

> Using LinuxMint v17.0 Qiana qith the MATE DE.
> 
> Have followed with interest the recent discussins on Base and have
> decided to try and learn how to use it, using PostGreSQL as the backend.
> But - and there is always one of those :-) - how many of the multitude
> of postgrsql files in Synaptic do I need to install, please.

Thank you NoOp, Wolfgang Keller and Alex Thurgood for your prompt and
helpful suggestions.

I have downloaded amd installed all the files suggested and will now read
the documentation to see whether my geriatric brain can understand it.

Will report back in due course..

David


-- 
David Love
COMPUTER LITERACY? You mean my computer can READ?! 

-- 
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] LibreOffice - Base...

[David Love]

Using LinuxMint v17.0 Qiana qith the MATE DE.

Have followed with interest the recent discussins on Base and have decided
to try and learn how to use it, using PostGreSQL as the backend.  But -
and there is always one of those :-) - how many of the multitude of
postgrsql files in Synaptic do I need to install, please.

David
-- 
David Love
Oxymoron: smokeless cigarette

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

[David M Pelly]

I am a Libre office user and have run into  some problems.

I wanted to file a bug report,  but found the feedback process overwhelmingly 
complicated, and filled with jargon and code  only experts can understand.


I went to upgrade my version from 4.2.3.3  to 4.2.5.

During the downloading process I ran into several incongruencies.

Simply stated;  not enough information posted during down load process  to tell 
a non techie, non expert what is happening, what has happened, and what to do 
next.

They are difficult to remember and explain.

The last problem I ran into, during installing was that I got a pop up  saying 
that I need to close file number 948, before installation can be completed.

How in the world am I supposed to know what file 948  is?

When you guys are making this software,  you have to take into consideration 
that people who are not experts, people that do not know anything  about the 
technical side of computers and software, other than to be a final user.


All programs have to be average non techie user friendly, and second nature to 
use and automatic as much as possible.



Another thing, that just came to mind is, on the download page,  you should 
explain to the non expert user, what he needs to do (list the steps)  to get 
the final product, in clear plain language.  And explain waht each function and 
step is. 

1.


2.

3.

4.

etc.


And why aren't the installer and the actual program set up as "one click"  
install package?


Also an end user does not  know what a torrent is, and all other jargon is?




And ask the user if he wants to replace the old program with the new program or 
updated program.

And ask if he wants to remove the old program too?


If you want more clarification you call me, 226  887  3830  Toronto/ New York 
Time zone. 

I am mostly in. 

David Pelly










 




  
-- 
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: Spell Check Dictionary

[David Love]

MR ZenWiz  wrote:

> The longest word in any English language is the name of a small town in
> Wales - Llanfairpwllgwyngyllgogerychwyrndrobwyantysiliogogogoch (see
> Wikipedia if you're curious about what and where this is).  I had
> thought it was 56 letters, but this one is 59.  Hmm.

Sorry, that's the second longest.  The longest is in the North Island of
New Zealand.

Taumata­whakatangihanga­koauau­o­tamatea­turi­pukakapiki­maunga­horo­nuku­pokai­whenua­kitanatahu
(85 letters) which means  "The summit where Tamatea, the man with the big
knees, the climber of mountains, the land-swallower who travelled about,
played his nose flute to his loved one"


See http://en.wikipedia.org/wiki/List_of_long_place_names

David


-- 
David Love
Dogs think they are human.  Cats believe they are God

-- 
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] [Draw] Confused about how to render rotated text

[KARR, DAVID]

> -Original Message-
> From: Cley Faye [mailto:cleyf...@gmail.com]
> Sent: Wednesday, May 14, 2014 10:05 AM
> Cc: users@global.libreoffice.org
> Subject: Re: [libreoffice-users] [Draw] Confused about how to render
> rotated text
> 
> 2014-05-14 17:55 GMT+02:00 KARR, DAVID :
> 
> > I can't figure out how to render a short piece of rotated text. The
> > instructions I saw referred to a "text" icon. In the Draw app the only
> one
> > that comes close is the "Label Field" in the "Form Controls" toolbar.
> The
> > later instructions for selecting that for rotation just don't work.
> >
> > What am I missing?
> >
> 
> ​Writing rotated text in Draw:
> 1 - In the "Drawing" toolbar, select the text icon (if the ​Drawing toolbar
> is not visible, show it first from the Display->Toolbars menu):
> http://i.imgur.com/n52PGyo.png
> 2 - Place your text somewhere
> 3 - Right click in the hashed outline of the text object, then select
> "Position and sizing" (not sure about the english translation, but you get
> the idea)
> 4 - In the "Rotation tab, you can set the angle you want (
> http://i.imgur.com/wB1ZQkg.png)
> 
> And the result: http://i.imgur.com/rucFDqj.png
> 
> I believe this answer your question.

Sigh.  My main disconnect was that I never thought to look at the bottom of the 
window where the "Drawing" toolbar shows.  Once I found that, these 
instructions worked fine.

Thanks.

-- 
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] [Draw] Confused about how to render rotated text

[KARR, DAVID]

I'm on Win7-64bit, LO 4.2.4.2.

I can't figure out how to render a short piece of rotated text. The 
instructions I saw referred to a "text" icon. In the Draw app the only one that 
comes close is the "Label Field" in the "Form Controls" toolbar. The later 
instructions for selecting that for rotation just don't work.

What am I missing?

-- 
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: [Sclug] (no subject)

[David Lang]

googling for "grub2 windows parition" finds several pages that look promising

http://askubuntu.com/questions/110698/add-windows-to-my-boot-menu

suggests running update-grub and it should detect the windows partition.

what does running this report?

David Lang


On Fri, 2 May 2014, jelan...@gmail.com wrote:


Date: Fri, 2 May 2014 23:28:13 -0700
From: jelan...@gmail.com
Reply-To: LO Users ,
Simi-Conejo Linux Users Group 
To: Simi-Conejo Linux Users Group 
Subject: [Sclug] (no subject)

Jon upgraded from Kubuntu 13.10 to Kubuntu 14.04. In the process Grub2 lost his 
Windows (XP) boot option. Jon is willing to use Linux but not to the exclusion 
of Windows.

I also upgraded but I think I use legacy Grub as my boot loader. In any case I 
did not lose my Windows (Vista) boot option.

Any comments other than the obvious ones disparaging Windows?




--
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] gstreamer-1.0 vs gstreamer-0.10

[David Ronis]

Hi Vladimir,

Thanks for the reply.   I have the same versions for the
gst-plugins/libav as you.  The only difference may be that I built mine
here, while you may have gotten them from your distribution.  (My
distribution is slackware which doesn't officially support gnome any
more). 

As I think I wrote, strace clearly shows that my LO is looking ONLY for
gst-0.10 modules--no hint of any 1.0.  I downloaded LO from the main LO
site and I suspect that it was built with 0.01 support only.   My bet is
that your distribution's LO, assuming that you're using it, supports
1.0.

I've played with building my own LO, and there are configure flags that
allow on to choose the gstreamer versions.  Unfortunately, the build
dies in nss-related code. If you're interested, have a look at:

   https://bugs.freedesktop.org/show_bug.cgi?id=75731


Again, thanks for the reply.

David

On Thu, 2014-03-06 at 15:06 +0200, v...@ukr.net wrote:
>   Hello!
>   I had a somewhat similar problem to the one you described, and
> yesterday I installed the 
> 'media-libs/gst-plugins-bad-1.2.3' 
> and
> 'media-libs/gst-plugins-good-1.2.3'
> packages (I am using Gentoo GNU/Linux), and now the video files
> embedded into my Impress presentation are played back correctly.
>   These are in addition to the 'media-plugins/gst-plugins-libav-1.2.0'
> package of course.
> 
>   So if your LibreOffice also displays some problems trying to play the
> video through the Gstreamer-1.0, I suggest you to search the packages I
> mentioned in your distribution also. Maybe, your problem will be solved
> just like mine.
> 
>   Regards,
> Vladimir
> 
> On Wed, 29 Jan 2014 17:44:48 -0500
> David Ronis  wrote:
> 
> > I have a presentation that contains a mpeg video.   It works on some
> > Linux machines, but not on others.  I finally realized that the
> > difference seems to be in the version of gstreamer installed: version
> > 0.10 works, version 1.0 doesn't.  
> > 
> 
> - 
>  
> 

-- 
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: gstreamer-1.0 vs gstreamer-0.10

[David Ronis]

Hi Alex,

Thanks for the reply.  From various searches on the net I was starting
to think that that was the problem, but am resistant to the idea of
building my own loclly. 

FWIW:  I installed/downloaded LO from the official web site.  Is there a
link to a 1.0 enabled version?

David

On Fri, 2014-01-31 at 10:24 +0100, Alex Thurgood wrote:
> Le 30/01/2014 23:43, David Ronis a écrit :
> 
> Hi David,
> 
> > Finally I ran LO under strace on a system that only has 1.0 installed.
> > I see various gst-0.10 files that came with LO being opened, e.g.,
> > 
> > 
> > "/opt/libreoffice4.1/program/../program/libavmediagst_0_10.so"
> > 
> > and failures for -0.10 related libs in the system directories.  Nowhere
> > do I see any attempt (failed or not) to open a 1.0 lib/module.
> > 
> 
> Long story short, it depends on the compile switch used to build LO. It
> is possible to build LO with either 1.0 or 0.10 support, but not both
> (apparently, at least from my attempts). For example, on my own master
> builds on a Linux Mint 16 Petra 64bit system, I build with the following
> compile switch :
> 
> --disable-gstreamer-0-10
> 
> otherwise, the configure script step fails because somewhere it is coded
> to look for gstreamer-1.0, and only finds gstreamer-0-10 (despite my
> best attempts at having installed all possible dev libraries). So,
> instead of gstreamer, I build with VLC support (which is experimental).
> 
> Your version of LO, wherever it might have come from, appears to have
> been built against gstreamer-0-10, whereas you only have the
> gstreamer-1.0 libs. So, it is either the builder's fault, or the OS'
> defaults on which the builder compiled LO.
> 
> 
> Alex
> 
> 
> 

-- 
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] gstreamer-1.0 vs gstreamer-0.10

[David Ronis]

Hi Paul,

Thanks for the reply.  In gstreamer-1.0 gst-ffmpeg has been replaced by
gst-libav (which is installed).   My video plays on all machines using
mplayer and things like gst-play-1.0 or totem.  When it works (on
gstreamer-0.10 boxes), the presentation is what these external tools
show.

Finally I ran LO under strace on a system that only has 1.0 installed.
I see various gst-0.10 files that came with LO being opened, e.g.,


"/opt/libreoffice4.1/program/../program/libavmediagst_0_10.so"

and failures for -0.10 related libs in the system directories.  Nowhere
do I see any attempt (failed or not) to open a 1.0 lib/module.

David


On Thu, 2014-01-30 at 16:11 -0500, Paul D. Mirowsky wrote:
> Also note: you need to make sure that gstreamer-ffmpeg (in my case 
> gstreamer-0_10-ffmpeg) is installed - et voila, it works.
> 
> From: 
> http://forums.opensuse.org/showthread.php/466113-Solved-libreoffice-not-playing-video
> 
> On 1/29/2014 5:44 PM, David Ronis wrote:
> > I have a presentation that contains a mpeg video.   It works on some
> > Linux machines, but not on others.  I finally realized that the
> > difference seems to be in the version of gstreamer installed: version
> > 0.10 works, version 1.0 doesn't.
> >
> > Other than the obvious installation of both versions (which causes
> > problems elsewhere, is there a 1.0 version of LO?
> >
> > Any suggestions?
> >
> > David
> >
> >
> 
> 

-- 
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] gstreamer-1.0 vs gstreamer-0.10

[David Ronis]

I have a presentation that contains a mpeg video.   It works on some
Linux machines, but not on others.  I finally realized that the
difference seems to be in the version of gstreamer installed: version
0.10 works, version 1.0 doesn't.  

Other than the obvious installation of both versions (which causes
problems elsewhere, is there a 1.0 version of LO? 

Any suggestions?

David


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

[David M. Pelly]

Hi Tom and James,

Thank you both for your replies.

First off, ...

I did go to my documents and found  about half  a dozen  files down  loaded.

So I double clicked on  one.

And see that it has now completed installing.



1.  My first suggestion is that you should have a pop up that tells us dummies 
what happened and what to do next.






2.  I still do not see "writer".


As for anything else, I need some time to study and figure this all out.




I have not really used any other word processor besides Libre.

I am running windows xp.


See and address the other questions and suggestions I have, as explained in my 
first post.




Thanks again,

David 




> Date: Thu, 9 Jan 2014 17:13:58 +
> Subject: Re: [libreoffice-users] Re Libre writer
> From: tomc...@gmail.com
> To: david.pe...@hotmail.ca
> CC: users@global.libreoffice.org
> 
> Hi :)
> Several points here;
> 1.  If you have downloaded the installer file then that is really all
> you need.  It has Writer, Calc, Draw and all the rest in it.
> 2.  Just downloading the file is not the whole story.  Next thing is
> to install it!  So, find the file and double-click on it to install
> it.  I'm guessing you are on Windows, probably Xp or Win7.
>   *  On Xp open your "My Documents" folder and inside there should be
> your "My Downloads" folder.  The installer file should be in there.
> Double click on it.
>   *  On Win7 click on the yellow folder button on the taskbar at the
> bottom of the screen.  The window it open has 2 "panes" in the
> left-hand pane near the top should be a "Downloads" folder.  Click on
> that and then the right-hand pane should show the file you downloaded.
>  Double-click on that.  A new button appears in the taskbar.  if the
> screen goes dark then click on that new button a few times until a
> pop-up appears in the middle of the screen asking if you are certain
> you want to let the file install.  The pop-up looks a bit like a login
> box and tries to scare you because it's not an MS product.
> 3.  Unlike MS Office the whole of LibreOffice is just 1 program.  It
> has many modules such as; Writer, Calc, Draw, Impress etc.  It's not
> really possible to install just Writer without the rest.  All use the
> same core blocks of code so even if you could then you would save much
> resources or anything.
> 
> 4.  The 2nd 'button' on the web-page is the in-built help.  it is very
> useful to get it, particularly if you are new to
> Libreoffice/OpenOffice but it's better to get the full guides which
> are available as free downloads from
> https://wiki.documentfoundation.org/Documentation/Publications
> Hmm, it might be better to just bookmark, or make a note of that page
> and just download books or chapters as and when you need them.  I do
> recommend downloading the "Styles" chapter of the "Getting Started
> Guide" because that gives you the biggest fastest boost in
> productivity.  MS Office implementation of styles is so bad that it's
> painful but LibreOffice makes it an extremely useful feature.
> 
> 
> If you really do need just a word-processing program and don't want
> the rest then our sister project "AbiWord" might be what you are
> looking for.  Personally i would recommend giving LibreOffice a fair
> go first before trying that but mainly because i happen to prefer
> LibreOffice.  You can have both installed alongside each other and
> they both use the same native formats and work well together.  E,
> you can also have both alongside MS Office but i'm not sure why anyone
> would have more than 2 of the 3.
> 
> Regards from
> Tom :)
> 
> 
> 
> 
> 
> 
> 
> 
> 
> On 9 January 2014 16:46, David M. Pelly  wrote:
> >
> >
> > I want Libre office writer,
> >
> > I tried to download it from your website, which provided two green buttons.
> >
> >
> >
> > I clicked the first one, the  installer button.
> >
> > I think I have the installer installed.
> >
> >
> >
> > But your program does not give me the "libre office writer program" and the 
> >  facility to down load and install the actual "libre writer".
> >
> >
> > I looked all over for it and I can't find it.
> >
> >
> > Once the installer is installed,  your site should automatically  return me 
> > to the page that gives me the  button to download the actual "writer" 
> > program.
> >
> > If it is there, I  can't find it.
> >
> > Please help.
> >
> >
> >
> >
> >
> > David Pelly
> >
> >
> 

[libreoffice-users] Re Libre writer

[David M. Pelly]

I want Libre office writer,

I tried to download it from your website, which provided two green buttons.



I clicked the first one, the  installer button.

I think I have the installer installed.



But your program does not give me the "libre office writer program" and the  
facility to down load and install the actual "libre writer".


I looked all over for it and I can't find it.


Once the installer is installed,  your site should automatically  return me to 
the page that gives me the  button to download the actual "writer" program.

If it is there, I  can't find it.

Please help.





David Pelly


  
-- 
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] Help with libre

[David M. Pelly]

Hello Libre office Foundation,



I am using Libre office on  Windows XP.

Firefox is my preferred browser.

I am not a techie.


Your products are not user friendly to non techies, non geeks. Not dummy proof. 




My main expertise is email and websurfing.

And I do some writing on "libre office". 

When I encounter something other than standard main functions  I usually get 
lost and confused.


Even explaining the problem that I encounter to you is difficult to explain.

But here it is:


The present problem is:

Some how,  ( I think it is when I open or start up my computer,) I get a pop up 
that there is a Libre office update.



So I  click  to get the update.

I get a webpage with two green buttons:

Without
 going back there to that site to see what it actually exactly  says,  
because I forget what they are exactly, but what ever they are, they are
 confusing, especially to a non techie, non geek.

I think one button says it  is a  downloader or installer.

The other is something else. ( It does not say, update software.) 


That appears to mean that I need to use two functions.

One to download an installer first.

Then
 another one is required  to download the actual update software to the 
installer, so the installer can install the software in my   Libre 
office program.


It does not say that, but it seems to imply that. 

(Your
 products assume ( and take for granted)  that the user knows almost as 
much as the actual designers and program developers. ) 



Now I landed up clicking on some buttons, and there was no windows telling me 
what was happening.

As far as I thought at the time, I  did not get the update. I was ticked off. 



At
 the same time: You also ask for donations.  So I  did donate $10.  I 
ran into some confusions there too, but some how it at least appeared to
 go through.

It is not entirely user friendly either.

That should be cleared up and made dummy proof. 




So I went back to my work on my Libre office program.

And I still see the green something in the upper right hand corner.

 I click on it and it says there are updates for Libre.

So therefore I thought  I did not get the updates.

So I click on it and a window pops up and says that I have the 4.0.4.2 version.

I think that is the new update version. (Maybe I am wrong.)

If
 I am correct, why do you leave that green arrow up in the upper right 
hand corner, telling me that there are new updates available?  After I 
supposedly did get the update? 


Those kinds of things drive me crazy!




I just thought of another problem/ suggestion:

Why don't you include an "undo"  feature on the  "right click"  window?

That should be common sense.



Another one:

Some
 how when I was doing a lot of work on libre office,  I landed up with 
some solid lines running across my page, which I cannot delete or 
remove?

Why?

How can I remove them? 


Another suggestion:

When
 I am getting to the maximum data capacity of the  libre window I am 
working in,  you should have an indicator pop up that tells the user 
that  that  particular widow is reaching  it's maximum capacity  and  telling 
the user to begin a new document.





And
 also have  a clearly visible button for the user to send "suggestions 
for improvements"  or to report problems with libre office? 








I hope I have explained my self sufficiently well, so  that you understand what 
I mean.



And I am sure there are other problems that I do not know of or don't remember. 







David Pelly

Canada
  
-- 
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] Feature Request - Categories for special characters

[David Gast]

One additional idea.  Have some method so that if you type a character, LO can
show you all fonts that have that character.  Otherwise it can be difficult to 
find
a font with that character.  Bonus: This method would also let you see what 
that 
character looks like in different fonts.  You may not think about checking some 
font,
but it might have a great looking character (in your opinion) that you need all 
the time.
For example, when typesetting computer code, I prefer a slash through the zero 
so it 
does not get confused with a capital Oh. (I know some fonts put a dot inside; I 
prefer
a slash.)

Background: I have a program for creating randomized versions of tests.
The output format is HTML.  I Insert -> File into LO so that I can get the
page breaks correct (by adding blank lines) and make a PDF file for printing 
from a
computer that does not have LO installed.  (Firefox and/or our printer s/w 
breaks
pages differently in Print Preview and when actually printing.  Very annoying.)

On a recent test, I noticed that the HTML ␣ entities did not get changed 
when
inserting, so I had to hunt through different fonts to find that character.  
That is, the
Writer document showed something like  ␣␣100 .

Best regards,

David Gast

From: Kracked_P_P---webmaster [webmas...@krackedpress.com]
Sent: Friday, November 22, 2013 15:05
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Feature Request - Categories for special 
characters

On 11/22/2013 01:20 PM, Mark Bourne wrote:
> Kracked_P_P---webmaster wrote:
>> On 11/21/2013 01:59 PM, Mark Bourne wrote:
>>> David Gast wrote:
>>>> I have two ideas.
>>>
>>> Interestingly, Windows Vista's "Character Map" utility (and probably
>>> also Windows 7's?) has similar ideas...
>>>
>>>> 1. Highlight the categories, so it is easy to tell where the category
>>>> starts and ends.
>>>
>>> Vista's character map has an option to group by Unicode subrange,
>>> where only the characters from the selected subrange are shown - as
>>> opposed to LibreOffice's current behaviour of jumping to the first
>>> character in the range, but giving no easy indication where the range
>>> ends. As you suggest, highlighting the range would be similarly
>>> helpful.
>>>
>>>> 2. Allow some input box so you could type some substring of the
>>>> characters' names and get
>>>>  all matching characters.  For example, if you typed equal, all
>>>> characters with equal
>>>>  in the name would be listed.  (I do not know if the names are
>>>> i*18n or not.).
>>>
>>> Vista's character map does pretty much exactly this. I think the
>>> character names are defined in the Unicode standard. Not sure if
>>> they're internationalised though. The thing that keeps catching me out
>>> with Vista is that after searching, the "Search" button changes to
>>> "Reset" - so to do a new search you have to first reset, then type the
>>> query string, then search; you can't just type a new query and search
>>> for it.
>>>
>>> Mark.
>>>
>>
>> I think you are asking for something like Thunderbird's Insert Special
>> Character option.  That option might be used as a different Special
>> Character option.  I really do not think that it would work on the
>> non-Latin fonts or give you all of the glyphs/characters, especially the
>> Unicode font's glyphs/characters, that the font has to offer or needed.
>
> I don't know about Thunderbird, but Windows Vista's character map
> (which I was describing) does work for all Unicode characters in the
> selected font. I'd expect Window 7's character map to also work
> similarly. For example, search for "sharp" and it returns:
>   ß (U+00DF: Latin Small Letter Sharp S)
> and
>   ♯ (U+266F: Music Sharp Sign)
>
> Want a division sign? My initial attempt searching for "divide" didn't
> get it, but trying another term "division" gets:
>   ÷ (Division Sign)
>   ∕ (Division Slash - not the same as /)
>   ⊘ (Circled Division Slash)
>   ⋇ (Division Times)
>
> I'm not certain, but think the names for the characters are defined by
> the Unicode standard.
>
>> So I really think we need to keep the existing Special Character option,
>> but could add on the "alternative" and limited one that Thunderbird has
>> to LO.  Since Thunderbird is also Open Source [so I have been told] you
>> should be able to find the coding for this option if you look fo

RE: [libreoffice-users] Feature Request - Categories for special characters

[David Gast]

I have two ideas.

1. Highlight the categories, so it is easy to tell where the category starts 
and ends.
2. Allow some input box so you could type some substring of the characters' 
names and get
all matching characters.  For example, if you typed equal, all characters 
with equal
in the name would be listed.  (I do not know if the names are i*18n or 
not.).

I also have a related question.  Is the some way to sort using  LC_COLLATE=C,
that is, the ASCII character set, rather than en_US.ISO8859-15 or something
similar?

Best regards,

David Gast

From: Regina Henschel [rb.hensc...@t-online.de]
Sent: Thursday, November 14, 2013 07:55
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Feature Request - Categories for special 
characters

Hi Steve,

Steve Gruspier schrieb:
> Hello:
>
> I was wondering if this was the place to request a feature. I was
> thinking the "Special Character" section is very cluttered. My feature
> request is a setting that would narrow down special characters to ones
> that are used in specific fields such as "Engineering" or "Physics".
> Something along those lines that could help people become more efficient
> using Libreoffice. I am constantly using special characters such as the
> ohms (uppercase omega) symbol for resistance, particularly when I use
> Libreoffice to generate tests.

I do not like the idea to remove characters or group them in another
way. The Unicode groups are well defined and easy to handle.

But I would like the idea of a user defined, "favorite characters" list
or similar, or even more then one, each for a special topic.

For your problem I think of this methods:
* Write an Autotext or a document, which contains all your favorite
characters. Open it beside your actual text and use copy&paste to insert
the characters.
* Use your OS to insert the character by typing the number; you need a
list of numbers beside your keyboard.
* Use a macro to insert a special character. You can connect the macro
to a button; I use the character itself as "name" of the button, so it
is shown on the button. So you can generate your own toolbar with your
favorite characters. For Writer such macro in Basic is for example (I
hope the line end are set correctly in mail transport):

Sub lcl_InsertCharacter_Writer(byval sChar as string)
Dim oDoc as variant: oDoc = ThisComponent
Dim oCurrentController as variant: oCurrentController =
oDoc.getCurrentController()
if
not(oCurrentController.supportsService("com.sun.star.text.TextDocumentView"))
then
msgbox("Only for Writer")
exit sub
end if
Dim oTextViewCursor as variant: oTextViewCursor =
oCurrentController.getViewCursor()
Dim oText as variant
If IsEmpty(oTextViewCursor.Cell) Then
 oText=oTextViewCursor.Text
Else
 oText=oTextViewCursor.Cell.Text
End If
oText.insertString(oTextViewCursor,sChar,false)
End Sub

That is the general method, and for each single character:
sub OE_Lower_Ligature
lcl_InsertCharacter_Writer(chr(clng("&H153")))
end sub

Here &H153 is the number of the character œ , &H is the markup for a
hex-number and 153 is the number itself, as can be seen in the special
character dialog.

Kind regards
Regina




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

FW: [libreoffice-users] Re: CALC convert text to numbers

[David Gast]

From: David Gast
Sent: Tuesday, November 12, 2013 11:37
To: Denis Navas Vega
Subject: RE: [libreoffice-users] Re: CALC convert text to numbers

It does not contradict my assertion.  I did not discuss multiplication.
The answer is that it depends on how you multiply.  You did not
state how you multiplied but I am sure you used the * operator.
Using the * operator, you will get 123.  If you use product(a1),
where a1 contains '123, you will get 0.

Operators and functions do not work the same.

From: Denis Navas Vega [denis.na...@gmail.com]
Sent: Monday, November 11, 2013 22:06
To: users@global.libreoffice.org
Subject: [libreoffice-users] Re: CALC convert text to numbers

El 2013-11-11 04:00 p.m., David Gast escribió:
> Spreadsheets use the MVC (model view controller) paradigm.  That means
> that the model (how the data are actually stored) and how you view
> the data are separated.  You can take a number like 4.5 and view it
> as a date, a date and time, a real number, etc.  You can easily compare
> dates because they are stored as numbers, not character strings like
> "Monday, Nov. 11." Further, you can easily send your spreadsheet to
> someone who only knows some language you have never heard of and s/he
> can open it and display and compare the dates in whatever language
> s/he has set.
>
> The best way to see if a cell contains a number, text, or a formula is
> to use View -> Value Highlighting (F8).  (Does Excel even have this
> feature?  If so, it must hidden in the ribbon somewhere.)  A zero as
> text has the ASCII value 48; as a number, the value is 0, so text and
> numbers are not equal.  OpenOffice used to generate errors if one
> improperly tried to add text and a number, for example.  Along the
> way, that behavior was modified to emulate Excel.  (I prefered the
> old way along with the fact that either OOo or gnumeric or both used to
> evaluate -1^2 correctly--the mathematical answer is -1, not 1.)
>
> I just checked using Excel 2010, if you change the format (the view) of the
> cell, the underlying representation (the model) does not change.
>
> 1. Type '123 in a cell, say A1
> 2. Right click and choose Format Cells, then Format as a number.
>(That is, change General to Number.)
>
> The entry is still text.  You can confirm because =sum(A1) yields 0.
> Note: =A1+0 yields 123. (Also the text is still left justified.)
>
> That is, there is no conversion.
>
> Best regards,
>
> David Gast
>
> 
> From: Oogie McGuire [oog...@desertweyr.com]
> Sent: Monday, November 11, 2013 09:17
> To: Joel Madero
> Cc: Brian Barker; users@global.libreoffice.org
> Subject: Re: [libreoffice-users] CALC convert text to numbers
>
> For me dealing with an extension, installing it, making sure it doesn't 
> conflict with something else was more effort than creating a column, using 
> Value() and then pasting special.
>
> What's a problem is that in Excel even though it also uses the leading ' to 
> format text as numbers, if you change the format of a cell the conversions 
> happen without any problems. I want that same behavior in Calc because to me 
> it makes sense that the cell format should be the controlling factor for what 
> type of data is in a given cell.
>
>
> On Nov 10, 2013, at 7:43 PM, Joel Madero wrote:
>
>> Why is everyone straying away from the fact that there is a simple extension 
>> developed by Cor (one of our brilliant devs) which accomplishes all of this? 
>> Just curious if there's a benefit to doing these formula techniques instead 
>> of just pushing a button on a nice gui
>
> Eugenie (Oogie) McGuire
> Desert Weyr http://www.desertweyr.com/
> Paonia, CO USA
>
>
> --
> 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
>
>
>
>


With Excel 2010 I made the following test, that contradicts your assertion.

A)  Write just:  123-->  That's a number (just to compare).
B)  Write : '123-->  That's text.  Sum(cell) is equal to cero.
C)  Multiply:   In another cell write a formula that
references '123 address and multiply by 1.
You get a number!

Check it.





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

[libreoffice-users] Re: Using_LibreOffice_in_a_Web_Browser

[David Lastovicka]

bill  techservsys.com> writes:

> 
> On 2/23/2013 3:00 PM, Luuk wrote:
> > Not any good answers, and not any bad answers.
> > No answers at all. ;(
> >
> > Seems no one is interested in being able to edit via a browser
> 
> I can not imagine why I would want to.
> Why would I want to ?
> 

Because from anywhere I could connect to my home computer and edit my
libreoffice documents directly on this home computer without caring about
their synchronization or about
the fact whether libreoffice is installed on the computer that I happened to
be at.



-- 
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 convert text to numbers

[David Gast]

Spreadsheets use the MVC (model view controller) paradigm.  That means
that the model (how the data are actually stored) and how you view
the data are separated.  You can take a number like 4.5 and view it
as a date, a date and time, a real number, etc.  You can easily compare
dates because they are stored as numbers, not character strings like
"Monday, Nov. 11." Further, you can easily send your spreadsheet to
someone who only knows some language you have never heard of and s/he
can open it and display and compare the dates in whatever language 
s/he has set.

The best way to see if a cell contains a number, text, or a formula is
to use View -> Value Highlighting (F8).  (Does Excel even have this
feature?  If so, it must hidden in the ribbon somewhere.)  A zero as
text has the ASCII value 48; as a number, the value is 0, so text and 
numbers are not equal.  OpenOffice used to generate errors if one 
improperly tried to add text and a number, for example.  Along the 
way, that behavior was modified to emulate Excel.  (I prefered the 
old way along with the fact that either OOo or gnumeric or both used to
evaluate -1^2 correctly--the mathematical answer is -1, not 1.)

I just checked using Excel 2010, if you change the format (the view) of the
cell, the underlying representation (the model) does not change.

   1. Type '123 in a cell, say A1
   2. Right click and choose Format Cells, then Format as a number.
  (That is, change General to Number.)

The entry is still text.  You can confirm because =sum(A1) yields 0.
Note: =A1+0 yields 123. (Also the text is still left justified.)

That is, there is no conversion.

Best regards,

David Gast


From: Oogie McGuire [oog...@desertweyr.com]
Sent: Monday, November 11, 2013 09:17
To: Joel Madero
Cc: Brian Barker; users@global.libreoffice.org
Subject: Re: [libreoffice-users] CALC convert text to numbers

For me dealing with an extension, installing it, making sure it doesn't 
conflict with something else was more effort than creating a column, using 
Value() and then pasting special.

What's a problem is that in Excel even though it also uses the leading ' to 
format text as numbers, if you change the format of a cell the conversions 
happen without any problems. I want that same behavior in Calc because to me it 
makes sense that the cell format should be the controlling factor for what type 
of data is in a given cell.


On Nov 10, 2013, at 7:43 PM, Joel Madero wrote:

> Why is everyone straying away from the fact that there is a simple extension 
> developed by Cor (one of our brilliant devs) which accomplishes all of this? 
> Just curious if there's a benefit to doing these formula techniques instead 
> of just pushing a button on a nice gui

Eugenie (Oogie) McGuire
Desert Weyr http://www.desertweyr.com/
Paonia, CO USA


--
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] Avery 3x5 card form, portrait/landscape problem

[David Gast]

> I know I could just rotate the text 90 degrees, but that is a bit hard
> to read :-)

Make two styles.  Type the text using the first style.
When you are ready to print, use the second style
with rotated text.  After printing go back to the first
style.

There may be some size issues, but you should be able to get around those.

Best regards


From: Paul D. Mirowsky [p_mirow...@bentaxna.com]
Sent: Thursday, October 31, 2013 09:06
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Avery 3x5 card form, portrait/landscape problem

When in doubt, get out a ruler and create a table.

Make sure it is set to proper cell size for each card.

Type/insert text.  Rotate text.

It's a kludge, but it works.



On 10/31/2013 8:14 AM, william drescher wrote:
> I need to print some 3x5 inch cards across the narrow side.  This
> would be "portrait" on each card.  The Avery Letter Size 5386 label
> has 3 cards stacked on top of each other: eg the cards are landscape
> on a page that is portrait.
>
> When I load the template and switch the page to landscape, instead of
> just rotating the page and template, LO rotates the page but leaves
> the template as is.  The result is that I have 2 - 3x5 cards on the
> first page, and 1 on the next page, all in landscape orientation.
>
> I know I could just rotate the text 90 degrees, but that is a bit hard
> to read :-)
>
> I can build my own template, but does anyone have other suggestions ?
>
> bill
>
>


--
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] docx problems

[David Gast]

In theory sending a PDF works, however, I have found that many files created
with LibreOffice and/or pdflatex print differently depending on the printer 
used.
My guess is that it is a font issue because not only is the spacing off, but the
output looks like the worst font in world was substituted.

Note: Checking embed standard fonts in LO does not solve the problem.

Best regards,

David


From: Gerald Pechoc [fed...@pechoc.eu]
Sent: Friday, October 25, 2013 15:57
To: ubu...@pechoc.eu; users@global.libreoffice.org
Subject: Re: [libreoffice-users] docx problems

  Hi,

  and you don't have the possibility to send .pdf files to your clients?
  In this case you are sure that formatting and fonts will be correct.
  This seem to be very important, from my point of view, especially in the
  case you have to translate to languages like german, polish, french
  where you have a lot of special letters.

  To have them all correct it is the only chance I think.

best regards
gerald



> On 2013-10-26 00:22, baldwin linguas wrote:
>> I don't even really know where to begin with this.
>> I haven't enough information to file a bug, really, because what I
>> have is vague, broad.
>>
>> But I have been doing business as a freelance translator for 10 years,
>> using only FREE/OSS, (OmegaT, OpenOffice, etc., on Debian GNU/Linux)
>> without any major issues.
>>
>> Now, suddenly, every time a client sends me a .docx file, I get a
>> complaint
>> when I return their documents that the formatting has changed (tables
>> are different,
>> fonts changed, bullets disappear, or, worse, they can't even open the
>> document,
>> although it opens fine here).
>>
>> It's ruining my business.
>> I'm losing clients, losing money, and I have a family to feed.
>> And I don't know what to do about it.
>> OpenOffice won't write to .docx, and LibreOffice messes them up.
>>
>> I don't know what to do to diagnose these issues, which is why
>> I feel I haven't sufficient information to file a bug.
>> I know nothing of Java (LO is primarily java, yes?),
>> so I certainly can't contribute to any solution.
>> I'm very frustrated and concerned.
>> I absolutely will not use proprietary software, but I am unable to serve
>> my clients' needs with FLOSS at this time.
>> I'm at a loss for what to do here.
>> I suppose this is venting more than anything else, and a desperate
>> plea for help here.
>>
>> For what it's worth, I'm using the LO 3.5.4.2 in the Debian Wheezy repos,
>> on AMD64 architecture.
>>
>>

--


Gerald Pechoc
Fedora User
email: fed...@pechoc.eu



--
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: Modified Flag Set / No Changes

[David Gast]

Thanks to all who replied.  Perhaps I was not clear.  I am trying to find out 
why the Modified Flag
would be set if I have made no changes.  What objects can LibreOffice Calc 
*silently* modify when starting
up that would cause the modified flag to be set?

While I can copy the files to a computer at home and try different versions, it 
would not actually be useful
for my purposes (perhaps someone on the list wants to know, however).  If some 
file opened without change
in another version of LibreOffice Calc, then it might mean that the file was 
created in that version.  That would
obviously be unacceptable if the exam was to be done in the lab using a 
particular version.

Unfortunately, the lab is public space (for many classes) and I do not
the authority  to modify what the technicians call the "lab load" in
the middle of a semester.  We will update to the latest version in early 
January.

Best regards,

David Gast
____
From: David Gast [david.g...@csulb.edu]
Sent: Monday, October 21, 2013 12:33
To: users@global.libreoffice.org
Subject: [libreoffice-users] Modified Flag Set / No Changes

Hi
Perhaps you can help.

My students submit examinations done in LibreOffice Calc to a web page.
I bundle them up and download them to a Windows XP box running
LO Version 3.6.4.3 (Build ID: 2ef5aff).  In previous semesters, an older
version was used.  There were no problems like this in previous semesters.

This semester close to one third of the submitted examinations are
being modified when opened by me for grading.  I confirmed by

  1. Open file (usually from the Cygwin command line, but also from Recent 
Documents)
  2. Immediately clicking the X close icon in the upper right hand corner.
  3. A message pops up asking whether I want to change, dismiss, or cancel.

I typed nothing, yet if I cancel, and then do a save-as, the saved-as file is 
different.

I have two hypotheses.

#1)
RANDBETWEEN() is used this year in some problems, perhaps it sometimes causes 
this
problem.  I cannot recreate that behavior, however.  Further, Compare document 
shows no
differences, nor does oodiff.

#2)
Some students did work outside of class and the version they used is not 100% 
compatible
with the version in the labs.  My reasoning is that I found in one submittal (I 
have not checked
all of them to this level of detail) that one of the fonts changed from 
something like
"New Times Roman1" to "New Times Roman".   (I used unzip and then a script to 
split the
various files into lines so that diff produced useful output.)

Any advice?  Is it possible to determine what LO is changing?

Best regards,

David Gast







--
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] Modified Flag Set / No Changes

[David Gast]

Hi
Perhaps you can help.

My students submit examinations done in LibreOffice Calc to a web page.
I bundle them up and download them to a Windows XP box running
LO Version 3.6.4.3 (Build ID: 2ef5aff).  In previous semesters, an older
version was used.  There were no problems like this in previous semesters.

This semester close to one third of the submitted examinations are
being modified when opened by me for grading.  I confirmed by

  1. Open file (usually from the Cygwin command line, but also from Recent 
Documents)
  2. Immediately clicking the X close icon in the upper right hand corner.
  3. A message pops up asking whether I want to change, dismiss, or cancel.

I typed nothing, yet if I cancel, and then do a save-as, the saved-as file is 
different.

I have two hypotheses.

#1)
RANDBETWEEN() is used this year in some problems, perhaps it sometimes causes 
this
problem.  I cannot recreate that behavior, however.  Further, Compare document 
shows no 
differences, nor does oodiff.

#2)
Some students did work outside of class and the version they used is not 100% 
compatible
with the version in the labs.  My reasoning is that I found in one submittal (I 
have not checked
all of them to this level of detail) that one of the fonts changed from 
something like
"New Times Roman1" to "New Times Roman".   (I used unzip and then a script to 
split the
various files into lines so that diff produced useful output.)

Any advice?  Is it possible to determine what LO is changing?

Best regards,

David Gast







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

Re: [libreoffice-users] Re: Can't open the file which is exported from crastal report

[David Love]

peterhuang  wrote:

> 
> Thanks your very much.
> 
> the file link as below
> http://forum.openoffice.org/zh/forum/download/file.php?id=941
> 
> I think it is just a regular doc file, and it is exported from crystal
> report. Our company are looking for a good office software to replace
> MS-OFFICE 2003, and our ERP system is using crystal report to output doc
> file.
> 
> My os is windows 7 64 bit (traditional chinese), and libreoffice is
> version 4.1.1.2. the openoffice version is 3.1.4
> 
> I downloaded this file and saved it to my local document folder. but the
> situation is the same. I can open it by openoffice, but it doesn't work
> on libreoffice.

Using LinuxMint x64 and LlibreOfficeVersion 4.0.2.2 (Build ID:
400m0(Build:2))

File opens without any problem.  However, I cannot read it as I haven't
got the appropriate fonts loaded.

Looks as if it might be a LibreOffice/Windows problem.

David

-- 
David Love
Can it be a coincidence that "STRESSED" is "DESSERTS" spelled backwards 

-- 
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] the password of Libreoffice

[David Stuckey]

To the originator of this thread, I feel your pain and commiserate with
you.  As to the solution... I don't know.  I think the best answer I have
seen is to have a different password for every different type of file or
web sight, i.e. all write files or all calc. files...even they can be
individualized at will.  Then keep a special file with a benign, password
protected, name that holds all the passwords.  The secure password for this
file is carried around with you (until you have used it so many times that
you know it by heart.)
Of course, I inevitably forget to include a new password in the password
file!
By the way, thanks to all who replied to my cry for help with the
Formula/text difficulty in Calc.
Regards, David

|
David Stuckey, MBA. MHSA.


On Wed, Sep 11, 2013 at 6:07 AM, Tom Davies  wrote:

> Hi :)
> There are plenty of warnings out there and people take no notice of them.
> I saw a hot tap with a warning notice over it saying "Warning the water
> might be hot".  People cease to even notice warning notices because they
> are far tooo common.
>
> I my office we used to carefully hide the servers in a locked cabinet
> behind a filing cabinet which meant that everyone knew where they were.
> Now they are right in the middle of the office and people walk past them
> any time they walk around the office.  Consequently no-one notices them!
> My boss wanted me to label them with "Do not touch" signs so that kids
> wouldn't try playing with them but i managed to avoid it.  The kids don't
> go near them because they look boring but an exciting notice saying "Do not
> touch" would make them wonder why and make them curious to know what would
> happen if they did.
>
> Regards from
> Tom :)
>
>
>
>
> 
>  From: Gabriel Risterucci 
> To:
> Cc: "Users@Global.LibreOffice.Org" 
> Sent: Wednesday, 11 September 2013, 11:25
> Subject: Re: [libreoffice-users] the password of Libreoffice
>
>
> 2013/9/11 Tom Davies 
>
> > Hi :)
> > You can always try opening it with MS Office.
> >
> > I have opened password protected MS files in LibreOffice without even
> > being asked to type in a password.  I have been told the other way around
> > works too.  Both programs use different systems for password protection.
> >
> >
>
> > Another way might be to copy the file and then rename the file-ending to
> > .zip and then you should be able to poke around inside the coding of the
> > file.  I've not looked at a Calc file that way so i am not sure whether a
> > text-editor could help recover the information from "contents.xml".
> Also i
> > am not sure if there is a single element that could be deleted to remove
> > the password protection.
> >
>
> Unfortunately, while it's true that old mso formats used "password
> protection" as a simple access management tool, recent version (think docX)
> and libreoffice files *do* encrypt the files.
>
> Opening the file as a zip file will only yield ciphered files, except for
> the mimetype one, which is not very useful.
>
>
> > Most security is more likely to hamper legitimate users than really slow
> > down a determined cracker.  Encryption is a classic at being more often
> > responsible for losing crucial or private data.
> >
>
> If done correctly, the "slow down" part would grow into many years. That's
> the point of encryption, since a bruteforce attack is always possible with
> every cryptosystems :-)
>
> However, you're right; for most people this option is more like a trap if
> it is not part of a greater document management system that does take care
> of the details like password, keys, and allow for some kind of recovery.
> Maybe there should be a warning box that explicitely state that the
> document will be lost if the password is lost.
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] Re: Formulas in text instead of result - LO Calc

[David Stuckey]

Thanks to all.  It is amazing how such a little action can cause so much
anxiety.

|
David Stuckey, MBA. MHSA.


On Fri, Aug 23, 2013 at 11:01 AM, Pedro  wrote:

> Open Calc, go to Tools > Options. In the Options dialog click on the plus
> sign to the left of LibreOffice Calc (on the left hand tree)  and then on
> View.
> Uncheck the option on the top right Display > Formulas
>
> Hope this helps.
>
>
>
> --
> View this message in context:
> http://nabble.documentfoundation.org/Formulas-in-text-instead-of-result-LO-Calc-tp4071257p4071306.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

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

[libreoffice-users] Formulas in text instead of result - LO Calc

[David Stuckey]

I have inadvertently turned on an 'Option' in LO-Calc that now results in
the text of any/all formulae being written in the result cell instead of
the actual result.  Please can anybody help me to turn it off again?
Thanks, David.
|
David Stuckey, MBA. MHSA.

-- 
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: Sequentially numberted tickets...

[David Love]

Hi Nino

Nino Novak  wrote:

> Am 08.08.2013 06:53, schrieb David Love:
> > I have been asked to design and print numbered tickets for an event
> > being organised by a Club to which my wife belongs.
> 
> How I'd do it (it's from memory, so bear with me for little glitches):

Thank you for the prompt reply and my apologies for the delay in replying to
you.

> 1. Set up a Calc spreadsheet and enter a header (e.g."number") and the
> desired numbers (1 to 150 or even 001 to 150 by chosing a custom number
> format with two preceeding zeroes) into a column

Did that without problems.

> 2. design a nice text page with all 4 tickets in it (you could also try
> going with labels but for just 4 tickts per page I'd rather go with
> copy&paste instead of fumbling with labels)

O.K. Although I did have some trouble grouping all elements.

> 3. assign the spreadsheet from #1 as data source (for later use as
> mailmerge, from memory: File > New > Database > connect to existing >
> spreadsheet)

Perfect!

> 4. on your above designed ticket page, press F4 to open the spreadsheet
> from above as data source

No problem.  

> 5. enter (simply drag&drop) column header field into the appropriate place
> in stub and repeat this for the ticket

Went without a hitch.

> 6. after every SECOND field enter "next record" switch (Insert > field >
> others > database > next record) but NOT after the fourth ticket (as a
> page break always triggers a next record switch)

This is where I've gone wrong and I cannot figure out how.  As I understood
it, on the stub and ticket of tickets number 2, 3, 4, I do what you suggest
above.  Is that correct?

and then, as it will be a new page, the numbering will continue in sequence
until we reach the end of the records.  Is that correct

> 7. Print as mailmerge (or form letter or whatever it's called) into 1
> document

I do this by Printing to file.  The first ticket is correct.  Tickets number
2, 3 and 4 are not numbered.  It then goes to the next page where the first
ticket is numbered 2 and the other three are not numbered.  And so it goes
on until the end of the records.  Each page is the next number.

I notice that when I have Next Record highlighted and click Insert, all that
happens is a thin grey vertical line appears where I click.  I would have
thought the words  would have appeared.  Am I wrong?

> 8. review the document and if necessary correct&repeat some of the above
> steps

I am at a loss as to what I should do next.

> 9. print the merged documents,
> 
> 10. enter perforation (I use a sewing machine, works perfectly if you use
> a thin needle and adjust the step width appropriately)
> 
> 11. cut tickets apart :-)
> 
> Enjoy learning ;-)
 
My enjoyment is leading to "grinding of teeth in frustration"

David

-- 
David Love
A "running mate" is a husband who dared to talk back

-- 
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] Writer - selecting all items...

[David Love]

Tom Davies  wrote:

> Hi :) Ctrl A usually works.  Have you selected 1 things and then pressed
> Ctrl A to select all the rest?

But doesn't in this case. Yes, have tried by selecting single frame and then
pressing Ctrl A to select all the others.  Same result - doesn't select the
remainder.

> Is this related to the other question?  If you have loads of shapes and
> text-boxes and things it might be better to copy&Paste those into a Draw
> document to do all this sort of thing Regards from Tom :)

If you mean the one about Grouping, then Yes.

Did as you suggested but ran into some difficulties.  Only the first two
lines of each text frame (total 2) were pasted into Draw (although the frame
was the correct size.

Then created the whole item in Draw.  That was successful.  Copied and
pasted to Write and found that I couldn't then enter a frame into which I
can insert a database field.  

This is all tied up with my previous posting seeking advice regarding
sequential numbering of tickets.

What I'm trying to do is avoid the necessity of having to create the number
of tickets I need and typing the number on each one.  At 100 - 150 tickets
that is very laborious :-(

David
-- 
David Love
Not a morning person' doesn't even BEGIN to cover it..."  

-- 
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 - grouping objects...

[David Love]

How do I select all frames and Group them, please.

Whatever I do, the Group item in Format>Group is greyed out. I cannot find
anything aplicable in the Help File.

Can someone point me in the right direction, please?

David
-- 
David Love
CURSOR: An expert in four-letter words.

-- 
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 - selecting all items...

[David Love]

In most Linux programs, holding down the Ctrl key and pressing A selects all
items but this does not appear to work in Writer.  Am I missing something? 
I have looked in Help but cannot find anything to assist.

Can someone lead me in the right direction, please?

David
-- 
David Love
Use what talent you possess. The woods would be very silent if no birds sang
except those that sang best.  

-- 
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: Sequentially numberted tickets...

[David Love]

Nino Novak  wrote:

> Hi David,
> 
> Am 08.08.2013 06:53, schrieb David Love:
> > I have been asked to design and print numbered tickets for an event
> > being organised by a Club to which my wife belongs.
> 
> How I'd do it (it's from memory, so bear with me for little glitches):
> 
> 1. Set up a Calc spreadsheet and enter a header (e.g."number") and the
> desired numbers (1 to 150 or even 001 to 150 by chosing a custom number
> format with two preceeding zeroes) into a column
[snip]

Thanks, Nino.  I will give it a go and report back.

David

-- 
David Love
Do more than anyone expects, and pretty soon everyone will expect more   

-- 
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] Sequentially numberted tickets...

[David Love]

I have been asked to design and print numbered tickets for an event being
organised by a Club to which my wife belongs.  

Starting from the left edge:

(a) in the first third details of the event and a number. This is the "stub"


(b) in the remaining two thirds there is an image to the left and then
details of the event. This is the "ticket"

(c) each ticket has two numbers (both the same) printed to justify right on
the "stub" and on the "ticket"

(d) each ticket spans the width of an A4 page

(f) there are four tickets to an A4 page

(g) the ticket will be perforated between the "stub" and the "ticket" to
allow for easy detachment

(h) Designing the ticket is not a problem.  But how do I ensure that the
numbers are printed sequentially in groups of two?

Is it possible to do this on LibreOffice?

I realise that it is possible to number each  ticket on a A4 page and then
print it but as it is looking like 150 tickets that looks like a lot of
work.

David
-- 
David Love
"A lie gets halfway around the world before the truth has a chance to get
its pants on."

-- 
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] [base] Writing form trigger macros to modify other fields?

[David M. Karr]

Using OpenOffice/LibreOffice I've been building a small database with a 
form.  I'm now at the point where I have two fields (radio button pair 
and date field) that are somewhat connected.  When I set the radio 
button to "No", I should set the date field to null, and when I set the 
date field to non-null, I should set the radio button to "Yes".


It looks like I'll have to venture into macros to do this.  Could 
someone point me to specific current resources and hints that will help 
me achieve this?


From a language point of view, I'd prefer to write Java macros, but I 
can see the possibility that that might not be ideal for this 
situation.  Is it practical to write macros in Groovy?  Otherwise, I 
suppose I'll have to use the default, which appears to be a variant of 
Basic.


From what little I can tell about how macros are used, it looks like 
macros are not parameterized.  You just get the ability to call a macro 
on an event.  I would think it would be very useful to be able to write 
a macro that is intended to take parameters, like "trigger value", 
"target field", and "target value", and that could be reused in any 
situation where a new particular value for a field needs to cause a 
particular value to be set on another field.


--
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] exporting word completion list for multiple LO writer installations

[David Littman]

Obviously if I found the acor_en-US.dat I know about user profiles. I need
an answer to the specific question, not general information.
Thx.


On Thu, Jun 6, 2013 at 6:16 PM, Tom Davies  wrote:

> Hi :)
> I thought you might be interested in these links
> https://wiki.documentfoundation.org/Documentation/UserProfile
> User Profiles are well worth knowing about even if the details remain a
> little hazy.  You might also like this link
>
> https://wiki.documentfoundation.org/Documentation/Other_Documentation_and_Resources#Corporate_Users
> (or rather the links in that section)
>
> Sorry that doesn't answer the question directly!
> Good luck and regards from
> Tom )
>
>
>   --
>  *From:* David Littman 
> *To:* users@global.libreoffice.org
> *Sent:* Thursday, 6 June 2013, 21:33
> *Subject:* [libreoffice-users] exporting word completion list for
> multiple LO writer installations
>
> I would like to export my writer word completion entries so I can use them
> with several LO installations.
>
> The autocorrect file seems to be acor_en-US.dat, i found it, and exported
> it.
>
> Where are the accumulated word completions? If not in a file, is there a
> workaround?
> Thank you,
> David Littman
>
> --
> 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] exporting word completion list for multiple LO writer installations

[David Littman]

I would like to export my writer word completion entries so I can use them
with several LO installations.

The autocorrect file seems to be acor_en-US.dat, i found it, and exported
it.

Where are the accumulated word completions? If not in a file, is there a
workaround?
Thank you,
David Littman

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