Groups > comp.os.linux.advocacy > #348147

Re: Can anyone defend LibreOffice Calc 2016 crapware against MS Excel 2003?

Path	csiph.com!xmission!news.alt.net!not-for-mail
From	owl <owl@rooftop.invalid>
Newsgroups	comp.os.linux.advocacy
Subject	Re: Can anyone defend LibreOffice Calc 2016 crapware against MS Excel 2003?
Date	Wed, 30 Mar 2016 18:09:17 +0000 (UTC)
Organization	O.W.L.
Lines	48
Message-ID	<hjgi30a.af3io@rooftop.invalid> (permalink)
References	<ndduik$s24$3@dont-email.me> <hjg03.ahpa4t@rooftop.invalid> <ndgok2$fkt$1@dont-email.me>
NNTP-Posting-Host	boom.rooftop.invalid
User-Agent	tin/2.2.1-20140504 ("Tober an Righ") (UNIX) (Linux/3.16.0-4-amd64 (x86_64))
Xref	csiph.com comp.os.linux.advocacy:348147

Show key headers only | View raw

DFS <nospam@dfs.com> wrote:
> On 3/29/2016 1:04 PM, owl wrote:
>> DFS <nospam@dfs.com> wrote:
>>> LibreOffice Calc 5.1.0.3 (released early Feb 2016)
>>> Excel 2003 (released Aug 2003 - 11.5 years ago)
>>>
>> ...
>>>
>>>
>>> LMAO!   38 lines of code in LO Calc vs 9 in Excel?
>>>
>>> And when you run the macro you just recorded, Excel works flawlessly (it
>>> always has), but LibreOffice doesn't even put the formula in A4.  It's
>>> like it arbitrarily quits recording keystrokes.
>>>
>>
>> Verified.
> 
> Congrats.  You've now done more testing than the entire LibreOffice Calc 
> development "team".
> 

The macro recorder thing in OO/LO has never been that great.  I don't
use OO much.  I generally use sc or gnumeric for spreadsheets and
text editor + latex for pretty-print text stuff.  I do wish developers
in general would focus on core functionality perfection over UI changes. 


> 
> 
>> Testing shows that LO will record a function if you type the function
>> first, then put the "=".
>>
>> ex.
>> type: "sum(a1:a3)" in a cell.
>> go back and put the "=" sign in front of th sum().
> 
> That's bass-ackwards, but at least it works.
> 
> Also, note I never typed the range a1:a3.  I selected the range with the 
> keyboard.  Excel then recorded the range as a reference relative to the 
> cell containing the formula.
> 

You can also type the "=sum(...)" directly into the formula bar and use
the mouse to paint the range.  The macro recorder will correctly record
those actions.

Back to comp.os.linux.advocacy | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Can anyone defend LibreOffice Calc 2016 crapware against MS Excel 2003? DFS <nospam@dfs.com> - 2016-03-29 09:08 -0400
  Can anyone defend MS Excel 2003 crapware against LibreOffice Calc 2016? 7 <7@enemygadgets.com> - 2016-03-29 14:17 +0000
    Re: Can anyone defend MS Excel 2003 crapware against LibreOffice Calc 2016? Desk Rabbit <me@example.com> - 2016-03-29 15:50 +0100
      Re: Can anyone defend MS Excel 2003 crapware against LibreOffice Calc 2016? Me Sham <osirus47@yahoo.com> - 2016-03-29 07:54 -0700
        Re: Can anyone defend MS Excel 2003 crapware against LibreOffice Calc 2016? Somebody <somebody@nowhere.net> - 2016-03-29 12:33 -0400
          Somebody's lying Chris Ahlstrom <OFeem1987@teleworm.us> - 2016-03-29 15:47 -0400
            Re: Somebody's lying chrisv <chrisv@nospam.invalid> - 2016-03-29 15:04 -0500
              Re: Somebody's lying Chris Ahlstrom <OFeem1987@teleworm.us> - 2016-03-29 20:37 -0400
                Re: Somebody's lying chrisv <chrisv@nospam.invalid> - 2016-03-30 07:28 -0500
                Re: Somebody's lying Me Sham <osirus47@yahoo.com> - 2016-03-30 06:23 -0700
                Re: Somebody's lying Chris Ahlstrom <OFeem1987@teleworm.us> - 2016-03-30 11:53 -0400
                Re: Somebody's lying Me Sham <osirus47@yahoo.com> - 2016-03-30 10:26 -0700
                Re: Somebody's lying Chris Ahlstrom <OFeem1987@teleworm.us> - 2016-03-30 14:11 -0400
                Re: Somebody's lying chrisv <chrisv@nospam.invalid> - 2016-03-30 13:23 -0500
                Re: Somebody's lying Chris Ahlstrom <OFeem1987@teleworm.us> - 2016-03-30 15:08 -0400
                Re: Somebody's lying Me Sham <osirus47@yahoo.com> - 2016-03-30 13:27 -0700
                Re: Somebody's lying -hh <recscuba_google@huntzinger.com> - 2016-04-01 02:37 -0700
              Re: Somebody's lying vallor <vallor@cultnix.org> - 2016-03-30 20:56 +0000
    Re: Can anyone defend MS Excel 2003 crapware against LibreOffice Calc 2016? DFS <nospam@dfs.com> - 2016-03-29 10:58 -0400
    Can anyone defend ignorant k00k DFS? Chris Ahlstrom <OFeem1987@teleworm.us> - 2016-03-29 11:43 -0400
      Re: Can anyone defend ignorant k00k DFS? Desk Rabbit <me@example.com> - 2016-03-29 16:56 +0100
        Re: Can anyone defend ignorant k00k DFS? 7 <7@enemygadgets.com> - 2016-03-29 16:18 +0000
          Re: Can anyone defend ignorant k00k DFS? Desk Rabbit <me@example.com> - 2016-03-29 17:34 +0100
            Re: Can anyone defend ignorant k00k DFS? Somebody <somebody@nowhere.net> - 2016-03-29 12:56 -0400
              Re: Can anyone defend ignorant k00k DFS? Chris Ahlstrom <OFeem1987@teleworm.us> - 2016-03-29 15:45 -0400
                Re: Can anyone defend ignorant k00k DFS? Desk Rabbit <me@example.com> - 2016-03-31 09:19 +0100
            Re: Can anyone defend ignorant k00k DFS? 7 <7@enemygadgets.com> - 2016-03-29 19:40 +0000
        Re: Can anyone defend ignorant k00k DFS? Somebody <somebody@nowhere.net> - 2016-03-29 12:37 -0400
      Re: Can anyone defend MS Excel 2003 crapware against LibreOffice Calc 2016? DFS <nospam@dfs.com> - 2016-03-29 14:55 -0400
  Re: Can anyone defend LibreOffice Calc 2016 crapware against MS Excel 2003? owl <owl@rooftop.invalid> - 2016-03-29 17:04 +0000
    Re: Can anyone defend LibreOffice Calc 2016 crapware against MS Excel 2003? owl <owl@rooftop.invalid> - 2016-03-29 18:20 +0000
    Re: Can anyone defend LibreOffice Calc 2016 crapware against MS Excel 2003? DFS <nospam@dfs.com> - 2016-03-29 15:16 -0400
      Re: Can anyone defend LibreOffice Calc 2016 crapware against MS Excel 2003? owl <owl@rooftop.invalid> - 2016-03-29 19:24 +0000
        Re: Can anyone defend LibreOffice Calc 2016 crapware against MS Excel 2003? Snit <usenet@gallopinginsanity.com> - 2016-03-29 19:22 -0700
          Re: Can anyone defend LibreOffice Calc 2016 crapware against MS Excel 2003? Crusher <crusher4rockpile@mail.com> - 2016-03-29 22:28 -0400
          Re: Can anyone defend LibreOffice Calc 2016 crapware against MS Excel 2003? "Dr. John Grubor" <grubor@grubor.invalid> - 2016-03-30 11:27 +0000
    Re: Can anyone defend LibreOffice Calc 2016 crapware against MS Excel 2003? DFS <nospam@dfs.com> - 2016-03-30 10:45 -0400
      Re: Can anyone defend LibreOffice Calc 2016 crapware against MS Excel 2003? owl <owl@rooftop.invalid> - 2016-03-30 18:09 +0000
        Re: Can anyone defend LibreOffice Calc 2016 crapware against MS Excel 2003? DFS <nospam@dfs.com> - 2016-03-31 14:40 -0400
          Re: Can anyone defend LibreOffice Calc 2016 crapware against MS Excel 2003? owl <owl@rooftop.invalid> - 2016-03-31 21:01 +0000

csiph-web