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: 3.3.0 release
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-03-23 08:14 UTC by jkonecny
Modified: 2013-02-05 14:31 UTC (History)
0 users

See Also:
i915 platform:
i915 features:

Attachments

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.