Ask Your Question

seanmadsen's profile - activity

2018-09-12 12:34:22 +0200 received badge  Self-Learner (source)
2018-09-12 12:34:22 +0200 received badge  Teacher (source)
2016-05-27 22:59:49 +0200 received badge  Taxonomist
2014-11-19 17:44:31 +0200 received badge  Supporter (source)
2014-11-19 17:43:59 +0200 answered a question Calc sort messing up formulas?

I had this problem too and was also incredibly pissed off.

Upgradding to 4.3.3.2 fixed it for me. The default sorting has been restored to behaving the way it has been for years.

I can't believe the LibreOffice team let this happen. Thank goodness I had backups of my spreadsheets because this sorting issue sure mangled them!

2014-10-30 04:11:29 +0200 received badge  Notable Question (source)
2014-10-30 04:11:29 +0200 received badge  Famous Question (source)
2014-07-04 20:47:18 +0200 received badge  Student (source)
2014-01-05 10:01:19 +0200 received badge  Popular Question (source)
2013-12-28 02:34:12 +0200 commented answer Calc: user defined number format for time duration showing hours and minutes

Yes! That works. Thank you!

2013-12-28 02:30:53 +0200 received badge  Scholar (source)
2013-12-28 02:29:11 +0200 received badge  Famous Question (source)
2013-12-28 02:29:11 +0200 received badge  Notable Question (source)
2013-12-28 02:29:11 +0200 received badge  Popular Question (source)
2013-12-27 04:38:40 +0200 answered a question Calc: user defined number format for time duration showing hours and minutes

This format code [>=1]0.## "days";H:MM "hrs" doesn't quite satisfy the requirement, but it might be a suitable work-around if no other answers appear. It gives:

  • 0.1875 → 4:30 hrs
  • 1.75 → 1.75 days
2013-12-27 04:27:58 +0200 asked a question Calc: user defined number format for time duration showing hours and minutes

I have some cells in a LibreOffice Calc document the represent time duration (not time of day). I can set the format code to H:MM and it looks pretty good. For example four and a half hours can be entered by typing 4:30 or by typing 0.1875 (because it's 0.1875 days) and the cell will show 4:30. This is good.

But when I have a value over 24 hours, then the format does not produce a sensible display. For example, if I type 42:00 or type 1.75 I would like to see 42:00 but instead I see 18:00. This result makes sense to me, given the format code I'm using -- it's just showing the time of day on the next day.

I would like to find a number format code that will format 0.1875 as 4:30 and also format 1.75 as 42:00. Is this possible?

2012-10-26 04:52:43 +0200 asked a question how to add marks and bleed to a PDF export

I'd like to use LibreOffice to produce a PDF to send to a print house. The design includes graphics printed to the edge of the paper. The print house would like a PDF that has bleed (space outside the edge of the page that contains slightly extra content, to be trimmed off) and marks (lines to indicate where the page should be trimmed).

I understand that LibreOffice doesn't have these features built in, but are there some suitable work-arounds that people have found?