질문하기

MrP's profile - activity

2019-01-29 14:14:27 +0200 코멘트달린 답변 How to view 'full path' of open document?

The menu/keyboard shortcut does make this a bit easier: Alt + F, I (Although, if you've previously left the Properties w

2019-01-29 14:13:42 +0200 코멘트달린 답변 How to view 'full path' of open document?

The menu/keyboard shortcut does make this a bit easier: Alt + F, I (Although, if you've left the Properties window on a

2019-01-29 14:13:42 +0200 받은 배지  논객
2019-01-22 02:02:09 +0200 코멘트달린 답변 Automated timestamps, Please help. Thanks

But with this method the timestamp always shows the current date/time when the sheet is recalculated, not the date it wa

2018-10-10 23:54:59 +0200 코멘트달린 답변 CALC: default date format

"Consider to abandon 2-digit-year formats." - but how do you set a 4-digit-year as the default?

2018-10-10 23:45:31 +0200 질문에 댓글을 달았습니다 Moving from 32 bit to 64 bit

@Mike Kaganski I would have expected some kind of acknowledgement that an existing installation was found "here..." and

2018-10-10 23:44:58 +0200 질문에 댓글을 달았습니다 Moving from 32 bit to 64 bit

@Mike I would have expected some kind of acknowledgement that an existing installation was found "here..." and an option

2018-10-10 22:27:49 +0200 질문에 댓글을 달았습니다 Moving from 32 bit to 64 bit

I'm currently wondering the same thing. However, the 64-bit installer does not appear to be detecting a previous 32-bit

2014-02-27 23:22:45 +0200 받은 배지  족집게 도사 (source)
2014-02-27 23:22:45 +0200 받은 배지  자기 주도 학습자 (source)
2014-02-27 20:38:03 +0200 받은 배지  유명한 질문 (source)
2014-02-27 14:46:25 +0200 코멘트달린 답변 Change background colour of cell in Calc to last used colour?

I've just realised under what circumstances this doesn't "work as expected". If you have since picked "No Fill" from the background colour dropdown then the previous background colour remains below the icon, but now with a thin black border (this is shown in the screenshot in my question). Clicking this icon now clears the background colour, as opposed to colouring it, despite the colour still showing beneath the icon. (I've added an answer with screenshots.)

2014-02-27 14:36:46 +0200 질문에 답변하였습니다 Change background colour of cell in Calc to last used colour?

I've just realised what is going on! So, for the benefit of anyone else who has experienced this quandary. As suggested in my comment to oweng's answer... sometimes this works "as expected", other times it doesn't.

The cell is not always coloured to the same colour that appears below the icon. This happens when you have since selected "No Fill" as the background from the dropdown. When you select "No Fill", the previous colour (Purple in my question above) remains below the icon, but it now has a black (single pixel) border. Clicking this icon now clears the background colour from the cell, despite the previous "colour" still showing beneath the icon. This is a bit misleading, however, providing you are aware of the "black border" (indicating "No Fill") then it works OK.

For example:

(1) Having picked "red" from the background colour dropdown, the cell is coloured "red" and the colour "red" appears beneath the icon. Clicking the icon now colours any cell "red".

A colour has been picked from the background colour dropdown

(2) Now select "No Fill" from the background colour dropdown.

Select "No Fill" from the background colour dropdown

The background colour of the cell is cleared, but the previous colour is still shown below the icon - except there is now a single pixel black border around the colour - very subtle! (This is similar to the screenshot in my question above.)

The background colour of the cell is cleared but the colour remains below the icon - with a thin black border

(3) Now clicking this icon (with the thin black border around the colour) will clear the background colour, not colour it red (the colour beneath the icon). And if the selected cell does not already have a background colour, clicking this button/icon appears to do nothing!

2014-02-27 13:46:17 +0200 받은 배지  주목할 만한 질문 (source)
2014-02-27 13:46:17 +0200 받은 배지  인기있는 질문 (source)
2014-01-27 12:17:07 +0200 받은 배지  유명한 질문 (source)
2014-01-26 14:39:00 +0200 받은 배지  족집게 도사 (source)
2014-01-26 14:39:00 +0200 받은 배지  선생님 (source)
2014-01-26 13:54:46 +0200 질문에 답변하였습니다 accounting format in calc

I too have experienced the "###" being displayed for zero values when migrating a document from Excel to Calc when using Excel's "Accounting" format. The strange thing is that seemingly the same format code applied to different cells can result in different output (one with "-", the other with "###") and changing the width of the cell does not appear to help! Bizarre. Anyway, this can be fixed...

The "Format code" consists of up to 3 sections, separated by the semi-colon (;). The 3rd section indicates what is shown when the value is zero. (The first two are the positive and negative variants respectively.)

So, to display a hyphen (-) when the value is zero, you could use a format code like this:

#,##0.00;[RED](#,##0.00);"-"

The above format code includes 2 decimal places, 1 leading zero and thousands separators. Negative values are [RED] and surrounded by parentheses. And finally a single hyphen is shown when the value is zero.

You could pad the hyphen with a couple of spaces on the right to make it more Excel like.

2014-01-22 22:03:14 +0200 질문에 답변하였습니다 Conditional Formatting Based On Date

With conditional formatting (as previously mentioned) I think you could also do something like:

If... "Cell value is" - "greater than" - "A1+180"

Where A1 is a reference to the current cell (whatever that might be).

2014-01-19 12:17:20 +0200 받은 배지  학자 (source)
2014-01-19 12:17:02 +0200 코멘트달린 답변 Change background colour of cell in Calc to last used colour?

Strange, it's working for me today as well!? (I have rebooted the computer in the meantime.) It has certainly not worked for me on numerous occasions in the past, and it wasn't working yesterday when I posted the question. Maybe there's a sequence of events that triggers this? Thanks.

2014-01-18 12:48:58 +0200 질문하였습니다 Change background colour of cell in Calc to last used colour?

When you change the background colour of a cell in LibreOffice Calc, the last used colour is displayed below the icon on the toolbar:

image description

However, clicking the icon does not use the last used colour to colour the background - it does nothing?! You must re-pick the same colour from the dropdown. Since the last used colour is shown on the icon, I would have expected this colour to be used when clicking the icon, since otherwise I can't see any point in showing this? (Incidentally, this is how it works in Excel.)

  1. Should this work? Is it a bug (it's bugging me :) ?
  2. Is there an alternative way of quickly using the last used (background) colour?

Using Version 4.1.1.2 (Windows 7 - 64 bit)

2013-11-03 10:39:50 +0200 받은 배지  조력자 (source)
2013-11-03 03:09:09 +0200 받은 배지  학생 (source)
2013-11-02 23:52:12 +0200 받은 배지  주목할 만한 질문 (source)
2013-11-02 16:26:23 +0200 받은 배지  인기있는 질문 (source)
2013-11-02 14:41:01 +0200 코멘트달린 답변 How to change the default date format in Calc to show 4-digit years?

To be honest, it should at least default to the short date format of the machines locale (which is what Excel 97 does)? However, a user-entered default should then override the locale. There is also the issue of why a "2-digit year by default"!? Anyway, thanks for your suggestion and link, it is helpful. (I would upvote you, but I don't appear to have enough rep.)

2013-11-02 14:15:46 +0200 코멘트달린 답변 How to change the default date format in Calc to show 4-digit years?

"...there are simply too many default settings..." - I have seen this mentioned a few times, but it doesn't seem relevant?! All the different permutations don't need to be listed. There is already a single "hardcoded" default (initially dependent on locale) which needs to be editable. There is an edit box where you can enter an arbitrary format code - this is all that's required. At most there needs to be 1 default for each identifiable data type... Date, Time, Number, etc.?

2013-11-02 11:42:17 +0200 받은 배지  편집자 (source)
2013-11-02 11:41:40 +0200 질문하였습니다 How to change the default date format in Calc to show 4-digit years?

I'm set to a UK locale and the dates are formatted correctly in that respect. However, the default format is for a 2-digit year (DD/MM/YY), and I would like it to default to a 4-digit year (DD/MM/YYYY). Is there anyway I can set this as the default?

Despite typing 4-digits (eg. 02/11/2013) it always reverts to the 2-digit format, until I manually set the formatting for that cell or column. Unfortunately I'm having to do this rather a lot it seems and it's quickly becoming tedious.

Format cells dialog

2013-10-30 13:34:33 +0200 받은 배지  개근상
2013-10-24 01:49:39 +0200 코멘트달린 답변 Why is "The automatic download of the update...currently not available"?

This does not appear to be correct. I have OpenOffice.org 2.3 (release date 2007-09-17) installed on an old WinXP machine and this appears to have the same "update checking" mechanism that Libre Office (4.1.1.2) currently has. In fact, the icon and placement is exactly the same. To be honest, I've not used a later version of Open/Libre Office until LibreOffice 4.1.1.2, so was this feature removed in later versions?!