[libreoffice-users] Subtotal Function in Calc Spreadsheet

Libre Office Users,



I am a new user to Libre Office after many years on Excel.  Have an issue that needs your help.  
The "sum" subtotal works properly, and so does the "average" subtotal.  It's the "count" subtotal 
that does not calculate correctly.



After loading 4.0.4 and renaming the user profile to see if that would correct the "count" subtotal 
(suggested by AskLibo) it still does not work correctly. Have attached a spreadsheet with format 
examples. As you can see the LO format does not produce the correct response while using the Excel 
formula does.    How do you change a formula in Calc?  Is it something that we can do or must it be 
done by the developer?



Also, there are no label descriptions like there are with the "sum" subtotals.  How would we add 
them to the format? Or must it be done by the developer?



I know very little about programing so any instructions would need to be layman's terms.



Using the "count" subtotal function is an important part of what I do and I need Spreadsheets to to 
funtion properly as quickly as possible.



Thank you so much for your help!!!!

ALTOUR
Connie Price
Accounting Supervisor
9075 North Meridian Street
Indianapolis, IN 46260
T 317.587.1716
F 317.708.3523
E Connie.Price@altour.com
www.altour.com

________________________________________
From: Tom Davies [tomdavies04@yahoo.co.uk]
Sent: Thursday, July 25, 2013 2:37 PM
To: Users@Global.LibreOffice.Org
Subject: [libreoffice-users] desktop integration working now? Re: [tdf-announce] LibreOffice 4.1: a 
landmark for interoperability

Hi :)
Now that the 4.1.0 has been properly released you might find the proper release has all the desktop 
integration sorted out now.  it might be worth checking if you are keen and have the time
Good luck and regards from

Tom :)






> ________________________________
> From: Italo Vignoli <italo.vignoli@documentfoundation.org>
> To: announce@documentfoundation.org
> Sent: Thursday, 25 July 2013, 13:00
> Subject: [tdf-announce] LibreOffice 4.1: a landmark for interoperability
>
>
> The office suite features a large number of improvements which bring
> compatibility with proprietary and legacy file formats to the next level
>
> Berlin, July 25, 2013 - The Document Foundation announces LibreOffice
> 4.1, not only the best but also the most interoperable free office suite
> ever. LibreOffice 4.1 features a large number of improvements in the
> area of document compatibility, which increases the opportunities of
> sharing knowledge with users of proprietary software while retaining the
> original layout and contents.
>
> Interoperability is a key asset for LibreOffice, which is the de facto
> standard for migrations to free office suites since early 2012. Numerous
> improvements have been made to Microsoft OOXML import and export
> filters, as well as to legacy Microsoft Office and RTF file filters.
> Most of these improvements derive from the fundamental activity of
> certified developers backing migration projects, based on a professional
> support agreement.
>
> Instrumental for interoperability are also new features such as font
> embedding in Writer, Calc, Impress and Draw - which helps in retaining
> the visual aspect when fonts used to produce the document are not
> installed on the target PC - and import and export functions new in
> Excel 2013 for ODF OpenFormula compatibility.
>
> In addition to interoperability, LibreOffice 4.1 offers a very large
> number of new features and improvements also in other areas of the
> suite, which are listed here:
> https://www.libreoffice.org/download/4-1-new-features-and-fixes.
>
> LibreOffice 4.1 is also importing some AOO features, including the
> Symphony sidebar, which is considered experimental. LibreOffice
> developers are working at the integration with the widget layout
> technique (which will make it dynamically resizeable and consistent with
> the behaviour of LibreOffice dialog windows).
>
> LibreOffice 4.1 arrives at the end of a significant development process,
> which has just been outlined on the foundation blog:
> http://wp.me/p1byPE-q0. Feature wise, the summary is here:
> https://www.libreoffice.org/features/why-libreoffice/.
>
> In just two months, on September 25, 2013, the LibreOffice community
> will gather in Italy at the Third LibreOffice Conference, hosted by the
> Department of Computer Science of Milan State University. More
> information on the conference web site at the following address:
> http://conference.libreoffice.org/2013/en. The Call for Paper is open
> until Sunday, August 4.
>
> Downloading LibreOffice
>
> LibreOffice 4.1 is immediately available for download from the following
> link: http://www.libreoffice.org/download/. Extensions for LibreOffice
> are available from the following link:
> http://extensions.libreoffice.org/extension-center.
>
> Changelogs are available at
> https://wiki.documentfoundation.org/Releases/4.1.0/RC1 (changed in
> 4.1.0.1), https://wiki.documentfoundation.org/Releases/4.1.0/RC2
> (changed in 4.1.0.2) and
> https://wiki.documentfoundation.org/Releases/4.1.0/RC3 (changed in
> 4.1.0.3) and https://wiki.documentfoundation.org/Releases/4.1.0/RC4
> (changed in 4.1.0.4).
>
> Support The Document Foundation
>
> LibreOffice users, free software advocates and community members can
> support The Document Foundation with a donation at
> http://donate.libreoffice.org. Money collected will be used to grow the
> infrastructure, and support marketing activities to increase the
> awareness of the project, both at global and local level.
>
> Short link to post on TDF blog: http://wp.me/p1byPE-qn.
>
> --
> Italo Vignoli - Director
> italo.vignoli@documentfoundation.org
> mob +39.348.5653829 - sip italo@libreoffice.org
> The Document Foundation
> Zimmerstraße 69, 10117 Berlin, Germany
> Rechtsfähige Stiftung des bürgerlichen Rechts
> Legal Details: www.documentfoundation.org/imprint
>
> --
> To unsubscribe e-mail to: announce+unsubscribe@documentfoundation.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> List archive: http://listarchives.documentfoundation.org/www/announce/
--
To unsubscribe e-mail to: users+unsubscribe@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+unsubscribe@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