Re: [libreoffice-users] Concatenate Function inCalc

[Robert Großkopf]

Hi Luuk,
> 
> I decided not to report this as a bug.
> 
> Then only 'bug' i could find is that CONCAT is missing from the help,
> 
> where CONCATENATE leads to:
> https://help.libreoffice.org/6.2/en-US/text/scalc/01/04060110.html?System=WIN=CALC=SC_HID_FUNC_VERKETTEN#bm_id3153084
> 
> 
> 
> I (anyone) want to create a bug, you can do it here:
> https://bugs.documentfoundation.org/enter_bug.cgi

Already done: https://bugs.documentfoundation.org/show_bug.cgi?id=124502

Regards

Robert
-- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3


-- 
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] Tabs in selection of text

[Carl Paulsen]

I have a number of "paragraphs" of text (job listing section of a 
resume) for which I'd like to add tab stops.  I select the lines and 
click the tab stop I want, then click in the ruler, but nothing 
happens.  I see no menu item to format tabs, though I did stumble into 
one dialog box with Tabs that required manual setting and it was unclear 
just where those tabs would be applied.  In any case, I can't find that 
any more.


In the help document 
(https://help.libreoffice.org/Common/Inserting_and_Editing_Tab_Stops) it 
says for changing one or more paragraphs: "Select the paragraphs, then 
click inside the ruler."  That is most definitely not working.  Finally, 
if I clear all formatting, I get the default tab stops and could 
re-format the entire section that way.  But that's a bit of work given 
all the formatting I'd lose.


What do I do to quickly and simply edit tab stops, and why is it so 
difficult in LO?


FYI I find the Styles aspect of LibreOffice to be entirely unintuitive 
and I've never been able to work with them.  I realize that should be a 
goal but it's not possible in my current timeline.


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] Inserting a Trademark Symbol in Label

[Steve Edmonds]

Hi.

On 04/04/2019 05:25, Budge wrote:
> On 03/04/2019 06:29, Michael H wrote:
>> :tm: is in the LibreOffice autocorrect database. colon-tm-colon
>> (lower case matters.) should produce a TM logo if you have
>> autocorrect enabled.
>>
>> On Tue, Apr 2, 2019 at 8:30 PM Alan B > > wrote:
>>
>>     The following won't help you see/find the symbol. It will however
>>     let you
>>     type it directly.
>>
>>     Put your cursor where you want the symbol to appear then
>>
>>     If using Windows (tested with Windows 10 and LibreOffice 6.2.2.2) -
>>     Type 2122 then Alt+X
>>
>>     If using Linux -
>>     Ctrl+Shift+U and release, then 2122, then enter
>>
>>     On Tue, Apr 2, 2019 at 6:23 PM Budge >     > wrote:
>>
>>  > Using Writer with DejaVu Sans font and having created a label
>>     using the
>>  > Avery A4 template with Synchronize active, all is well until I
>>     try and
>>  > include the Trademark symbol.  The advice I have is:-
>>  >
>>  >      Place the cursor in the location where you want the symbol
>>     to appear.
>>  >      On the Insert menu select Special Character.
>>  >      In the dialog that appears, choose Symbol from the Font
>> list.The
>>  > trademark symbol is available in a Serif font (character 212)
>> or in a
>>  > San-Serif font (character 228). ...
>>  >      Click OK.
>>  >
>>  >   My problem is that once I select Special Characters the Font is
>>     shown
>>  > and then a huge list of available Subsets and using for
>> example Basic
>>  > Latin, I get a whole lot of characters, all too big and all
>>     overlapping
>>  > so even if the TM symbol is there I cannot see it.
>>  >
>>  > I need some guidance please.
>>  >
>>  > --
>>  > 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
>>  >
>>
>>
>>     --     Alan Boba
>>     CISSP, CCENT, ITIL v3 Foundations 2011
>>
>>     --     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
>>
> That might have worked but didn't but the autocorrection has many
> settings so may not be correctly set up.  Will play around in plain
> text document and ask again.
>
Do you get this dialogue for insert special character. Type in the
number 2122 then find and click on the square with the TM character.
Note, you have to be using a unicode font with the character for this to
work so change font if you need to.
(image deleted in list)

steve


-- 
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] Concatenate Function inCalc

[Luuk]

On 2-4-2019 19:33, Robert Großkopf wrote:

Hi Luuk,


In 6.2.0.3 on Windows, the function CONCATENATE(a1:a3) returns the value
of a1

This should be reported a a bug...

So please report this, if you could see the buggy behaviour in LO
6.2.2.2 also. I can't report it, because I couldn't reproduce it with LO
6.2.2.2.

Regards

Robert


I decided not to report this as a bug.

Then only 'bug' i could find is that CONCAT is missing from the help,

where CONCATENATE leads to:
https://help.libreoffice.org/6.2/en-US/text/scalc/01/04060110.html?System=WIN=CALC=SC_HID_FUNC_VERKETTEN#bm_id3153084


I (anyone) want to create a bug, you can do it here:
https://bugs.documentfoundation.org/enter_bug.cgi


--
Luuk




--
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] Inserting a Trademark Symbol in Label

[Budge]

On 03/04/2019 06:29, Michael H wrote:
:tm: is in the LibreOffice autocorrect database. colon-tm-colon (lower 
case matters.) should produce a TM logo if you have autocorrect enabled.


On Tue, Apr 2, 2019 at 8:30 PM Alan B > wrote:


The following won't help you see/find the symbol. It will however
let you
type it directly.

Put your cursor where you want the symbol to appear then

If using Windows (tested with Windows 10 and LibreOffice 6.2.2.2) -
Type 2122 then Alt+X

If using Linux -
Ctrl+Shift+U and release, then 2122, then enter

On Tue, Apr 2, 2019 at 6:23 PM Budge mailto:aje...@errichel.co.uk>> wrote:

 > Using Writer with DejaVu Sans font and having created a label
using the
 > Avery A4 template with Synchronize active, all is well until I
try and
 > include the Trademark symbol.  The advice I have is:-
 >
 >      Place the cursor in the location where you want the symbol
to appear.
 >      On the Insert menu select Special Character.
 >      In the dialog that appears, choose Symbol from the Font list.The
 > trademark symbol is available in a Serif font (character 212) or in a
 > San-Serif font (character 228). ...
 >      Click OK.
 >
 >   My problem is that once I select Special Characters the Font is
shown
 > and then a huge list of available Subsets and using for example Basic
 > Latin, I get a whole lot of characters, all too big and all
overlapping
 > so even if the TM symbol is there I cannot see it.
 >
 > I need some guidance please.
 >
 > --
 > 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
 >


-- 
Alan Boba

CISSP, CCENT, ITIL v3 Foundations 2011

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

That might have worked but didn't but the autocorrection has many 
settings so may not be correctly set up.  Will play around in plain text 
document and ask again.


--
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] Inserting a Trademark Symbol in Label

[Budge]

On 03/04/2019 02:27, Alan B wrote:

The following won't help you see/find the symbol. It will however let you
type it directly.

Put your cursor where you want the symbol to appear then

If using Windows (tested with Windows 10 and LibreOffice 6.2.2.2) -
Type 2122 then Alt+X

If using Linux -
Ctrl+Shift+U and release, then 2122, then enter

On Tue, Apr 2, 2019 at 6:23 PM Budge  wrote:


Using Writer with DejaVu Sans font and having created a label using the
Avery A4 template with Synchronize active, all is well until I try and
include the Trademark symbol.  The advice I have is:-

  Place the cursor in the location where you want the symbol to appear.
  On the Insert menu select Special Character.
  In the dialog that appears, choose Symbol from the Font list.The
trademark symbol is available in a Serif font (character 212) or in a
San-Serif font (character 228). ...
  Click OK.

   My problem is that once I select Special Characters the Font is shown
and then a huge list of available Subsets and using for example Basic
Latin, I get a whole lot of characters, all too big and all overlapping
so even if the TM symbol is there I cannot see it.

I need some guidance please.

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





Hi and thatks for the reply.  Do not use Windoze.
Tried the linux option several times but alas, no joy!


--
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] Concatenate Function inCalc

[Robert Großkopf]

Hi Jonathon,
> 
> It doesn't matter if concat or concatentate is the correct command to
> use. Neither concat(a20:a200) nor concatentate(a20:a200) return the
> expected the result. Both return the value in a20.

I couldn't confirm this with
Version: 6.2.2.2
Build ID: 2b840030fec2aae0fd2658d8d4f9548af4e3518d
CPU threads: 6; OS: Linux 4.12; UI render: default; VCL: gtk3;
Locale: en-US (de_DE.UTF-8); UI-Language: en-US
Calc: threaded
(OpenSUSE 15, rpm Linux)

I write down some text in A1, B1 and C1 and then in D1 =CONCAT(A1:C1) .
Shows the content of all fields together in D1.
Then the same with =CONCATENATE(A1:C1) .
Shows #VALUE!

You have tested with LO 6.2.2.2? Please show the Build ID here. Is it a
build of the Linux-distribution or is it a build directly from LO?

Regards

Robert
-- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3


-- 
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] Inserting a Trademark Symbol in Label

[W. Robert J. Funnell, Prof.]

On Tue, 2 Apr 2019, Budge wrote:

> ...
> My problem is that once I select Special Characters the Font is shown and 
> then a huge list of available Subsets and using for example Basic Latin, I 
> get a whole lot of characters, all too big and all overlapping so even if the 
> TM symbol is there I cannot see it.
> ...

I have never seen the behaviour you describe, with oversize characters 
in the Special Character selection window. I just tried it with the 
DejaVu fonts in my LO version 6.2.0.3 under Windows 10, to be sure.

What version of LibreOffice are you using, and under what version of 
which operating system? Do you have extensions or accessibility 
options running that might affect the behaviour?

- Robert

-- 
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] Inserting a Trademark Symbol in Label

[Dave Howorth]

On Wed, 3 Apr 2019 11:43:34 +0200
Philip Jackson  wrote:

> On 03/04/2019 07:29, Michael H wrote:
> > :tm: is in the LibreOffice autocorrect database. colon-tm-colon
> > (lower case matters.) should produce a TM logo if you have
> > autocorrect enabled. 
> In my LO Writer (6.0.7.3), the autocorrect option is (tm) using
> parentheses and not colons.

In mine (6.1.3.2) either works :)

But I get an unusable window to choose characters from if I follow
Budge's instructions. All the characters, and the window itself are far
too large and overlap horizontally. Vertically the window is taller
than my screen and not resizable.

If that occurs with a current version, I'd think a bug report was
appropriate. It's a surprisingly glaring bug.

-- 
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] Concatenate Function inCalc

[Dave Howorth]

On Tue, 2 Apr 2019 23:27:16 +0200
Regina Henschel  wrote:

> Hi Michael,
> 
> Michael H schrieb am 02-Apr-19 um 13:03:
> > CONCATENATE must either fail to accept ranges (with an error), or
> > accept them and provide the combination that acceptance suggests.
> > It is a bug that it accepts ranges, but returns something else.
> >   
> 
> Because CONCATENATE expects a list of simple references, it performs
> an "implicit intersection", if instead of a simple reference a range
> is given.
> http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#ImpliedIntersection
> 
> That is the reason, that sometimes you get the content of a single
> cell as result and sometimes an error.

That's a crazy idea that will lead to all kinds of obscure errors. Far
better to unconditionally return an error, IMHO.

> Kind regards
> Regina
> 


-- 
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] Inserting a Trademark Symbol in Label

[Philip Jackson]

On 03/04/2019 07:29, Michael H wrote:

:tm: is in the LibreOffice autocorrect database. colon-tm-colon (lower case
matters.) should produce a TM logo if you have autocorrect enabled.


In my LO Writer (6.0.7.3), the autocorrect option is (tm) using parentheses and 
not colons.

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