is Calc has "Watch Window" feature like excel ?

asked 2020-04-06 07:04:57 +0200

PhamHoangLong gravatar image

updated 2020-10-15 23:15:43 +0200

LeroyG gravatar image

Hello,

Are there any features in Libreoffice Calc or have the same feature like "Watch window" in Excel ? It's very useful, you can watch your formulas in a specific sheet while you are in the other sheet tab.

Picture :

image description

image description

==================================================

Maybe answered : There is no function "Watch window" like excel in Libreoffice Calc.

This is a trick to check your formulas : "Window -> New Window" (which creates 2nd view of the same document) and set View -> Show Formula in the second window.

I wrote here because it's maybe an answer for this moment, please tell me if you knew the other ways better than this.

(edited to show images)

edit retag flag offensive close merge delete

Comments

Read these guidelines and ask a good question. In particular, you say It's very useful. Be specific about its usefulness. What does it do actually? What is your goal?

gabix gravatar imagegabix ( 2020-04-06 08:29:42 +0200 )edit
1

Don't expect users of LibreOffice to know features of other software products.

Opaque gravatar imageOpaque ( 2020-04-06 12:29:52 +0200 )edit

you can watch your formulas in a specific sheet while you are in the other sheet tab.

You can do a similar thing with LibreOffice: Open Window -> New Window (which creates 2nd view of the same document) and set View -> Show Formula in the second window.

PS: My personal preference is to toggle view from show values to show formulas and vice versa by using the default shortcut for that ( STRG+` )

Opaque gravatar imageOpaque ( 2020-04-06 13:53:43 +0200 )edit

(STRG +`) : You mean (View - Show formula) and hotkey in windows is : Ctrl + ~?

PhamHoangLong gravatar imagePhamHoangLong ( 2020-04-06 14:09:19 +0200 )edit

Sorry my native language took over my brain - of course it is CTRL + ` (with my locale keyboard and you did not mention your operating system, so I could not take account for that)

Opaque gravatar imageOpaque ( 2020-04-06 14:33:19 +0200 )edit

The attached images are not appeared in my Firefox. 2020-10-16 9:06 (HU)

Zizi64 gravatar imageZizi64 ( 2020-10-16 09:07:32 +0200 )edit