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

[Remy Gauthier]

Greetings,
You can also create a custom number format to place text around the
value if you only want to show a single value. For example, you can
assign this number format to a cell:
"Jane bought "0" apples."
If you then set the value of the cell to 2, the cell will display:
Jane bought 2 apples.
And then even if the cell shows a text string, it remains a number that
can be used as reference in another formula. Brian's suggestion (that I
must confess use quite often) will "convert" the value to text and
cannot be used for calculations but can handle an unlimited number of
different values to be displayed in the same cell, like in his example.
I hope this helps.
Rémy Gauthier.
Le mardi 21 novembre 2017 à 05:47 +, Brian Barker a écrit :
> 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 "&SQRT(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] Importing a csv (tab delimited) to existing non-empty sheet (overwrite)

[Johnny Rosenberg]

2017-11-21 1:06 GMT+01:00 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...
>

Ok, I'll have a look, thank you for replying!
And thanks to everyone else who also replied, here or to me in private
(probably intended for the list).

I also remembered that I think I've done this before a couple of years ago
(I wonder how I found out how to do it back then…), so I'll also have a
look at old code. I usually never delete anything, so I should find it if
it exists…


Kind regards

Johnny Rosenberg


> Sent from BlueMail 
> On Nov 20, 2017, 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

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

[Tom Davies]

Hi :)
Brilliant!  Thanks for letting us know.

Congrats on fixing it :))
Regards from
a Tom :)



On 21 Nov 2017 07:11, "Joe Conner"  wrote:

> 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-un
> subscribe/
> 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

apt vs apt-get. Re: [libreoffice-users] ttf-mscorefonts-installer

[Tom Davies]

Hi :)
Try just "apt" instead of "apt-get" sometime.  It's new, I think.  It uses
apt-get but adds some functionality and I think it can be set to be more
colourful too.

Apt-Get Upgrade often leaves about 4 packages (perhaps the
linux-headers?).  These can be installed seperately by apt-get now but I
used to have to use Synaptic's upgrade button.

Apt Upgrade does it all and after the download/get part it gives a
progress-bar to show how far it's got through the (unpack/unzip/uncompress
+ install + setting-up/configuring) processes.  The progress-bar doesn't
claim to show time & an eta but instead just shows work-done and work
remaining.

I think "apt" uses apt-get to do most of the work but then just adds some
extra bits, or makes them easier to remember or something.

So apt is more like the default package manager in Arch now - but easier to
remember and use.

Regards from
a Tom :)




On 16 Nov 2017 19:54, "Tim-L"  wrote:

>
> Yes, I have to add "Synaptic" every time I do a clean install of Ubuntu.
>
> I also go to "Ubuntu Software Center" to see what might be a good package
> to install.
>
> I also like "sudo apt-get update" and "upgrade"
>
> On 11/15/2017 09:38 PM, Tom Davies wrote:
>
>> Hi :)
>> Yeh, each different package manager offers it's own advantages.  Synaptic
>> is no longer the default one but I usually install it because it can
>> handle
>> individual packages and it's about as powerful as using the command-line
>> package managers such as apt and apt-get.
>> Regards from
>> a Tom :)
>>
>> On 15 Nov 2017 01:00, "Tim-L"  wrote:
>>
>> I go to the Synaptic Package Manager and check the package for removal,
>>> not complete removal.  That ends the system trying to install the package
>>> after the first "fail to install".
>>>
>>> I learned this the hard way months ago with a different set of packages I
>>> wanted to try that kept giving me errors installing or will not open up
>>> without errors.
>>>
>>>
>>>
>>> On 11/14/2017 11:28 AM, Tom Davies wrote:
>>>
>>> Hi :)
 Thanks :)

 The line under the "apt remove" which was just the package name repeated
 was a typo that i'd meant to delete.  Typing that line in prolly
 wouldn't
 do anything at all, or it might sort the problem out by accident.

 The main idea was to just remove the package and remove any lingering
 bits
 jic.
 Regards from
 a Tom :)

 On 13 Nov 2017 22:50, "Joe Conner"  wrote:

 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
>
>
> --
>>> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>>> Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-un
>>> subscribe/
>>> Posting guidelines + more: https://wiki.documentfoundatio
>>> n.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-un
> subscribe/
> 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