Ask Your Question

Wojtek's profile - activity

2018-03-19 14:50:35 +0200 received badge  Notable Question (source)
2017-11-24 15:18:10 +0200 commented question calc 5.3 slow scroll and cursor movement

Also I've just noticed - scrolling works just fine if... LibreOffice Calc doesn't have focus (so simply hovering over it

2017-11-24 15:17:06 +0200 commented question calc 5.3 slow scroll and cursor movement

@SteveTX - there is also https://bugs.documentfoundation.org/show_bug.cgi?id=105957 but it doesn't seem to have any trac

2017-11-24 15:13:33 +0200 commented question scrolling in calc is slow in 5.4 on macos

Current version 5.4.3.2 still exhibits the issue. I've noticed, that it's more noticeable with scrolling down (i.e. try

2017-09-19 02:29:03 +0200 received badge  Famous Question (source)
2017-08-23 17:24:18 +0200 commented question scrolling in calc is slow in 5.4 on macos

Thanks, I've added comment there.

2017-08-22 14:45:46 +0200 received badge  Notable Question (source)
2017-08-16 18:03:28 +0200 received badge  Popular Question (source)
2017-08-14 17:39:55 +0200 asked a question scrolling in calc is slow in 5.4 on macos

scrolling in calc is slow in 5.4 on macos After recent upgrade to 5.4 I'm struggling a bit with scrolling in Calc (under

2017-08-14 17:36:27 +0200 received badge  Popular Question (source)
2016-10-28 11:02:27 +0200 commented answer autoinput is being dumb

That was my idea that it takes all unique values top-to-bottom, but it's not very handy.

There is an option (linked article) which gives you a drop-down list, but... it requires you to type "0" and then press "alt+down", then hit down one or more times and hit enter instead "0" -> enter.

My first idea was to create a ticket in bugzilla, but... they migrated the accounts from old freedesktop and 'reset your password' doesn't work :/ hence my message here...

2016-10-26 22:16:29 +0200 asked a question autoinput is being dumb

I'm fairly certain it worked in a more sane way ages ago (sorting by the reversed order of column) and now autoinput seems to sort the values (0...9, a...z) or somesuch.

For example let's consider following set:

12/0/0
12/0/0

12/0/0
12/0/0
12/0/0
12/0/0
12/0/0






12/0/0
12/0/0
0/0/20

0/0/20
0/0/25
0/0/25
0/0/25
0/0/25

0/0/25

0/0/25


0/0/25





0/0/25
0/0/25
0/0/25
0/0/25
0/0/25
0/0/25
0/0/25

Now, when I enter "0" it suggests... yes, of course! "0/0/20"... it doesn't matter that recently "0/0/25" was used more often and was actually last value.

I think that either using value one-up-that-matches or using statistics (resource consuming, doesn't make that much sense?) would be more useful... I'm aware about https://help.libreoffice.org/Calc/Aut... but using alt+arrow-down or ctrl+tab is not very handy (as you have to use it all the time to correct the value instead of confirm the value that's one-up)

2013-12-10 16:09:39 +0200 received badge  Nice Question (source)
2013-08-22 18:14:55 +0200 received badge  Notable Question (source)
2013-08-22 18:14:55 +0200 received badge  Famous Question (source)
2013-08-18 02:13:07 +0200 received badge  Famous Question (source)
2013-08-18 02:13:07 +0200 received badge  Popular Question (source)
2013-08-18 02:13:07 +0200 received badge  Notable Question (source)
2013-07-18 09:28:17 +0200 received badge  Famous Question (source)
2013-06-12 15:03:24 +0200 received badge  Notable Question (source)
2013-05-23 20:34:33 +0200 received badge  Popular Question (source)
2013-04-08 18:37:05 +0200 received badge  Popular Question (source)
2013-04-07 16:00:59 +0200 asked a question Default view for Styles and Formatting

Is there a ways to configure default view of Styles and Formatting? Currently it always starts with "All styles", which is less than helpful for me and I always have to switch to Hierachical view. Can the latter be confitured as default? Or at least make LibreOffice remember last selected view?

2013-03-15 09:05:38 +0200 received badge  Supporter (source)
2013-03-15 09:05:37 +0200 received badge  Scholar (source)
2013-03-15 09:03:55 +0200 commented answer auto refresh pitvot table after changes in source range

I've actually created ticket for same question there: fdo#61793 and got response, that it would be nice idea to implement. Bottomline - there is some discrepancy when it comes to functionality vs code vs documentation ;)

2013-03-04 16:03:49 +0200 asked a question auto refresh pitvot table after changes in source range

Is there a way to auto refresh pivot table after any change is made to the cells that are within selection range upon which Pivot Table is built?

EDIT: as per request - reported as bug/feature fdo#61793

2013-02-18 09:51:49 +0200 edited question How to return null/empty from function in calc

Hello, In previous versions of LibreOffice calc (up to and including 3.5.x) it was easy to have semi-blank field as a result of a function (for example "if"):

=if(a1=0;1;"")

then if a1 wasn't 0 we had empty cell -- was working ok, no problems. But starting with 3.6.x (including recently released 4.0.0) it is somehow broken - returning "" causes to misbehave counting functions as well as pivot tables (which then fallbacks to text summary even if the source cell formating is number or even time -- highly annoying.

tl;dr how to return null/empty/non-value form function? I've tried:

=if(a1=0;1;)
=if(a1=0;1;null)
=if(a1=0;1;NULL)

and nothing seems to works

EDIT: Don't know why I cannot comment or particular answer so here it is: ma original problem comes from this bug report https://bugs.freedesktop.org/show_bug... as indicated there default returned value messes up PivotTable.

  • @mariosv - unfortunatelly your solution doesn't work as i get "0" instead of empty cell (so it's same as =if(true;1;0), but it causes PivotTable to show correct values
  • @Edward - in your case ignoring optional argument causes the cell to display "0" (it's time formatted) thus not what I want (i want to have empty cell)
  • @ROSt52 - please set format of the cell to time and it will display "00:00" instead of empty cell...
2013-02-18 09:51:49 +0200 received badge  Editor (source)
2013-02-18 09:46:32 +0200 received badge  Commentator
2013-02-18 09:45:46 +0200 commented question How to return null/empty from function in calc
  • @ROSt52 - please set format of the cell to time and it will display "00:00" instead of empty cell...
2013-02-18 09:39:59 +0200 commented question How to return null/empty from function in calc
  • @Edward - in your case ignoring optional argument causes the cell to display "0" (it's time formatted) thus not what I want (i want to have empty cell)