Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.os.linux.advocacy > #348250
| From | owl <owl@rooftop.invalid> |
|---|---|
| Newsgroups | comp.os.linux.advocacy |
| Subject | Re: Can anyone defend LibreOffice Calc 2016 crapware against MS Excel 2003? |
| Date | 2016-03-31 21:01 +0000 |
| Organization | O.W.L. |
| Message-ID | <hjgkd9303.ajg9@rooftop.invalid> (permalink) |
| References | <ndduik$s24$3@dont-email.me> <hjg03.ahpa4t@rooftop.invalid> <ndgok2$fkt$1@dont-email.me> <hjgi30a.af3io@rooftop.invalid> <ndjqp5$qqu$1@dont-email.me> |
DFS <nospam@dfs.com> wrote:
> On 3/30/2016 2:09 PM, owl wrote:
>
>
>> 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.
>
> Yes. eg, rather than adding new Excel features and Ribbon changes, MS
> should tackle the issues in their statistical implementations.
>
It's all about the shiny stuff. (Not just for MS -- it's a pandemic
disease).
>
>
>> 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.
>
> Wonderful. I'd prefer it to faithfully record all keystrokes and mouse
> actions, or the results of them. Whatever is appropriate. Without me
> having to work around their limitations.
>
>
> ========================================================================
> Put a value in every other cell
> ========================================================================
> Excel
> Range("D4").Select
> ActiveCell.FormulaR1C1 = "1"
> Range("D6").Select
> ActiveCell.FormulaR1C1 = "2"
> Range("D8").Select
> ActiveCell.FormulaR1C1 = "3"
>
> Note Excel didn't record the (arrow down) keystrokes where I skipped
> over a cell. If I hit Enter to move down, it doesn't record that either.
>
>
> Calc
> dim document as object
[holy shit].
> args9(0).Value = 1
> args9(1).Name = "Sel"
> args9(1).Value = false
> dispatcher.executeDispatch(document, ".uno:GoDown", "", 0, args9())
>
> That's all for one mouse click, 3 numbers entered, and 3 down arrows?
> Insano!
>
> If you use the Enter key to move down, it records fewer lines but
> records 'JumpToNextCell', and then it becomes hard or impossible to
> follow what the macro is doing.
>
> The LO macro recorder seems to try and capture every keystroke, plus up
> to 4 actions or properties per cell, even if you didn't do anything
> except skip over it.
>
> MS Office is doomed.
>
The easiest way to record a sum() macro in LO is to just click
the sigma button, paint the range, and hit enter. Below is the
generated code for that. The resulting macro, when run, puts
the formula in the current cell, but the summed range is not
relative to the current cell; it's the fixed range you selected.
sub test8
rem ----------------------------------------------------------------------
rem define variables
dim document as object
dim dispatcher as object
rem ----------------------------------------------------------------------
rem get access to the document
document = ThisComponent.CurrentController.Frame
dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")
rem ----------------------------------------------------------------------
dim args1(0) as new com.sun.star.beans.PropertyValue
args1(0).Name = "StringName"
args1(0).Value = "=SUM(A1:A17)"
dispatcher.executeDispatch(document, ".uno:EnterString", "", 0, args1())
end sub
Back to comp.os.linux.advocacy | Previous | Next — Previous in thread | Find similar | Unroll 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