WPS picture Excel open does not display the problem, do you understand?

WPS pictures, can not be opened in Excel, how to do?

Sanshui, my former colleague, we all know each other, right?

When I was working together, I had a good relationship, but I didn't expect to find out after I left that my understanding was too one-sided.

1-about friendship

The heart is separated by the belly! Unexpectedly, as a manager of Sanshui students, even WPS can not!

The picture in WPS is gone when you open it with Excel.

And she still uses a Mac computer. I don't deserve to have the troubles of the rich.

I replied in a funny way.

Everyone should be able to see that I'm kidding, right?

However, the other party ignored me! Are you serious?

Therefore, in the workplace, no matter how good the relationship is, you should pay attention to the occasion and discretion in joking.

2-about pictures

Let's talk about the problem that the WPS image does not display.

The problem is very simple, that is, I inserted several pictures in WPS, all of which showed no problem.

But when you open it in Excel, it becomes # NAME? Error

What is # NAME? A mistake? # NAME? That is to say, this function formula is not found in Excel.

Look at the formula of this cell, which is the formula of DISPIMG.

The formula is as follows:

= @ _ xlfn.DISPIMG ("ID_0088DCB6A4964EEE86E72379D016275C", 1)

DISPIMG is a WPS-specific function that is used to display pictures and embed them in cells.

It has two parameters:

-Parameter 1: indicates the name of the picture to be displayed.

-Parameter 2: indicates how the image is displayed. 0 indicates cropping the image, and 1 indicates zooming the image.

But either way, as long as the DISPIMG function is used, it means that the picture is embedded in the cell.

Excel does not support embedding pictures into cells, so you just need to change the picture to a "floating" picture.

The operation in WPS is easy to modify to a floating picture.

Select all the pictures and right-select [switch to floating Picture].

The effect is as follows, then save the table, then open it with Excel, and you can display it normally.

Summary

There are many small functions in WPS that are very consistent with the habits of Chinese people.

This embedded picture can be counted as one, and there are others.

1-quickly merge the same cells

2-change the number to RMB capitalization with one click

3-[reading mode] with spotlight

There are table slimming, merging worksheets, workbooks and other very useful features, if you are interested, you can like to tell me, like > 50, I write a collection of WPS skills.

At the end of the story, let's go back to Sanshui.

Without waiting for her reply, I sent her a long list of the above principles, solutions, and so on. I hope I can make up for the joke.

Sanshui didn't talk to me because he just ran away to do something else. I'm thinking too much.

Therefore, jokes should be played less on different occasions, even if they do not cause misunderstandings, their own thinking will continue to produce internal friction, affecting work efficiency.

This article comes from the official account of Wechat: ID:ladengchupin, author: bin Laden Dony