n the windows version, since I don't have windows
on home machines. Looked for a place to report this as a bug, but
the list is the best I was able to find.
Thanks.
+--+
Michael D. Setzer II - Computer Science Instructor
Guam
manifest.xml
+--+
Michael D. Setzer II - Computer Science Instructor
Guam Community College Computer Center
mailto:mi...@kuentos.guam.net
mailto:msetze...@gmail.com
http
rom: "Dennis E. Hamilton"
To:
Copies to: "'Michael D. Setzer II'"
Subject:RE: [libreoffice-users] Export to html with links
doesn't work
Date sent: Tue, 24 May 2011 09:25:14 -0700
Organiza
Just as a note. I was using export to xhtml option.
On 24 May 2011 at 9:25, Dennis E. Hamilton wrote:
Send reply to:
From: "Dennis E. Hamilton"
To:
Copies to: "'Michael D. Setzer II'"
Subject:
=IF(NOW()=DATE(2011,5,1),100,0)
If the comparison is with the May 2011, instead of just being later
than May.
Since it is now past May 1, 2011, the same could be done in
reference to a cell with a date value. So, instead of now(), it could
be a reference to a cell with a date in it, or u
eater than. If comparing to a cell with a date value, it might have
the zero time value, so definitately the >= should be used.
>
> Regards from
> Tom :)
>
>
>
>
>
>
> From: Michael D. Setzer II
> To: users@libreoffice.o
gt;>
> >> Which obviously doesn't work...
> >>
> >> Is there an easy way to do this?
> >>
> >
>
>
> --
> Unsubscribe instructions: E-mail to users+h...@libreoffice.org
> Posting guidelines + more: http://wiki.documentfoundation.
2011-05-25 11:37 AM, Michael D. Setzer II wrote:
Note that if you use the month( ) then it would be any date in
which the month is5, so 6/1 thru 12/31 of any year.
Are the cells refereced entered as dates (numeric) or as strings?
There are no cells being referenced, I'm simply evaluating the CU
ms unsubscribing, write to postmas...@documentfoundation.org
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/www/users/
> All messages sent to this list will be publicly archived and cannot be deleted
>
+--
All messages sent to this list will be publicly archived and cannot be deleted
>
+------+
Michael D. Setzer II - Computer Science Instructor
Guam Community College Computer Center
mailto:mi...@kuentos
)
>
> Greetings,
> Andreas
>
>
> --
> Unsubscribe instructions: E-mail to users+h...@libreoffice.org
> In case of problems unsubscribing, write to
postmas...@documentfoundation.org
> Posting guidelines + more:
http://wiki.documentfoundation.org/Netiquette
>
: users@libreoffice.org
> Am 06.06.2011 15:12, Michael D. Setzer II wrote:
> >
> > I've tried another method that seems to give the results.
> > Unfortunately, it appears the current() doesn't give the results of
> > what is before the style when used in
rs/
> All messages sent to this list will be publicly archived and cannot be deleted
>
+--+
Michael D. Setzer II - Computer Science Instructor
Guam Community College Computer Center
mailto:mi...@kuentos.guam.net
equal to $AG$1.
>
> Regards
> Stephan
>
> --
> Unsubscribe instructions: E-mail to users+h...@libreoffice.org
> In case of problems unsubscribing, write to postmas...@documentfoundation.org
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http
14 #VALUE!
15 #VALUE!
On 8 Jun 2011 at 20:19, Michael D. Setzer II wrote:
From: "Michael D. Setzer II"
To: Stephan Zietsman ,
users@libreoffice.org
Date sent: Wed, 08 Jun 2011 20:19:23 +100
x27;s/\".\/#/\"#/g' >g4l0.37-
documentation2.html
mv g4l0.37-documentation2.html g4l0.37-documentation.html
Had to look for ./# in the document, since there where some ./ that
were correct in other locations.
+--------------+
Michael D
if it was already
there, but did want to note that I didn't see anything about it in the
release notes, and testing showed it was still there.
> - Dennis
>
> -Original Message-
> From: Michael D. Setzer II [mailto:mi...@kuentos.guam.net]
> Sent: Friday, June 17, 2011 16
fice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be deleted
>
+------+
Michael D. Setzer II - Computer Science Instructor
Guam Community College Computer Center
mailto:m
t;
> >>
> >
> >
> >
> >
> > No virus found in this incoming message.
> > Checked by AVG - www.avg.com
> > Version: 9.0.901 / Virus Database: 271.1.1/3732 - Release Date: 06/28/11
> > 19:34:00
> >
> >
>
>
> -
splay just fine.
Both files open fine on machines using mozilla on Windows and
Linux, but not on Mac?
So, this might be a MAC/Safari issue, but if it could be fixed that
would be best.
Thanks.
+--+
Michael D. Setzer II - Computer Sc
before it is on the main site? Am just
downloading it on a windows machine now, since I don't have
windows at home to check that it is 3.4.1 and not a renamed rc?
+----------+
Michael D. Setzer II - Computer Science Instructor
subscribing, write to postmas...@documentfoundation.org
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be deleted
>
+
; Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
> In case of problems unsubscribing, write to postmas...@documentfoundation.org
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users
hives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be deleted
>
+--+
Michael D. Setzer II - Computer Science Instructor
Guam Community College Computer Center
etiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be deleted
>
+--+
Michael D. Setzer II - Computer Science Instructor
Guam Community Colleg
ula =DATEVALUE(A2)
perhaps DATEVALUE would work with the DD/MM/ format if
that is the default for your setting?
Get the formula in another column, and then do a copy special to
copy the value back to the original column.
+--------------+
gt; Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived an
e/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be deleted
>
+--+
Michael D.
tp://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be deleted
>
+--+
Michael D. Setzer II - Computer Science Instructor
Guam Community College Computer Center
mailto:mi...@kuentos.guam.net
en int used.
On 24 Apr 2015 at 3:49, sserra wrote:
Date sent: Fri, 24 Apr 2015 03:49:06 -0700 (MST)
From: sserra
To: users@global.libreoffice.org
Subject:[libreoffice-users] Re: time and date difference
> hello,
> wonder
On 12 Jun 2015 at 8:49, Gordon Burgess-Parker wrote:
Date sent:Fri, 12 Jun 2015 08:49:35 +0100
From:Gordon burgess-parkergordo...@mail.com
To:users@global.libreoffice.org
Subject:Re: [libreoffice-users] Calc date formulae
On 12/06/15 08:44, Dries Feys wrote:
If the date to check is in B3, try t
=On 12 Jun 2015 at 18:39, Gordon Burgess-Parker , users wrote:
From:=Michael D. Setzer iimi...@kuentos.guam.net
To:http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libre
rg/global/users/
> All messages sent to this list will be publicly archived and cannot be deleted
+--+
Michael D. Setzer II - Computer Science Instructor
Guam Community College Computer Center
mailto:mi...@kuentos.guam.net
t; http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot b
=1
2
3
4
5
6
6
#N/A
#N/A
2
0
0
2
C2
2
C2
Probable a better way to do it, but this seems to work, could probable get it
into a single cell, but would be a long formula. Using the Row 7 and 8
method seems fine to figure which column, and then the row.
Numbers in A1C2;
A3 - =MAX(A1:C2);
A4 - =MA
$2),B1:B2,0),"")
C7 - =IFNA(MATCH(MAX($A$1:$C$2),C1:C2,0),"")
Row 8 creates Address
A8 - =IF(A7<>"","A","")&IF(B7<>"","B","")&IF(C7<>"
=ADDRESS(MAX((A1:C2=MAX(A1:C2))*ROW(A1:C2)),MAX((A1:C2 =
> > MAX(A1:C2))*COLUMN(A1:C2)),4)
> >
> > This is an array function and you need to use Ctrl-Shift-Enter instead
> > of Enter.
> >
> > Hope this works for you,
> >
> > TomW
> >
On 27 Nov 2015 at 11:11, Brian Barker wrote:
Date sent:Fri, 27 Nov 2015 11:11:17 +
To:users@global.libreoffice.org
From:Brian barkerb.m.bar...@btinternet.com
Subject:Re: [libreoffice-users] How to return cell address/reference
instead of function result with 2d operations?
At 03:56 27/11/20
function result with 2d operations?
> At 22:07 27/11/2015 +1000, Michael D. Setzer II wrote:
> >On 27 Nov 2015 at 11:11, Brian Barker wrote:
> >>At 03:56 27/11/2015 -0500, Edwar Cifuentes wrote:
> >>>On 11/26/2015 09:26 AM, Tom Webb wrote:
> >>>&
cumentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be deleted
+--+
Michael D. Setzer
Think this is what you want.
=ROUND(A1/TIME(1,0,0)*4,0)/4
On 5 May 2016 at 12:44, Russell wrote:
To: users@global.libreoffice.org
From: Russell
Subject:[libreoffice-users] Calc HH:MM:SS to decimal
Date sent: Thu, 5 May 2016 12:4
I was able to get this to work as I understand it?
03/28/11
08/19/13
07/02/14
more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be deleted
+--+
Michael D.
I've been working with some data recently, and have run across a long delay
with no response, and then a message pops up that LibreOffice wants to
install a Russian font. I can then close, and it continues fine. If I tell it
to go
ahead, I eventually get a message that it can not find the font
ses the asking to install
russian font, and the second is when I select close. It I let it search, it
come
back with it finds no font?
Thanks.
+--------------+
Michael D. Setzer II - Computer Science Instructor
Guam Community
d it still seemed to use the
old one.
Is there a step I am missing.
Thanks.
+--+
Michael D. Setzer II - Computer Science Instructor
Guam Community College Computer Center
mailto:mi...@kuento
Think the issue is that with "MMM", it treats the number as a date value
instead of as being a month, so that 1 would result in December, and 2-12
result in January.
So, the text option with month() doesn't seem to work at all, since the values
don't match. Here is using choose to get what I th
ing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be deleted
>
+---
I was doing some testing with single characters, but then saw it was three
characters. Originally, just used the code of the character, changed code to
ascii, but with 3 multiple each value to get a number that matched.
In both put the row number in next column.
Put the match field in C15 both t
t; To
> unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice
ww.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be deleted
+---
org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be deleted
+--+
Michael D. Setzer II - Computer Science Instructor
Guam Community College Computer Center
mailto:mi...@guam
The help shows no --utf-8 option, it is a filter not an option?
I think this is what it would look like? Not sure of the LF,,, part of it?
/usr/bin/soffice --headless --infilter=Text (encoded):UTF8,LF,,,--convert-to
xlsx test.csv
On 22 Jun 2017 at 7:30, Uwe Brauer wrote:
To:users@global.
The following section of this message contains a file attachment
prepared for transmission using the Internet MIME message format.
If you are using Pegasus Mail, or any other MIME-compliant system,
you should be able to save it or view it from within your mailer.
If you cannot, please ask your syst
Attempt with attachment didn't seem to go thru, so sending just the message
with this one.
See if this is what you are looking for.
=$C2+E$1-WEEKDAY($C2)+(E$1WEEKDAY($C2))*7+7*($B$1-1)
Is the formula I put in E2, and copied from E2 to K13
B1 contains the number of the occurance.
A2-A13 has
The following section of this message contains a file attachment
prepared for transmission using the Internet MIME message format.
If you are using Pegasus Mail, or any other MIME-compliant system,
you should be able to save it or view it from within your mailer.
If you cannot, please ask your syst
tiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be deleted
+--------+
Michael D. Setzer II - Computer Science Instructor (Retired)
mail
I think you have WC and WD reversed in your formula, but copied the formula
that I
had in my spreadsheet, and converted it to a single formula instead of the
multiple
cell one. Put this in I7 and then copied it to I8-I18, and it does get the
results you
expect.
=DATE($B$1,$A7,1)+$B$2-WEEKDA
=Seems to be a lot of work with all the sheets.
Year
2017
Month
1
January
=CHOOSE(B2,January,February,=March,April,May,June,;July,August,September,October,"November,December)
Day
1
Sunday
=CHOOSE(B3,Sunday,Monday,ot;Tuesday,Wednesday,Thursday,Fridayuot;,Saturday)
Week
1
First
=CHOOSE(B4,First,Secon
Not sure what messed up the contents, but what I got had a number changes
from the original message?? So, trying again, with just straight text.
In rows 2-4, added a simple choose option to show the text version of the
Monday, Day, and Week selected.
Four input cells in B1-B4, provide data for s
New to dropbox, so hopefully, the links below will work.
nthweekday.odson Dropbox.
https://www.dropbox.com/l/scl/AACOvRvGCKENXdOpjwXoA40M4DZwc1YhAew
simplenth.odson Dropbox.
https://www.dropbox.com/l/scl/AADOenugbyhmi8kSNxM2l_sT5kuBFhpWNxI
--
To unsubscribe e-mail to: users+unsubscr...@g
Dropbox didn't seem to work. Put the files there, but then sent a link to my
other email account, and it worked for that, but seems to be specific to users.
Looked, and it says the just changed the public folders, and they are no
longer available?? Also, looked at google drive, and it seems to b
=Not clear on formula.It seems to be more complex then mine, but does also
work a little differently. Yours does seem to give the 4th week instead of the
5th week, if it falls in the next month.
=IF(MONTH(DATE(Input.$A$2,1,1)-7+(Input.$C$2*7)-(WEEKDAY(DATE(Input.$A$2,1,1)))+Input.$B$2)1,DATE(In
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/
> 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
++
Mich
lobal.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.document
ot;&TEXT(MOD(((A5+B5)-(A2+B2))/TIME(1,0,0)/24,1),""HH:MM"")"
Last formula only needs the one cell, but if it is just to display, looks nice.
On 25 May 2018 at 1:21, James wrote:
From: James
To: "Michael D. Setzer II"
Date sent:
=3DTEXT(A3+3, D, )60;TEXT(A4,#)
A3 was1/15/18 in my case and A4 was 27 result in cell is:
Thursday, January 18, 201827
Would be nice if you could put actually wanting with examples.
You can get the formating you need using the text command, and you can
see the diffiernt f
D, )60;TEXT(A4,#)
So copied it to a text editor, and then pasted it.
On 3 Jun 2018 at 11:44, Michael D. Setzer II wrote:
From: "Michael D. Setzer II"
To: Brian Barker ,
users@global.libreoffice.org,
Carl Winerich
Date se
=Here is what I did.
11886.87
48
291.09;
13972.32=A3*48
$291.09=-PMT(8.16%/12,A2,A1)
;
0.68%=RATE(A2,-A3,A1,0)
8.16%=A7*12
Three values in A1 to A3
Calculated total in A4
Used PMT function, and manually figured the interest rate by trying values till
correct value gotten.
In A6 used the rate
istarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>
+----------------+
Michael D. Setzer II - Computer Science Instructor (Retired)
mailto:mi...@guam.net
mail
> 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/
=Not fully clear on what you want, but this is what I did in a little test.
Did this withmono font, but list might change things so they don't line up,
but sould be easy to figure out.
DateMonthDay60;WeekdayJulianweek of year01/01/1811=Monday1;1
01/02/1812=Tuesday20;101/03/1813=Wednesday360;1
s, so changed them to blanks.
Some other stuff got thrown in there that didn't exist in the text??
On 13 Jul 2018 at 1:20, Michael D. Setzer II wrote:
=Not fully clear on what you want, but this is what I did in a little test.
Did this with mono font, but list might change things so
3...1
On 13 Jul 2018 at 1:37, Michael D. Setzer II wrote:
From:Michael D. Setzer iimsetze...@gmail.com
To:Carl winerichl...@ipadring.net,
users@global.libreoffice.org
Date sent:Fri, 13 Jul 2018 01:37:48 +1000
Subject:Re: [libreoffice-users] date, day number, week
number in one cell
subscr...@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
=On 13 Jul 2018 at 15:11, Krunose wrote:
Subject:;Re: [libreoffice-users] Calculate difference
between two dates time)
To:;users@global.libreoffice.org
From:60;krunosekruno...@gmx.com
Date sent:60;Fri, 13 Jul 2018 15:11:58 +0200
12.07.2018 u 22:52, libreoffice-ml.mbou...@spamgourmet.com je nap
ction like that...
>
> Thanks,
>
> Kruno
>
>
> --
> 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/Netiqu
<0,D26+12,D26)-(E26<0);"=IF(E26<0,DA
Y($B$2),E26)-(F26<0);"=IF(F26<0,F26+24,F26)-(G26<0);"=IF(H22<0,G26-1,
G26);"=IF(H26<0,H26+60,H26)
;;"=IF(D27<0,C27-1,C27);"=IF(D27<0,D27+12,D27)-(E27<0);"=IF(E27<0,DA
Y($B$2),E27)-(F27<
quot;", 0, Array())
dim args17(0) as new com.sun.star.beans.PropertyValue
args17(0).Name = "ToPoint"
args17(0).Value = "$L$1"
dispatcher.executeDispatch(document, ".uno:GoToCell", "", 0, args17())
rem -----------
s/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
++
Calc from
modifying the number
I type into a column
To: "Michael D. Setzer II" ,
users@global.libreoffice.org
From: Art
Date sent: Wed, 12 Sep 2018 02:44:26 -0400
> On 09/12/2018 01:09 AM, Michael D. Setzer II wrote:
> >
Art
>
>
>
>
> --
> 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: htt
> Hello Michael,
>
> Le 04/09/2018 à 14:08, Michael D. Setzer II a écrit :
> >
> > Second issue was it deleted two different columns. When recording clicked
> > on the column with mouse, and deleted each column. Record didn't record
> > anything of clicki
font-size: 10pt; }
> --
> 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://lis
Your numbers don't seem to match up on a bigger scale.
Unfortunately, ths list reformats text, so headings will not directly match
with
the columns.
Using the values in message gave in message the result is 299.04888 as
shown, and the 3 digit of 8 causes it to round the 4 up to a 5, which is
=With the updated first number I get the 295.54 as it should be.
Third position is a 4, it doesn't change the 2nd position.
Num 1
Num 2
Num 1 * Num 2
Rounded
2024.28
0.146
295.54488
295.54
Are the values you show for the Num 1 and Num 2 entered link that or are
that what is displayed on screen.
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 th
.Value = false
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
2 then F9 then
Enter 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:/
st 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 r
p;"" Months ""),"""")&IF(DATEDIF(" & sText &
",""md""),IF(DATEDIF(" & sText & ",""md"")=1,""1 Day "",DATEDIF(" & sText
& " ,""md&q
(in Spreadsheet)
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
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
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 -
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 elim
Text_!~),~~_H_Hours__M_Minutes_~~)_~
dispatcher.executeDispatch(document, ~.uno:EnterString~, ~~, 0, args1())
end sub
+----+
Michael D. Setzer II - Computer Science Instructor (Retired)
mailto:mi...@gua
pertyValue
args1(0).Name = "StringName"
args1(0).Value = "=DATEDIF(" & sText & ",""d"")"&"&"" days ""&TEXT(("&
mText &")-INT("& mText &"),""
uot;m""),12),IF(MOD(DATEDIF(" &
sText & ",""m""),12)=1,""1 Month "",MOD(DATEDIF(" & sText &
",""m""),12)&"" Months ""),"""")&IF(DATEDIF
=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: =IF(AND(A1D1,A1G1)
1 - 100 of 188 matches
Mail list logo