[libreoffice-users] Format>Page freezes LO 5.3.2

[Tim-L--Elmira-NY]

I downloaded LO 5.3.2 64-bit DEB.

When I opened Writer and tried to format the default page margins, I 
waited maybe 10 seconds and it froze.  I used the force to quit option 
when it came up. Then I tried again, the page was shown as Untitled 
(Remote).  I have to idea while the "remote" text showed up in the 
document name.  I opened a page I created last month and it froze again 
when I tried to format the page again.



Any Ideas?

For now I am going back to 5.2.x so I can get my work done.  But soon it 
would be nice to go to 5.3.x.



--
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] Showing two sheets of the same spreadsheet

[Brian Barker]

At 14:36 20/04/2017 -0500, Anne Noname wrote:
yes, on Apple's MacIntosh, this is simple ... it's one of the 
advantages, I've discovered in finally making the decision to purchase ;-)
on MsFt's, it's a matter of re-sizing each window then keeping each 
running. ;-)


How is this "simple" on Macintosh, please? It's a well established 
idea, I think, that aficionados of Apple systems often prefer them 
through genuinely held but erroneous notions of what other operating 
systems cannot do. See
https://thejaggedworddotcom.files.wordpress.com/2014/08/apple-religious-fanaticism.jpg?w=238=179 
. So it's fair that we should enquire.


If you don't have two windows, how do you see two sheets? That would 
have to be a facility in LibreOffice itself, which I don't see 
exists. In any case, if it did it would exist equally under different 
operating systems.


If there are two windows and you don't have both windows running, 
they cannot be operative and functional: nothing can work. (And you 
don't have to "keep each running": they do this by themselves!) If 
you have two windows each running in the same instance of 
LibreOffice, how is this different from what happens under Windows? 
And from what happens under Linux?


Are you able to explain in detail, please, exactly what you think Mac 
OS will do for you in this context - and how you achieve it - that 
isn't provided by other operating systems?


Or can anyone else confirm the advantage and explain the difference?

Brian Barker  



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