Fwd: Re: [libreoffice-users] ttf-mscorefonts-installer

[Joe Conner]

That seems to have fixed the problem. I have not gotten the pop-up since 
removing the installer.


Thanks very much!

Blessings, Joe



 Forwarded Message 
Subject:Re: [libreoffice-users] ttf-mscorefonts-installer
Date:   Mon, 13 Nov 2017 14:47:35 -0800
From:   Joe Conner 
To: users@global.libreoffice.org



Thanks Tom, I will implement your suggestion. I have been getting the
pop up two to three times a day. If I don't get it again for awhile I
will post that info too.

Blessings, Joe Conner


On 11/12/2017 04:41 PM, Tom Davies wrote:

sudo apt remove ttf-mscorefonts-installer
ttf-mscorefonts-installer


--

A smile - is a sign of joy.
A hug - is a sign of love.
A laugh - is a sign of happiness.
And a friend like me??
...that's just a sign of good taste!!

Blessings, Joe Conner
Joshua 24:15 "...as for me and my house, we will serve the LORD."


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

Re: [libreoffice-users] Formula and text in same cell?

[Joe Conner]

Would insert -> comment be of help?


On 11/20/2017 09:47 PM, Brian Barker wrote:

At 20:04 20/11/2017 -0500, Dotty Carl wrote:

In a cell, let's say A1, ...


I don't see that matters ...

... there's a formula such as =DayNum(Z1, Z3). I'd like to also put 
text in the same cell.


So what do you want to have displayed in that cell? Any formula 
defines what is displayed. What would be the function of the 
additional text?



How can this be done?


If you need a function reference, as here, but want the displayed 
result to contain additional material, you need to include that 
material inside the formula containing the function. You can 
concatenate text with a function result using the CONCATENATE() 
function, or more simply using the "&" operator. Any non-text value, 
such as a number, is implicitly converted to text to enable this. For 
example,

=SQRT(3+1)
displays
2
whereas
="The square root of 3+1 is "(3+1)&"."
displays
The square root of 3+1 is 2.

I trust this helps.

Brian Barker




--

A smile - is a sign of joy.
A hug - is a sign of love.
A laugh - is a sign of happiness.
And a friend like me??
...that's just a sign of good taste!!

Blessings, Joe Conner
Joshua 24:15 "...as for me and my house, we will serve the LORD."


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

Re: [libreoffice-users] Formula and text in same cell?

[Brian Barker]

At 20:04 20/11/2017 -0500, Dotty Carl wrote:

In a cell, let's say A1, ...


I don't see that matters ...

... there's a formula such as =DayNum(Z1, Z3). I'd like to also put 
text in the same cell.


So what do you want to have displayed in that cell? Any formula 
defines what is displayed. What would be the function of the additional text?



How can this be done?


If you need a function reference, as here, but want the displayed 
result to contain additional material, you need to include that 
material inside the formula containing the function. You can 
concatenate text with a function result using the CONCATENATE() 
function, or more simply using the "&" operator. Any non-text value, 
such as a number, is implicitly converted to text to enable this. For example,

=SQRT(3+1)
displays
2
whereas
="The square root of 3+1 is "(3+1)&"."
displays
The square root of 3+1 is 2.

I trust this helps.

Brian Barker


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

Re: [libreoffice-users] Create scan button?

[James Knott]

No, the info in the link from Regina did the trick.


On 11/20/2017 08:20 PM, Howard Barr wrote:
> Hi James,
>
> Other than what's been discussed on this list so far was there
> anything else you did to get it to work?
>
> On 21 Nov 2017 01:06, "James Knott"  > wrote:
>
> After a few attemps, I finally got it to work right, with the icon
> showing with view set to automatic.
>
> tnx jk
>
>
> On 11/19/2017 09:22 PM, James Knott wrote:
> > That works, sort of.  I have to leave the size at small to see the
> > icon.  If I leave it at large or automatic, as originally set, I
> don't
> > see it.  I'll have to try a different size icon, to see if that
> helps.
> > However, it did say 16x16 was the best size.
> >
> > tnx jk
> >
> >
> > On 11/19/2017 07:10 PM, Regina Henschel wrote:
> >> Hi,
> >>
> >> adding icons it a little bit tricky. Please try my answer in
> >>
> 
> https://ask.libreoffice.org/en/question/130416/toolbar-icon-does-not-change-when-replaced/
> 
> 
> >>
> >>
> >> Kind regards
> >> Regina
> >>
> >> James Knott schrieb am 19.11.2017 um 20:38:
> >>> On 11/19/2017 02:14 PM, Robert Großkopf wrote:
> > Curious thing.  I found a scanner icon and it shows up in the
> > customize
> >> panel, on the request item, but not on the tool bar.
> >>
>  Could be you have to change it in the toolbar, too. I have
> only tested
>  this with a macro I added to a toolbar - so the command
> couldn't be
>  found anywhere else.
> >>> I tried that.  When I look at "Visible buttons", the icon is
> shown,
> >>> along with the word Request, but still not on the tool bar.
> >>>
> >>>
> >>
> >
>
>
> --
> 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
>


-- 
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] Formula and text in same cell?

[.]

Hello all,In a cell,let's say A1, there's a formula such as =DayNum(Z1,
Z3).  I'd like to also put text in the same cell. How can this be 
done?Thanks,Carl
-- 
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

Re: [libreoffice-users] Importing a csv (tab delimited) to existing non-empty sheet (overwrite)

[Andrew Pitonyak]

http://www.pitonyak.org/database/

Look at my random DB ramblings

I don't remember if I have better coverage they're pretty in my primary macro 
book

http://www.pitonyak.org/oo.php

But I do explain them, but I cannot check the documents from my phone...

⁣Sent from BlueMail ​

On Nov 20, 2017, 4:47 PM, at 4:47 PM, Johnny Rosenberg  
wrote:
>Hi!
>
>I have some problems to find information about this. All I found after
>hours of searching are few examples that probably work in some
>situations
>but certainly not what I'm looking for,
>
>The problem is that those examples contains a lot of anonymous numbers
>and
>stuff but no explanation what so ever what those numbers mean or where
>I
>can find the details.
>
>Here's the closest thing I came up with so far:
>Sub Main
>Dim HOME As String
>Dim DirName As String
>Dim FileName As String
>Dim Args(1) As new com.sun.star.beans.PropertyValue
>
>HOME="/home/"
>DirName = HOME & "/Some/Path/"
>FileName = ConvertToURL(DirName & "/MyFile.csv")
>' Get the latest results.
>Shell(HOME & "/bin/ScriptThatCreatesMyFile.sh", True)
>Args(0).Name = "FilterName"
>Args(0).Value = "Text - txt - csv (StarCalc)"
>Args(1).Name = "FilterOptions"
>Args(1).Value = "44,34,76,1,,0,False,True,True,False"
>StarDesktop.loadComponentFromURL(FileName, "_default", 2, Args())
>End Sub
>
>Questions:
>Exactly what does ”44,34,76,1,,0,False,True,True,False” mean? Where can
>I
>find information about this? What is True? What is False? Why is
>something
>missing between two commas? Many questions come to my mind…
>
>Problems at the moment:
>
>1. The code above seems to treat my file as comma separated. I need TAB
>   only as separator.
>   2. The CSV file is imported to a new window. I want it to overwrite
>existing (old and outdated) information in columns A:D (without messing
>   with my conditional and unconditional formatting) on Sheet 0.
>
>After som further experimenting I seem to have solved problem 1. It
>seems
>lik means Chr(44), which is a comma, and Chr(34) os a double quote. The
>following line gave me separate columns for every TAB:
>Args(1).Value = "9,,76,1,,0,False,True,True,False"
>But what does the rest mean? Chr(76)="L", which seems weird, so I guess
>the
>”76” means something else.
>
>I wonder why this kind of information is so hard to find. For easy
>stuff,
>when no manual is needed, you can find tons of information, but when
>things
>are a bit more cryptic, when a manual is really, really needed, you can
>search for hours and find nothing, as it seems. Maybe I'm wrong, I
>actually
>hope I am, even if I would look stupid… :P
>
>
>
>Kind regards
>
>Johnny Rosenberg
>
>--
>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

-- 
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] Importing a csv (tab delimited) to existing non-empty sheet (overwrite)

[Johnny Rosenberg]

Hi!

I have some problems to find information about this. All I found after
hours of searching are few examples that probably work in some situations
but certainly not what I'm looking for,

The problem is that those examples contains a lot of anonymous numbers and
stuff but no explanation what so ever what those numbers mean or where I
can find the details.

Here's the closest thing I came up with so far:
Sub Main
Dim HOME As String
Dim DirName As String
Dim FileName As String
Dim Args(1) As new com.sun.star.beans.PropertyValue

HOME="/home/"
DirName = HOME & "/Some/Path/"
FileName = ConvertToURL(DirName & "/MyFile.csv")
' Get the latest results.
Shell(HOME & "/bin/ScriptThatCreatesMyFile.sh", True)
Args(0).Name = "FilterName"
Args(0).Value = "Text - txt - csv (StarCalc)"
Args(1).Name = "FilterOptions"
Args(1).Value = "44,34,76,1,,0,False,True,True,False"
StarDesktop.loadComponentFromURL(FileName, "_default", 2, Args())
End Sub

Questions:
Exactly what does ”44,34,76,1,,0,False,True,True,False” mean? Where can I
find information about this? What is True? What is False? Why is something
missing between two commas? Many questions come to my mind…

Problems at the moment:

   1. The code above seems to treat my file as comma separated. I need TAB
   only as separator.
   2. The CSV file is imported to a new window. I want it to overwrite
   existing (old and outdated) information in columns A:D (without messing
   with my conditional and unconditional formatting) on Sheet 0.

After som further experimenting I seem to have solved problem 1. It seems
lik means Chr(44), which is a comma, and Chr(34) os a double quote. The
following line gave me separate columns for every TAB:
Args(1).Value = "9,,76,1,,0,False,True,True,False"
But what does the rest mean? Chr(76)="L", which seems weird, so I guess the
”76” means something else.

I wonder why this kind of information is so hard to find. For easy stuff,
when no manual is needed, you can find tons of information, but when things
are a bit more cryptic, when a manual is really, really needed, you can
search for hours and find nothing, as it seems. Maybe I'm wrong, I actually
hope I am, even if I would look stupid… :P



Kind regards

Johnny Rosenberg

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

Re: [libreoffice-users] Create scan button?

[James Knott]

After a few attemps, I finally got it to work right, with the icon
showing with view set to automatic.

tnx jk


On 11/19/2017 09:22 PM, James Knott wrote:
> That works, sort of.  I have to leave the size at small to see the
> icon.  If I leave it at large or automatic, as originally set, I don't
> see it.  I'll have to try a different size icon, to see if that helps. 
> However, it did say 16x16 was the best size.
>
> tnx jk
>
>
> On 11/19/2017 07:10 PM, Regina Henschel wrote:
>> Hi,
>>
>> adding icons it a little bit tricky. Please try my answer in
>> https://ask.libreoffice.org/en/question/130416/toolbar-icon-does-not-change-when-replaced/
>>
>>
>> Kind regards
>> Regina
>>
>> James Knott schrieb am 19.11.2017 um 20:38:
>>> On 11/19/2017 02:14 PM, Robert Großkopf wrote:
> Curious thing.  I found a scanner icon and it shows up in the
> customize
>> panel, on the request item, but not on the tool bar.
>>
 Could be you have to change it in the toolbar, too. I have only tested
 this with a macro I added to a toolbar - so the command couldn't be
 found anywhere else.
>>> I tried that.  When I look at "Visible buttons", the icon is shown,
>>> along with the word Request, but still not on the tool bar.
>>>
>>>
>>
>


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

Re: Fwd: [libreoffice-users] Macro Dim Dialog and Control

[Johnny Rosenberg]

2017-11-20 0:40 GMT+01:00 Andrew Pitonyak :

> Sorry, using my phone for this... And off the top of my head...
>
> Each object usually supports multiple interfaces...
>
> In basic, the actual type does not matter.
>
> Names starting with an x refer to an interface.
>
> I need to look it up, but I think that the preference was a variant rather
> than object, but...
>
> It may no longer matter
>
> The developer who told me this could not remember why it when it mattered
>
> And
>
> I only had a problem because of it once, and that was years ago.
>
> Other languages, like Java, it matters. I'd we had a smarter IDE it might
> be useful to declare the actual type.
>
>
According to the little information I found, types like Variant and Object
are considered slow. Probably fast enough for most situations, but fast is
never a bad thing, is it?
Also, I'm trying out the other new "experimental" features as well, such
as… whatever that's called in English… code expansion? Text expansion? That
is, when I type I get suggestions. This only work with the new extended
data types.

I work with VBA in Excel at work (that's what they have so that's what I
must use), and I kind of miss that feature. In LibreOffice, it means that I
don't have to use xray as much as otherwise. Another minor thing I miss
from Excel VBA, is that I can see the value of a variable by just hovering
the mouse pointer over it. Excel has a lot of nasty bugs though, I don't
miss them… :P Not said that LibreOffice Calc is bugfree in any way, there
are some, there too.

Anyway, at the moment I'm only experimenting with it, just for fun, but it
would be nice to see some documentation of all this. If examples are
included – even better.


Kind regards

Johnny Rosenberg



>
> Sent from BlueMail 
> On Nov 19, 2017, at 5:31 PM, Johnny Rosenberg 
> wrote:
>>
>> Oops, sorry. I did it again, I accidentally replied privately rather than
>> to the list. I'm sorry for that, Robert.
>>
>> -- Forwarded message --
>> From: Johnny Rosenberg 
>> Date: 2017-11-19 23:19 GMT+01:00
>> Subject: Re: [libreoffice-users] Macro Dim Dialog and Control
>> To: Robert Großkopf 
>>
>>
>> 2017-11-19 20:00 GMT+01:00 Robert Großkopf :
>>
>>  Hi Jonny,
>>>

  This works, but what about oDlg and oCtl? Are there special data types

>>>  for
>>>
  them too? The documentation I've found so far doesn't give any hints at
  all. I tried this:
  Dim Dlg As com.sun.star.awt.XDialog ' No error here,
  ' but next line throws an error:
  oDlg = CreateUnoDialog(DialogLibraries.Standard.MyDialogue)
  ' Error: No access to object.
  'Invalid usage of the object.
  ' Well, something like that, it's actually in Swedish.

>>>
>>>  What is the name of the dialog? Is ist called "MyDialogue"?.
>>>
>>
>>
>> No, I actually faked it for this mailing list. The real name is in Swedish,
>> so I figured it would be easier for you guys if I picked an English name
>> instead, just for this example. But the name isn't the problem anyway. My
>> question is if there is an ”extended data type” for dialogs and controls,
>> just like there is for sheets (com.sun.star.sheet.XSpreadsheet) and cells (
>> com.sun.star.table.XCell). I searched for and while and thought that
>> com.sun.star.awt.XDialog could be it for dialogs, but as I said, I got that
>> error message. When I used Object, like you do below, everything worked for
>> me too, but my question wasn't about getting it working, it was if there is
>> such a data type. I'm not doing anything particular, I'm just trying to
>> learn this new stuff about those ”new data types”, that I enable by
>> selecting Tools → Options… → LibreOffice → Advanced → Activate experimental
>> features, then restart LibreOffice, then Tools → Options… → LibreOffice →
>> Basic IDE options → ☒ Use extended data types (give or take some words or
>> phrases, since this is a translation from Swedish).
>>
>> When trying to get information I found this page:
>> https://help.libreoffice.org/Common/Basic_IDE_Options#Use_extended_types
>>
>> However, they only provided two examples of those new data types (the two I
>> mention above), and there's no link or anything that points to the rest of
>> them, so it's pretty useless, unfortunately.
>>
>>
>>  It should
>>>  appear at the left (catalog of objects - don't konwo if this is the
>>>  right name ..) and at the bottom (like the standard "Module1")
>>>
>>>  Declare the dialog first, out of a sub:
>>>  DIM oDialog0 AS OBJECT
>>>
>>>  Start the dialog:
>>>
>>>  SUB Dialog0Start
>>>  DialogLibraries.LoadLibrary("Standard")
>>>  oDialog0 = createUnoDialog(DialogLibraries.Standard.Dialog0)
>>>  oDialog0.Execute()
>>>  END SUB
>>>
>>>  Name of the dialog is "Dialog0"
>>>
>>>  End the dialog:
>>>
>>>  SUB Dialog0Ende
>>>