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