First time here? Check out the FAQ!
2018-12-20 15:09:25 +0100 | received badge | ● Famous Question (source) |
2017-03-31 23:41:34 +0100 | received badge | ● Notable Question (source) |
2017-03-29 11:43:10 +0100 | received badge | ● Popular Question (source) |
2017-03-28 06:42:24 +0100 | asked a question | how do I change the font in a calc textbox existing textbox |
2016-09-27 17:39:48 +0100 | received badge | ● Famous Question (source) |
2016-04-21 09:55:06 +0100 | received badge | ● Notable Question (source) |
2016-04-21 09:55:06 +0100 | received badge | ● Popular Question (source) |
2016-03-09 21:16:01 +0100 | received badge | ● Notable Question (source) |
2016-03-09 21:16:01 +0100 | received badge | ● Popular Question (source) |
2016-03-09 21:14:48 +0100 | received badge | ● Famous Question (source) |
2016-03-09 21:14:48 +0100 | received badge | ● Notable Question (source) |
2015-11-11 21:56:43 +0100 | received badge | ● Notable Question (source) |
2015-03-20 18:20:53 +0100 | received badge | ● Popular Question (source) |
2015-01-19 03:01:03 +0100 | asked a question | Optimal row height, in linked cell Is it possible to get a destination cell's Row Height to automatically adjust, when the text in a source cell increases (causing the source cell's row height to automatically increase). Both source and destination are merged to equal sizes, but are on different sheets. I can get the source cell to increase as I increase the text, but I cannot (yet) get the destination cell to do likewise, without having to manually re-select Optimal Row Height for the destination cell. Is there a solution to this? Perhaps with a Macro if necessary? |
2015-01-19 02:44:00 +0100 | commented question | Linking text from a merged cell. I have another related question, but I'll post it as a new item. |
2015-01-19 02:27:12 +0100 | commented question | Linking text from a merged cell. Thank you. That fixed it. Bless LO Ask. |
2015-01-17 09:37:12 +0100 | commented answer | fit to page A4 with calc problem Format > Page > Page > Paper Format > Format (Select 'A4') > OK. This should get the page outlines / limits to be visible on your Worksheet. You can also set your margins to suit your requirements. |
2015-01-17 09:24:27 +0100 | asked a question | Linking text from a merged cell. I am trying to link (copy) text that is in a merged cell on one sheet, to a merged cell on another sheet (in the same workbook). In the destination cell, I have typed =, then the address of the source cell. All I get in the destination cell is the reference to the source cell IE: Sheet1.A1, instead of the text that is in Sheet1.A1. If I un-merge both cells, everything works as it should. Unfortunately, this is no good for what I am trying to achieve, as I need both source and destination cells to be merged to certain sizes, so that they look appropriate, for data (text) entry on the source sheet, and for printing on the destination sheet. Any ideas ? Thank you. |
2015-01-17 08:57:55 +0100 | received badge | ● Enthusiast |
2015-01-14 00:19:56 +0100 | commented answer | absolute reference Thank you. |
2015-01-14 00:17:41 +0100 | received badge | ● Popular Question (source) |
2015-01-11 00:25:33 +0100 | asked a question | absolute reference Does Calc have an F key short cut to change a cell reference to absolute? |
2015-01-08 04:35:53 +0100 | commented question | Can row height increase automatically You are correct. Thank you for pointing it out to me. |
2015-01-08 03:37:19 +0100 | asked a question | Can row height increase automatically Can a spreadsheet be set so that a row height will automatically increase as a cell wraps with new text? |
2014-02-23 22:28:22 +0100 | received badge | ● Taxonomist |
2014-02-04 22:17:47 +0100 | received badge | ● Famous Question (source) |
2013-08-08 22:05:42 +0100 | received badge | ● Popular Question (source) |
2013-08-08 22:05:42 +0100 | received badge | ● Notable Question (source) |
2013-07-08 04:42:01 +0100 | received badge | ● Editor (source) |
2013-07-08 04:40:53 +0100 | asked a question | vlookup with named range from another workbook I am trying to use VLOOKUP using a Named Range from another Workbook, ideally from an existing Excel Workbook, but failing that, from another LO Workbook. Any ideas? |