Fai la tua domanda

artfulrobot's profile - attività

2018-08-27 10:29:43 +0200 received badge  Domande famose (source)
2017-12-03 14:51:25 +0200 received badge  Domande famose (source)
2017-10-04 16:59:27 +0200 ha commentato una risposta Select/move to lowest row with data

Thanks for the code! I couldn't get it to work - just seemed to select the cell I was in. I tried to write my own but co

2017-09-28 17:19:42 +0200 received badge  Domanda notevole (source)
2017-09-28 15:12:51 +0200 received badge  Domande famose (source)
2017-09-28 01:48:06 +0200 received badge  Domanda gettonata (source)
2017-09-27 18:15:38 +0200 ha modificato una domanda Select/move to lowest row with data

Select/move to lowest row with data Ctrl-* selects the full data set. Great. But what I often, like always seem to need

2017-09-27 18:14:30 +0200 ha posto una domanda Select/move to lowest row with data

Select/move to lowest row with data Ctrl-* selects the full data set. Great. But what I often, like always seem to need

2017-09-20 17:55:58 +0200 received badge  Domanda notevole (source)
2017-09-20 16:34:25 +0200 ha commentato una risposta How to convert date to text with given format?

Thanks, understood.

2017-09-20 15:24:31 +0200 received badge  Domanda gettonata (source)
2017-09-20 15:17:35 +0200 ha commentato una risposta How to convert date to text with given format?

Interesting, but does not appear to work on my LO (5.1.6): when I click in a Date cell in the created pivot table and cl

2017-09-20 15:16:08 +0200 ha commentato una domanda How to convert date to text with given format?

Thanks, Mike! that's it! If you want to write it as an answer I can tick it.

2017-09-20 14:06:21 +0200 ha posto una domanda How to convert date to text with given format?

How to convert date to text with given format? I have data like this: Date Value 2016-01-02 12 2016-

2017-03-30 12:03:55 +0200 received badge  Domanda notevole (source)
2017-03-30 11:41:45 +0200 ha modificato una domanda How to save a document with macros while keeping macros disabled?

How to save a document with macros while keeping macros disabled? EDITED FOR CLARITY Answers and comments so far have f

2017-03-30 11:37:44 +0200 ha modificato una domanda How to save a document with macros while keeping macros disabled?

How to save a document with macros? I've been sent a document with a macro virus - probably - and it's password protecte

2017-03-30 11:37:02 +0200 ha commentato una risposta How to save a document with macros while keeping macros disabled?

Thanks, but I do not wish to run the macro, which is what your instructions lead to, I just need to be able to save it w

2017-03-30 11:37:02 +0200 received badge  Commentatore
2017-03-30 11:34:17 +0200 received badge  Entusiasta
2017-03-29 21:55:01 +0200 received badge  Domanda gettonata (source)
2017-03-29 13:15:32 +0200 ha posto una domanda How to save a document with macros while keeping macros disabled?

How to save a document with macros? I've been sent a document with a macro virus - probably - and it's password protecte

2016-08-30 11:26:03 +0200 ha commentato una risposta Why can't I get past the 'address block' step in the Mail Merge wizard on Ubuntu?

This does not solve it for me.

2016-03-04 19:28:14 +0200 ha accettato una risposta I set up my account with myOpenId, now I can't log in

myopenid closed in Feb 2014. I have logged in by using the recover account by email method. I went to Manage Login Methods, but the page just crashes - I see the list of login methods appear momentarily, then it redirects to a 404 missing page at http://ask.libreoffice.org/en/account/signin/undefined

2016-03-03 22:24:59 +0200 received badge  Domande famose (source)
2016-02-22 17:47:04 +0200 ha accettato una risposta How to copy blanks from one sheet to another?

A cell in one workbook has a VLOOKUP formula that yields empty.

When I copy that cell and paste special into a second workbook (different file) I can't get the blank to come through - it's translated into a zero.

A zero and a blank mean completely different things in this dataset. I need a way to do this. For my purposes, a blank can be represented as a ZLS "", because it's going to get exported as CSV anyway.

Example sheet:

A1: =VLOOKUP("foo",B1:C2,2,0)
B1: foo
  1. A1 is blank (because the vlookup returns blank cell C1).
  2. Copy A1
  3. Paste-special somewhere else, without formula. You get a zero
2015-09-06 17:33:34 +0200 received badge  Domande famose (source)
2015-05-19 12:04:38 +0200 ha commentato una risposta Change default printer language type to PostScript (Level from driver)

This does not set the default.

2015-03-02 14:28:49 +0200 received badge  Domande famose (source)
2015-02-28 07:02:55 +0200 received badge  Domanda notevole (source)
2015-02-24 16:22:42 +0200 received badge  Studioso (source)
2015-02-08 12:13:58 +0200 received badge  Domanda gettonata (source)
2015-02-06 10:34:59 +0200 ha commentato una risposta Relationship between bullet/numbering button and Lists styles?

Always useful to promote the manual, but I do not consider this to be an answer to my question. The manual is nearly 500pages long and AFAICS makes no reference to a link between the buttons and the styles.

For others' reference, the relevant sections of the manual appear to be p88 ch3, "Creating numbered or bulleted lists" and p241 ch7 "Working with list styles".

The bullet button does not in any install I've seen link to List style 1.

2015-02-05 17:06:05 +0200 ha commentato una domanda I set up my account with myOpenId, now I can't log in

no it doesn't crash any longer. However, neither will it let me delete my defunkt myopenid login.

2015-02-05 17:03:34 +0200 ha posto una domanda Relationship between bullet/numbering button and Lists styles?

I'm using LO fresh 4.4.

Is there any link between the bullets button and the list styles? List styles seem a great way to have document-wide control over the bullets, but having a button that slaps on any ol' style is really unhelpful. Is there any way to link the button with, say, "List 1" and the numbered button with "Numbering 1" or some such?

2014-10-05 03:57:42 +0200 received badge  Domande famose (source)
2014-09-21 01:33:26 +0200 received badge  Domanda notevole (source)
2014-09-20 12:48:50 +0200 received badge  Domanda gettonata (source)
2014-09-19 16:20:43 +0200 ha posto una domanda What is the point of Ctrl-A Select All in Calc?

I find it very helpful that Ctrl-End takes you to the bottom right corner of your worksheet.

I find it incredibly problematic that there is no way to select all down to the bottom of the defined region (i.e. down to the row that you'd be at using Ctrl-End) or across likewise.

I honestly do not understand why the job of selecting every cell in the spreadsheet, that is all 1.07 billion cells, has been made trivially easy, while moving around the boundaries of your defined sheet is near impossible. Of course if you accidentally do anything with those billion cells your computer is likely to crash anyway because of the ridiculous load.

There is an edge case that somebody needs to select a billion cells, I'm sure, but it's a big UX fail for the far more common everyday use cases. If you need to do some global formatting, that's what Styles are for.

Am I missing some magic shortcut keys? Is there a re-mapping I can do to make this useful?

2014-08-26 16:11:08 +0200 ha commentato una risposta COUNTING TEXT IN COLUMNS

@Nifty regular expressions can be disabled in the (advanced) options/settings screen. Perhaps yours is disabled? CF.* would match anything containing CF, followed by any number of characters.

2014-08-26 16:09:28 +0200 received badge  Sostenitore (source)
2014-06-27 08:03:58 +0200 received badge  Domanda notevole (source)
2014-06-26 14:04:23 +0200 received badge  Negromante (source)
2014-06-26 14:04:23 +0200 received badge  Insegnante (source)
2014-06-26 14:04:09 +0200 received badge  Studente (source)
2014-06-25 12:55:29 +0200 ha commentato una domanda Is there an automatic sort function in Calc?

(I am not allowed to post answers yet) Why not use a Pivot Table. It won't automatically update, but it's only a right-click menu then click Refresh to update it.

2014-06-24 18:38:24 +0200 ha commentato una domanda Is login on AskLibO ever going to change?

Yep, and if your openid provider should go away, you cannot login nor change your login providers!

2014-06-24 18:36:32 +0200 ha risposto a una domanda How can we encourage more people to sign in to the Ask site?

Make it possible!

Having signed up with an myOpenId account (a service which is now closed), the only way I can possibly sign in now is by using the recovery email route. Using that link crashes the site, but does leave me logged in (hence this answer). However it crashes again whenever I go to Manage My Logins, so I'm stuck forever in limbo!

If it was easy to sign in I would be quite active; I love the stackexchange sites that work the same way (although I appreciate the work that SE must put in to helping users use the site correctly as it's clear they do...)