Ask Your Question

dejayajay's profile - activity

2018-12-20 15:09:25 +0200 received badge  Famous Question
2017-03-31 23:41:34 +0200 received badge  Notable Question (source)
2017-03-29 11:43:10 +0200 received badge  Popular Question (source)
2017-03-28 06:42:24 +0200 asked a question how do I change the font in a calc textbox

existing textbox

2016-09-27 17:39:48 +0200 received badge  Famous Question (source)
2016-04-21 09:55:06 +0200 received badge  Notable Question
2016-04-21 09:55:06 +0200 received badge  Popular Question
2016-03-09 21:16:01 +0200 received badge  Notable Question (source)
2016-03-09 21:16:01 +0200 received badge  Popular Question (source)
2016-03-09 21:14:48 +0200 received badge  Famous Question (source)
2016-03-09 21:14:48 +0200 received badge  Notable Question (source)
2015-11-11 21:56:43 +0200 received badge  Notable Question (source)
2015-03-20 18:20:53 +0200 received badge  Popular Question (source)
2015-01-19 02:44:00 +0200 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 +0200 commented question Linking text from a merged cell.

Thank you. That fixed it. Bless LO Ask.

2015-01-17 09:37:12 +0200 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 +0200 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 +0200 received badge  Enthusiast
2015-01-14 00:19:56 +0200 commented answer absolute reference

Thank you.

2015-01-14 00:17:41 +0200 received badge  Popular Question (source)
2015-01-11 00:25:33 +0200 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 +0200 commented question Can row height increase automatically

You are correct. Thank you for pointing it out to me.

2015-01-08 03:37:19 +0200 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 +0200 received badge  Taxonomist
2014-02-04 22:17:47 +0200 received badge  Famous Question (source)
2013-08-08 22:05:42 +0200 received badge  Popular Question (source)
2013-08-08 22:05:42 +0200 received badge  Notable Question (source)
2013-07-08 04:42:01 +0200 received badge  Editor (source)
2013-07-08 04:40:53 +0200 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?