Ask Your Question
0

I cannot select cells from external worksheet while calculating

asked 2018-08-29 16:42:35 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I am trying to create a simple calculation (as a test) within a worksheet that draws from an external worksheet. While doing this, LibreOffice is not allowing me to select the cells from the external worksheet. I have tried various methods to figure this out, but am unable. Any suggestions?

edit retag flag offensive close merge delete

Comments

Which operating system do you use? Which file format does the external table and the table have in LO? How long does the calculation take? Is your computer busy with the calculation? Describe exactly what you are doing.

ebot gravatar imageebot ( 2018-08-29 17:00:07 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2018-08-29 17:30:28 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I found a work-around by having both worksheets not only opened but both minimized and showing on the same screen (o showing on two desktop screens). For some reasons the formulas allowed me to select cells from an external worksheet, unlike before, when they were both just open and not actually showing on the desktop.

Hope this helps (for those who may have been experiencing this same problem).

David

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-08-29 16:42:35 +0200

Seen: 23 times

Last updated: Aug 29 '18