It is crucial to understand that WPS's support for VBA is not 100% identical to Microsoft Office. There are key compatibility differences to keep in mind. WPS does not fully replicate Microsoft Office's VBA object model due to being based on the Gnumeric engine. This can lead to errors when running macros that were originally designed for Excel.

当上述常规步骤都未能解决问题时，可以按以下系统化流程进行深层次排查：

The software can read the file data, but it lacks the compiler needed to execute the underlying programming language.

Re-run the installation if necessary to ensure the VBA module is included.

For the changes to take effect, close all open instances of WPS Writer, WPS Spreadsheets, and WPS Presentation. Relaunch your macro-enabled document. The error should now be resolved, and your macros will run seamlessly. Method 2: Upgrade to WPS Office Business or Professional

Once the library is installed, you must ensure the interface and security settings allow macros to run.

In rare cases, you can point WPS to an existing Microsoft Office VBA installation. However, due to registry and DLL mismatches.

The "VBA support library is not installed" error in WPS Office is almost always a licensing or missing component issue. By installing the necessary WPS Office VBA plugin or upgrading to a professional license, you can restore full functionality. If you're still having trouble, you might want to:

Go to Control Panel > Programs > Uninstall a program, and remove WPS Office.

Navigate to > Macro Security (or through Options > Trust Center ).

If you’ve tried all methods and the error persists, consider these final options:

If you need help tracking down a safe link for your specific operating system version, let me know. To help narrow things down, tell me:

Note: Always download files from reputable sources and scan them with an updated antivirus before running. Step 2: Install the Package

: Ensure all instances of Writer, Spreadsheets, and Presentation are fully closed.

A world of geom

ggplot2 builds charts through layers using geom_ functions. Here is a list of the different available geoms. Click one to see an example using it.

geom_bar geom_bin geom_boxplot geom_density geom_error geom_hex geom_hist geom_hline geom_jitter geom_label geom_line geom_point geom_polygon geom_rect geom_ribbon geom_rug geom_segment geom_smooth geom_text geom_tile geom_violin geom_vline

Annotation with ggplot2

Annotation is a key step in data visualization. It allows to highlight the main message of the chart, turning a messy figure in an insightful medium. ggplot2 offers many function for this purpose, allowing to add all sorts of text and shapes.

Annotate with geom_text

geom_text() allows to add annotation to one, several or all markers of your chart.

wps office macros cannot be run because the vba support library is not installed hot

Annotate with geom_label

Very close to geom_text, geom_label produces a label wrapped in a rectangle. This example also explains how to apply labels to a selection of markers.

Rectangle

Learn how to use the annotate function to add a rectangle on a specific part of the chart.

Segment

How to add one or several segments to the chart.

Arrow

Basically the same as for a segment, with just one additional argument.

Abline

Add horizontal or vertical ablines with geom_hline and geom_vline.

Curved arrows

Dicover how to draw curved arrows in ggplot It is crucial to understand that WPS's support

Marginal plot

Marginal plots are not natively supported by ggplot2, but their realisation is straightforward thanks to the ggExtra library as illustrated in graph #277.

Scatterplot with rug

Add rug on X and Y axis to describe the numeric variable distribution. Show how geom_rug() works.

Marginal distribution

Add marginal distribution around your scatterplot with ggExtra and the ggMarginal function.

Marginal boxplot

Using boxplots is another way to show the marginal distribution. Find more in this post. This can lead to errors when running macros

ggplot2 chart appearance

The theme() function of ggplot2 allows to customize the chart appearance. It controls 3 main types of components:

Axis: controls the title, label, line and ticks
Background: controls the background color and the major and minor grid lines
Legend: controls position, text, symbols and more.

Axis

Customize ggplot2 axis: title, line, labels and ticks.

Background

Customize ggplot2 background: color, major and minor grid lines.

Legend

Customize ggplot2 legend: position, title, text, key symbol and more. For the changes to take effect, close all

Re-ordering with ggplot2

When working with categorical variables (= factors), a common struggle is to manage the order of entities on the plot.

Post #267 is dedicated to reordering. It describes 3 different way to arrange groups in a ggplot2 chart:

Using the forcats package
With dplyr
With the reorder() function of base R

Read post

Tidyverse

Here’s the official ggplot2 cheatsheet created by Posit. It covers all the key concepts of the library.

I've also compiled it with the most useful R and data visualization cheatsheets into a single PDF you can download:

ggplot2

A cheatsheet for quickly recalling the key functions and arguments of the ggplot2 library.

ggplot2 title

The ggtitle() function allows to add a title to the chart. The following post will guide you through its usage, showing how to control title main features: position, font, color, text and more.

Basic

Learn how to add a title with ggtitle, default options.

Appearance

Learn how to change title font, size, color, text and more.

Position

Check how to change title position.

Use custom fonts with ggplot2

If you don't want your plot to look like any others, you'll definitely be interested in using custom fonts for your title and labels! This is totally possible thanks to 2 main packages: ragg and showtext. The blog-post below should help you using any font in minutes.

Custom font

Learn how to add a custom font using the ragg or the showtext library in a ggplot2 chart.

Small multiples: facet_wrap() and facet_grid()

Small multiples is a very powerful dataviz technique. It split the chart window in many small similar charts: each represents a specific group of a categorical variable. The following post describes the main use cases using facet_wrap() and facet_grid() and should get you started quickly.

Facet_wrap

Facet wrap allows to build small multiples using one categorical variable.

Facet_grid

Same idea, but using 2 categorical variables for the faceting.

Customized

An advanced examples to make sure you know how to make your small multiple pretty.

Strip features

Customize the general layout with the strip option.

Mixing charts

How to combine several charts together with ggplot2.

A set of pre-built themes

It is possible to customize any part of a ggplot2 chart thanks to the theme() function. Fortunately, heaps of pre-built themes are available, allowing to get a good style with one more line of code only. Here is a glimpse of the available themes. See code

→ ggplot2

default theme_bw() theme_minimal() theme_classic() theme_gray()

→ ggthemes

theme_excel() theme_economist() theme_fivethirtyeight() theme_tufte() theme_gdocs() theme_wsj() theme_calc() theme_hc()

→ other

theme_article() theme_pubclean() theme_bigstatsr() theme_ipsum()

Wps Office Macros Cannot Be Run Because The Vba Support Library Is Not Installed Hot Updated (2024)