on.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
++
Michael D. Setzer II - Computer Science Instructor
(Retired)
mailto:mi...@guam.net
mailto:msetze...@gmail
hive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
++
Michael D. Setzer II - Computer Science Instructor
(Retired)
mailto:mi...@guam.net
mail
e: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
+----------------+
Michael D. Setzer II - Computer Science Instructor (Retired)
mailto:mi...@guam.net
mailto:msetze...@gmail.com
Guam - Where A
uno:Copy", "", 0, Array())
rem --
dim args82(0) as new com.sun.star.beans.PropertyValue
args82(0).Name = "Nr"
args82(0).Value = 1
dispatcher.executeDispatch(document, ".uno:JumpToTable
reoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
++
Michael D. Setzer II - Computer Science Instructor
(Retired)
mailto:mi...@guam.net
mailto:msetze...@gmai
: Permission denied
File doesn't exist in ~/.cache directory?
File in /root is an empty file?
++
Michael D. Setzer II - Computer Science Instructor (Retired)
mailto:mi...@guam.net
mailto:msetze
"A"())-INDIRECT("A"()-1),0)
+----------------+
Michael D. Setzer II - Computer Science Instructor (Retired)
mailto:mi...@guam.net
mailto:msetze...@gmail.com
Guam - Where America's Day Begins
G4L Disk Imagi
>> 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/
with an external link??
Copies to: "Michael D. Setzer II"
> At 00:45 19/05/2023 +1000, Michael D. Setzer II wrote:
> >Have a spreadsheet that has internal link that is updated on
> >loading. 6 of the columns have numbers with either 1 or 2 decimal
> >places
.
++
Michael D. Setzer II - Computer Science Instructor
(Retired)
mailto:mi...@guam.net
mailto:msetze...@gmail.com
Guam - Where America's Day Begins
G4L Disk Imaging Project maintainer
http://sourceforge.net
ael,
>
> Michael D. Setzer II schrieb am 16.03.2023 um 22:45:
> > On 16 Mar 2023 at 18:22, ady wrote:
> >
> >
> > From:ady
> > Date sent:Thu, 16 Mar 2023 18:22:56 -0300
> > Subject:Re: [libreoffice-users] Function acting on
> > range
> > To:Users
>
eoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
++
Michael D. Setzer II - Computer Science Instructor (Retired)
mailto:mi...@guam.net
mailto:msetze...@gmail.com
Guam - Where Ame
te
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
+--------+
Michael D. Setzer II - Computer Science Instructor (Retired)
mailto:mi...@guam.net
7.3.2 say would be seen as an upgrade.
>
> This means it is easy to swap back from say 7.4 to 7.3 if you strike a
> bug that is a show stopper for you while you wait for the bug
> resolution, as I have had on a few occasions.
> Steve
>
> On 04/02/2023 01:28, Michael D. Setzer II w
gt; ---
> Lee
>
> On Fri, Feb 3, 2023 at 3:53 PM Michael D. Setzer II
> wrote:
>
> > On 3 Feb 2023 at 12:20, Lee Thomas Stephen wrote:
> >
> > From: Lee Thomas Stephen
> >
> > Date sent: Fri, 3 Feb
//listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
++
Michael D. Setzer II - Computer Science Instructor
(Retired)
mailto:mi...@guam.net
mai
s + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>
++
Michael D. Setzer II - Computer Science Instructor
(Retir
delines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
++
Michael D. Setzer II - Computer Science In
ibreOffice Användare
> Den mån 15 aug. 2022 kl 13:38 skrev Michael D. Setzer II <
> msetze...@gmail.com>:
>
> > In Linux that are a number of option using standard
> > commands.
> >
>
> I think he said he's on Windows, actually.
>
Yes, but mentioned that
s+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: http
ffice.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] multiplying time
To: 0;msetze...@gmail.com
> On 8/8/2022 10:46 AM, Michael D. Setzer II wrote:> > If I understand
> what you are looking at.> > With A1 having 8:45
> > B1 having A1/time(1,0,0)
> > B1 would have decimal equivalent of time in hours
>
eoffice.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.
ation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
+----------------+
Michael D. Setzer II - Computer Science Instructor (Retired)
mailto:mi...@
;=SENDING%20"&
mid(Path$,8,100)
shell(cmd$)
Else
Print "The document has not yet been stored"
End If
End Sub
++
Michael D. Setzer II - Computer Science Instructor (Retired)
mailto:mi...@guam.net
org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
+----+
Michael D. Setzer II - Computer Science Instructor
(Retired)
mailto:mi...@guam.net
mailto:msetze...@gmail.com
Guam - Where America's Day Begins
Bergmann
> On 7/19/22 00:07, Michael D. Setzer II wrote:
> > Found some code at end of strace
> >
> > (soffice:166273): GLib-GObject-WARNING **: 07:19:47.960: invalid cast from
> > 'GtkBox' to 'GtkMenuShell'
> >
> > (soffice:166273): GLib-GObject-WARN
My macro seems to work, and perhaps someone has detailed
option of the WSENDTO beyond just sending filename.
Sometime things showed up in To: or Subject: lines, so must be something.
+--------+
Michael D. Setzer II - Computer Science Inst
is calling xdg-email or why the xdg-email
doesn't link the filename passed without the --attach or if there is suppose to
be
an xdg-email-hook.sh somewhere? dnf failed to find anything that includes it?
++
Michael D. Setzer II - Computer
:35, Michael D. Setzer II wrote:
> > Thanks for the reply. I have LibreOffice 7.2.7.2 version as
> > loaded by default for my Fedora 35 and also have
> > LibreOffice 7.3.4.2 downloaded from libreoffice.
> >
> > With both I have tried a simple saved file with the word
&g
. The macro
calls same program and takes the passed parameter, and
does trim the FILE:// off the parameter.
> Philip
>
> On 18/07/2022 12:14, Michael D. Setzer II wrote:
> > Was trying to get the option to work, but after setting the
> > program for Internet email n
the mapi client that
works in windows and works from firefox. Surprized that
nothing shows with libreoffice.
Thanks.
+----------------+
Michael D. Setzer II - Computer Science Instructor
(Retired)
mailto:mi...@guam.net
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:
p/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
+---
cy
To: 0;LibreOffice Användare
> Den sön 5 juni 2022 kl 11:55 skrev Michael D. Setzer II <;msetze...@gmail.com
> >:
>
> > One windows excell page mentions that it uses the
> > banking rounding method, which I believe is the round to
> > nearest even. So, using
ation.org/privacy
> >
>
> --
> 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:
requires manually
FORMAT/CONDITIONAL/MANAGE/EDIT/CELL RANGE
to change it.
So 4 clicks change range and two OK clicks. Not a big deal, but
wondering why range changes, or why absolute or range name is
not an option??
> Hope this helps.
>
>
> On 5/3/22 04:33, Michael D. Setzer II wrote:
?
++
Michael D. Setzer II - Computer Science Instructor
(Retired)
mailto:mi...@guam.net ;
mailto:msetze...@gmail.com
Guam - Where America's Day Begins
G4L Disk Imaging Project maintainer
http://sourceforge.net/projects/g4l
but LO inserts the ' so it
> becomes '123.00 and changes the cell format to number but forcing the
> contents to remain as text.
>
> From this point my question arose as to how to remove the ' so the
> contents of the cell became a number, and which Brian solved for me.
>
>
it shows that value as a text
field and is left justified..
On 6 Apr 2022 at 10:58, Michael D. Setzer II wrote:
From: "Michael D. Setzer II"
To: Steve Edmonds
,
users@global.libreoffice.org
Date sent: Wed, 06 A
archives.libreoffice.org/global/users/> Privacy
> Policy: https://www.documentfoundation.org/privacy
+--------+
Michael D. Setzer II - Computer Science Instructor
(Retired)
mailto:mi...@guam.net ;
mailto:msetze...@gm
wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
++
Michael D. Setzer II - Computer Science Instructor
(Retired)
mailto:m
g/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
+--------+
Michael D. Setzer II - Computer Science Instructor
(Retired)
mailto:mi...@guam.ne
On 16 Mar 2022 at 21:04, Ian Graham wrote:
Date sent:60;Wed, 16 Mar 2022 21:04:28 +
From: Ian Graham
Subject: ;[libreoffice-users] orientating a
right-angled triangle.
To: 0;users@global.libreoffice.org
> I feel as if I must be being incredibly stupid, but I'm trying to draw a
>
regular expression term immediately
preceding it that can be present for a match to occur.
(The maximum number of occurrences is limited only by
the size of the document). For example, "tre{2,}"
matches "tree", "treee", and "tre".
So, [:space:]{1,}$ matches one
emove 1
space at end of line {1,}$ or [:space:]{1,}$ will
remove all spaces 1 to whatever.
>
>
> --
> 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.o
dation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
+----+
Michael D. Setzer II - Computer Science Instructor
(Retired)
mai
date and time to date and
time values.
On 13 Mar 2022 at 11:03, Michael H wrote:
From: Michael H
Date sent: Sun, 13 Mar 2022 11:03:32 -0500
Subject:Re: [libreoffice-users] Spreadsheet question
To: "Rogier F. van Vlissingen"
Copies to: "Micha
3 Mar 2022 at 9:30, Rogier F. van Vlissingen wrote:
From: "Rogier F. van Vlissingen"
Date sent:60;Sun, 13 Mar 2022 09:30:49 -0400
Subject: ;Re: [libreoffice-users] Spreadsheet
question
To: 0;"Michael D. Setzer II"
Copies to:60;users@global.libreoffice.org
> Funny com
The spreadsheet I sent gave columns A thru AB, but some
may not have separated exactly correct. Not knowing
exactly what changes would be needed.
Started by inserting a row at top.
To convert date to an actual date field. In ad1 put B.
In ad2 put this formula to make a date.
> >>
> >> in column 2 and drag right for ten columns and down.
> >>
> >> David Lynch
> >>
> >>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-li
On 7 Feb 2022 at 21:24, Andrew Pitonyak wrote:
From: "Andrew Pitonyak"
Date sent: Mon, 07 Feb 2022 21:24:32 -0500
Copies to: "Dave Barton" ,
users@global.libreoffice.org
To: "Michael D. Setzer II"
ste Faure wrote:
> > Hi,
> >
> > Le 03/02/2022 à 10:56, Michael D. Setzer II a écrit :
> >> Yesterday, Downloaded and installed and it reports a
> >> crash, but just gives option to submit it, but no details.
> >> Come up in safe mode, but opening ca
ines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
++
Mi
Copies to: mi...@guam.net
Organization: The Document Foundation
> Hi,
>
> Le 03/02/2022 à 10:56, Michael D. Setzer II a écrit :
> > Yesterday, Downloaded and installed and it reports a
> > crash, but just gives option to submit it, but no details.
>
Have some raw data I get that has mostly numeric data.
The minor issue I have is that some fields in these
numeric columns have a - (dash) rather than a 0 or other
number. After importing data into LibreOffice Calc these
cells are left aligned text fields, where numeric fileds are
right
Reply without the other stuff since this is somewhat long.
Wanted to try to create a macrothat would do everthing
with just the original data in columns A-D.
With old Quattro pro would have been amuch simpiler
process.. Would be nice if we could upload sheets.
Well, just wanted to see if I
=The subtotal seems to cause issues, so another option.
Again in Column E:
E1: Date Only
E2:Ex: =int(a2) copy down
F2 - Formula $5 needs to be changed to last row
=IF(E2E3,SUMIFS($C$2:$C$5,$E$2:$E$5,=uot;INT($A$2:$A$5)),)
Copy down Column F
G2 - Same as F
=IF(E2E3,E2,)
Copy down Column G
Data is
idelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
++
Michael D. Setzer II - Computer Science Instructor
(R
=TIME(INT(A1/100),MOD(A1,100),0)
On 11 Jun 2021 at 19:00, Dutton wrote:
To:users@global.libreoffice.org
From:duttonl...@ipadring.net
Subject:[libreoffice-users] LoCalc- convert a 4
digit number to time
Date sent:Fri, 11 Jun 2021 19:00:39 -0400
Here's what I'd like to
do;
In cell A1
; Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
++
M
; Privacy Policy: https://www.documentfoundation.org/privacy
+----------------+
Michael D. Setzer II - Computer Science Instructor
(Retired)
mailto:mi...@guam.net
mailto:msetze...@gmail.com
Guam - Where America's Day Begins
G4L Disk Imag
nother
reason?? Would just be one key off.
>
>
> --
> 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.docu
elp/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
+-----------------
I've done things with Calc, and it has options to set how
the importing of csv files goes..
Was chatting with a person that was trying to convert odt
to pdf files via command line. That was actually simple.
libreoffice --headless --convert-to pdf filename.odt
Issue was that it uses the
3000
> >> 4 40 10
> >> 5 50 0
> >> 6 60 0
> >>
> >> Is there a MINBUTGREATERTHANZERO function?
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-li
> 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
ce.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
++
Michael D. Setzer II - Computer Science Instructor (Retired)
mailto:mi...@guam.net
mailto:msetze...@gmail.com
Guam - Where America's Day Begins
nd just reversed the process
of pasting the lines into the window, and they seem to transfer just fine.
I also like keeping multiple copies, so I can compare them to see how
I've made changes over time. Sometimes make a mistake, and having a
back to be able to restore all or whatever macros.
Just use the
> 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
the default from PNG to JPG. For this
chart the JPG seems to be much sharper than the same exported to PNG.
Thanks. Have a Great Day, and be safe.
++
Michael D. Setzer II - Computer Science Instructor (Retired)
mailto:mi
t; > Privacy Policy: https://www.documentfoundation.org/privacy
>
>
> --
> Informatique
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting g
Does a file with them exist in full or part.
Was recently looking thru menus and found something interesting that I
had not noticed before.
Data / Calculate / Formula to Value
I did a test, and it did what I wanted, so recorded the macro.
Strangely, the command to do the Formula to Value was
Does a file with them exist in full or part.
Was recently looking thru menus and found something interesting that I
had not noticed before.
Data / Calculate / Formula to Value
I did a test, and it did what I wanted, so recorded the macro.
Strangely, the command to do the Formula to Value was
..@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: http
=The solution to modify the data to time format with special edit option
was really nice, but not sure how much work would be required to
modify it. Tried to do it directly in other ways, but couldn't do it, and
from feedback it seems it is no longer possible since libreoffice doesn't
support
=Wanted to see if it could be done outside libreoffice calc, since it doesn't
want to work.
Since I don't have the original user info, I created a file with 1000
randomly created data elements.
Created a bash script using sed to do the same processing.
Shell script gps3.sh
sed -e
=On 24 Nov 2020 at 13:05, Brian Barker wrote:
Date sent:60;Tue, 24 Nov 2020 13:05:46 +
To:;=users@global.libreoffice.org
From:60;Brian Barker;b.m.bar...@btinternet.com
Subject:;Re: [libreoffice-users] Question on value command
and Err:502
At 14:48 24/11/2020 +1000, Michael D. Setzer II
ert a text
string to a value? Is there another command, or am I doing something
wrong?
Contents of a simple spreadsheet
2 "=value(1+1)
Err:502 "=VALUE("1+1")
"1+1TRUE=ISTEXT(A3)
Err:502 "=value(a3)
+------------
L("CONTENTS",A59)
Err:502"=VALUE(A61)
03+15/60+090/3600copy VALUE OF A61
Err:502"=VALUE(A63)
3.275"=VALUE(3+15/60+90/3600)
Err:502"=VALUE("3+15/60+90/3600")
++
Michael D. Setzer II - Computer Scienc
=Wanted to see if could make a time formula that worked without have to reenter
the data in
column a to a time format. Uses regex to convert to time format. First set uses
original
combined value. Second set uses values split in B and C to make D and E simpler.
Just interesting. Know I
. For instance, in
> >>> A3, type (for a result with 8 decimals):
> >>> =ROUND(A1*24;8) & ", " & ROUND(B1*24;8)
> >>>
> >> =ROUND(B1*24;8) & ", " & ROUND(A1*24;8)
> >>
> >>> or, if you want to use the values in A2 and B2:
starchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
++
Michael D. Setzer II - Computer Science Instructor (Retired)
mailto:mi...@guam.net
mailto:msetze...@gmail.com
Guam - Where America's Day B
=On 18 Nov 2020 at 19:23, Remy Gauthier wrote:
Subject:;Re: [libreoffice-users] Easily format cells to bold and a
certain
ion.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
++
Michael D. Setzer II - Computer Science Instructor (Retired)
mailto:mi...@guam.net
e
> > List archive: https://listarchives.libreoffice.org/global/users/
> > Privacy Policy: https://www.documentfoundation.org/privacy
> >
> >
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreo
ww.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
+---
=If I understand your issue?? Don't know if this will come thru OK.
Put these vaues in row 1 and formula in A2 and B2.
Change Date to my format. Changed values in D1,A1, and G1, and got
the matching date when it was larger.
25
07/01/20
60
05/09/20
30
07/26/20
60
05/09/20
A2:
ot;m""),12),IF(MOD(DATEDIF(" &
sText & ",""m""),12)=1,""1 Month "",MOD(DATEDIF(" & sText &
",""m""),12)&"" Months ""),"""")(DATEDIF(" & sText &
pertyValue
args1(0).Name = "StringName"
args1(0).Value = "=DATEDIF(" & sText & ",""d"")"&"&"" days ""(("&
mText &")-INT("& mText &"),"" H "
!~),~~_H_Hours__M_Minutes_~~)_~
dispatcher.executeDispatch(document, ~.uno:EnterString~, ~~, 0, args1())
end sub
++
Michael D. Setzer II - Computer Science Instructor (Retired)
mailto:mi...@guam.net
List is screwing with the messages by removing quotes and some places
spaces?? Send myself a copy of message and it is unmodified? So, assume
is some filter system that is brain dead??
Did a replace of all quotes in macro to ~.
Hopefully, that will go thru, and the other spaces will not be
Worked on creating a macro, and had to change it to two inputs.
Tried to do the single input, but ran into issues splitting it to change order
and convert , to -?? So simple solution to input each separate.
Hopefully, the email will have the's correctly..
sub ZT
rem
with spaces replaced with _
=DATEDIF($A$1,A2,~d~)~_days_~TEXT((A2-$A$1)-INT(A2-$A$1),~_H_~~hours~~_M_~~minutes_~~__~)
On 8 Jul 2020 at 3:12, Michael D. Setzer II wrote:
From:Michael D. Setzer iimsetze...@gmail.com
To:Michael tiernanmichael.tier...@gmail.com,
users@global.libreoffice.org
Date
)
To:users@global.libreoffice.org
Date sent:Tue, 7 Jul 2020 08:34:38 -0400
On 7/2/20 2:06 PM, Michael D. Setzer II wrote:
I've been trying to take a formula that calculates the difference between to
dates into years/months/days.
I'll ask if anyone has a macro or formulae that would do almost
t;" Months ""),"""")(DATEDIF(" & sText &
",""md""),IF(DATEDIF(" & sText & ",""md"")=1,""1 Day "",DATEDIF(" & sText
& " ,""md"")&
is hard to understand. Please write, what you want to achieve
with your macro.
Kind regards
Regina
Michael D. Setzer II schrieb am 05-Jul-20 um 00:30:
Been doing a lot of googling, but finding lots of stuff, but nothing that works?
Have done a lot of versions and this is the latest one.
The record
then
Enter)
end sub
++
Michael D. Setzer II - Computer Science Instructor (Retired)
mailto:mi...@guam.net
mailto:msetze...@gmail.com
Guam - Where America's Day Begins
G4L Disk Imaging Project maintainer
http://sourceforge.net/projects
e
args2(5).Name = "MoveMode"
args2(5).Value = 4
dispatcher.executeDispatch(document, ".uno:InsertContents", "", 0, args2())
msgbox ("To complete process,"+chr$(13)+" Formula Press F2 then Space
then Enter" + chr$(13)+"For Text Result Press F2 then F9 th
I've been trying to take a formula that calculates the difference between to
dates into years/months/days.The original formula works fine.
Wanted to make a macro or function that would make modifications to
formula to new date cells. Didn't get anything to work with functions, but
have gone
1 - 100 of 179 matches
Mail list logo