[libreoffice-users] Issue install on a a Dell

[Wade Smart]

My friends computer is a Dell GX280 with 3gb ram.
Her hd became corrupted (had XP on it) and with
a new hd installed we install Windows 7 Home.

Trying to install LibraOffice, Im having this problem.
It says its installing - it skips to installed. No icons.
No program files were created.

When I run the install program again it shows either
repair or remove - so it things its installed.

Avast is the virus program installed and other than
firefox, nothing else has been installed on the
system.

Wade
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

-- 
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.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] SumIF / SumProduct question

[Wade Smart]

I have a spread sheet I use to manage a soccer league.

This shows me of the registered players who is on Dk Blue team.
=SUMPRODUCT($AU$2:$AU$131=Dk Blue, $O$2:$O$131=x)

This shows me the team strength based on assigned values of the players.
=SUMPRODUCT($AU$2:$AU$131=Dk Blue, $AW$2:$AW$131)

I would like to do something like this (this will not work):
=SUMIF($O$2:$O$131=x,$AU$2:$AU$131=Dk Blue, $AW$2:$AW$131)

If 02-0131 is the Spring registration column. If there is a x there
then I know
they are playing for the year. I would like to say, If they are registered for
spring then add up the points in AW2-131 if they are on TeamName.

Any ideas appreciated.

Wade
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

-- 
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.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] SumIF / SumProduct question

[Wade Smart]

Gives a Err:508.
I dont think it can be text that its comparing.
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005


On Tue, Jul 29, 2014 at 4:42 PM, Paul paulste...@afrihost.co.za wrote:
 Just an off-the-top-of-my-head stab at it, but can't you do something
 like:

 =SUMIF(($O$2:$O$131=x AND $AU$2:$AU$131=Dk Blue), $AW$2:$AW$131)

 ?

 Paul



 On Tue, 29 Jul 2014 16:34:00 -0500
 Wade Smart wadesm...@gmail.com wrote:

 I have a spread sheet I use to manage a soccer league.

 This shows me of the registered players who is on Dk Blue team.
 =SUMPRODUCT($AU$2:$AU$131=Dk Blue, $O$2:$O$131=x)

 This shows me the team strength based on assigned values of the
 players. =SUMPRODUCT($AU$2:$AU$131=Dk Blue, $AW$2:$AW$131)

 I would like to do something like this (this will not work):
 =SUMIF($O$2:$O$131=x,$AU$2:$AU$131=Dk Blue, $AW$2:$AW$131)

 If 02-0131 is the Spring registration column. If there is a x there
 then I know
 they are playing for the year. I would like to say, If they are
 registered for spring then add up the points in AW2-131 if they are
 on TeamName.

 Any ideas appreciated.

 Wade
 --
 Registered Linux User: #480675
 Registered Linux Machine: #408606
 Linux since June 2005



 --
 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.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? 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 be deleted

Re: [libreoffice-users] SumIF / SumProduct question

[Wade Smart]

I guess I should have just tried this:
=SUMPRODUCT($O$2:$O$131=x,$AU$2:$AU$131=Dk Blue, $AX$2:$AX$131)
I thought I had and it did not work but, it does.

:D Thanks
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005


On Tue, Jul 29, 2014 at 5:16 PM, Paul paulste...@afrihost.co.za wrote:
 Yeah, you're right, forgot how SUMIF works for a moment...

 It's easy with an intermediate column, but one-shot...

 In fact, I'm not sure that it isn't *supposed* to be done with
 intermediate columns. At least, the only way I can see that it could be
 done without them would be either some sort of temporary column, or by
 defining the return value of a range, neither of which are really the
 purpose of spreadsheets, as I see it.

 Maybe Brian has some smart ideas.

 Paul



 On Tue, 29 Jul 2014 16:50:58 -0500
 Wade Smart wadesm...@gmail.com wrote:

 Gives a Err:508.
 I dont think it can be text that its comparing.
 --
 Registered Linux User: #480675
 Registered Linux Machine: #408606
 Linux since June 2005


 On Tue, Jul 29, 2014 at 4:42 PM, Paul paulste...@afrihost.co.za
 wrote:
  Just an off-the-top-of-my-head stab at it, but can't you do
  something like:
 
  =SUMIF(($O$2:$O$131=x AND $AU$2:$AU$131=Dk Blue), $AW$2:$AW$131)
 
  ?
 
  Paul
 
 
 
  On Tue, 29 Jul 2014 16:34:00 -0500
  Wade Smart wadesm...@gmail.com wrote:
 
  I have a spread sheet I use to manage a soccer league.
 
  This shows me of the registered players who is on Dk Blue team.
  =SUMPRODUCT($AU$2:$AU$131=Dk Blue, $O$2:$O$131=x)
 
  This shows me the team strength based on assigned values of the
  players. =SUMPRODUCT($AU$2:$AU$131=Dk Blue, $AW$2:$AW$131)
 
  I would like to do something like this (this will not work):
  =SUMIF($O$2:$O$131=x,$AU$2:$AU$131=Dk Blue, $AW$2:$AW$131)
 
  If 02-0131 is the Spring registration column. If there is a x
  there then I know
  they are playing for the year. I would like to say, If they are
  registered for spring then add up the points in AW2-131 if they are
  on TeamName.
 
  Any ideas appreciated.
 
  Wade
  --
  Registered Linux User: #480675
  Registered Linux Machine: #408606
  Linux since June 2005
 
 
 
  --
  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.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? 
 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 be deleted


-- 
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.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Access value separated by a comma

[Wade Smart]

Im working on a sheet that has numbers for a sports club.
At the moment we use two columns and at the end of
the columns of data, we calculate values in one column
leaving another empty.

What I would like to do is move to a single column design.

A3:A15= Date
B,D,F,H,J,K,etc,1=team name
B3:B14 = Point values
C3:C14 = Goal values

B17:B22 = calculated values for B1 team.

Example data:
B3=3
B4=0
B5=1
B6=3
B7=0

C3=7
C4=10
C5=2
C6=1
C7=4

What I would like to do is:
B3=3,7
B4=0,10
B5=1,2

How would I access the first or second value a pair value?

--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

-- 
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.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Access value separated by a comma

[Wade Smart]

On Sat, Aug 9, 2014 at 9:03 PM, Alan B abo...@gmail.com wrote:
 On Sat, Aug 9, 2014 at 9:29 PM, Wade Smart wadesm...@gmail.com wrote:

 Im working on a sheet that has numbers for a sports club.
 At the moment we use two columns and at the end of
 the columns of data, we calculate values in one column
 leaving another empty.

 What I would like to do is move to a single column design.

 What I would like to do is:
 B3=3,7
 B4=0,10
 B5=1,2

 How would I access the first or second value a pair value?


  Wade, I believe you will be stuck with messy formulas if you move to a
 single cell. Once you put 3,7 into a cell it is now treated as text, not a
 number. So to use in a number formula it must be converted to a number.

 Since you will use a comma to separate your numbers you have a reliable
 separator to pick out the first or second number.

 A formula to get the fist number from B3 would be
 =VALUE( MID(B3,1,SEARCH(,,B3)-1))
 The above formula will give you the number 3 which you can then use in your
 other calculations.

 A formula for the second number would be
 =VALUE(RIGHT(B3,LEN(B12)-FIND(,,B3)))
 It will you the number 7 which again can be used in your other formulas.

 Others may suggest better formulas. I think most will recommend a different
 spreadsheet design.

I was afraid of that.
Ok.. it was just something I was working on. I can stick with two columns
until I find a better way.

Thanks :D

-- 
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.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Fwd: [libreoffice-users] Re: function value not being counted

[Wade Smart]

On Wed, Jan 14, 2015 at 1:22 PM, Andreas Säger ville...@t-online.de wrote:
 Am 14.01.2015 um 19:23 schrieb Wade Smart:
 Ive stumbled into one of those totally frustrating things that you
 cant see the reason for:

 C65=countif(C3:C61, Lt Blue)
 E65=countif(E3:E61, Lt Blue)
 G65=sum(c65+e65) = 2


 And what is wrong? (apart from the obsolete sum of an addition which
 makes no difference)

Didnt know it was obsolete ... use it all the time.

Sorry, the result didnt paste ..
out of 50 results for say Lt Blue, its only showing 4.

But I found at least one problem.  Even though I copy and pasted
there is a space at the end of some of the names like Lt Blue .
Removing that space has helped a lot. Im guessing there could
be a space at the beginning of others.

-- 
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.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] function value not being counted

[Wade Smart]

Ive stumbled into one of those totally frustrating things that you
cant see the reason for:

C65=countif(C3:C61, Lt Blue)
E65=countif(E3:E61, Lt Blue)
G65=sum(c65+e65) = 2

I have cleared all formatting.
I have started from scratch.
I opened another sheet and started.
Im not typing the words in, Im copy and pasting
into the cells and for the life of me I can not figure
out why the C column shows no counted values.

(I have many colors here so its not just Lt Blue.
Its also Red, Green, White, etc.)


--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

-- 
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.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Sumproduct with a AND

[Wade Smart]

What Im looking to do is, if O column has an x,
count how a range of numbers.
AW column has numbers that fall in the 20's, 30's, 40's etc.
I want to do something like  less than 40 greater than 30.
I tried AND but that caused an error.

=SUMPRODUCT(O2:O168=x, $AW$2:$AW$168 30)



--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

-- 
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.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] LibreOffice Sort Bug ?

[Wade Smart]

**cough cough** .. feature understood.
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005


On Wed, Mar 25, 2015 at 6:02 PM, Michael Tiernan
michael.tier...@gmail.com wrote:
 On 3/25/15 6:53 PM, Wade Smart wrote:
 I have 4.2.7.2 on Ubuntu 14.04 and you are correct, sort is not working.
 When I reported it, I provided a great deal of information about it and
 was told Not a bug and works for me by those who have the power to
 close bugs.

 My argument was/is that if you use the sort arrows (as you have done
 here) then you're asking/telling LO to sort the selected rows with no
 options.

 Instead it was deemed correct that instead, LO assumes the first cell
 found is used as a label regardless of any other settings.

 This feature (*cough*) cost me a number of hours of work to get around
 and avoid.

 The argument is that since you can use the Sort menu option and change
 this behavior *for each sort occurrence* then there's a work around for
 the feature and we should be happy with that.

 --
MCT  Michael C Tiernan. http://www.linkedin.com/in/mtiernan
   Non Impediti Ratione Cogatationis
   Women and cats will do as they please, and men and dogs
should relax and get used to the idea. -Robert A. Heinlein


 --
 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.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? 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 be deleted

Re: [libreoffice-users] LibreOffice Sort Bug ?

[Wade Smart]

I have 4.2.7.2 on Ubuntu 14.04 and you are correct, sort is not working.

I tried with several sets of letters:
p
a
b
q
r
z

The above is the sorted column.
a isnt first? hmmm

Wade

--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005


On Wed, Mar 25, 2015 at 5:42 PM, Richard VINCK charvi...@gmail.com wrote:
 Hello at the nice people at LibreOffice! (especially you :-) )

 I'm using LibreOffice version 4.4.1.2

 I was very surprised to see a bug (?!) in the internal SORT function of
 Calc.

 Please fill the following cells with a simple letter:
 L17=Z
 L18=B
 L19=Y
 L20=R
 L21=Q
 L22=P

 Now select those 6 cells and click on the Down/Up arrow in the toolbar
 (Sort), select Sort Key 1 : Z, Ascending, then click OK. Expected result was
 B-P-Q-R-Y-Z, but the Z did not move at all ! =-O

 This is undoubtedly a serious bug... and nobody has detected this before?
 How strange.

 Hopefully I could be of help making the software still better!
 Cheers
 Richard


 --
 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.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? 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 be deleted

Re: [libreoffice-users] LibreOffice Sort Bug ?

[Wade Smart]

Hmm I just tried to sort going through the
sort menu and I still cant get it to sort
properly.

It does numbers just fine though.
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005


On Wed, Mar 25, 2015 at 6:04 PM, Wade Smart wadesm...@gmail.com wrote:
 **cough cough** .. feature understood.
 --
 Registered Linux User: #480675
 Registered Linux Machine: #408606
 Linux since June 2005


 On Wed, Mar 25, 2015 at 6:02 PM, Michael Tiernan
 michael.tier...@gmail.com wrote:
 On 3/25/15 6:53 PM, Wade Smart wrote:
 I have 4.2.7.2 on Ubuntu 14.04 and you are correct, sort is not working.
 When I reported it, I provided a great deal of information about it and
 was told Not a bug and works for me by those who have the power to
 close bugs.

 My argument was/is that if you use the sort arrows (as you have done
 here) then you're asking/telling LO to sort the selected rows with no
 options.

 Instead it was deemed correct that instead, LO assumes the first cell
 found is used as a label regardless of any other settings.

 This feature (*cough*) cost me a number of hours of work to get around
 and avoid.

 The argument is that since you can use the Sort menu option and change
 this behavior *for each sort occurrence* then there's a work around for
 the feature and we should be happy with that.

 --
MCT  Michael C Tiernan. http://www.linkedin.com/in/mtiernan
   Non Impediti Ratione Cogatationis
   Women and cats will do as they please, and men and dogs
should relax and get used to the idea. -Robert A. Heinlein


 --
 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.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? 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 be deleted

[libreoffice-users] Style a text value if a value is present, after a vlookup

[Wade Smart]

This fills out the team rosters:
Sheet 1
G16=VLOOKUP($E16,$Teams.$A$12:$I$23,($O$13+1),0)

Sheet 2
Column B2:B9 = team name
Column C2:C9 = captain name

What I would like to do is bold the capt name for each team.
How would you go about doing this (automatically)?
How do you style a element based on a range with a IF statement?

Wade

--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

-- 
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.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Style a text value if a value is present, after a vlookup

[Wade Smart]

--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005


On Sun, Sep 13, 2015 at 12:54 AM, Brian Barker
<b.m.bar...@btinternet.com> wrote:
> At 09:12 11/09/2015 -0500, Wade Smart wrote:
>>
>> This fills out the team rosters:
>> Sheet 1
>> G16=VLOOKUP($E16,$Teams.$A$12:$I$23,($O$13+1),0)
>>
>> Sheet 2
>> Column B2:B9 = team name
>> Column C2:C9 = captain name
>>
>> What I would like to do is bold the capt name for each team. How would you
>> go about doing this (automatically)?
>
>
> I'm, not sure I understand your general problem, but ...
>
>> How do you style a element based on a range with a IF statement?
>
>
> You may find the STYLE() function useful - something like:
> =(STYLE(IF(condition;;)))
> The condition is evaluated and the appropriate style name returned to the
> STYLE() function, which applies that style to the cell. The STYLE() function
> itself returns the value zero; to avoid this being appended inappropriately
> to the result of  (which is what you want to see in the cell),
> the T()function is used. This returns an empty string for numerical
> arguments.
>
> If you want the style to depend on the result of  (i.e. the
> value in the cell itself), you can use something like:
> =(STYLE(IF(CURRENT()=;;)))
>
> I trust this helps.
>
> Brian Barker
>
>
> --
> 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.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

I messed with this for a while and just made a mess of it. I think I can do
without the styling for now.

Thanks

-- 
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.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: downloading Libre Office

[Wade Smart]

>
> I have downloaded and installed, but unable to open

What specifically did you download?
The name of the specific file?

-- 
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.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Win 10

[Wade Smart]

--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005


On Sat, Dec 12, 2015 at 4:21 PM, John Boyle  wrote:
> To Users: I belong to a computer club, and today we had a presentation on
> WIN 10 and how much of a headache it really is to install, even for
> professionals. I would like to know what version of LibreOffice has even a
> chance to work with WIN 10???

I installed libreoffice on my sons w10 and my wifes w10 machine
without any problem.

-- 
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.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] If value is not present, count it.

[Wade Smart]

This does not work but this is what Im thinking about.

If a item in this range does not have PO, and is Red and is M
then I want to count it.

=IF( $E$2:$E$160 <> "PO",
SUMPRODUCT($B$2:$B$160="Red",$D$2:$D$160="M"))

This is for tracking our league jerseys and our inventory
to be checked out seasonally to the players. I want to know
how many of Medium shirts Red team has.


--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

-- 
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.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] If value is not present, count it.

[Wade Smart]

Sure.

B C D E
Red 8 XLIN
Red 9 L  PO
Red 10
Red 11XL   IN
Red 12L  OUT

First line is the column.
In column B I have all the jersey colors.
There are currently 12 colors.

Column C is the number on the jersey.

Column D is the size of the jersey. You'll
notice that Red #10 has no size. That jersey
has been lost and will need to be replaced.

Column E has one of these designations:
IN, OUT, PO, Replace, ?

So, Red #8 jersey is a XL and is currently in
inventory. Red #9 size L is PO. Red #10 has
either been lost or otherwise missing and will
be replaced (though since I copied and pasted
the data here, it currently says nothing). Red #12
is size L but is currently checked out.



--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005


On Fri, Jul 15, 2016 at 6:24 AM, Bruce Hohl <bruceh...@gmail.com> wrote:
> Can you give some examples of the cell contents of column E when a PO is
> present and not present.
>
> On Fri, Jul 15, 2016 at 7:03 AM, Wade Smart <wadesm...@gmail.com> wrote:
>>
>> --
>> Registered Linux User: #480675
>> Registered Linux Machine: #408606
>> Linux since June 2005
>>
>>
>> On Thu, Jul 14, 2016 at 8:01 PM, Bruce Hohl <bruceh...@gmail.com> wrote:
>> > Perhaps one of these depending the content of Column E:
>> > =COUNTIFS(E2:E160,"<>PO",  B2:B160,"Red",  D2:D160,"M")
>> > =COUNTIFS(E2:E160,"",  B2:B160,"Red",  D2:D160,"M")
>>
>> The first one produces 4 and the second one produces 0.
>
>

-- 
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.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] If value is not present, count it.

[Wade Smart]

=SUMPRODUCT($E$2:$E$160="PO",$B$2:$B$160="Red",$D$2:$D$160="L")

This = TRUE.
There is only 1 PO and it is a Large.
If D column is set to M for medium, the value is FALSE.

This one
=SUMPRODUCT($E$2:$E$160<>"PO",$B$2:$B$160="Red",$D$2:$D$160="L")

also = TRUE.
There are Large Red jerseys without PO but it doesnt count them.

--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005


On Fri, Jul 15, 2016 at 6:38 AM, Wade Smart <wadesm...@gmail.com> wrote:
> 4 = the total number of M shirts for Red.
> So this
> =SUMPRODUCT($E$2:$E$160<>"PO",$B$2:$B$160="Red",$D$2:$D$160="M")
> is not matching the first section.
>
> Maybe <> doesnt work on text?
> --
> Registered Linux User: #480675
> Registered Linux Machine: #408606
> Linux since June 2005
>
>
> On Fri, Jul 15, 2016 at 6:34 AM, Wade Smart <wadesm...@gmail.com> wrote:
>> Sure.
>>
>> B C D E
>> Red 8 XLIN
>> Red 9 L  PO
>> Red 10
>> Red 11XL   IN
>> Red 12L  OUT
>>
>> First line is the column.
>> In column B I have all the jersey colors.
>> There are currently 12 colors.
>>
>> Column C is the number on the jersey.
>>
>> Column D is the size of the jersey. You'll
>> notice that Red #10 has no size. That jersey
>> has been lost and will need to be replaced.
>>
>> Column E has one of these designations:
>> IN, OUT, PO, Replace, ?
>>
>> So, Red #8 jersey is a XL and is currently in
>> inventory. Red #9 size L is PO. Red #10 has
>> either been lost or otherwise missing and will
>> be replaced (though since I copied and pasted
>> the data here, it currently says nothing). Red #12
>> is size L but is currently checked out.
>>
>>
>>
>> --
>> Registered Linux User: #480675
>> Registered Linux Machine: #408606
>> Linux since June 2005
>>
>>
>> On Fri, Jul 15, 2016 at 6:24 AM, Bruce Hohl <bruceh...@gmail.com> wrote:
>>> Can you give some examples of the cell contents of column E when a PO is
>>> present and not present.
>>>
>>> On Fri, Jul 15, 2016 at 7:03 AM, Wade Smart <wadesm...@gmail.com> wrote:
>>>>
>>>> --
>>>> Registered Linux User: #480675
>>>> Registered Linux Machine: #408606
>>>> Linux since June 2005
>>>>
>>>>
>>>> On Thu, Jul 14, 2016 at 8:01 PM, Bruce Hohl <bruceh...@gmail.com> wrote:
>>>> > Perhaps one of these depending the content of Column E:
>>>> > =COUNTIFS(E2:E160,"<>PO",  B2:B160,"Red",  D2:D160,"M")
>>>> > =COUNTIFS(E2:E160,"",  B2:B160,"Red",  D2:D160,"M")
>>>>
>>>> The first one produces 4 and the second one produces 0.
>>>
>>>

-- 
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.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] If value is not present, count it.

[Wade Smart]

4 = the total number of M shirts for Red.
So this
=SUMPRODUCT($E$2:$E$160<>"PO",$B$2:$B$160="Red",$D$2:$D$160="M")
is not matching the first section.

Maybe <> doesnt work on text?
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005


On Fri, Jul 15, 2016 at 6:34 AM, Wade Smart <wadesm...@gmail.com> wrote:
> Sure.
>
> B C D E
> Red 8 XLIN
> Red 9 L  PO
> Red 10
> Red 11XL   IN
> Red 12L  OUT
>
> First line is the column.
> In column B I have all the jersey colors.
> There are currently 12 colors.
>
> Column C is the number on the jersey.
>
> Column D is the size of the jersey. You'll
> notice that Red #10 has no size. That jersey
> has been lost and will need to be replaced.
>
> Column E has one of these designations:
> IN, OUT, PO, Replace, ?
>
> So, Red #8 jersey is a XL and is currently in
> inventory. Red #9 size L is PO. Red #10 has
> either been lost or otherwise missing and will
> be replaced (though since I copied and pasted
> the data here, it currently says nothing). Red #12
> is size L but is currently checked out.
>
>
>
> --
> Registered Linux User: #480675
> Registered Linux Machine: #408606
> Linux since June 2005
>
>
> On Fri, Jul 15, 2016 at 6:24 AM, Bruce Hohl <bruceh...@gmail.com> wrote:
>> Can you give some examples of the cell contents of column E when a PO is
>> present and not present.
>>
>> On Fri, Jul 15, 2016 at 7:03 AM, Wade Smart <wadesm...@gmail.com> wrote:
>>>
>>> --
>>> Registered Linux User: #480675
>>> Registered Linux Machine: #408606
>>> Linux since June 2005
>>>
>>>
>>> On Thu, Jul 14, 2016 at 8:01 PM, Bruce Hohl <bruceh...@gmail.com> wrote:
>>> > Perhaps one of these depending the content of Column E:
>>> > =COUNTIFS(E2:E160,"<>PO",  B2:B160,"Red",  D2:D160,"M")
>>> > =COUNTIFS(E2:E160,"",  B2:B160,"Red",  D2:D160,"M")
>>>
>>> The first one produces 4 and the second one produces 0.
>>
>>

-- 
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.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] If value is not present, count it.

[Wade Smart]

Its been pointed out that actually state my problem
making it difficult for people help. Valid point.

I have a spread sheet that tracks jersey inventory.

Column B = Jersey Color
Column C = Number printed on the Jersey
Column D = Jersey Size
Column E = Status of the jersey
 IN, OUT, PO, Replace, ?

Column B: E, 2:160 is the range.

=SUMPRODUCT($E$2:$E$160<>"PO",$B$2:$B$160="Red",$D$2:$D$160="L")

This I would think would show me all Large Red jerseys
that are not PO.

What I want to know is, for each size of jersey in
a certain color, how many do I have that are NOT PO.

I have gone through to make sure any line with PO
is actually "PO" and not " PO", " PO " or "PO ".







As for correctness of each entry, I have been going
back through all entries to make sure "PO" is just that
and not "PO " or " PO" or " PO ". I have found a three
like that.

As you said, it is exclusion of PO in a jersey color and
size that I am counting. So, for example, below I would
have  2 XL Red jerseys, 1 L Red jersey.

PO stands for Private Owned. I know from my spreadsheet
that I have x number of Red jerseys, that 1 ( in the example
data below ) is PO and is number 9 and that the rest are owned
by the league. If I have to check them in and out or have to
reorder jerseys, I will not be purchasing a shirt and put #9 on it.
So,what I want to know is, how many Red Jerseys in a size
I have that are not PO.
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005


On Fri, Jul 15, 2016 at 7:12 AM, Wade Smart <wadesm...@gmail.com> wrote:
> Perhaps you missed this post.
> I was asked what data was in each column.
>
> As for correctness of each entry, I have been going
> back through all entries to make sure "PO" is just that
> and not "PO " or " PO" or " PO ". I have found a three
> like that.
>
> As you said, it is exclusion of PO in a jersey color and
> size that I am counting. So, for example, below I would
> have  2 XL Red jerseys, 1 L Red jersey.
>
> PO stands for Private Owned. I know from my spreadsheet
> that I have x number of Red jerseys, that 1 ( in the example
> data below ) is PO and is number 9 and that the rest are owned
> by the league. If I have to check them in and out or have to
> reorder jerseys, I will not be purchasing a shirt and put #9 on it.
> So,what I want to know is, how many Red Jerseys in a size
> I have that are not PO.
>
>
>
> B C D E
> Red 8 XLIN
> Red 9 L  PO
> Red 10
> Red 11XL   IN
> Red 12L  OUT
>
> First line is the column.
> In column B I have all the jersey colors.
> There are currently 12 colors.
>
> Column C is the number on the jersey.
>
> Column D is the size of the jersey. You'll
> notice that Red #10 has no size. That jersey
> has been lost and will need to be replaced.
>
> Column E has one of these designations:
> IN, OUT, PO, Replace, ?
>
> So, Red #8 jersey is a XL and is currently in
> inventory. Red #9 size L is PO. Red #10 has
> either been lost or otherwise missing and will
> be replaced (though since I copied and pasted
> the data here, it currently says nothing). Red #12
> is size L but is currently checked out.
> --
> Registered Linux User: #480675
> Registered Linux Machine: #408606
> Linux since June 2005
>
>
> On Fri, Jul 15, 2016 at 6:55 AM, Brian Barker <b.m.bar...@btinternet.com> 
> wrote:
>> At 04:23 15/07/2016 -0500, you wrote:
>>>
>>> On Thu, Jul 14, 2016 at 8:31 PM, Brian Barker wrote:
>>>>
>>>> =SUMPRODUCT($E$2:$E$160<>"PO",$B$2:$B$160="Red",$D$2:$D$160="M")
>>>
>>>
>>> This produces 4. I do not know how it gets that.
>>
>>
>> Hopefully because in rows 2 to 160 there are four rows for which En is not
>> exactly "PO", Bn is exactly "Red", and Dn is exactly "M". That's what it
>> does for me.
>>
>>> For Red shirts, I have 1 PO, 1 INV and 16 IN. In all shirts I have over 20
>>> PO.
>>
>>
>> It's not the number of "PO"s that matters, but how many are *not* "PO".
>>
>> I can have no idea what "INV" and "IN" are, still less which columns they
>> might be in!
>>
>> I avoided saying this before, but you have fallen into the trap of trying to
>> specify a problem by offering a formula that you know doesn't work. (To be
>> fair, you did make clear that you knew that.) Such an incorrect formula does
>> not define the problem, of course, so anyone trying to help has to guess

Re: [libreoffice-users] Overly aggressive autofomatting issues in LibreOffice

[Wade Smart]

You have to register to read the article.
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005


On Fri, Aug 26, 2016 at 9:13 AM, M Henri Day  wrote:
> This *Wapo* article (
> https://www.washingtonpost.com/news/wonk/wp/2016/08/26/an-alarming-number-of-scientific-papers-contain-excel-errors/)
> - while dealing more specifically with Microsoft's Excel, should, as noted
> in the next-to-last paragraph, give even LibreOffice developers pause. If
> the claim that LibreOffice behaves like Microsoft Office in this particular
> respect is indeed true, then I submit that some attention should be devoted
> to making turning off autoformatting in Calc easier for users
>
> Henri
>
> --
> 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.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? 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 be deleted

Re: [libreoffice-users] Overly aggressive autofomatting issues in LibreOffice

[Wade Smart]

> I tried - and a popup appers to write down my mailadress and register.
> Couldn't read the text in background.
>
> Regards
>
> Robert

This is what I saw as well.

-- 
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.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Overly aggressive autofomatting issues in LibreOffice

[Wade Smart]

--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005


On Fri, Aug 26, 2016 at 10:58 AM, M Henri Day <mhenri...@gmail.com> wrote:
> 2016-08-26 17:31 GMT+02:00 Wade Smart <wadesm...@gmail.com>:
>>
>> > I tried - and a popup appers to write down my mailadress and register.
>> > Couldn't read the text in background.
>> >
>> > Regards
>> >
>> > Robert
>>
>> This is what I saw as well.
>
>
> We seem to be discussing an entirely different issue from that which I
> originally proposed. I hope Cristopher Ingraham will regard it as fair use
> if I reproduce the content of the article below
> :
>
> «A surprisingly high number of scientific papers in the field of genetics
> contain errors introduced by Microsoft Excel, according to an analysis
> recently published in the journal Genome Biology.
>
> A team of Australian researchers analyzed nearly 3,600 genetics papers
> published in a number of leading scientific journals — like Nature, Science
> and PLoS One. As is common practice in the field, these papers all came with
> supplementary files containing lists of genes used in the research.
>
> The Australian researchers found that roughly 1 in 5 of these papers
> included errors in their gene lists that were due to Excel automatically
> converting gene names to things like calendar dates or random numbers.
>
> You see, genes are often referred to in scientific literature by symbols —
> essentially shortened versions of full gene names. The gene "Septin 2" is
> typically shortened as SEPT2. "Membrane-Associated Ring Finger (C3HC4) 1, E3
> Ubiquitin Protein Ligase" gets mercifully shortened to MARCH1
>
> Even worse, there's no easy way to undo this automatic formatting once it
> has happened. Edit -> Undo simply deletes everything in the cell. You can
> try to convert the formatting from "General," the default, to "Text," which
> you might expect to change it back to the original characters you enter. But
> instead, changing the formatting to "Text" makes the cell contents appear as
> 42615 — Excel's internal numeric code referring to the date 9/2/2016.
>
> Even more troubling, the researchers note that there's no way to permanently
> disable automatic date formatting within Excel. Researchers still have to
> remember to manually format columns to "Text" before you type anything in
> new Excel sheets — every. single. time.
> But even the genetics researchers among us are only human, and they
> sometimes forget to do this. Hence, you end up with 20 percent of these
> genetics papers containing preventable errors introduced by Excel.
>
> The Australian researchers note that this problem was first identified in a
> paper published more than a decade ago. "Nevertheless, we find that these
> errors continue to pervade supplementary files in the scientific
> literature," they write.
>
> Genetics isn't the only field where a life's work can potentially be
> undermined by a spreadsheet error. Harvard economists Carmen Reinhart and
> Kenneth Rogoff famously made an Excel goof — omitting a few rows of data
> from a calculation — that caused them to drastically overstate the negative
> GDP impact of high debt burdens. Researchers in other fields occasionally
> have to issue retractions after finding Excel errors as well.
>
> The Australian researchers note that Excel isn't the only spreadsheet
> program with overly aggressive autoformatting issues — the same errors crop
> up in open-source programs like LibreOffice Calc and Apache OpenOffice Calc
> too.
>
> They do note, however, that one perfectly free spreadsheet program did not
> have any issues storing the gene names as typed — Google Sheets.»
>
>
> Perhaps now we can get back to discussing the issue of overly aggressive
> autoformatting in LibreOffice ?...
>
> Henri

Looks like a user problem to me.
Is no one proof reading this papers before submission?

Wade

-- 
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.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: How to reverse a date format

[Wade Smart]

On Mon, Jul 17, 2017 at 7:26 AM, V Stuart Foote <vstuart.fo...@utsa.edu> wrote:
> Wade Smart wrote
>> This spread sheet has several columns of dates
>> written MM/DD/. I need to reverse it to
>> /MM/DD...
>
> You can not change the internal format of the dates.
>
> If they are columns of Dates in an ODF spreadsheet they do not need to be
> changed--actually can not be changed--rather you just need to change their
> display format. Select the column, the Format -> Cells  and in the dialog
> select Date and a format you need. The -MM-DD is predefined. Or you can
> add a format code to use an alternate separator.
>
> If the file is CSV, set it as date during import and set the display format
> needed.

Well, that fixes one column.
Ill have to figure out the rest then.

Thanks for the information.

--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

-- 
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.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] How to reverse a date format

[Wade Smart]

On Mon, Jul 17, 2017 at 7:38 AM, Brian Barker <b.m.bar...@btinternet.com> wrote:
> At 06:26 17/07/2017 -0500, Wade Smart wrote:
>>
>> This spread sheet has several columns of dates written MM/DD/. I need
>> to reverse it to /MM/DD. This is what I came up with:
>>
>> =MID(A17,FIND("/",A17)+4,1024)&"/"(LEN(LEFT(A14,FIND("/",A14)-1))=1,LEFT(A14,FIND("/",A14)-2)&"0"(A14,FIND("/",A14)-1))&"/"(A17,FIND("/",A17)+1,2)
>
>
> I'm guessing that you mean that this is for dates written as text, not
> proper spreadsheet dates as internal numbers formatted to show as you
> describe. I'd consider doing this a different way.
> o Select the relevant column.
> o Go to Data | Text to Columns... .
> o Under Fields, click the column header.
> o For Column type, select "Date (MDY)" (yes: really!).
> o OK.
> Your dates are now in internal numeric format and can be formatted as
> /MM/DD if you wish.
>
>> I created this using one column as my example not realizing the other
>> columns dates were created at a later date and formatted differently. The
>> column I used the format was Number general. Another column is Number
>> -//1234 with a format code of #"/"##"/" ...
>
>
> The above technique should work with these values, too.
>
>> ... and another of Date 12/31/1999 format.
>
>
> Leave those as they are.
>
> You now have two obvious choices: either
> o Leave your values as normal spreadsheet dates and format the relevant
> cells as /MM/DD to show as you wish, or
> o Use a formula such as =TEXT(Xn;"/MM/DD") to derive an explicit text
> version of your values.
>
> I trust this helps.
>
> Brian Barkero this list will be publicly archived and cannot be
> deleted
>

HA! That worked!
You way was much easier than that long formula I did :D
Thanks for that. I very much appreciate it.

Wade
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

-- 
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.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] How to reverse a date format

[Wade Smart]

This spread sheet has several columns of dates
written MM/DD/. I need to reverse it to
/MM/DD. This is what I came up with:

=MID(A17,FIND("/",A17)+4,1024)&"/"(LEN(LEFT(A14,FIND("/",A14)-1))=1,LEFT(A14,FIND("/",A14)-2)&"0"(A14,FIND("/",A14)-1))&"/"(A17,FIND("/",A17)+1,2)

I created this using one column as my example
not realizing the other columns dates were
created at a later date and formatted differently.

The column I used the format was Number general.
Another column is Number -//1234 with a format
code of #"/"##"/"  and another of Date
12/31/1999 format.

This formula will not work on the second and third
columns. Any suggestions how to adapt this or
other ideas?


--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

-- 
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.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] [OffTopic] Bounce Message Notifications...

[Wade Smart]

Between OO and Libra I get a bouncing message notification at least once a day.
I have gmail so its not as if I can do much about but, anyone have
this crazy number
of bounced notifications?

I filter them out but there sure are a lot.

--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

-- 
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.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] [OffTopic] Bounce Message Notifications...

[Wade Smart]

On Mon, Oct 9, 2017 at 6:52 PM, Toki <toki.kant...@gmail.com> wrote:
> On 10/09/2017 10:23 PM, Wade Smart wrote:
>
>> Between OO and Libra I get a bouncing message notification at least once a 
>> day.
>
> Don't worry, on both AOL mail and Yahoo Mail, you'll get double the
> number of bounces that you get on GMail.
>
> A couple of months ago I looked at what was bouncing, and came to the
> following conclusions:
> * Anything bounced by AOL or GMail will be bounced by Yahoo;
> * Roughly three quarters of the messages bounced by GMail, are also
> bounced by AOL;
> * Whatever causes the bounces, ignores DKIM;
>
> jonathon

Alright .. then Ill let that filter do its work.
Thanks

Wade
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

-- 
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.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc - opening a .csv file challenge

[Wade Smart]

Did you try opening in notepad?
-- 
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005


On Tue, Jun 12, 2018 at 11:21 AM, charles meyer  wrote:
> Hi Folks,
>
>
>
> I’m running Libre Office 5.1.1 installed on my hard drive running Windows 7
> Pro.
>
>
>
> A friend emailed me a .csv file created and saved in Excel 10 exported in
> the .csv format but no matter how I try opening it – Western Europe
> (ASCII/US) or (ISO-8859-1) or (Windows – 1252/Win Latin 1) it just opens to
> gibberish.
>
>
>
> Any thoughts about what may be going wrong?
>
>
>
> Thank you.
>
>
>
> Charles.
>
> --
> 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

-- 
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] Frustrated with stupid behavior while trying to do a project.

[Wade Smart]

From the help menu:

You can enable a selection cursor in a read-only text document or in the Help.
Choose Edit - Select Text or open the context menu of a read-only document
and choose Select Text. The selection cursor does not blink.

-- 
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005


On Mon, Jun 4, 2018 at 6:27 PM, Peggy <33mar...@gmail.com> wrote:
> I am using a table to list all of our scattered names, phone numbers, etc
> to keep them together in alphabetical order. It means I guess where the
> names go and cut and paste to put entries in the correct places. All has
> been fine, until now.
>
> Now suddenly, I can't cut and paste one of the cells. It cuts, but won't
> paste where I want it to go.. I tried to just write the information into
> the cell and get this message: "Read only content; Write protected content
> cannot be changed. No modifications will not be accepted"
>
> It's my document for heaven's sake. I didn't write protect it. I've tried
> to find a place under the table menu where something got changed and can't.
> If I have to I'll try save it under another name and then see if the
> problem sticks, but I shouldn't have to.
>
> Can anyone tell me how this glitch happened and if there's anything I can
> do to change it?
>
> I've been working all day and hoped to finish tonight. What's wrong with
> this program! I would be so grateful for an answer!
>
> Peggy
>
> --
> 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

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

Fwd: [libreoffice-users] Summing currency fields in base

[Wade Smart]

In field 3
=field1+field2
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

On Thu, Oct 11, 2018 at 1:41 PM Adam Fenn  wrote:
>
> I have three currency fields - 'Fee1', 'Fee2' and 'Total'.  How do I add fee1 
> and fee2 together and put the result automatically into the Total field?
>
> TIA
> Adam.
> --
> 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
>

-- 
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] Summing currency fields in base

[Wade Smart]

Ah, sorry. I cant see the whole subject line
on my phone. Though a quick search on
calculated fields shows you can:

http://sheepdogguides.com/fdb/fdb1calcf1.htm
-- 
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005
On Thu, Oct 11, 2018 at 2:00 PM Adam Fenn  wrote:
>
> I'm not using Calc, I'm making a database using base. If you use a drop down 
> field there is a place in the properties to add sql but not in a currency 
> field. I'm wondering how you do it.
>
> > On 11 Oct 2018, at 19:52, Wade Smart  wrote:
> >
> > If A1 is fee1
> > fee2 is B1
> > then in
> > c1 you type
> > =A1+B1
> >
> > --
> > Registered Linux User: #480675
> > Registered Linux Machine: #408606
> > Linux since June 2005
> >
> > On Thu, Oct 11, 2018 at 1:51 PM Adam Fenn  wrote:
> >>
> >> Thanks Wade, but where do I put that?
> >>
> >>> On 11 Oct 2018, at 19:45, Wade Smart  wrote:
> >>>
> >>> In field 3
> >>> =field1+field2
> >>> --
> >>> Registered Linux User: #480675
> >>> Registered Linux Machine: #408606
> >>> Linux since June 2005
> >>>
> >>> On Thu, Oct 11, 2018 at 1:41 PM Adam Fenn  wrote:
> >>>>
> >>>> I have three currency fields - 'Fee1', 'Fee2' and 'Total'.  How do I add 
> >>>> fee1 and fee2 together and put the result automatically into the Total 
> >>>> field?
> >>>>
> >>>> TIA
> >>>> Adam.
> >>>> --
> >>>> 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
> >>>>
> >>>
> >>> --
> >>> 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
> >>
> >>
> >> --
> >> 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
> >>
> >
> > --
> > 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
>

-- 
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] Summing currency fields in base

[Wade Smart]

If A1 is fee1
fee2 is B1
then in
c1 you type
=A1+B1

-- 
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

On Thu, Oct 11, 2018 at 1:51 PM Adam Fenn  wrote:
>
> Thanks Wade, but where do I put that?
>
> > On 11 Oct 2018, at 19:45, Wade Smart  wrote:
> >
> > In field 3
> > =field1+field2
> > --
> > Registered Linux User: #480675
> > Registered Linux Machine: #408606
> > Linux since June 2005
> >
> > On Thu, Oct 11, 2018 at 1:41 PM Adam Fenn  wrote:
> >>
> >> I have three currency fields - 'Fee1', 'Fee2' and 'Total'.  How do I add 
> >> fee1 and fee2 together and put the result automatically into the Total 
> >> field?
> >>
> >> TIA
> >> Adam.
> >> --
> >> 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
> >>
> >
> > --
> > 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
>
>
> --
> 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
>

-- 
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] [LibreOffice] CountIF in range AND in another range

[Wade Smart]

My two ranges:
E2:E455 = IN, OUT
F2:F455 = F or S + Year = "F 2018"

What I want to do is:
countIF E2:E455 = OUT AND F2:F455 = F 2018

After reading the help docs and just cant seem to figure out
the way to write this for two ranges.


-- 
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

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

Fwd: [libreoffice-users] CountIF in range AND in another range

[Wade Smart]

On Mon, Dec 3, 2018 at 11:45 AM Brian Barker  wrote:
>
> At 11:15 03/12/2018 -0600, Wade Smart wrote:
> >My two ranges:
> >E2:E455 = IN, OUT
> >F2:F455 = F or S + Year = "F 2018"
> >
> >What I want to do is: countIF E2:E455 = OUT AND F2:F455 = F 2018
> >
> >After reading the help docs and just cant seem to figure out the way
> >to write this for two ranges.
>
> How about:
> =SUMPRODUCT(E2:E455="OUT";F2:F455="F 2018")
>
> Each of the equations in the arguments creates an array of boolean
> values. The SUMPRODUCT() function first multiplies corresponding
> members, which requires TRUE to be interpreted as 1 and FALSE as 0.
> The product is thus 1 only if both conditions are true. The sum of
> all the appropriate 1s is the count you require.
>
> I trust this helps.
>
> Brian Barker

Ah, excellent.
Well, that is a lot easier than what I was trying to do.
Over thinking it.

Thanks Brian.

--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

-- 
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] I have been using open office, libre office and open everything since 1985

[Wade Smart]

I use Libre everyday. Never had a stability issue. My spreadsheets are up and
used seven days a week around 60 tabs and under 900 rows per tab. No issues.

I would say its user and/or user machine issues.
-- 
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

On Fri, Jan 11, 2019 at 5:01 AM fudmier  wrote:
>
>
>
> but I can tell you what has happened to libre office over the past two
> years has turned me off..
> nothing about it is stable.. it stinks.
>
> --
> 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

-- 
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] Libre affected by gmail

[Wade Smart]

Charles, LO did not affect your email.
Messages from 1 sender - unless they send you lots of attachments,
isnt going to help you. You need to search for messages over a certain
size - if that is the route you want to take.

That question is for another group overall as it has nothing to do
with LO/OO.

Just search on whatever search engine - gmail: messages over
a certain size.
-- 
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

On Sun, Apr 14, 2019 at 1:43 PM charles meyer  wrote:
>
> Hi Folks,
>
> I've Googled this but found little help in reducing my gmail account use.
>
> For any of the fellow Gmail users on this list...
>
> I've save my messages which I then read/edit often in Libre Writer.
>
> I've searched in my Gmail Inbox for messages from a certain sender and then
> chosen to delete all messages from the at sender for 1 year.
>
> It deletes them all but no matter how many senders I do that with I'm still
> stuck using 47% of my gmail account.
>
> Is there any easy way to search for my largest messages (by size) in my
> Inbox and/or Sent box so I can delete them to lower my percentage of use in
> my Gmail boxes?
>
> Thanks so much.
>
> --
> 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

-- 
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] Libre affected by gmail

[Wade Smart]

OR, you just type the number 5 next to greater than in the search bar.
-- 
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

On Sun, Apr 14, 2019 at 8:45 PM Michael Manning
 wrote:
>
> Have a look at:
> https://www.labnol.org/internet/gmail-size-search/26669/
>
>
> Mike
>
>
>
>
> On Mon, 15 Apr 2019 at 04:42, charles meyer  wrote:
>
> > Hi Folks,
> >
> > I've Googled this but found little help in reducing my gmail account use.
> >
> > For any of the fellow Gmail users on this list...
> >
> > I've save my messages which I then read/edit often in Libre Writer.
> >
> > I've searched in my Gmail Inbox for messages from a certain sender and then
> > chosen to delete all messages from the at sender for 1 year.
> >
> > It deletes them all but no matter how many senders I do that with I'm still
> > stuck using 47% of my gmail account.
> >
> > Is there any easy way to search for my largest messages (by size) in my
> > Inbox and/or Sent box so I can delete them to lower my percentage of use in
> > my Gmail boxes?
> >
> > Thanks so much.
> >
> > --
> > 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
> >
>
> --
> 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

-- 
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] FODT Write Error. The file could not be written.

[Wade Smart]

With the info provided - sounds like a permission problem.
Which folder are you writing too?
Right click and see what the permissions are.
-- 
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

On Fri, Apr 12, 2019 at 2:07 PM Francesco Ongaro  wrote:
>
> Dear LibreOffice Community,
>
> I programmatically generate a FODT that opens without any problem and
> can be edited.
>
> When saving such FODT document I get "Write Error. The file could not be
> written.".
>
> BTW the document is valid XML, is there a method to debug such issue?
>
> I tried -DXSLTransformer.statsfile=/tmp/xslt_debug.txt as a Java startup
> parameter but the file is not created and I'm not sure that Java's XSLT
> is called when saving a document.
>
> Thanks a lot,
> ascii
>
> https://ask.libreoffice.org/en/question/190226/fodt-write-error-the-file-could-not-be-written/
>
> --
> 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

-- 
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] Problem with comments in Calc-deleting as I enter

[Wade Smart]

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
-- 
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

On Sat, Nov 30, 2019 at 9:48 AM frank hutton  wrote:
>
> remove me from your distribution list please.
>
>
> On Fri, Nov 29, 2019 at 11:16 AM Eric Beversluis <
> ebe...@researchintegration.org> wrote:
>
> > Of course, as soon as I sent this, the problem went away, though I didn’t
> > do anything different.
> >
> > ???
> >
> > 
> > When I create a comment in my Calc spreadsheet and start entering text,
> > either right away or after a few letter LO starts deleting each letter as I
> > enter it.
> >
> > Have I got some setting wrong?
> >
> > Eric Beversluis
> > Short fiction at www.ericbeversluis.com
> >
> >
> > --
> > 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
> >
>
> --
> 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

-- 
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] IF problem

[Wade Smart]

Make sure there is no spaces at all in the C column.
I removed all formatting and your formula result
is .014648438

-- 
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

On Sun, May 17, 2020 at 3:42 PM Wade Smart  wrote:
>
> When I format C as text or all it displays FALSE, not true.
>
> --
> Registered Linux User: #480675
> Registered Linux Machine: #408606
> Linux since June 2005
>
> On Sun, May 17, 2020 at 3:35 PM James  wrote:
> >
> > AB C DE
> > 3/10/202015KB015
> >
> > E1 contains this:
> > =IF(C3="KB",B3/1024,B3)
> > It displays 15
> >
> > I tried:
> > =IF(C3="KB")
> > It displays TRUE
> >
> > My formula works elsewhere.
> > Any ideas?
> >
> >
> >
> > --
> > 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

-- 
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] IF problem

[Wade Smart]

When I format C as text or all it displays FALSE, not true.

-- 
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

On Sun, May 17, 2020 at 3:35 PM James  wrote:
>
> AB C DE
> 3/10/202015KB015
>
> E1 contains this:
> =IF(C3="KB",B3/1024,B3)
> It displays 15
>
> I tried:
> =IF(C3="KB")
> It displays TRUE
>
> My formula works elsewhere.
> Any ideas?
>
>
>
> --
> 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

-- 
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: IF problem

[Wade Smart]

If you make a change to your formula, click in the field
to get it to 'take'.

-- 
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

On Sun, May 17, 2020 at 7:46 PM James  wrote:
>
> On 2020-05-17 4:46 p.m., Wade Smart wrote:
> > Make sure there is no spaces at all in the C column.
> > I removed all formatting and your formula result
> > is .014648438
> >
> Very weird, I just closed the file and reoponed it.
> Maybe it needed to do a recalculation.
>
>
>
> --
> 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

-- 
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: sum text column of common unit of measure numbers

[Wade Smart]

=if(B1="MB,A1*1000,A1*??)

You just change the final A1 to multiple by another number.

-- 
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

On Thu, May 7, 2020 at 4:46 PM James  wrote:
>
> On 2020-05-07 4:17 p.m., Malcolm Jaros wrote:
> > In Cell C1 put =IF(B1="MB",A1*1000,A1)
> >
> How can I have 2 IFs in case there are GBs?
>
>
> --
> 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

-- 
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: sum text column of common unit of measure numbers

[Wade Smart]

=IF(B1="kb",A3, IF(B1="mb",A1*1000,A1*100))


-- 
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

On Thu, May 7, 2020 at 4:56 PM Wade Smart  wrote:
>
> =if(B1="MB,A1*1000,A1*??)
>
> You just change the final A1 to multiple by another number.
>
> --
> Registered Linux User: #480675
> Registered Linux Machine: #408606
> Linux since June 2005
>
> On Thu, May 7, 2020 at 4:46 PM James  wrote:
> >
> > On 2020-05-07 4:17 p.m., Malcolm Jaros wrote:
> > > In Cell C1 put =IF(B1="MB",A1*1000,A1)
> > >
> > How can I have 2 IFs in case there are GBs?
> >
> >
> > --
> > 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

-- 
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] sum text column of common unit of measure numbers

[Wade Smart]

Copy your data into a txt file. Open with your
spreadsheet, separate by space to put numbers
in Col A and Kb/mb in Col b. Col c =  A1*1000 to get
total kb. The sum up the whole thing. Divide the total
by 1000 to get mb.
-- 
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

On Thu, May 7, 2020 at 2:05 PM James  wrote:
>
> My cell phone provider only provides me a CSV with a text field for the
> usage.
> I want to =sum( it so I need it to be numbers.
> Is a macro the easiest way to make a new column of common unit of
> measure (GB?) numbers?
>
> 15 KB
> 5 KB
> 10 KB
> 15 KB
> 5 KB
> 5 KB
> 5 KB
> 1.8 MB
> 5 KB
> 5 KB
> 15 KB
> 215 KB
> 130.2 MB
> 9.2 MB
> 475 KB
> 11.7 MB
> 10 MB
> 15 KB
> 12.1 MB
> 5 KB
> 10 KB
> 7.1 MB
> 5.3 MB
> 4.9 MB
> 15 KB
> 240 KB
> 130 MB
> 2.9 MB
>
>
> --
> 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

-- 
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] breaking lines on the page - is not print area

[Wade Smart]

For the life of me I can not figure out what I have
accidentally turned on that is showing these lines.

Broken lines horizontal and vertical. It is not the
page break lines but it is off set from that line by
one column.

Ive been scanning the View menu .. as well as
the rest and cant find something that is turned
on that I can turn off to change it.

Wade
-- 
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

-- 
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] Start Date

[Wade Smart]

To get the number of work days:
=workday(end date; -25)

https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_WORKDAY_function

And assuming each service gets a different date:
=workday(end date; -service B)
You can do a lookup table for each service.

-- 
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

On Mon, Jun 14, 2021 at 5:58 AM Wade Smart  wrote:
>
> Question: does the meter per day have any relevance to the date?
> Is a working day equal to a business day? -> Mon - Fri only?
>
>
> --
> Registered Linux User: #480675
> Registered Linux Machine: #408606
> Linux since June 2005
>
> On Mon, Jun 14, 2021 at 5:44 AM Silvio Siefke  wrote:
> >
> > Hello,
> >
> > I have a table like:
> >
> > 11.04.2022;service a;250
> > 12.04.2022;service a;250
> > 13.04.2022;service a;250
> > 14.04.2022;service b;250
> > 15.04.2022;service b;250
> > 12.05.2022;service b;250
> > 13.05.2022;service c;250
> > 14.05.2022;service c;250
> > 17.05.2022;service d;250
> > 18.05.2022;service d;250
> >
> > Service a need 10 meters par day.
> > Service b need 1 meters par day.
> > Service c need 3 meters par day.
> > Service d need 5 meters par day.
> >
> > This mean 11.04.2022 - 25 working days = Project Start Day.
> >
> > The date is enddate, I need the start day based on service values of meters
> > and only working days.
> >
> > Is there a way?
> >
> > Thank you
> > Silvio
> >
> > --
> > 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
> >

-- 
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] Start Date

[Wade Smart]

Question: does the meter per day have any relevance to the date?
Is a working day equal to a business day? -> Mon - Fri only?


-- 
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

On Mon, Jun 14, 2021 at 5:44 AM Silvio Siefke  wrote:
>
> Hello,
>
> I have a table like:
>
> 11.04.2022;service a;250
> 12.04.2022;service a;250
> 13.04.2022;service a;250
> 14.04.2022;service b;250
> 15.04.2022;service b;250
> 12.05.2022;service b;250
> 13.05.2022;service c;250
> 14.05.2022;service c;250
> 17.05.2022;service d;250
> 18.05.2022;service d;250
>
> Service a need 10 meters par day.
> Service b need 1 meters par day.
> Service c need 3 meters par day.
> Service d need 5 meters par day.
>
> This mean 11.04.2022 - 25 working days = Project Start Day.
>
> The date is enddate, I need the start day based on service values of meters
> and only working days.
>
> Is there a way?
>
> Thank you
> Silvio
>
> --
> 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
>

-- 
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] Has something happened to the list?

[Wade Smart]

Oct 24 was the last message that I see.
Probably just light right now.
-- 
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

On Tue, Nov 2, 2021 at 7:32 AM Thomas Blasejewicz  wrote:
>
> Good evening
> I was just wondering 
> I have not receive any messages through this list for a week now.
> Has something happened to the list?
>
> Thomas Blasejewicz
>
> --
> 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

-- 
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] Password Protected file

[Wade Smart]

Louise, when you click on the file to open, does not a small
dialog box come up to put in your password?
-- 
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

On Thu, Mar 10, 2022 at 9:02 AM Owen & Louise Alcock-Smith
 wrote:
>
> Hello
>
> I recently started using LibraOffice. Today i created a file i wanted to
> password protect and now i can't reopen the file - see attached message.
>
> Please tell me how i can open this file again?
>
> Most sincerely
>
> Louise
>
> --
> 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

-- 
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] how to generate a re-scaled column

[Wade Smart]

Try
=A1/MAX($A$1:$A$7)
-- 
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

On Mon, Oct 2, 2023 at 8:13 AM Uwe Brauer  wrote:
>
>
> Hi
>
> I have the following simple table
>
> | Marks | Scaled  |
> |---+|
> | 1 ||
> | 2 ||
> | 3 ||
> | 4 ||
> | 5 ||
> | 6 ||
> | 7 ||
>
>
> In the column scaled I want each value from column Marks, divided by the
> maximum of column marks which is 7.
>
>
> So I thought
>
> | Marks | Scaled |
> |---+|
> | 1 | =A1/max(A1:A7) |
> | 2 ||
> | 3 ||
> | 4 ||
> | 5 ||
> | 6 ||
> | 7 ||
>
> That gives the correct entry for B1, however if now, drag with the mouse
> down that formula I obtain
>
> | Marks | Scaled |
> |---+|
> | 7 | =A1/max(A1:A7) |
> | 2 | =B1/max(A2:A7) |
> | 3 ||
> | 4 ||
> | 5 ||
> | 6 ||
> | 1 ||
>
>
>
> Which is not what I want.
>
> That is a very elementary question, but google does not help me.
> regards
>
>
> Uwe Brauer
>
>
> --
> Warning: Content may be disturbing to some audiences
> I strongly condemn Putin's war of aggression against the Ukraine.
> I support to deliver weapons to Ukraine's military.
> I support the NATO membership of the Ukraine.
> I support the EU membership of the Ukraine.
> https://addons.thunderbird.net/en-US/thunderbird/addon/gmail-conversation-view/
>
>
> --
> 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
>

-- 
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: Debian Suicide Team, Elio Qoshi (Ubuntu, Fedora Ambassador) underage girlfriend

[Wade Smart]

I have no idea who that is.
That is completely off topic.

-- 
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

On Mon, Jul 11, 2022 at 11:50 AM Anja Xhakani  wrote:
>
> In memory of Ian Murdock we are creating the Debian Suicide Team
>
> People are dying to join us
>
> Full members are Ian Murdock and Frans Pop
>
> Apprentices are Lucy Wayland, Thiemo Seufer and Molly de Blanc. Molly has 
> bipolar so she will join us sooner or later.
>
> This is the only team where Molly de Blanc can't expel you
>
> I am the Ubuntu underage girl
>
> I started dating the Fedora ambassador Elio Qoshi in Albania when I was 16.  
> He brought me to the OSCAL conference sponsored by Red Hat.
>
> Elio had to resign as a Fedora ambassador but he had no problems getting a 
> new job at Ubuntu
>
> When he started paying me to be the 17 year old sysadmin, this wasn't a 
> payment for sex
>
> Chris Lamb started spreading gossip about abuse because he wanted an Albanian 
> girlfriend too
>
>
>
>
> --
> ubuntu-users mailing list
> ubuntu-us...@lists.ubuntu.com
> Modify settings or unsubscribe at: 
> https://lists.ubuntu.com/mailman/listinfo/ubuntu-users

-- 
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] [more] Vlookup, and other Help

[Wade Smart]

Well, that is odd.
Im uploading again ...

What about this link?
https://drive.google.com/file/d/1-9vnC9UAoffLdXcVDTTN6oIJ8UJO041w/view?usp=sharing
-- 
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

On Mon, Oct 10, 2022 at 6:37 PM Steve Edmonds
 wrote:
>
> At that link I get no download option and a message that the file is in
> your trash.
> Steve
>
> On 11/10/2022 12:27, Wade Smart wrote:
> > https://drive.google.com/file/d/1Q4Skv003T-puY-2CBr-MMQHUVC-qBhfw/view?usp=sharing
> >
> > I thought I was making headway but just got myself into more of a problem.
> >
> > The link above is a sample of what Im working with.
> > In this spread sheet I have hundreds of sections of this that are
> > added to and updated.
> >
> > If you click on cell BG4 you'll see the IF hell function that I
> > continually update (and fix).
> > This is created by someone else and the IF statement doesnt account
> > for all the things
> > that are currently going on but - in general - Section One is B4 to
> > I4. The entire colored
> > space from B3 to I13 is the whole section. Each row is calculated by
> > putting in 1 thru 4 under
> > each item name, though at the moment, and the reason Im looking to do
> > this [upgrade] is that
> > 3 and 4 and the coming 5 are not being calculated.
> >
> > Row 4, B4 to I4 either a 1 or 2 is put in. J4 is the number of items.
> > Cell BE4 totals all items from each section.
> >
> > Cell BG4 - currently the massive and incorrect IF statement - adds up
> > each cell and calculates
> > a number. In this example, F4 is BL SM and is a 1 so BG is 38. Each
> > row can have a 1 thru 4
> > (upcoming 5) in each of the available cells.
> >
> >
> > Looking at Row 7, Cell BG7 is the start of something I thought would
> > work but... I got stuck.
> > And, to be really honest, I got stuck writing this email for help
> > because - I got lost in trying to
> > explain this HAHA
> >
> > Looking at the function in BG7, check if its a number first and then
> > look up the value of F3 item
> > 1 in Sheet two which is 38. Cell BG8 does the same but shows the
> > quickly growing IF statement
> > for getting data for 2 cells.
> >
> > Question: does someone know of an easier way to do this without
> > ongoing IF statements?
> >
> > Wade
> >
> >
> >
>
>
> --
> 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

-- 
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] [more] Vlookup, and other Help

[Wade Smart]

https://drive.google.com/file/d/1Q4Skv003T-puY-2CBr-MMQHUVC-qBhfw/view?usp=sharing

I thought I was making headway but just got myself into more of a problem.

The link above is a sample of what Im working with.
In this spread sheet I have hundreds of sections of this that are
added to and updated.

If you click on cell BG4 you'll see the IF hell function that I
continually update (and fix).
This is created by someone else and the IF statement doesnt account
for all the things
that are currently going on but - in general - Section One is B4 to
I4. The entire colored
space from B3 to I13 is the whole section. Each row is calculated by
putting in 1 thru 4 under
each item name, though at the moment, and the reason Im looking to do
this [upgrade] is that
3 and 4 and the coming 5 are not being calculated.

Row 4, B4 to I4 either a 1 or 2 is put in. J4 is the number of items.
Cell BE4 totals all items from each section.

Cell BG4 - currently the massive and incorrect IF statement - adds up
each cell and calculates
a number. In this example, F4 is BL SM and is a 1 so BG is 38. Each
row can have a 1 thru 4
(upcoming 5) in each of the available cells.


Looking at Row 7, Cell BG7 is the start of something I thought would
work but... I got stuck.
And, to be really honest, I got stuck writing this email for help
because - I got lost in trying to
explain this HAHA

Looking at the function in BG7, check if its a number first and then
look up the value of F3 item
1 in Sheet two which is 38. Cell BG8 does the same but shows the
quickly growing IF statement
for getting data for 2 cells.

Question: does someone know of an easier way to do this without
ongoing IF statements?

Wade



-- 
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

-- 
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] [more] Vlookup, and other Help

[Wade Smart]

The reason is as the IF statements have grown, changed, copied -- they
are not working as they should. And this is why Im looking for a
better way. IF!!! I could do this in a db with a better front end -
that would be great but - Im not sure this company will let me do that
so for right now - small steps to at least fix all the problems this
sheet is causing.  As for specifically H and I, both of those items
have had - as said in the original post - more possible values added
to over time, and will each have 5 possible values in a few months so,
the IF statement will be updated again and if someone put the wrong
numbers in or it gets corrupted by the copying - Ill need to go back
and fix that. Its a mess.


--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005
On Mon, Oct 10, 2022 at 8:22 PM Michael D. Setzer II
 wrote:
>
> Looked at the spreadsheet and tried some things, but not clear on your 
> calculation.
> Copied formula from first row down to row 16 then modified.
> =IF(B16=1,6)+IF(B16=2,12)
> +IF(C16=1,10)+IF(C16=2,20)
> +IF(D16=1,16)+IF(D16=2,32)
> +IF(E16=1,28)+IF(E16=2,56)
> +IF(F16=1,38)+IF(F16=2,76)
> +IF(G16=1,46)+IF(G16=2,92)
> +IF(H16=1,60)+IF(H16=2,120)+IF(H16=3,180)+IF(H16=4,30)
> +IF(I16=1,80)+IF(I16=2,160)+IF(I16=3,40)
> Not clear why H16 being 4 give 30 where previous patterns would have it give 
> 240?? Same with I16 being 3 gives 40 instead of 240.
> Came with this simple formula and it mached result in most cases.
> =b16*6+c16*10+d16*16+e16*28+f16*38+g16*46*h16*60+i16*80
> Copied the relative formulas and numbers matched except where values in H or 
> I was 4 or 3.
> Didn't look at vlookup formula.
> Did note that on some of the lower rows you have blanks in cells that 
> resulted in #value, but chaning them to 0 resulted in correct numbers.
> So, is there a reason why H and I being 4 or 3 give different values from the 
> pattern. Same thing with shifting to other blocks.
> On 10 Oct 2022 at 18:40, Wade Smart wrote:
> From:Wade Smart 
> Date sent:   Mon, 10 Oct 2022 18:40:55 -0500
> Subject: Re: [libreoffice-users] [more] Vlookup, and other Help
> Copies to:   users@global.libreoffice.org
> > Well, that is odd.
> > Im uploading again ...
> >
> > What about this link?
> > https://drive.google.com/file/d/1-9vnC9UAoffLdXcVDTTN6oIJ8UJO041w/view?usp=sharing
> > --
> > Registered Linux User: #480675
> > Registered Linux Machine: #408606
> > Linux since June 2005
> >
> > On Mon, Oct 10, 2022 at 6:37 PM Steve Edmonds
> >  wrote:
> > >
> > > At that link I get no download option and a message that the file is in
> > > your trash.
> > > Steve
> > >
> > > On 11/10/2022 12:27, Wade Smart wrote:
> > > > https://drive.google.com/file/d/1Q4Skv003T-puY-2CBr-MMQHUVC-qBhfw/view?usp=sharing
> > > >
> > > > I thought I was making headway but just got myself into more of a 
> > > > problem.
> > > >
> > > > The link above is a sample of what Im working with.
> > > > In this spread sheet I have hundreds of sections of this that are
> > > > added to and updated.
> > > >
> > > > If you click on cell BG4 you'll see the IF hell function that I
> > > > continually update (and fix).
> > > > This is created by someone else and the IF statement doesnt account
> > > > for all the things
> > > > that are currently going on but - in general - Section One is B4 to
> > > > I4. The entire colored
> > > > space from B3 to I13 is the whole section. Each row is calculated by
> > > > putting in 1 thru 4 under
> > > > each item name, though at the moment, and the reason Im looking to do
> > > > this [upgrade] is that
> > > > 3 and 4 and the coming 5 are not being calculated.
> > > >
> > > > Row 4, B4 to I4 either a 1 or 2 is put in. J4 is the number of items.
> > > > Cell BE4 totals all items from each section.
> > > >
> > > > Cell BG4 - currently the massive and incorrect IF statement - adds up
> > > > each cell and calculates
> > > > a number. In this example, F4 is BL SM and is a 1 so BG is 38. Each
> > > > row can have a 1 thru 4
> > > > (upcoming 5) in each of the available cells.
> > > >
> > > >
> > > > Looking at Row 7, Cell BG7 is the start of something I thought would
> > > > work but... I got stuck.
> > > > And, to be really honest, I got stuck writing this email for help
> > > > because - I got lost in trying to
> >

Fwd: [libreoffice-users] Calc- combine columns data

[Wade Smart]

=concat(a1," ",a2)

So A1 = Mark, A2 = Smith, A3 will be Mark Smith
If A1 is Mike and A2 is empty, A3 will be Mike

--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

On Fri, Dec 2, 2022 at 7:07 AM .  wrote:
>
> I want to be able to combine the contents of, say, column A into column
> B without losing data in any of the rows.
>
> Each column have blanks in certain rows so the data wont be overwritten.
>
> Example;  A1 has data but B1 doesn't
>
> A2 has no data but B2 does
>
> Can this be done?
>
> Thanks,
>
> 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

-- 
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] Libre Office version 7.4.5.1 (x64)

[Wade Smart]

I just set up a new HP - also a i5 with 12gb ram. Had a similar problem.
Went thru several uninstall - reinstall and .. after turning off the installed
virus protection - then installing - it worked. Im not 100% sure that was
the problem - Im not a Windows person - but that did work.
-- 
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

On Thu, Feb 23, 2023 at 5:11 PM Jim hebert  wrote:
>
> Hi:
> One month ago I purchased a new Acer Predator Helios 300 PH317-55-59J9
> laptop with Windows 11 Home. Libre Writer crashes many times and causes me
> to lose all my work. While I am working the program locks up. I can not
> highlight anything, I can't type anything. I can't close the page. The only
> thing that works is the cursor. I can move it freely. After about a minute
> of being locked, the screen goes blank. I then re-open another session and
> a recovery prompt appears and I click it and it restores the page but all
> of the fresh work I did is not there. I have an older laptop with the same
> version of Libre Office and it crashes occasionally but not near as much as
> on this new laptop. Also when it does a recovery on the older Acer Aspire 5
> laptop, I don't lose any of my work. That makes it a lot less frustrating.
> I have contacted Acer support and they had me do a command prompt with
> administrative privileges  (sfc /scannow) and I also deleted Norton
> anti-virus which I thought may have been using too much memory, but nothing
> seemed to help. I don't know if it is a Windows 11 problem, a Laptop
> problem or a Libre Office problem.
>
> --
> 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

-- 
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] [libreoffice] Tool Bar Changed

[Wade Smart]

When I started Calc this morning a message popped up and in trying
to move to read it I hit enter on the keyboard and then my tool bar changed.
Its now tabbed looking across the top. Ive been clicking around trying to
figure out how to get it back.  How does one do that?

Wade
-- 
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

-- 
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] [libreoffice] Tool Bar Changed

[Wade Smart]

I have Libre 7.3.7.2 on Kubuntu 22.04.
Under View .. I dont those options.
Which menu are you under?
-- 
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

On Fri, Mar 31, 2023 at 6:47 AM Michael H  wrote:
>
> Menu ---> View --> User Interface (but I'm on 6.4 that comes in Ubuntu 20.04)
>
> On Fri, Mar 31, 2023 at 6:41 AM Wade Smart  wrote:
>>
>> When I started Calc this morning a message popped up and in trying
>> to move to read it I hit enter on the keyboard and then my tool bar changed.
>> Its now tabbed looking across the top. Ive been clicking around trying to
>> figure out how to get it back.  How does one do that?
>>
>> Wade
>> --
>> Registered Linux User: #480675
>> Registered Linux Machine: #408606
>> Linux since June 2005
>>
>> --
>> 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

-- 
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] [libreoffice] Tool Bar Changed

[Wade Smart]

Found it!
It is now a tiny little icon in the top left corner.

Thanks! Appreciate it!

-- 
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

On Fri, Mar 31, 2023 at 7:01 AM Wade Smart  wrote:
>
> I have Libre 7.3.7.2 on Kubuntu 22.04.
> Under View .. I dont those options.
> Which menu are you under?
> --
> Registered Linux User: #480675
> Registered Linux Machine: #408606
> Linux since June 2005
>
> On Fri, Mar 31, 2023 at 6:47 AM Michael H  wrote:
> >
> > Menu ---> View --> User Interface (but I'm on 6.4 that comes in Ubuntu 
> > 20.04)
> >
> > On Fri, Mar 31, 2023 at 6:41 AM Wade Smart  wrote:
> >>
> >> When I started Calc this morning a message popped up and in trying
> >> to move to read it I hit enter on the keyboard and then my tool bar 
> >> changed.
> >> Its now tabbed looking across the top. Ive been clicking around trying to
> >> figure out how to get it back.  How does one do that?
> >>
> >> Wade
> >> --
> >> Registered Linux User: #480675
> >> Registered Linux Machine: #408606
> >> Linux since June 2005
> >>
> >> --
> >> 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

-- 
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] Is anyone using Libreoffice SYNCHED to Google drive or One drive or Soho Drive or similar online / cloud drives ?

[Wade Smart]

Yes. Just keep your doc/spreadsheet in that folder on your computer.

-- 
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

On Tue, Jul 25, 2023 at 11:11 PM Hastham S  wrote:
>
> dear allGood day
> Is anyone using Libreoffice SYNCHED to Google drive or One drive or Soho 
> Drive or similar online / cloud drives ?When I save a Libre office sheet, 
> that should be auto saved to Google drive or One Drive ..or ...I am NOT 
> talking of backup end of day or end of hourI am talking of cloud drive
> Pls helpPls pointTIA
> regardsSubu
>
> --
> 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

-- 
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] I paid for my Libre Office

[Wade Smart]

If you paid for free software one might wonder if it has been tampered with.
Uninstall it, download the correct version from the site - then try again.

-- 
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

On Tue, Nov 14, 2023 at 3:04 AM Jose David Alcantara  wrote:
>
> Thanks for the advice. I use windows 10. When I open a blank LO is gives me
> the said message when I try to save it.
>
> I tried and tried. SWitched to OpenOffice and I can do the changes without
> the said Message. LOL. I like LO (dont know why exactly, perhaps its more
> intuitive for me) but OO is good enough for now. Thanks.
>
> JDA
>
> On Mon, Nov 13, 2023 at 7:37 PM Rob Jasper  wrote:
>
> > Jose,
> >
> > You don’t specify what OS your are using.
> > This is not a problem of LO, but rather a file permission issue.
> >
> > I myself use a Mac and I assume it is the same on Linux.
> > I see this if I try to edit a file that is sent to me through email if I
> > open the file directly from mail (open the file by dubbelclick the
> > attachment). This due to the security of mail attachments. If I copy the
> > attachment out, or save it in a different location LO works flawlessly.
> >
> > Hope this helps for you too,
> >
> > Best,
> > Rob
> >
> > > Op 14 nov. 2023, om 00:57 heeft Jose David Alcantara 
> > het volgende geschreven:
> > >
> > > Dear LO,11 13 23
> > >
> > > I am getting this message and cannot really use my LO Writer:
> > >
> > > The lock file could not be created for exclusive access by LibreOffice,
> > due
> > > to missing permission to create a lock file on that file location or lack
> > > of free disk space.
> > >
> > > Do you have an easy way to 1) understand this  2) get around this ?
> > >
> > > It is important.
> > >
> > > Cordially,
> > >
> > > Jose D. Alcantara, ESq.
> > > Attorney
> > > Tel. 609-782-2494
> > >
> > > --
> > > 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
> >
> >
>
> --
> 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

-- 
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] Demo Request

[Wade Smart]

Just download it and use it. 
Its free.


On Thursday 18 April 2024 12:11:40 PM (-05:00), Anela Hebratovic wrote:

> Good afternoon,
> 
> Does LibreOffice provide demos of the software?
> I am looking for a tool that assists with document mapping.
> 
> Thanks,
> Anela
> 
> -- 
> 
> Anela Hebratovic
> Supervisor, Technical Services, Credentialing | QGenda
> 
> 3280 Peachtree Rd NE, Suite 1400
> 
> 
> Atlanta, GA, 30305
> 
> Phone: 770-399-9945 (x8700)
> 
> Email: anela.hebrato...@qgenda.com <770-399-9945>
> 
> Website: www.QGenda.com
> 
> QGenda Resource Center 
> 
> [image: __tpx__]
> 

-- 
-- 
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

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