Re: [libreoffice-users][windows] Calc: Text numbers

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

[libreoffice-users] Question on Opening PDF files created by LibreOffice?

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 Science

[libreoffice-users] Is LibO_3.4.1_Win Out?

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

Re: [libreoffice-users] Re: xls file causing crash

+--+ Michael D. Setzer II - Computer Science Instructor Guam Community College Computer Center mailto:mi...@kuentos.guam.net mailto:msetze...@gmail.com http://www.guam.net/home/mikes Guam - Where America's Day Begins

Re: [libreoffice-users] Re: [Calc] Create and export chart

and cannot be deleted +--+ Michael D. Setzer II - Computer Science Instructor Guam Community College Computer Center mailto:mi...@kuentos.guam.net mailto:msetze...@gmail.com

Re: [libreoffice-users] Re: New User: Three Questions

+--+ Michael D. Setzer II - Computer Science Instructor Guam Community College Computer Center mailto:mi...@kuentos.guam.net mailto:msetze...@gmail.com http://www.guam.net/home/mikes Guam

Re: [libreoffice-users] Calc. Changing format of data types

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. +--+ Michael D. Setzer II - Computer Science

Re: [libreoffice-users] Calc Formula Help

+ 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. Setzer II - Computer

Re: [libreoffice-users] Calc

+--+ Michael D. Setzer II - Computer Science Instructor Guam Community College Computer Center mailto:mi...@kuentos.guam.net mailto:msetze...@gmail.com http://www.guam.net/home/mikes Guam - Where America's

[libreoffice-users] Export to html with links doesn't work

it in 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 Community

Re: [libreoffice-users] Export to html with links doesn't work

2011 at 9:25, Dennis E. Hamilton wrote: From: Dennis E. Hamilton dennis.hamil...@acm.org To: users@libreoffice.org Copies to: 'Michael D. Setzer II' mi...@kuentos.guam.net Subject:RE: [libreoffice-users] Export to html with links

Re: [libreoffice-users] Calculating the month number

=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

Re: [libreoffice-users] Calculating the month number

: On 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 CURRENT

Re: [libreoffice-users] Re: Calc: Has anyone tested the backward-compatibility of LibreOffice 3.4?

be deleted +--+ Michael D. Setzer II - Computer Science Instructor Guam Community College Computer Center mailto:mi...@kuentos.guam.net mailto:msetze...@gmail.com http://www.guam.net

Re: [libreoffice-users] Re: Multuple rules/conditions to range of cells

D. Setzer II - Computer Science Instructor Guam Community College Computer Center mailto:mi...@kuentos.guam.net mailto:msetze...@gmail.com http://www.guam.net/home/mikes Guam - Where America's Day Begins G4L

Re: [libreoffice-users] Re: Multuple rules/conditions to range of cells

+0200 Send reply to: 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 a formula? Difficult

Re: [libreoffice-users] Re: Calc: Has anyone tested the backward-compatibility of LibreOffice 3.4?

+--+ Michael D. Setzer II - Computer Science Instructor Guam Community College Computer Center mailto:mi...@kuentos.guam.net mailto:msetze...@gmail.com http://www.guam.net/home/mikes Guam - Where America's Day Begins

Re: [libreoffice-users] Re: Calc: Has anyone tested the backward-compatibility of LibreOffice 3.4?

://listarchives.libreoffice.org/www/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

Re: [libreoffice-users] Re: Calc: Has anyone tested the backward-compatibility of LibreOffice 3.4?

! 15 #VALUE! On 8 Jun 2011 at 20:19, Michael D. Setzer II wrote: From: Michael D. Setzer II mi...@kuentos.guam.net To: Stephan Zietsman szi...@gmail.com, users@libreoffice.org Date sent: Wed, 08 Jun 2011 20:19:23 +1000

[libreoffice-users] Export to Html Bug still in 3.4.1rc1

/\.\/#/\#/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. Setzer II - Computer

Re: [libreoffice-users] Export to Html Bug still in 3.4.1rc1

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:17 To: users@global.libreoffice.org Subject

Re: [libreoffice-users] Re: time and date difference

be deleted +--+ Michael D. Setzer II - Computer Science Instructor Guam Community College Computer Center mailto:mi...@kuentos.guam.net mailto:msetze...@gmail.com http://www.guam.net

Re: [libreoffice-users] time and date difference

+--+ Michael D. Setzer II - Computer Science Instructor Guam Community College Computer Center mailto:mi...@kuentos.guam.net mailto:msetze...@gmail.com http://www.guam.net/home/mikes Guam - Where America's Day Begins

Re: [libreoffice-users] Calc date formulae

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

Re: [libreoffice-users] Calc date formulae

+--+ Michael D. Setzer II - Computer Science Instructor Guam Community College Computer Center mailto:mi...@kuentos.guam.net mailto:msetze...@gmail.com http://www.guam.net/home/mikes Guam - Where America's Day Begins G4L

Re: [libreoffice-users] Calc date formulae

=On 12 Jun 2015 at 18:39, Gordon Burgess-Parker , users wrote: From:=Michael D. Setzer iimi...@kuentos.guam.net To:! -- 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:

Re: [libreoffice-users] LibreOffice does not start any more

+ 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. Setzer

Re: [libreoffice-users] How to return cell address/reference instead of function result with 2d operations?

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

Re: [libreoffice-users] How to return cell address/reference instead of function result with 2d operations?

ddress/reference instead of 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 wro

Re: [libreoffice-users] How to return cell address/reference instead of function result with 2d operations?

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

Re: [libreoffice-users] How to return cell address/reference instead of function result with 2d operations?

quot;) C7 - =IFNA(MATCH(MAX($A$1:$C$2),C1:C2,0),"") Row 8 creates Address A8 - =IF(A7<>"","A","")(B7<>"","B","")(C7<>"","C","")(A7:C7)

Re: [libreoffice-users] How to return cell address/reference instead of function result with 2d operations?

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

Re: [libreoffice-users] Calc HH:MM:SS to decimal

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:

Re: [libreoffice-users] COUNTIFS with cells of yyyy-mm-dd

I was able to get this to work as I understand it? 03/28/11 08/19/13 07/02/14

Re: [libreoffice-users] error installing LO 5.2.2

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

[libreoffice-users] Issue with recent request for Russian font?

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

Re: [libreoffice-users] Calculating MONTHNAME

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

[libreoffice-users] Conditional formatting and named ranges issues.

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...@kuentos.guam.net

[libreoffice-users] Marcos in Calc.. Am I doing something wrong??

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 College Computer Center

Re: [libreoffice-users] Re: Libreoffice 5.2 not starting

://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 be deleted > +--

Re: [libreoffice-users] sort order

-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 > > > -- > To unsubscribe e-mail t

Re: [libreoffice-users] vlookup case

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

Re: [libreoffice-users] convert csv to xlsx command line UTF8 coding problem

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

Re: [libreoffice-users] Re: convert csv to xlsx command line UTF8 coding problem

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:

Re: [libreoffice-users] COUNTIF / DAYS / ?

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

Re: [libreoffice-users] Re: Calculating the Nth weekday of a month.

", "=DATE(B1,B2,1)+B3-WEEKDAY(DATE(B1,B2,1))+(B3<WEEKDAY(DATE(B 1,B2,1)))*7+7*(B4-1) Row 8: Same as Row 7, but slight difference in formula. ,,"Sunday, January 1, 2017", "=DATE(B1,B2,1)+B3-WEEKDAY(DATE(B1,B2,1))+((B3<WEEKDAY(DATE( B1,B2,1)))+B4-1)*7 Note sure ho

Re: [libreoffice-users] Re: Calculating the Nth weekday of a month.

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:

Re: [libreoffice-users] Re: Calculating the Nth weekday of a month.

=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

Re: [libreoffice-users] Re: Calculating the Nth weekday of a month.

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

Re: [libreoffice-users] Calculating the Nth weekday of a month.

ssages sent to this list will be publicly archived and cannot be deleted +--------+ Michael D. Setzer II - Computer Science Instructor (Retired) mailto:mi...@guam.net mailto:msetze...@gmail.com http://www.guam.net/home/mikes Guam - Where America's Day Begins

Re: [libreoffice-users] Calculating the Nth weekday of a month.

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

Re: [libreoffice-users] Calculating the Nth weekday of a month.

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

Re: [libreoffice-users] Calculating the Nth weekday of a month.

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

Re: [libreoffice-users] Re: Calculating the Nth weekday of a month.

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.

Re: [libreoffice-users] Re: Calculating the Nth weekday of a month.

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

Re: [libreoffice-users] Calc: Autofilter sorting fails to expand selection when a column has empty cells at the bottom

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

Re: [libreoffice-users] difference in hours between two times

ot;")" 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 <bjloc...@lockie.ca> To: "Michael D. Setzer II" <msetze...@gmail.com> Date sent:

Re: [libreoffice-users] difference in hours between two times

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

Re: [libreoffice-users] Calc - Rate Function similar to Excel

=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

Re: [libreoffice-users] Two formulas in one cell?

=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

Re: [libreoffice-users] Two formulas in one cell?

)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 sent:

Re: [libreoffice-users] Calculate difference between two dates time)

> 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/Netiquette > List archive: h

Re: [libreoffice-users] Calculate difference between two dates time)

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

[libreoffice-users] Issues with macro recorder??

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

Re: [libreoffice-users] Writer: Sorting in a Table

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

Re: [libreoffice-users] Calculate difference between two dates (with time)

cr...@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://w

Re: [libreoffice-users] Calculate difference between two dates (with time)

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] date, day number, week number in one cell

=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

Re: [libreoffice-users] date, day number, week number in one cell

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 they don't

Re: [libreoffice-users] date, day number, week number in one cell

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

Re: [libreoffice-users] Calculate difference between two dates time)

=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

Re: [libreoffice-users] can't prevent Calc from modifying the number I type into a column

/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy ++ Michael D. Setzer I

Re: [libreoffice-users] can't prevent Calc from modifying the number I type into a column

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

Re: [libreoffice-users] LO calc, how to copy partial sheet onto a new sheet

ibe/ > 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] Issues with macro recorder??

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

Re: [libreoffice-users] Calc week number problem

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

Re: [libreoffice-users] Calc error?

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

Re: [libreoffice-users] Calc error?

=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

Re: [libreoffice-users] can't prevent Calc from modifying the number I type into a column

bscribe 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/ &g

Re: [libreoffice-users] LO 6.4.6.2 CALC : Appropriate formula?

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

Re: [libreoffice-users] LO 6.4.6.2 CALC : Appropriate formula?

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

Re: [libreoffice-users] Static vs. dynamic time

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

[libreoffice-users] Strange question on Macro??

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

[libreoffice-users] The macro to do date difference in years months days.

ot;m""),12),IF(MOD(DATEDIF(" & sText & ",""m""),12)=1,""1 Month "",MOD(DATEDIF(" & sText & ",""m""),12)&"" Months ""),"""")(DATEDIF(" & sText &

[libreoffice-users] Macro to do days hours minutes

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

[libreoffice-users] Testing email options to see if goes thru unmodified...

pertyValue args1(0).Name = "StringName" args1(0).Value = "=DATEDIF(" & sText & ",""d"")"&"&"" days ""(("& mText &")-INT("& mText &"),"" H "

[libreoffice-users] Third try - List keeps modifying the message that corrupts the macro.

!~),~~_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

[libreoffice-users] Macro version for the time

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

[libreoffice-users] Confused with Macro results??

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

Re: [libreoffice-users] Confused with Macro results??

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

Re: [libreoffice-users] Confused with Macro results??

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

Re: [libreoffice-users] Confused with Macro results??

t;" Months ""),"""")(DATEDIF(" & sText & ",""md""),IF(DATEDIF(" & sText & ",""md"")=1,""1 Day "",DATEDIF(" & sText & " ,""md"")&

Re: [libreoffice-users] Strange question on Macro?? (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 that would do almost

Re: [libreoffice-users] Strange question on Macro?? (in Spreadsheet)

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

Re: [libreoffice-users] Date number has 5 digits

> 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

[libreoffice-users] Question on getting a list of all the macro commands

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

Re: [libreoffice-users] [Calc] Convert GPS coords from DMS to decimals?

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

[libreoffice-users] OT: GPS Problem Solutions with Original format to Digital:

=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

Re: [libreoffice-users] bug in LARGE function?

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

[libreoffice-users] Away around problem. Don't do it with libreoffice??

=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

  1   2   >