[libreoffice-users] Issue install on a a Dell

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

[libreoffice-users] SumIF / SumProduct question

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

Re: [libreoffice-users] SumIF / SumProduct question

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

Re: [libreoffice-users] SumIF / SumProduct question

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

[libreoffice-users] Access value separated by a comma

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 =

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

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

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

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

[libreoffice-users] function value not being counted

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,

[libreoffice-users] Sumproduct with a AND

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

Re: [libreoffice-users] LibreOffice Sort Bug ?

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

Re: [libreoffice-users] LibreOffice Sort Bug ?

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

Re: [libreoffice-users] LibreOffice Sort Bug ?

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

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

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

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

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

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

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

Re: [libreoffice-users] Win 10

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

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

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

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

> 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: #4086

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

0="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 shi

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

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

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

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

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

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

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

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

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

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

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

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 t

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

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:

[libreoffice-users] How to reverse a date format

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

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

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:

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

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

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

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

Re: [libreoffice-users] Frustrated with stupid behavior while trying to do a project.

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:

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

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

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

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

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

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

[libreoffice-users] [LibreOffice] CountIF in range AND in another range

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:

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

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 20

Re: [libreoffice-users] I have been using open office, libre office and open everything since 1985

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

Re: [libreoffice-users] Libre affected by gmail

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

Re: [libreoffice-users] Libre affected by gmail

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/

Re: [libreoffice-users] FODT Write Error. The file could not be written.

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

Re: [libreoffice-users] Problem with comments in Calc-deleting as I enter

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

Re: [libreoffice-users] IF problem

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

Re: [libreoffice-users] IF problem

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

Re: [libreoffice-users] Re: IF problem

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

Re: [libreoffice-users] Re: sum text column of common unit of measure numbers

=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

Re: [libreoffice-users] Re: sum text column of common unit of measure numbers

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

Re: [libreoffice-users] sum text column of common unit of measure numbers

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

[libreoffice-users] breaking lines on the page - is not print area

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

Re: [libreoffice-users] Start Date

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: #4

Re: [libreoffice-users] Start Date

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

Re: [libreoffice-users] Has something happened to the list?

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

Re: [libreoffice-users] Password Protected file

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

Re: [libreoffice-users] how to generate a re-scaled column

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

[libreoffice-users] Re: Debian Suicide Team, Elio Qoshi (Ubuntu, Fedora Ambassador) underage girlfriend

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

Re: [libreoffice-users] [more] Vlookup, and other Help

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

[libreoffice-users] [more] Vlookup, and other Help

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

Re: [libreoffice-users] [more] Vlookup, and other Help

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

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

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

Re: [libreoffice-users] Libre Office version 7.4.5.1 (x64)

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

[libreoffice-users] [libreoffice] Tool Bar Changed

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

Re: [libreoffice-users] [libreoffice] Tool Bar Changed

t 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

Re: [libreoffice-users] [libreoffice] Tool Bar Changed

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

Re: [libreoffice-users] Is anyone using Libreoffice SYNCHED to Google drive or One drive or Soho Drive or similar online / cloud drives ?

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

Re: [libreoffice-users] I paid for my Libre Office

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

Re: [libreoffice-users] Demo Request

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