質問する

_dave's profile - activity

2019-07-30 15:47:08 +0200 質問をする clear a field in pivot table

clear a field in pivot table How do I clear (delete) a field description? I have a field that is "," and I don't know w

2019-07-19 12:50:31 +0200 バッジを受け取った  卓越した質問 (source)
2019-06-24 17:03:42 +0200 バッジを受け取った  人気の質問 (source)
2019-06-24 02:45:52 +0200 質問をする Libreoffice linux (mint19.1) - how to get the new files to the front?

Libreoffice linux (mint19.1) - how to get the new files to the front? When I open a new file it always goes behind other

2019-05-01 19:56:34 +0200 バッジを受け取った  有名な質問 (source)
2019-03-22 21:59:59 +0200 バッジを受け取った  有名な質問 (source)
2019-03-15 23:30:43 +0200 バッジを受け取った  卓越した質問 (source)
2019-03-14 23:43:14 +0200 バッジを受け取った  人気の質問 (source)
2019-03-14 19:44:49 +0200 編集された質問 SOLVED - [CALC] How to add days to a date

[CALC] How to add days to a date In Column A is "DATE", Column B is "Open/Close". I would like Column B to say "Open" if

2019-03-14 19:42:48 +0200 コメント付き回答 SOLVED - [CALC] How to add days to a date

Thanks, that work for me.

2019-03-14 19:41:13 +0200 コメント付き回答 SOLVED - [CALC] How to add days to a date

Thanks, that work for me.

2019-03-14 19:40:41 +0200 ベストアンサーマーク SOLVED - [CALC] How to add days to a date

In Column A is "DATE", Column B is "Open/Close". I would like Column B to say "Open" if the date is less then 30 days and "Close" once it passed the 30th day. I'm at lost trying to get this to work. Sample of my output I would like is below (included the file as well).

  A                   B
date         open/close

01/01/19 close 03/14/19 open

C:\fakepath\add date.ods

Ahead of time, a Big "Thanks" for any and all help with this.

2019-03-14 18:03:23 +0200 編集された質問 SOLVED - [CALC] How to add days to a date

[CALC] How to add days to a date In Column A is "DATE", Column B is "Open/Close". I would like Column B to say "Open" if

2019-03-14 17:59:57 +0200 質問をする SOLVED - [CALC] How to add days to a date

[CALC] How to add days to a date In Column A is "DATE", Column B is "Open/Close". I would like Column B to say "Open" if

2019-02-17 15:23:17 +0200 バッジを受け取った  卓越した質問
2019-02-17 15:23:17 +0200 バッジを受け取った  有名な質問
2019-02-17 01:03:12 +0200 質問に回答する How can I add to the cell background palette in calc?

When you select "format Cells", then select "Background", you will see a "button" under New called "Pick". Here you can

2019-02-16 20:32:55 +0200 バッジを受け取った  人気の質問
2019-02-16 17:45:09 +0200 質問に回答する How do I start page numbers at 1 instead of 0.

Hope this helps, found it in the online help sections: To Start With a Defined Page Number Now you want some more cont

2019-01-27 17:07:54 +0200 バッジを受け取った  卓越した質問 (source)
2019-01-27 14:33:34 +0200 コメント付き回答 New question on how can I get the total count [Solved]

Pierre-Yves, I have a question for you. Under parts, how could I change the formula if I just wanted the following: "Loc

2019-01-27 13:40:38 +0200 コメント付き回答 New question on how can I get the total count [Solved]

This is really good (for me). It allows me to add other products without having to change the formula. Thank you.

2019-01-27 13:35:20 +0200 編集された質問 New question on how can I get the total count [Solved]

New question on how can I get the total count I am going to revise my question with a new sample. What I am trying to do

2019-01-27 13:33:19 +0200 コメント付き回答 New question on how can I get the total count [Solved]

Thank you for your solution, Pierre-Yves gives an answer which would allow me to add new product without having to edit

2019-01-27 13:26:42 +0200 ベストアンサーマーク New question on how can I get the total count [Solved]

I am going to revise my question with a new sample. What I am trying to do is to count the items based on their current status. I cannot seem to "see" on how to do this.Thanks ahead for any and all suggestions.

C:\fakepath\Item Total Count.ods

2019-01-27 13:26:23 +0200 コメント付き質問 New question on how can I get the total count [Solved]

I'm sorry about that. I knew there was an answer and not seeing any replies I decided to ask again in a different way. I

2019-01-27 12:54:12 +0200 バッジを受け取った  人気の質問 (source)
2019-01-27 08:20:19 +0200 質問をする New question on how can I get the total count [Solved]

New question on how can I get the total count I am going to revise my question with a new sample. What I am trying to do

2019-01-27 08:16:03 +0200 編集された質問 How can I get the correct numbers of items?

How can I get the correct numbers of items? I am going to revise my question with a new sample. What I am trying to do i

2019-01-27 08:16:03 +0200 バッジを受け取った  編集者 (source)
2019-01-25 04:44:52 +0200 質問に回答する Avery 5267 label misalignment

You might try the template at https://www.worldlabel.com/Templates/openoffice-template.htm and select WL-25. Hopefully,

2019-01-25 04:19:15 +0200 バッジを受け取った  解説者
2019-01-25 04:15:19 +0200 バッジを受け取った  卓越した質問
2019-01-25 04:11:27 +0200 質問をする How can I get the correct numbers of items?

How can I get the correct numbers of items? See below image. What I am trying to do is to count the items shipped. I c

2019-01-20 12:32:06 +0200 バッジを受け取った  人気の質問
2018-09-22 02:02:55 +0200 バッジを受け取った  有名な質問 (source)
2018-09-13 18:37:06 +0200 バッジを受け取った  有名な質問 (source)
2018-08-19 14:11:14 +0200 バッジを受け取った  人気の質問 (source)
2018-08-19 10:12:34 +0200 質問に回答する how do I list rows alphabetically?

It is not clear on what you are asking. Are you asking about the row numbers? Or listings in the columns? If it listing

2018-08-19 09:53:03 +0200 バッジを受け取った  熱心な人
2018-08-18 04:50:42 +0200 ベストアンサーマーク How do I round off a concatenate value

I have typed in the following: =CONCATENATE(G37-D37," just about match.") I get the following back - 13.7166666666667 just about match

My question is, how do I round it off to 13.7? I tried format cell - Number with 1 decimal places, this did not work.

The value in cell G37 is 39.47 and D37 is 25.75. And just to let you know the "about match" value was 14.25 Any suggestion is helpful and thanks ahead.

_dave