Re: [libreoffice-users] em-dash sticking to its left term:follow up

[Eric Beversluis]

On 06/26/2016 05:28 PM, Eric Beversluis wrote:
It seems in M$ Word that the default if for the em-dash always to 
stick with its left term when confronted with a line break.


In LO Writer, this seems not the case. One seems to have to first 
insert U+FEFF and then the em-dash. Is there a way to change the 
default in LO Writer?


I thought to try search and replace. But it's behaving strangely. When I 
use a hex code in the search field (\u2014) it finds them. But when I 
put the same kind of code in the replace field, it replaces with the 
code (\ufeff or \u00e8) rather than with the character the code stands 
for. Why would the regular expression work in the search field but not 
in the replace field?

--
Eric Beversluis
www.ericbeversluis.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] em-dash sticking to its left term

[Eric Beversluis]

It seems in M$ Word that the default if for the em-dash always to stick 
with its left term when confronted with a line break.


In LO Writer, this seems not the case. One seems to have to first insert 
U+FEFF and then the em-dash. Is there a way to change the default in LO 
Writer?



--
Eric Beversluis
www.ericbeversluis.com 

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

Re: [libreoffice-users] Calc suggestion

[Joel Madero]

Hi Kolbjørn,

I just want to make sure expectations here are realistic (I believe I 
was one who commented on the bug). Our project works by the "doers 
deciding" - so even if 100 users say they'd like the feature, *at most* 
this would result in the enhancement going to NEW as a valid enhancement 
request and then *very likely* would sit there for a long time (until a 
developer with the skills required *volunteered* to implement it.


I've pointed out a couple issues with adding entirely new functions:

1) We (The Document Foundation) does not control ods standards, I 
suggested to you that you poke them to see if they're at all interested 
in adding a new standards;


2) When there is currently a workable formula (even if requiring some 
nested functions) - the reason is that there are almost infinite 
combinations of nested functions that people use - if we start taking 
enhancements based on "well one function could replace this x(y(z(#,#))) 
function" than we almost have no limit. I could almost immediately file 
probably two dozen such requests.


Again, just trying to keep things realistic. Best case is that this goes 
to "NEW" just as a "fine it's a valid enhancement" but then it'll almost 
definitely sit there (possibly indefinitely).



Warmest Regards,

Joel



On 6/26/2016 12:01 PM, Kolbjørn Stuestøl wrote:
I asked for this as an enhancement. (Bug125848 
).
It looks like the developers has plenty to do adding functions to be 
compatible with other spreadsheets (read: Excel?). So most likely it 
will be marked WONTFIX.

 I just asked for this function because
1) I needed it (instead of using workarounds), and
2) it would be nice if Calc sometimes was ahead of Excel.
But, as I said, if I am the only one in need for such function(s), it 
is undesirable to waste time on it.


Kolbjørn


*
*Den 20.06.2016 21:54, Kolbjørn Stuestøl skreiv:
I have not found an active forum for developers so I am trying this 
forum. Perhaps someone know where to post it?


I would like to have a function who finds the first or last 
occurrence of an item in a cell area.

Something like

   FIND.FIRST(B1:C20,A1) and FIND.LAST(B1:C20,A1)

where A1 contains the needle (what should be found), C1:C20 the 
search area (the heystack) and if found in C1:C20 returns the value 
of the corresponding row from B1:B20.


Also FIND.FIRST(B1:B20,A1) where the returned value is the address to 
the actual cell in B1:B20 will do.


A1 could contain a number value or something like "<5" to find the 
first occurrence of a number less than 5. Including text would be top.


What could this function be used for?
If I for example are running a shop opening at 7 in the morning with 
a few employers. (I assume the cash register is connected to Calc). 
What time of the day is the first sale? If I never sell anything 
before 10 o'clock, I could save some wages, and consider sleeping 3 
hours more in the morning. :-)
Or I could find out what day was the first rainy day in June or the 
first frosty day in the autumn the latest 20 years, or when my 
wildlife cameras first recognized an elk.


I have not found this function in other spreadsheets, so perhaps Calc 
will be the first one?


I am now using a walk around, so I am not asking for how to do this 
calculations. I am only asking for a function to do this in a simpler 
way.


Kolbjørn Stuestøl








---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


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

[Kolbjørn Stuestøl]

I asked for this as an enhancement. (Bug125848 
).
It looks like the developers has plenty to do adding functions to be 
compatible with other spreadsheets (read: Excel?). So most likely it 
will be marked WONTFIX.

 I just asked for this function because
1) I needed it (instead of using workarounds), and
2) it would be nice if Calc sometimes was ahead of Excel.
But, as I said, if I am the only one in need for such function(s), it is 
undesirable to waste time on it.


Kolbjørn


*
*Den 20.06.2016 21:54, Kolbjørn Stuestøl skreiv:
I have not found an active forum for developers so I am trying this 
forum. Perhaps someone know where to post it?


I would like to have a function who finds the first or last occurrence 
of an item in a cell area.

Something like

   FIND.FIRST(B1:C20,A1) and FIND.LAST(B1:C20,A1)

where A1 contains the needle (what should be found), C1:C20 the search 
area (the heystack) and if found in C1:C20 returns the value of the 
corresponding row from B1:B20.


Also FIND.FIRST(B1:B20,A1) where the returned value is the address to 
the actual cell in B1:B20 will do.


A1 could contain a number value or something like "<5" to find the 
first occurrence of a number less than 5. Including text would be top.


What could this function be used for?
If I for example are running a shop opening at 7 in the morning with a 
few employers. (I assume the cash register is connected to Calc). What 
time of the day is the first sale? If I never sell anything before 10 
o'clock, I could save some wages, and consider sleeping 3 hours more 
in the morning. :-)
Or I could find out what day was the first rainy day in June or the 
first frosty day in the autumn the latest 20 years, or when my 
wildlife cameras first recognized an elk.


I have not found this function in other spreadsheets, so perhaps Calc 
will be the first one?


I am now using a walk around, so I am not asking for how to do this 
calculations. I am only asking for a function to do this in a simpler 
way.


Kolbjørn Stuestøl





--
Kolbjørn Stuestøl, Stuestølveien 212, 4580 Lyngdal
Telefon: (47) 38 34 78 62,  (47) 917 81 125
Stuestøl heimesider: http://www.stuestoel.no
Andre sider eg administrerer:
Lyngdal hagelag: http://lyngdal.hagelag.no
(Passive sider: http://www.stuestoel.no/hagelag/hagelag.php)
Mandal og Lister pyntegrøntlag: http://www.mlpynt.no

Member of the GIMP Documentation Team
Language coordinator LibreOffice (www.libreoffice.org/)


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

[libreoffice-users] LO Base - Dropdown boxes

[Ian Whitfield]

Hi all

I'm trying to use LO Base - linked to a Spreadsheet and so far all is 
going well.
However I don't seem to be able to get Dropdown Boxes to work. On my 
'User Form' they are greyed out and do not react when clicked. I have 
set them to be Dropdown, entered the list of options and set the display 
line number.
Any ideas please?? They worked with HSQLDB but I've had too many crashes 
and lost data with that system so am trying a Spreadsheet source 
instead. Do they work with this system??


My OpSys is PClinuxOS and LO is version 5.1.4.2.

Thanks a lot

IanW
Pretoria RSA

--
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 5.1.4.2 calc consistently crashing on row deletion

[Bruce Hohl]

Tom,
I just updated to LO 5.1.4.2 from the Ubuntu PPA's on Ubuntu 14.04 (really
LXLE Posh).  I checked deleting rows from a few worksheets and encountered
no errors.  If you are using Ubuntu or an Ubuntu based OS you might try
getting LO from the PPAs per the links below as these are packaged for
Ubuntu.
https://wiki.ubuntu.com/LibreOffice
https://launchpad.net/~libreoffice/+archive/ubuntu/ppa

On Fri, Jun 24, 2016 at 6:54 PM, Tom Cloyd  wrote:

> I downloaded the *.deb installer yesterday, and installed it a little over
> an hour ago. It's crashed 6 times in the first hour. No matter how I try to
> delete a spreadsheet row, I get a modal window with an error message.
> Clicking that away leads to all of LO just disappearing.
>
> Here's my version:
>
>
>
>
> And the error message I keep seeing -
>
>
> ​
> I can't use this version if it acts like this, so I'm reverting to my
> previous one.
>
> Let me know if I can help any more.
>
> Tom
>
> --
>
> ~
> Tom Cloyd, MS MA LMHC (WA)
> Psychotherapist (psychological trauma, dissociative disorders)
> Spokane, Washington, U.S.A: (435) 272-3332
> << t...@tomcloyd.com >> (email)
> << TomCloyd.com >> (website)
> ~
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

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

Re: [libreoffice-users] LO 5.1.4.2 calc consistently crashing on row deletion

[M Henri Day]

2016-06-26 0:03 GMT+02:00 Tom Cloyd :

> Yeah, apparently not. That's just plain dumb. The error message is long
> and full of technogarble. I'm not about to attempt to flip back and forth
> to another window or workspace (95 mouseclicks, anyone?) to type it out. I
> took a screenshoot - two, in fact - and they were part of my now obvious
> meaningless message. I guess the server protocol stripped them out.
>
> Thanks for letting me know about this, and for trying to replicate the
> problem, with little information to go on.
>
> I'm a very busy professional. I just can't take the time to work this out.
> My schedule is always overloaded. Wish I could help more with this, but
> almost every time I've tried, in the past, the time cost has been
> prohibitive. I thought that this time, with the screenshots I'd found a
> path, but...not so.
>
> Tom
>
> On Sat, Jun 25, 2016 at 8:42 AM, M Henri Day  wrote:
>
>> 2016-06-25 0:54 GMT+02:00 Tom Cloyd :
>>
>>> I downloaded the *.deb installer yesterday, and installed it a little
>>> over
>>> an hour ago. It's crashed 6 times in the first hour. No matter how I try
>>> to
>>> delete a spreadsheet row, I get a modal window with an error message.
>>> Clicking that away leads to all of LO just disappearing.
>>>
>>> Here's my version:
>>>
>>>
>>>
>>>
>>> And the error message I keep seeing -
>>>
>>>
>>> ​
>>> I can't use this version if it acts like this, so I'm reverting to my
>>> previous one.
>>>
>>> Let me know if I can help any more.
>>>
>>> Tom
>>>
>>
>> ​<...>​
>>
>> Tom, neither your version nor the error message you see are reproduced in
>> the above. I'm running Version: 5.1.4.2 Build ID: 1:5.1.4-0ubuntu1~trusty1
>> on Linux Mint 17.3, but do not see the behaviour your observed
>>
>> Henri
>>
>
​Hullo Tom !

According to my experience, screenshots, like links, are stripped out on
the forum as a security measure. Saving them to a website and then
providing the relevant URL in a message to this forum would be one way to
get 'round the problem

May I ask what version of Linux you are using ?...

Henri

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