質問する

bosyber's profile - activity

2017-06-25 21:17:17 +0200 バッジを受け取った  よくわかっていらっしゃる (source)
2017-06-25 21:17:13 +0200 バッジを受け取った  良い回答 (source)
2014-01-04 17:51:38 +0200 バッジを受け取った  良い質問 (source)
2014-01-04 17:48:35 +0200 バッジを受け取った  有名な質問 (source)
2014-01-04 17:48:35 +0200 バッジを受け取った  卓越した質問 (source)
2013-07-24 21:14:12 +0200 バッジを受け取った  解説者
2013-07-24 21:14:12 +0200 コメント付き質問 What is wrong with my native mysql connection?

If you try to connect locally on your ubuntu server, does it work? Also, are you sure you aren't connecting via TCP/IP rather than sockets? Perhaps http://unix.stackexchange.com/questions/32134/how-can-i-determine-the-connection-method-used-by-a-mysql-client is a helpful link, and especially this http://unix.stackexchange.com/a/3213 answer

2013-07-24 20:37:04 +0200 バッジを受け取った  オーガナイザー (source)
2013-07-24 20:31:28 +0200 コメント付き回答 convert-to command line parameter

Thanks, that is a useful caveat about headless conversion only working when no other LOis open, by default. Sure explains why I had trouble before; now I am using the -env trick.

2013-07-24 20:21:41 +0200 コメント付き回答 How to NOT connect to a running instance

Thanks, very useful. Small correction though, it should be:

-env:UserInstallation="file:///tmpLibO_Conversion"

2013-04-24 09:50:30 +0200 バッジを受け取った  人気の質問 (source)
2013-02-24 17:50:06 +0200 バッジを受け取った  素晴らしい回答 (source)
2012-07-13 17:12:09 +0200 バッジを受け取った  体系学者
2012-05-10 17:33:14 +0200 コメント付き回答 How can I put two data series with different categories in one chart?

Would like to point out here too: Using XY(scatter) plot is the main issue here, I think. Note that in creating a diagram, you can tweak what field is used for labels, X- or Y- values (combining multiple columns with a ";" between them is easy too), though that might get more complex than you'd like

2012-05-10 17:22:28 +0200 コメント付き質問 How can I put two data series with different categories in one chart?

Do you mean that you want all the data to be seen as a single data set in the plot, or as two separate series?

2012-05-10 17:22:28 +0200 コメント付き質問 How can I put two data series with different categories in one chart?

Do you mean that you want all the data to be seen as a single data set in the plot, or as two separate series? Pedro's answer gives you the second. In both cases: use XY(scatter) plots when you have a real dataset where x is more than just a counter, it gives better results.

2012-05-10 16:55:23 +0200 コメント付き回答 A Real PITA... LO 3.5.x Installer Fails Ad Infinitum: Quickstarter

This is a known problem with the upgrade (on windows?). LO3.4 needs to be removed before 3.5 install. See http://ask.libreoffice.org/question/1... for a more complete description of how to solve it.

2012-05-10 16:44:25 +0200 コメント付き質問 A Real PITA... LO 3.5.x Installer Fails Ad Infinitum: Quickstarter

Same issue, Windows vista. update from 3.4 (3.4.4 OOO340m1 (Build:402)). I usually run linux, windows mostly games, I don't run the quickstarter; tried w/o any browser running, didn't even start LO3.4. http://ask.libreoffice.org/question/1... might help.

2012-03-05 09:06:44 +0200 バッジを受け取った  学者 (source)
2012-03-02 18:38:09 +0200 バッジを受け取った  ナイス質問 (source)
2012-03-02 18:16:22 +0200 バッジを受け取った  生徒 (source)
2012-03-02 18:06:45 +0200 コメント付き回答 How can I display two cells contents in another cell, both in hour format ?

That is odd. Or embarrassing? Before I couldn't get that to work without #502 errors. But now it does indeed work.

2012-03-02 18:05:00 +0200 バッジを受け取った  編集者 (source)
2012-03-02 17:52:52 +0200 バッジを受け取った  サポーター (source)
2012-03-02 17:39:08 +0200 バッジを受け取った  素晴らしい回答 (source)
2012-03-01 21:27:06 +0200 コメント付き回答 To display two cells contents together in another cell

True, that's why, just like with your answer, where you add '& " " &' for a space in between the cell references, you'd have to concatenate a space before every next word apart from the first one. As I said: functionally the same, but more verbose. I' be mostly using 'your' & way in future.

2012-03-01 20:35:53 +0200 バッジを受け取った  教師 (source)
2012-03-01 14:27:45 +0200 質問に回答する Diagonal Fractions?

It would be a nice feature addition, something like a "compact" or "in-line" format option, I agree (something like the two different LaTeX equation types). I don't know how hard that is though.

For now, I keep using TexMath for equations (but I know LaTeX syntax already, and am used to the way the equations turn out); if only that could create something more than a picture. It is much more complex than what Libreoffice Math can do, so using the output of that with Math seems unlikely to be easier than adding an option for diagonal fractions.

2012-03-01 14:02:00 +0200 質問に回答する How can I auto-switch between languages in LibreOffice on Debian Linux?

Perhaps you could provide more information what you mean by "spellcheck auto-switch". Is it similar to this one: askUbuntu: switch spellcheck language when switching keyboard layout?

If so, and if your languages are supported (Russian and English, also Ukrainian, Belorussian, French, Romanian, Kazakh and German), maybe the Xneur package suggested in that link is useful. Note that development seems to have stalled though.

If it is not this issue, just to note, I don't use a different layout keyboard, as most languages I write can be done using a US layout with "special" characters provided via spellcheck. That works as long as I tell libreoffice which language they are supposed to be in (and have spellcheck for those languages installed). Checking a document that mixes languages then just "automatically" switches between different vocabularies as appropriate. This works both under linux and windows (but windows is more work to get the right language vocabularies installed).

2012-03-01 13:24:08 +0200 質問をする How can I display two cells contents in another cell, both in hour format ?

I know how to show (concatenate) the result of two cells. However, if the contents of the cells is in date-time format this seems harder.

I have a list of how many hours I worked on something per week over a period: 8 6 16 18 12 24 36 24 12. I want do display the min, and max. amount of hours I did (so far easy). I wish to show that in a single cell: "6-36" (with the unit for that column the absolute number of hours).

I have only been able to get the results shown as fraction of days, ie. "0.25-1.5".

I tried converting the numbers with the TEXT function, but that gives an error. Seemingly it won't work with date-time because those aren't simple numbers. I haven't found a DATETIME function that would return the right number.

Note that one issue in this is wanting absolute hours ([HH]), which I then use as a normal number, but wanting to keep them as a time-value so I can enter fractions of an hour in minutes (and not wanting to wrap after 24 h, hence [HH], not HH as a unit).

2012-03-01 13:00:33 +0200 質問に回答する To display two cells contents together in another cell

You can concatenate the contents of several cells using & Example: A1=Bad B1=Dog C1=A1&B1 = BadDog If you want to add a space between two text Values you need to type C1=A1&" "&B1 = Bad Dog (it's a space between the double quotes)

In addition to the above answer: there is the CONCATENATE function, which is what I used so far, before seeing Pedro's answer.

Why use it as it is longer but seems to do the same? Discover-ability (for me) and being more explicit in what you are doing; would consider keeping CONCATENATE for macro's, for example.

(@Lupp also editing:)
Now and then a user may want to expand this in a way concatenating an arbitrary number of cell contents given by one or more cell ranges e.g.
Starting with V5.2 there was implemented the new function TEXTJOIN which works well for such a task since V5.3, and is capable of inserting a chosen delimiter. There is also a setting to disregard empty content completely. The above example would be solved by =TEXTJOIN(" "; 0; A1:B1) e.g. returning "Bad Dog".
(Editing again:)
Concerning the comment by @Gilberto Schiavinatto I attach this little demo.
Please also note: While testing a bit for this demo I had to experience that TEXTJOIN is still not correctly implemented with some respect. In the most simple cases this may not spoil the usability.