Bug 35593 - macro themecolor - tintandshade - patterntintandshade are all problems.
Summary: macro themecolor - tintandshade - patterntintandshade are all problems.
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: BASIC (show other bugs)
Version:
(earliest affected)
3.3.0 release
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Macro-VBA
  Show dependency tree / graph
 
Reported: 2011-03-23 08:14 UTC by jkonecny
Modified: 2020-07-04 04:52 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
tintandshade demo file (23.76 KB, application/vnd.ms-excel.sheet.macroEnabled.12)
2020-07-04 04:51 UTC, johnks 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description jkonecny 2011-03-23 08:14:30 UTC 
The macro below which which came over from an unknown version of excel does not run.  themecolor - tintandshade - patterntintandshade are all problems.

Rem Attribute VBA_ModuleType=VBAModule
Option VBASupport 1
Sub WhiteReset()
'
' WhiteReset Macro
'
' Keyboard Shortcut: Ctrl+w
'
    ActiveCell.Range("A1:B1").Select
    With Selection.Interior
        .Pattern = xlSolid
        .PatternColorIndex = xlAutomatic
        .PatternTintAndShade = 0
    End With
    With Selection.Font
        .ColorIndex = xlAutomatic
        .TintAndShade = 0
    End With
End Sub
Comment 1 Noel Power 2013-02-05 14:31:48 UTC 
marking this as an enhancement, I don't currently have plans to look at this so putting back to default
Comment 2 johnks 2020-07-04 04:51:58 UTC 
Created attachment 162626 [details]
tintandshade demo file

BASIC runtime error.
'423'
TintAndShade



attaching this file containing tintandshade. removing this from the macro makes the macro work just fine