First time here? Check out the FAQ!
asked 2012-08-26 20:19:33 +0200GreylinRo
I have a multi-worksheet spreadsheet, and I am trying to reference the value of one cell on one sheet in another. When I type "=" in the destination cell, and click on the cell to reference on the other sheet, the sheet:cell reference (i.e. ='Monthly Plan'.B53), nothing happens. I get a red border around the target cell, but the reference is not made. Further more, I can make this operate as expected from other cells on this and other worksheets, it is just certain cells that will not work. I have tried adding and deleting rows, to no avail - it seems that certain columns on this worksheet will not let me reference cells from other worksheets. I upgraded to 18.104.22.168, but that has not changed anything.
answered 2013-02-22 09:32:37 +0200qubit
As @moggi notes above:
Please file a bug about this problem, and provide a test document and a list of steps that can reproduce it. The QA team will be happy to help you track down this issue!
Please post a link to any bugs you file in a comment below using the format "fdo#123456".
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-08-26 20:19:33 +0200
Seen: 614 times
Last updated: Feb 22