Ask Your Question

tntrush's profile - activity

2014-03-07 23:22:49 +0100 received badge  Famous Question (source)
2014-02-09 11:38:29 +0100 received badge  Taxonomist
2013-12-15 23:02:50 +0100 received badge  Self-Learner (source)
2013-12-15 23:02:50 +0100 received badge  Teacher (source)
2013-12-14 23:19:27 +0100 received badge  Notable Question (source)
2013-12-14 23:19:27 +0100 received badge  Popular Question (source)
2013-09-27 15:48:41 +0100 commented question Format Paintbrush and delete button strange behavior

I am using Fedora 19.

2013-09-26 18:10:13 +0100 answered a question Format Paintbrush and delete button strange behavior

I acquired it from a regular fedora update.

I will reinstall and if it insists, I will report the bug.

Thank you!

EDIT: The bug us already open at the following URL:

https://bugs.freedesktop.org/show_bug.cgi?id=69709

2013-09-26 17:17:09 +0100 received badge  Famous Question (source)
2013-09-26 17:17:09 +0100 received badge  Notable Question (source)
2013-09-26 17:17:09 +0100 received badge  Popular Question (source)
2013-09-26 17:16:19 +0100 received badge  Famous Question (source)
2013-09-26 17:16:19 +0100 received badge  Notable Question (source)
2013-09-26 17:16:19 +0100 received badge  Popular Question (source)
2013-09-26 17:13:08 +0100 received badge  Editor (source)
2013-09-26 17:12:19 +0100 asked a question Format Paintbrush and delete button strange behavior

Hallo,

After updating to libreoffice-calc-4.1.2.2-1, the "format paintbrush" copies the format but also deletes the contents of the cell(s) that is applied. Also, the delete button along with the comments, it also removes the formatting of the cell that it is applied.

Is there a way to change back to the previous friendlier version of these functions?

Kind regards, tntrush

2012-12-27 17:18:31 +0100 answered a question Extract named formulas and use them in another spreadsheet

Thank you Mariosv!

Indeed, the named formulas are in the second spreadsheet.

How could I append them in the "Insert->Names->Define" table?

Should I do it manually or there is a way to append them at once?

I need to do that, because the formulas contain other formulas. For example:

=CONCATENATE("<tr class=""mprow_title""><td

colspan=""3"" class=""mpcell1"">",OFFSET(INDIRECT(ADDRESS(ROW(),COLUMN())),0,2),"")

Which grubs the contents of the secondly next cell and concatenates them in the predefined text.

Kind regards, tntrush

2012-12-27 17:09:06 +0100 received badge  Scholar (source)
2012-12-21 18:51:56 +0100 asked a question Hyperlink is not executed for security reasons

Hallo,

I am using Libreoffice Calc 3.5.7.2 and I would like to use the Hyperlink function on order to provide a link to another cell in an adjacent sheet.

The code I am providing is the following:

=HYPERLINK(Sheet5.B3,"go")

When I click on the text "go" I receive the following message:

For security reasons, the hyperlink cannot be executed.
The stated address will not be opened.

Is it possible to use the hyperlink function in Libreoffice calc?

Kind regards, tntrush

2012-12-21 17:05:06 +0100 asked a question Extract named formulas and use them in another spreadsheet

Hallo,

I have named several formulas and use them in my spreadsheet.

For example, through Insert -> Names -> Define, I created -among others- the "sum" formula which performs a sum up procedure.

Could I possibly extract all the formulas I created along with their names, in order to use them in another spreadsheet?

Even better, is there a way to store all the names and the corresponding formulas in a spreadsheet called "Formulas" and make it work from there? (probably not ...)

I would appreciate your help.

Kind regards,