I concur with Brian.  Also one of the problems that Excell users have who use VBscript is specifically because they are dependent on a Microsoft proprietary language.  LibreOffice has tried to ameliorate that with it's Basic like scripting but does have a long way to go in that regard.

I have been using OpenOffice and LibreOffice for years and no longer have any spreadsheets in Excel (or anything in MS Office), but I have never seen any serious problems other than figuring out how to accomplish certain tasks.  Excel truly has been best of class for years.  I just don't need to pay for it for anything I still do.


On Fri, Sep 27, 2013 at 4:59 PM, Brian Cluff <brian@snaptek.com> wrote:
If you are seeing that, I would encourage you to upgrade.  That is some basic functionality that is not working for you.  I've never seen such a basic bug before.

Brian


On 09/27/2013 02:52 PM, Michael Havens wrote:
3.6.2.2
If I remember correctly it happens sporadically.

:-)~MIKE~(-:


On Fri, Sep 27, 2013 at 2:06 PM, Brian Cluff <brian@snaptek.com
<mailto:brian@snaptek.com>> wrote:

    What version are you using, because I definitely can't reproduce
    that. If I delete any of the cells, the answer is correct.

    Brian


    On 09/27/2013 12:53 PM, Michael Havens wrote:

        here is a good example... I found if I delete cells that
        functions are
        performed on (cell1+cell2=cell3) the total isn't recalculated (cell3
        isn't right).

        :-)~MIKE~(-:


        On Fri, Sep 27, 2013 at 11:34 AM, Paul Mooring <paul@opscode.com
        <mailto:paul@opscode.com>
        <mailto:paul@opscode.com <mailto:paul@opscode.com>>> wrote:

             I'm not really much of an office suite user, but my
        experience and
             the feedback I've heard has always been yes it is bad
        compared to MS
             Office.  I think Libre/Open office covers 90% of use cases
        and is
             more than capable of handling what most users need, however
        it's
             interface isn't nearly as good, it lacks the vbscript
        macros the
             rest of the world uses, it's charting/graphs don't look as
        nice and
             formatting comes out mangled when excel users open it (or
        when you
             open an xlsx).  Microsoft has invested a lot of time, money and
             energy into getting Excel just right and it really is a
        great (if
             not their best) product.  The heavy excel users I know that
        don't
             run Windows keep a Win7 VM around for Office/Excel use.

             As a side note I think one thing that the Linux/FLOSS
        community is
             very bad at is learning from what others get right.  You
        might not
             like Microsoft but to claim their popularity was in no way
        due to
             making some good products is disingenuous at best.  If people
             genuinely care about increasing Linux desktop usage (which
        is not of
             any particular interest to me personally) the right
        questions to ask
             are about what MS and Apple get right rather than what they
        get wrong.


             On Fri, Sep 27, 2013 at 10:54 AM, <kitepilot@kitepilot.com
        <mailto:kitepilot@kitepilot.com>
             <mailto:kitepilot@kitepilot.__com

        <mailto:kitepilot@kitepilot.com>>> wrote:

                 So I talked my brother into ditching Micro$haft and
        moving to Linux.
                 Baaaad idea...
                 The man uses Excel *HEAVILY*, and LibreOffice just
        could not
                 keep up.
                 But it was not lack of features or limitations, it was
        *STUPID*
                 (but dangerous) things like cells not showing the real
        value
                 and/or recalculating wrong.
                 I didn't take his word for it, he showed me the
        (unbelievable)
                 problems (I could not believe what I was seeing).
                 The guy is back to Excel...
                 What am I missing?
                 ET
                 ------------------------------____---------------------
                 PLUG-discuss mailing list -
        PLUG-discuss@lists.phxlinux.____org
                 <mailto:PLUG-discuss@lists.__phxlinux.org

        <mailto:PLUG-discuss@lists.phxlinux.org>>

                 To subscribe, unsubscribe, or to change your mail settings:
        http://lists.phxlinux.org/____mailman/listinfo/plug-discuss
        <http://lists.phxlinux.org/__mailman/listinfo/plug-discuss>



        <http://lists.phxlinux.org/__mailman/listinfo/plug-discuss
        <http://lists.phxlinux.org/mailman/listinfo/plug-discuss>>




             --
             Paul Mooring
             Operations Engineer
             Opscode, Inc.



             ------------------------------__---------------------
             PLUG-discuss mailing list -
        PLUG-discuss@lists.phxlinux.__org
        <mailto:PLUG-discuss@lists.phxlinux.org>
             <mailto:PLUG-discuss@lists.__phxlinux.org

        <mailto:PLUG-discuss@lists.phxlinux.org>>

             To subscribe, unsubscribe, or to change your mail settings:
        http://lists.phxlinux.org/__mailman/listinfo/plug-discuss
        <http://lists.phxlinux.org/mailman/listinfo/plug-discuss>




        ------------------------------__---------------------
        PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.__org
        <mailto:PLUG-discuss@lists.phxlinux.org>
        To subscribe, unsubscribe, or to change your mail settings:
        http://lists.phxlinux.org/__mailman/listinfo/plug-discuss
        <http://lists.phxlinux.org/mailman/listinfo/plug-discuss>


    ------------------------------__---------------------
    PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.__org
    <mailto:PLUG-discuss@lists.phxlinux.org>
    To subscribe, unsubscribe, or to change your mail settings:
    http://lists.phxlinux.org/__mailman/listinfo/plug-discuss
    <http://lists.phxlinux.org/mailman/listinfo/plug-discuss>




---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org
To subscribe, unsubscribe, or to change your mail settings:
http://lists.phxlinux.org/mailman/listinfo/plug-discuss


---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org
To subscribe, unsubscribe, or to change your mail settings:
http://lists.phxlinux.org/mailman/listinfo/plug-discuss



--
Dazed_75 a.k.a. Larry

Please protect my address like I protect yours. When sending messages to multiple recipients, use the BCC: (Blind carbon copy). Remove addresses from a forwarded message body before clicking Send.