Issue 68515 - Calc - Subtotals can't be automated with the macro
Summary: Calc - Subtotals can't be automated with the macro
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: 680m176
Hardware: PC Windows, all
: P3 Trivial with 3 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Blocks: 20046
  Show dependency tree
Reported: 2006-08-11 07:59 UTC by kpalagin
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

example file for the issue (8.65 KB, application/vnd.oasis.opendocument.spreadsheet)
2006-08-11 08:00 UTC, kpalagin
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description kpalagin 2006-08-11 07:59:11 UTC
If I include calculation of subtotals in macro, execution of macro stops 
displaying Subtotals dialog.

Repro steps - open attached file, agree to Enable Macros, click Tools, Macros, 
Run, expand "macro-with-subtotals"\Standard\Module1, in "Macro Name" 
select "Main" and click Run. It will not run to copletion.

Please make it so that Subtotals can be inserted with macro.
Thanks a lot!
Comment 1 kpalagin 2006-08-11 08:00:31 UTC
Created attachment 38434 [details]
example file for the issue
Comment 2 jjmckenzie 2006-08-12 06:34:33 UTC
I managed to look at the macro:

I don't think this is what you want:

REM  *****  BASIC  *****

sub Main
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("")

rem ----------------------------------------------------------------------
dispatcher.executeDispatch(document, ".uno:DataSubTotals", "", 0, Array())

end sub

I will confirm that the macro does not work.

James M.
Comment 3 andrew 2006-08-24 04:56:57 UTC
So what you really want, is that the dispatch will accept arguments containing
all of the information required to create the subtotal without opening a dialog
or requiring any sort of user interaction.

Realize that at the moment, the macro recorder noticed that you opened the
dialog, but it does not record what you do in the dialog.
Comment 4 kpalagin 2006-08-24 12:26:40 UTC
you are absolutely correct.
Somebody have changed to RFE already.
Comment 5 frank 2006-08-24 13:37:00 UTC
one for requirements