Ask Your Question

rrbd's profile - activity

2016-04-29 07:58:45 +0100 received badge  Taxonomist
2015-10-22 19:28:00 +0100 received badge  Famous Question (source)
2015-10-22 19:28:00 +0100 received badge  Notable Question (source)
2015-10-22 19:28:00 +0100 received badge  Popular Question (source)
2015-03-11 15:03:27 +0100 received badge  Famous Question (source)
2014-04-16 06:42:19 +0100 received badge  Nice Question (source)
2013-12-18 11:03:08 +0100 received badge  Famous Question (source)
2013-08-08 23:23:41 +0100 received badge  Notable Question (source)
2013-07-16 23:16:11 +0100 received badge  Popular Question (source)
2013-07-16 15:35:53 +0100 received badge  Notable Question (source)
2013-07-16 15:35:53 +0100 received badge  Popular Question (source)
2013-07-16 15:34:36 +0100 received badge  Famous Question (source)
2013-07-16 15:34:36 +0100 received badge  Notable Question (source)
2013-07-16 15:34:36 +0100 received badge  Popular Question (source)
2013-07-16 11:34:45 +0100 asked a question find new line

find new line

2013-04-08 09:06:19 +0100 answered a question Numbering Pages - HELP

I only know a solution with some chin ups (not far away from the steps you mentioned): a) create a single row 2 columns table b) To cell A1: 'Insert -> Fields -> Page Number c) Go Cell B1: F2 -> "<a1>/2" (F2 for Writer formula input, Input without quotation marks, of course) d) cell number format for B1 = "1234" (0 decimals) e) some styling: text white or covered by white rectangle, table borders, ... ready

2013-03-17 11:18:10 +0100 received badge  Famous Question (source)
2013-02-14 06:45:34 +0100 commented question Figure Numbering disrupted in Master Document (LO 3.5)

I doubt that we can get a result here. nik should submit a bug in Bugzilla

2013-02-14 06:44:13 +0100 commented question How can I create flexible Text Boxes with any Form Controls tool?

I doubt that we can get a result here

2013-02-14 06:42:35 +0100 received badge  Critic (source)
2013-02-09 20:14:20 +0100 received badge  Notable Question (source)
2013-02-09 20:14:20 +0100 received badge  Popular Question (source)
2013-02-06 07:28:03 +0100 received badge  Necromancer (source)
2013-01-27 11:51:20 +0100 received badge  Necromancer (source)
2012-12-26 10:43:55 +0100 answered a question Finding text with italics AND font name specified

You should try "Alternative dialog Find & Replace for Writer", where you have powerful tools to select very particular styles and character properties by "Caracter Properties - Based on Cursor position", what can be edited manually.

2012-12-13 18:52:19 +0100 received badge  Scholar (source)
2012-12-13 18:51:48 +0100 answered a question How Can I copy paste Calc formulas with absolute references

Hi all, Thank you for your hints. I think I will use the "deformularize" trick, it seems the most easy and reliable one. Even if the number of Sheets differs in the documents this will work

The "$Tabelle1." to "Tabelle1." trick also might work often.

I did not understand the regular expressions trick, I will try to understand some more details of RE next weekend.

Thanks

Rainer

2012-12-12 16:29:23 +0100 received badge  Student (source)
2012-12-11 17:06:54 +0100 asked a question How Can I copy paste Calc formulas with absolute references

Very often I use formulas looking like =SUMIF($Tabelle1.$AH$242:$AH$389;$B86;$Tabelle1.$M$242:$M$389) I use many spreadsheet documents all with the same sheet structure, and when I have improved the usability of the area with such a formula I would like to use this improvement in other documents with the same structure. Unfortunately when I copy/paste the cells (or import the complete improved sheets) the formula changes to something like "=SUMMEWENN('file:///C:/Users/Public/....." referring to the source document.

In Bug 45385 - EDITING: Copy Paste formula to different document adds source document filename to references I learned that that is intended, unfortunately I never need that intended behavior, but simply copy/paste the formulas as they are so that they refer to Sheets and cells in the new document.

Is there any way to reach my goal in a comfortable way?

2012-12-10 18:43:38 +0100 commented answer How ro rename hyperlinks in spreadsheet smultanously

Thx for Ideas. I know HYPERLINK(), but that's too sophisticated for a simple Link collection. I submitted "Bug 58096 - Allow to find and replace (hidden) properties like hyperlinks, picture names and descriptions, ..." <https://bugs.freedesktop.org/show_bug.cgi?id=58096>

2012-12-09 18:07:38 +0100 commented answer How ro rename hyperlinks in spreadsheet smultanously

Hm, that really works for you? Not for me with parallel installation of "LOdev 4.0.0.0.beta1". May be I should have written explicitly "Not text looking like hyperlink, but real hyperlink in a word not looking like the link itself?

2012-12-09 17:59:30 +0100 commented question How ro rename hyperlinks in spreadsheet smultanously

Hi John, I already tried similar tricks with unzipping, but I have had too much trouble iwth the rezipped documents.

2012-12-09 16:40:52 +0100 asked a question How ro rename hyperlinks in spreadsheet smultanously

Hi, I have lots of hyperlinks in a spreadsheet what have to be renamed in the same way ("file:///G:/" to "file:///U:/"). Most elegant way would be some 'Edit -> Find and Replace', but I think that is not possible. Is there any other way, at least to find hyperlinks with a particular string in it?

CU, Rainer

2012-10-06 17:37:41 +0100 answered a question Spell check is not working.
2012-08-01 19:45:34 +0100 asked a question recommendable Blog hoster?

Hi, I am not satisfied with wordpress.com for my blog on the TDF Planet, because they do not allow .odp, .odg and .ods as media. Can someone recommend an alternative where as much as possible works like on wordpress.com, but where "our" document formats are welcome?

2012-07-21 10:44:08 +0100 asked a question Community building using OpenStreetMap

Hi, does anybody know an "easy to use" possibility to use OpenStreetMap to show Members of the LibO community on a map? This, for example, could be used for organizing events, hitch hiking and many other needs. We have something similar at Open Hatch, but that's only English and for not easy to understand for No-Nerds. I remember to have seen working other examples, but currently I don't remember any

2012-06-13 08:09:05 +0100 commented question Slow in Spreadsheet after update to 3.5.4.2

Results please also to [https://bugs.freedesktop.org/show_bug.cgi?id=51019] (Bugzilla)

2012-06-06 19:50:48 +0100 commented question Is there a dictionary in Portugese...(something)? (Dicionário PT-pt)

无论你问的机会,这将让你一个答案,大幅上升,如果你问的问题在英语(孔子) ;-)

2012-05-29 06:52:06 +0100 commented question Make table grid lines visible in Writer 3.5

This seems to be an enhencement request or bug report, not a question?! I can't reproduce your observations with WIN / LibO 3.5.1. Default for table creation is black borders 0.05pt, and for a table without visible borders I can switch on/of cell visibility in menu 'Table -> Table boundaries' easily

2012-05-28 08:58:46 +0100 answered a question Draft Layout option for Writer (aka Normal View)

Nobody here can have better and more current information than you see in Bug 37967 - UI: "normal" view option needed.

So the Bug is the best place to participate or to watch for latest news