Re: [libreoffice-users] Adding a / (forward slash)
At 20:24 03/04/2020 -0400, Peter Dutton wrote:
Here's a formula I'm using
=DATEDIF($Begin_Here.$E$76,R4,"d")
The above formula returns the day number of the year where
$Begin_Here.$E$76 [...] the date of 12/31/19
Cell R4 has the date 10 (which is Monday, February 10, 2020)
"10" is not a date - unless you mean the date that is internally
stored as the number 10, which would be 9 January 1900! And that
would be an error for the function, since the end date needs to be
later than the start date.
"d" is the interval
Well, it's the unit in which you want the returned interval specified.
Wouldn't it be easier to use
=DAYS("2020-02-10";$Begin_Here.$E$76)
or just
="2020-02-10"-$Begin_Here.$E$76
?
Even more easily, abandon your "Begin_Here" value and try (with your
10 February 2020 date in R4)
=R4-DATE(YEAR(R4)-1;12;31)
This will produce the number 41 - providing the result cell is
appropriately formatted.
It would be nice to have a / (forward slash) after the day number of
the year which is returned by the above formula. How can this be done?
You can concatenate strings using the "&" operator, so just put &"/"
after any of these formulae, such as
=R4-DATE(YEAR(R4)-1;12;31)&"/"
The numerical value 41 is implicitly converted to a string and
concatenated with the slash to create the *string* 41/ .
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/
Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Adding a / (forward slash)
Here's a formula I'm using =DATEDIF($Begin_Here.$E$76,R4,"d") The above formulareturns the day number of the year where; $Begin_Here.$E$76 $Begin_Here is a sheet and $E$76 is a cell (on that sheet) with the date of 12/31/19 Cell R4 has the date 10 (which is Monday, February 10, 2020) "d" is the interval It would be nice to have a/(forward slash) after the day number of the year which is returned by the above formula. How can this be done? Thank you, Peter -- 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
Fw: [libreoffice-users] Re: Unable to subscribe to users@global.libreoffice.org
Sorry, there's been some correspondence offlist. Mea culpa; I didn't check the reply-to address. Begin forwarded message: From: Dave Howorth On Fri, 3 Apr 2020 15:47:16 -0400 Robert Steinmetz wrote: > I have and they aren't there. But you obviously got my mail, so you are getting some at least? (and of course, that was offlist, so do you see this?) > On 4/3/20 3:31 PM, Dave Howorth wrote: > > On Fri, 3 Apr 2020 12:35:05 -0400 > > Robert Steinmetz wrote: > > > >> I am apparently subscribed but have not been receiving > >> messages. > > Have you checked your spam directory/mechanisms? > > > >> On 4/3/20 12:27 PM, users+h...@global.libreoffice.org wrote: > >>> Hi, this is the Mlmmj program managing the > >>> mailing list. > >>> > >>> You were unable to be subscribed to the list because you are > >>> already subscribed. > > -- 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] Re: Unable to subscribe to users@global.libreoffice.org
On Fri, 3 Apr 2020 12:35:05 -0400 Robert Steinmetz wrote: > I am apparently subscribed but have not been receiving messages. Have you checked your spam directory/mechanisms? > On 4/3/20 12:27 PM, users+h...@global.libreoffice.org wrote: > > Hi, this is the Mlmmj program managing the > > mailing list. > > > > You were unable to be subscribed to the list because you are already > > subscribed. -- 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] Setting up Custom Outline Format
On 2020-04-03 13:24, Robert Steinmetz wrote:
I have been attempting to set up a custom outline format and have searched the
Internet for an answer but many of the answer refer to older versions of LO and
I really am having trouble understanding how to do it.
So which version are you using?
I need Something like this:
Section - 1
1.1
A.
1)
a)
1.2
Section - 2
2.1
A.
2.2
A.
What I can't figure out is how to get the sub paragraph automatic pick up the
section number.
Not sure what you are asking, so let's begin with definition of your levels:
Level 1: Numeric {1..}, "" token after
Level 2: Numeric {1..}, level 1 prepended, "." separator, "" token
after
Level 3: Alpha UC {A..}, "." token after
Level 4: Numeric {1..}, ")" token after
Level 5: Alpha LC {a..}, ")" token after
Are you saying you cannot get Level 2 ({L1}.{L2}) to display properly?
--
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] Setting up Custom Outline Format
I have been attempting to set up a custom outline format and have searched the Internet for an answer but many of the answer refer to older versions of LO and I really am having trouble understanding how to do it. I need Something like this: Section - 1 1.1 A. 1) a) 1.2 Section - 2 2.1 A. 2.2 A. What I can't figure out is how to get the sub paragraph automatic pick up the section number. -- 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] Re: Unable to subscribe to users@global.libreoffice.org
I am apparently subscribed but have not been receiving messages. On 4/3/20 12:27 PM, users+h...@global.libreoffice.org wrote: Hi, this is the Mlmmj program managing the mailing list. You were unable to be subscribed to the list because you are already subscribed. -- 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] Error invoking Help in Linux
El jue, 02-04-2020 a las 21:54 +0200, Valter Mura escribió: > Hi All > > I get an error when invoking the help through the Help menu or F1, in > Linux. > > This is the error: > "Object not accessible. > The object cannot be accessed > due to insufficient user rights." > > The program is installed correctly, and also the help package(s). > > Another user told me that when he installed the "snap" package, the > issue > disappeared. > > Has anyone else experimented the same problem in a Linux environment? > > LibreOffice details: > Version: 6.4.2.2 > Build ID: 1:6.4.2-0ubuntu0.18.04.3 > CPU threads: 8; OS: Linux 5.3; UI render: default; VCL: kf5; > Locale: it-IT (it_IT.UTF-8); UI-Language: en-US > Calc: threaded > -- > My system: > Operating System: KDE neon Testing Edition > KDE Plasma Version: 5.18.4 > KDE Frameworks Version: 5.69.0 > Qt Version: 5.14.1 > Kernel Version: 5.3.0-46-generic > OS Type: 64-bit > -- > > > TIA > Regards, > -- > Valter > Hi Valter, Mageia Cauldron working fine with 6.4.3.1 Gtk and did not note a problem before these updates. Have you reported this to Neon? This sounds like a packaging or possible Plasma problem (having seen that Plasma just issued a minor update). These files should be "owned" by root, so there should be no problem. You can check ownership in the terminal with: ls -lart /usr/lib64/libreoffice/help/ (The files are located there on my 64-bit system. Double check the location on yours.) Best, Roy -- Roy W. Reese, DipTransIoLET Traductor español-inglés Tlf.: (34) 626 526 623 www.babelmania.com Traductores y editores Producido y enviado usando Linux y programas libres -- 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
