<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <div class="moz-cite-prefix">Extraordinary claims require
      extraordinary evidence (or proof depending on who you quote).<br>
      <br>
      I use Libre Office on Ubuntu daily for manipulating and fixing all
      kinds of data. I have never had it, "do math wrong".  I have
      however had it completely fail to import Microsoft Excel files
      with complex formatting.<br>
      <br>
      The fundamental way that spreadsheets handle math could easily be
      the issue, for example most spreadsheets interpret a string as a
      literal zero, if a column is incorrectly formatted this could
      produce an incorrect result. Range errors , auto range extension,
      filters, and formula processing order can also skew the results.<br>
      <br>
      If the spreadsheet is so complicated, it probably shouldn't be a
      spreadsheet in the first place.  Some of the links posted by
      Justin have quite strong arguments in that regard.<br>
      <br>
      I would be willing to bet lunch for one (loser buys) that the
      issue is not a math bug in Calc, but some other issue inherent to
      spreadsheets or import / user error.<br>
      <br>
      --Jason<br>
      <br>
      On 9/28/13 2:38 PM, Stephen Kraus wrote:<br>
    </div>
    <blockquote
cite="mid:CAN1egVA318i08u2CK6yC9AC+FTCt0tFCmaxOkpBq6ior4HwK5w@mail.gmail.com"
      type="cite">
      <div dir="ltr">OpenOffice works awesome for me in my Physics and
        Math classes, because it comes with a formula writer and layout
        program, makes it so much easier than having to try writing up a
        couple pages worth of formulas.<br>
        <br>
        Its done well for me in every other category too.</div>
      <div class="gmail_extra"><br>
        <br>
        <div class="gmail_quote">On Sat, Sep 28, 2013 at 2:07 PM, wes <span
            dir="ltr"><<a moz-do-not-send="true"
              href="mailto:wes@the-wes.com" target="_blank">wes@the-wes.com</a>></span>
          wrote:<br>
          <blockquote class="gmail_quote" style="margin:0 0 0
            .8ex;border-left:1px #ccc solid;padding-left:1ex">
            <div dir="ltr">That's right, when trying to convince someone
              to use open source software, we should proclaim it a
              failure and do nothing to help the situation.
              <div>
                <br>
              </div>
              <div>Troll.<span class="HOEnZb"><font color="#888888"><br>
                    <div><br>
                    </div>
                    <div>-wes</div>
                  </font></span></div>
            </div>
            <div class="HOEnZb">
              <div class="h5">
                <div class="gmail_extra"><br>
                  <br>
                  <div class="gmail_quote">On Sat, Sep 28, 2013 at 10:58
                    AM, Chad Smith <span dir="ltr"><<a
                        moz-do-not-send="true"
                        href="mailto:chad78@gmail.com" target="_blank">chad78@gmail.com</a>></span>
                    wrote:<br>
                    <blockquote class="gmail_quote" style="margin:0 0 0
                      .8ex;border-left:1px #ccc solid;padding-left:1ex">
                      <div dir="ltr">Also, when you are trying to
                        convince someone to switch to open source
                        software, the last thing you should have to do
                        is stop in the middle of it and file a bug
                        report.</div>
                      <div class="gmail_extra"><br clear="all">
                        <div><font size="4"><i><span
                                style="font-family:garamond,serif">-</span><font
                                style="font-family:garamond,serif"> Chad
                                W. Smith</font></i></font></div>
                        <div>
                          <div>
                            <br>
                            <br>
                            <div class="gmail_quote">On Sat, Sep 28,
                              2013 at 12:56 PM, Chad Smith <span
                                dir="ltr"><<a moz-do-not-send="true"
                                  href="mailto:chad78@gmail.com"
                                  target="_blank">chad78@gmail.com</a>></span>
                              wrote:<br>
                              <blockquote class="gmail_quote"
                                style="margin:0 0 0 .8ex;border-left:1px
                                #ccc solid;padding-left:1ex">
                                <div dir="ltr">This isn't some Microsoft
                                  shill.  ET has been on this list for a
                                  long time.  Why would he lie?</div>
                                <div class="gmail_extra"><br clear="all">
                                  <div><font size="4"><i><span
                                          style="font-family:garamond,serif">-</span><font
style="font-family:garamond,serif"> Chad W. Smith</font></i></font>
                                    <div>
                                    </div>
                                  </div>
                                  <div>
                                    <div>
                                      <br>
                                      <br>
                                      <div class="gmail_quote">On Sat,
                                        Sep 28, 2013 at 12:43 PM,
                                        William Roush <span dir="ltr"><<a
                                            moz-do-not-send="true"
                                            href="mailto:william.roush@roushtech.net"
                                            target="_blank">william.roush@roushtech.net</a>></span>
                                        wrote:<br>
                                        <blockquote class="gmail_quote"
                                          style="margin:0 0 0
                                          .8ex;border-left:1px #ccc
                                          solid;padding-left:1ex">
                                          You want evidence to huge
                                          claims? That's absurd! I can't
                                          be bothered to back them up.<br>
                                          <br>
                                          Also how about a bug number
                                          instead... You know doing the
                                          right thing for open source
                                          software you get for free and
                                          reporting issues.
                                          <div>
                                            <div><br>
                                              <br>
                                              Chad Smith <<a
                                                moz-do-not-send="true"
                                                href="mailto:chad78@gmail.com"
                                                target="_blank">chad78@gmail.com</a>>
                                              wrote:<br>
                                              <br>
                                              <div dir="ltr">Yeah,
                                                because everyone
                                                remembers every math
                                                problem they ever did.</div>
                                              <div class="gmail_extra">
                                                <br clear="all">
                                                <div><font size="4"><i><span
style="font-family:garamond,serif">-</span><font
                                                        style="font-family:garamond,serif">
                                                        Chad W. Smith</font></i></font>
                                                  <div>
                                                  </div>
                                                </div>
                                                <br>
                                                <br>
                                                <div class="gmail_quote">On
                                                  Sat, Sep 28, 2013 at
                                                  11:54 AM, wes <span
                                                    dir="ltr"><<a
                                                      moz-do-not-send="true"
href="mailto:wes@the-wes.com" target="_blank">wes@the-wes.com</a>></span>
                                                  wrote:<br>
                                                  <blockquote
                                                    class="gmail_quote"
                                                    style="margin:0 0 0
                                                    .8ex;border-left:1px
                                                    #ccc
                                                    solid;padding-left:1ex">
                                                    <div dir="ltr">
                                                      <div>On Sat, Sep
                                                        28, 2013 at 7:32
                                                        AM, <span
                                                          dir="ltr"><<a
moz-do-not-send="true" href="mailto:kitepilot@kitepilot.com"
                                                          target="_blank">kitepilot@kitepilot.com</a>></span>
                                                        wrote:<br>
                                                      </div>
                                                      <div
                                                        class="gmail_extra">
                                                        <div
                                                          class="gmail_quote">
                                                          <div>
                                                          <blockquote
                                                          class="gmail_quote"
                                                          style="margin:0px
                                                          0px 0px
0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">Just
                                                          to clarify:
                                                          <div><br>
                                                          <blockquote
                                                          class="gmail_quote"
                                                          style="margin:0px
                                                          0px 0px
0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">the
                                                          program *DID
                                                          MATH WRONG*.<br>
                                                          </blockquote>
                                                          </div>
                                                          means just
                                                          that.<br>
                                                          No excel
                                                          import, no
                                                          weird things
                                                          here.<br>
                                                          This was
                                                          freshly
                                                          created
                                                          (albeit
                                                          complex)
                                                          spreadsheet.<br>
                                                          Cells would
                                                          display wrong
                                                          numbers or not
                                                          at all.<br>
                                                          I could
                                                          position the
                                                          cursor in a
                                                          cell and see a
                                                          simple formula
                                                          yielding a bad
                                                          result. <br>
                                                          This were
                                                          problems that
                                                          you'd figure
                                                          basic testing
                                                          would catch.<br>
                                                          It was, in
                                                          short,
                                                          completely
                                                          unreliable...
                                                            :(<br>
                                                          ET <br>
                                                          </blockquote>
                                                          <div><br>
                                                          </div>
                                                          </div>
                                                          <div>if it was
                                                          just a simple
                                                          formula, you
                                                          should be able
                                                          to give us the
                                                          formula.<span><font
color="#888888">
                                                          <div><br>
                                                          </div>
                                                          <div>-wes</div>
                                                          </font></span></div>
                                                          <div>
                                                          <div> </div>
                                                          <blockquote
                                                          class="gmail_quote"
                                                          style="margin:0px
                                                          0px 0px
0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><br>
                                                          <br>
                                                          Chad Smith
                                                          writes: <br>
                                                          <blockquote
                                                          class="gmail_quote"
                                                          style="margin:0px
                                                          0px 0px
0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
                                                          <div>
                                                          <div>
                                                          Everyone who
                                                          going to bat
                                                          for
                                                          LibreOffice -
                                                          did you miss
                                                          the part where
                                                          ET<br>
                                                          said that the
                                                          program *DID
                                                          MATH WRONG*. <br>
                                                          That's not
                                                          some "obscure
                                                          feature set"
                                                          needed only by
                                                          "power users"
                                                          or<br>
                                                          people who are
                                                          afraid of
                                                          change....
                                                          That's the one
                                                          thing that no<br>
                                                          **computer**
                                                          program should
                                                          ever get
                                                          wrong. <br>
                                                          COMPUTER...
                                                           it computes.
                                                           That is its
                                                          original
                                                          intention.
                                                           It's native<br>
                                                          language is 1s
                                                          and 0s.  A
                                                          computer
                                                          spreadsheet
                                                          that can't do
                                                          math correctly<br>
                                                          is not just
                                                          useless - it's
                                                          dangerous and
                                                          should be
                                                          avoided like
                                                          the plague. <br>
                                                          I like the
                                                          idea of
                                                          Libre/Open
                                                          Office.  It is
                                                          what
                                                          introduced me
                                                          to open<br>
                                                          source as
                                                          being a thing
                                                          that exists.
                                                           But if Calc
                                                          (the name of
                                                          the<br>
                                                          Spreadsheet
                                                          mode of the
                                                          program) can't
                                                          Calculate - it
                                                          shouldn't be
                                                          allowed<br>
                                                          to continue to
                                                          exist... not
                                                          until they fix
                                                          that.  omg. <br>
                                                          </div>
                                                          </div>
                                                          *- Chad W.
                                                          Smith*<br>
                                                          </blockquote>
                                                          <div>
                                                          <div>
_______________________________________________<br>
                                                          Chugalug
                                                          mailing list<br>
                                                          <a
                                                          moz-do-not-send="true"
href="mailto:Chugalug@chugalug.org" target="_blank">Chugalug@chugalug.org</a><br>
                                                          <a
                                                          moz-do-not-send="true"
href="http://chugalug.org/cgi-bin/mailman/listinfo/chugalug"
                                                          target="_blank">http://chugalug.org/cgi-bin/mailman/listinfo/chugalug</a><br>
                                                          </div>
                                                          </div>
                                                          </blockquote>
                                                          </div>
                                                        </div>
                                                        <br>
                                                      </div>
                                                    </div>
                                                    <br>
_______________________________________________<br>
                                                    Chugalug mailing
                                                    list<br>
                                                    <a
                                                      moz-do-not-send="true"
href="mailto:Chugalug@chugalug.org" target="_blank">Chugalug@chugalug.org</a><br>
                                                    <a
                                                      moz-do-not-send="true"
href="http://chugalug.org/cgi-bin/mailman/listinfo/chugalug"
                                                      target="_blank">http://chugalug.org/cgi-bin/mailman/listinfo/chugalug</a><br>
                                                    <br>
                                                  </blockquote>
                                                </div>
                                                <br>
                                              </div>
                                            </div>
                                          </div>
                                          <br>
_______________________________________________<br>
                                          Chugalug mailing list<br>
                                          <a moz-do-not-send="true"
                                            href="mailto:Chugalug@chugalug.org"
                                            target="_blank">Chugalug@chugalug.org</a><br>
                                          <a moz-do-not-send="true"
                                            href="http://chugalug.org/cgi-bin/mailman/listinfo/chugalug"
                                            target="_blank">http://chugalug.org/cgi-bin/mailman/listinfo/chugalug</a><br>
                                          <br>
                                        </blockquote>
                                      </div>
                                      <br>
                                    </div>
                                  </div>
                                </div>
                              </blockquote>
                            </div>
                            <br>
                          </div>
                        </div>
                      </div>
                      <br>
                      _______________________________________________<br>
                      Chugalug mailing list<br>
                      <a moz-do-not-send="true"
                        href="mailto:Chugalug@chugalug.org"
                        target="_blank">Chugalug@chugalug.org</a><br>
                      <a moz-do-not-send="true"
                        href="http://chugalug.org/cgi-bin/mailman/listinfo/chugalug"
                        target="_blank">http://chugalug.org/cgi-bin/mailman/listinfo/chugalug</a><br>
                      <br>
                    </blockquote>
                  </div>
                  <br>
                </div>
              </div>
            </div>
            <br>
            _______________________________________________<br>
            Chugalug mailing list<br>
            <a moz-do-not-send="true"
              href="mailto:Chugalug@chugalug.org">Chugalug@chugalug.org</a><br>
            <a moz-do-not-send="true"
              href="http://chugalug.org/cgi-bin/mailman/listinfo/chugalug"
              target="_blank">http://chugalug.org/cgi-bin/mailman/listinfo/chugalug</a><br>
            <br>
          </blockquote>
        </div>
        <br>
      </div>
      <br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <br>
      <pre wrap="">_______________________________________________
Chugalug mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Chugalug@chugalug.org">Chugalug@chugalug.org</a>
<a class="moz-txt-link-freetext" href="http://chugalug.org/cgi-bin/mailman/listinfo/chugalug">http://chugalug.org/cgi-bin/mailman/listinfo/chugalug</a>
</pre>
    </blockquote>
    <br>
  </body>
</html>