Ask Your Question

I'm trying to enter a formula referencing another sheet. When I click the mouse the sheet+cell reference is not entered in the input line. Ver. 4.0 [closed]

asked 2013-02-11 17:54:23 +0200

Magic_Chef gravatar image

updated 2020-08-19 05:39:41 +0200

Alex Kemp gravatar image

I just upgraded to 4.0 on a Mac. I'm trying to reference cells on different sheets and in other files. In the past I entered an "=" sign in the formula cell, switched to the other sheet and selected a cell with the mouse. The reference was added to the input line. Now, nothing appears in the input line when I click. I found a workaround when selecting a cell in the same file by clicking right after the equal sign and then clicking the cell I wanted to reference. It doesn't work when referencing other files.

Any suggestions?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-21 15:36:28.348931


Hi @Magic_Chef,

qubit taps you with his karma wand

That should give you enough karma to comment on posts :-)

qubit gravatar imagequbit ( 2013-02-11 19:45:20 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2013-02-11 19:56:49 +0200

qubit gravatar image

@Magic_Chef -- I can't reproduce this problem on my system (GNU/Linux), but it looks like you may have found a bug in the OSX version.

On Ubuntu 12.04.2, here's what I did to test:

  1. Open LO; open Calc
  2. Add a new sheet by clicking the "+" sign to the right of "Sheet 1"
  3. On Sheet 2, put the number "2" in cell A1.
  4. On Sheet 1, move to cell A2 and type "=", then click on the tab for Sheet 2, and left-click on A1. (At this point, I see =Sheet2.A1 in the Input Line)
  5. Hit the Enter key, and you will be taken back to cell A2 of Sheet 1, and cell A2 will display "2".

Please file a bug report about this problem and provide clear instructions on what isn't working for you (feel free to use my steps above, if those exercise the bug). Oh -- and please mention that you're on a Mac, so we can get a Mac user to triage your bug report.


edit flag offensive delete link more


Pinging @jorendc...

qubit gravatar imagequbit ( 2013-02-11 20:05:04 +0200 )edit

First sorry for the delayed response. Thank you for responding. I followed your steps and did not get the result you did. In the past the program DID since I have used this method numerous times to build formulas. For some reason it has quit auto-pasting from the mouse click. Bug report->

Magic_Chef gravatar imageMagic_Chef ( 2013-02-13 04:10:34 +0200 )edit

Hi @Magic_Chef, Looks like your comment got cut off (sorry about that 300-character limit). Please feel free to post another comment containing a link to the bug (syntax like fdo#123456 works just fine)

qubit gravatar imagequbit ( 2013-02-13 06:07:01 +0200 )edit

I have found that the second & third cells at the beginning of 3 rows I inserted prevent the mouse selection while the rest on the row do not. This appears sporadically in columns B & C. Checked & no protection set. Kind of puzzled:/

Magic_Chef gravatar imageMagic_Chef ( 2013-02-13 06:41:15 +0200 )edit

Further trials show that problem exists when trying to enter formulas with cell references pointing to one particular sheet! I can point to cells in the same sheet or in another sheet. But if I try to enter the data in the "BadSheet" the cell border turns red but the reference does not appear

Magic_Chef gravatar imageMagic_Chef ( 2013-02-13 07:26:59 +0200 )edit

in the formula bar. It only has the equal sign. And I meant to say "But if I try to click on a cell in the "BadSheet"......

Magic_Chef gravatar imageMagic_Chef ( 2013-02-13 07:28:53 +0200 )edit

@Magic_Chef -- Ah, interesting! Please make sure to include this information in your bug report so that the QA folks are aware of it.

qubit gravatar imagequbit ( 2013-02-14 19:33:09 +0200 )edit

answered 2013-02-11 20:53:15 +0200

jorendc gravatar image

I also can't confirm this using Mac OSX 10.8.2 with LibreOffice (=release). Have you any extentions installed? Not a big chance, but does a profile reset resolve your problem (guide: If this is indeed still reproducible, please see comment of Qubit and file a bug report.

Thanks in advance,

edit flag offensive delete link more

Question Tools


Asked: 2013-02-11 17:54:23 +0200

Seen: 4,107 times

Last updated: Feb 11 '13