Re: [libreoffice-users] filter bank transactions and then sum
James, Le 14/01/2020 à 00:10, James a écrit : [...] but sum(C1:C3) gives 7.0 (the sum of the unfiltered spreadsheet. I can copy but filtered rows but that is too easy. :-) What is the hardest overkill way? :-) Maybe a template or macro that I can reuse. I just want to filter them so I can add up the interest I got. check the SUMIF() function which should give the answer you're looking for. Best, -- Jean-Francois Nifenecker, Bordeaux -- 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] font formats
I am pursuing the suggestions made particularly checking the record of all formatting applications. Will be back to you soon. Thanks for the suggestions. John On 13/1/20 1:52 pm, John Sweeney wrote: > Thanks for the idea. Yes the fonts are installed, liberation sans, a very > vanilla font. > Cheers, John > > On January 12, 2020 11:26:25 PM UTC, Remy Gauthier > wrote: >> Hi, >> Just a thought: are the fonts that are defined in the styles installed? >> It sounds a lot like font substitution playing tricks on you. This >> would explain how you try to apply a style and nothing happens. >> I hope this helps. >> Rémy.Le vendredi 10 janvier 2020 à 12:29 +0100, Pieter van Oostrum a >> écrit : >>> John Sweeney writes: I am using 6.3, vanilla ubuntu. I continue to have a lot of problemsgetting the font of a paragraph to obey the paragraph style instruction,instead it tends to default to a font called "Default paragraph font" orsomething else and no amount of removal of direct formatting or usingctrl-m helps. Anyone got any ideas? >>> Is this the Default paragraph style, or your own style?If it is your >>> own style, did you select the text and apply this paragraph style to >>> all the text? Otherwise the paragraph will be in the default >>> style.You apply a style to the selection by double clicking on the >>> style in the Styles and Formatting side pane or in the Style >>> selector.Also your own style will have to specify itself for Next >>> Style, otherwise the next paragraph will again be the default style.- >>> - Pieter van Oostrumwww: http://pieter.vanoostrum.org/ >>> PGP key: [8DAE142BE17999C4] -- 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] filter bank transactions and then sum
James wrote: I've got a spreadsheet of all my bank transactions and I want to filter them by type and them the results. eg. Tran Type Amount 1 A 1.5 2 B 2.0 3 A 3.5 I can use Data/More Filters/Standard Filer to get: Tran Type Amount 1 A 1.5 3 A 3.5 but sum(C1:C3) gives 7.0 (the sum of the unfiltered spreadsheet. I can copy but filtered rows but that is too easy. :-) What is the hardest overkill way? :-) Maybe a template or macro that I can reuse. I just want to filter them so I can add up the interest I got. Assuming the above is in columns A, B. and C, and rows 1, 2, 3 and 4 ... In Cell D2 place ... =IF(B2="A",C2,0) In Cell E2 place ... =IF(B2="B",C2,0) Drag those down to fill the relevant cells, and SUM those columns. Hope that helps Regards Fred James -- 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] filter bank transactions and then sum
Hi James, you can use the function SUBTOTAL. https://help.libreoffice.org/6.3/en-US/text/scalc/01/04060106.html?DbPAR=CALC#bm_id3165633 Kind regards Regina James schrieb am 14-Jan-20 um 00:10: I've got a spreadsheet of all my bank transactions and I want to filter them by type and them the results. eg. Tran Type Amount 1 A 1.5 2 B 2.0 3 A 3.5 I can use Data/More Filters/Standard Filer to get: Tran Type Amount 1 A 1.5 3 A 3.5 but sum(C1:C3) gives 7.0 (the sum of the unfiltered spreadsheet. I can copy but filtered rows but that is too easy. :-) What is the hardest overkill way? :-) Maybe a template or macro that I can reuse. I just want to filter them so I can add up the interest I got. -- 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] filter bank transactions and then sum
I've got a spreadsheet of all my bank transactions and I want to filter them by type and them the results. eg. Tran Type Amount 1 A 1.5 2 B 2.0 3 A 3.5 I can use Data/More Filters/Standard Filer to get: Tran Type Amount 1 A 1.5 3 A 3.5 but sum(C1:C3) gives 7.0 (the sum of the unfiltered spreadsheet. I can copy but filtered rows but that is too easy. :-) What is the hardest overkill way? :-) Maybe a template or macro that I can reuse. I just want to filter them so I can add up the interest I got. -- 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: Base Java Mac
Le 12/01/2020 à 21:26, William Gathoye (LibreOffice) a écrit : > Are you iplaw67 on Twitter ? :) > > If yes, I'm the person behind LibreOfficeFR :) Yes, I know ;-) > > In all cases, these have been reescalated to ESC (as soon my mail > becomes whitelisted). I meant *re*escalated because they have been the > center of topic for some weeks and then faded away from the main topics > :( Will keep you posted of progress being made :) Thanks ! Alex -- 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