Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

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

Connie Price
Accounting Supervisor
9075 North Meridian Street
Indianapolis, IN 46260
T 317.587.1716
F 317.708.3523

From: Tom Davies []
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 <>
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:

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: Feature wise, the summary is here:

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: The Call for Paper is open
until Sunday, August 4.

Downloading LibreOffice

LibreOffice 4.1 is immediately available for download from the following
link: Extensions for LibreOffice
are available from the following link:

Changelogs are available at (changed in,
(changed in and (changed in and
(changed in

Support The Document Foundation

LibreOffice users, free software advocates and community members can
support The Document Foundation with a donation at 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:

Italo Vignoli - Director
mob +39.348.5653829 - sip
The Document Foundation
Zimmerstraße 69, 10117 Berlin, Germany
Rechtsfähige Stiftung des bürgerlichen Rechts
Legal Details:

To unsubscribe e-mail to:
List archive:

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted
To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.