Pergunte aqui

Perfil de bosyber - atividade

2017-06-25 21:17:17 +0200 Medalha recebida  Iluminado (fonte)
2017-06-25 21:17:13 +0200 Medalha recebida  Resposta boa (fonte)
2014-01-04 17:51:38 +0200 Medalha recebida  Pergunta boa (fonte)
2014-01-04 17:48:35 +0200 Medalha recebida  Pergunta famosa (fonte)
2014-01-04 17:48:35 +0200 Medalha recebida  Pergunta notável (fonte)
2013-07-24 21:14:12 +0200 Medalha recebida  Palpiteiro
2013-07-24 21:14:12 +0200 Pergunta comentada 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 Medalha recebida  Organizador (fonte)
2013-07-24 20:31:28 +0200 Resposta comentada 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 Resposta comentada 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 Medalha recebida  Pergunta popular (fonte)
2013-02-24 17:50:06 +0200 Medalha recebida  Resposta legal (fonte)
2012-07-13 17:12:09 +0200 Medalha recebida  Taxonomista
2012-05-10 17:33:14 +0200 Resposta comentada 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 Pergunta comentada 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 Pergunta comentada 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 Resposta comentada 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 Pergunta comentada 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 Medalha recebida  Acadêmico (fonte)
2012-03-02 18:38:09 +0200 Medalha recebida  Pergunta boa (fonte)
2012-03-02 18:16:22 +0200 Medalha recebida  Estudante (fonte)
2012-03-02 18:06:45 +0200 Resposta comentada 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 Medalha recebida  Editor (fonte)
2012-03-02 17:52:52 +0200 Medalha recebida  Torcedor (fonte)
2012-03-02 17:39:08 +0200 Medalha recebida  Resposta legal (fonte)
2012-03-01 21:27:06 +0200 Resposta comentada 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 Medalha recebida  Professor (fonte)
2012-03-01 14:27:45 +0200 Respondeu uma pergunta 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 Respondeu uma pergunta 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 Perguntou 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 Respondeu uma pergunta 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.