Bug 35593

Summary: macro themecolor - tintandshade - patterntintandshade are all problems.
Product: LibreOffice Reporter: jkonecny
Component: BASICAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: enhancement    
Priority: medium    
Version: 3.3.0 release   
Hardware: Other   
OS: All   
Whiteboard:
i915 platform: i915 features:

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

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.