Fai la tua domanda

Moshpirit's profile - attività

2021-02-11 02:03:26 +0200 ha posto una domanda Any way to get the Descriptive Statistics resume (through Data) when using absolute frequencies?

Any way to get the Descriptive Statistics resume (through Data) when using absolute frequencies? To run the descriptive

2021-01-23 05:35:20 +0200 received badge  Domande famose (source)
2020-12-20 23:25:02 +0200 ha accettato una risposta How to move the position of a comment in LO Writer?

Imagine this text, where "*" means there's a comment:

Fractal and multifractal analysis are commonly used to evaluate pore structure and its heterogeneity. Compared with fractal analysis, multifractal analysis can determine the globe and local properties of pores in rocks.* Low-field NMR measurement in laboratory and field wells is an important method for studying pore structures and other petrophysical parameters of reservoirs.

So in this example there is a comment after "pores in rocks.", but let's imagine I want to move it after "Low-field NMR":

Fractal and multifractal analysis are commonly used to evaluate pore structure and its heterogeneity. Compared with fractal analysis, multifractal analysis can determine the globe and local properties of pores in rocks. Low-field NMR* measurement in laboratory and field wells is an important method for studying pore structures and other petrophysical parameters of reservoirs.

Is there any way to just move the comment without copying/pasting it in a new comment?

2020-12-20 18:12:59 +0200 received badge  Domanda gettonata (source)
2020-12-19 19:57:08 +0200 ha commentato una risposta How to move the position of a comment in LO Writer?

Cool! thanks! IDK why but I thought I could not do that.

2020-12-19 19:36:55 +0200 received badge  Domande famose (source)
2020-12-19 19:36:06 +0200 ha posto una domanda How to move the position of a comment in LO Writer?

How to move the position of a comment in LO Writer? Imagine this text, where "*" means there's a comment: Fractal an

2020-11-06 17:26:26 +0200 ha commentato una risposta [Writer] Why while the style is the same (Text body), they appear so differently?

I see, thanks!

2020-11-06 10:45:24 +0200 received badge  Domanda gettonata (source)
2020-11-06 00:38:46 +0200 received badge  Entusiasta
2020-11-05 23:33:59 +0200 ha commentato una risposta [Writer] Why while the style is the same (Text body), they appear so differently?

I see, thank you so much for such complete explanation! I was asking before noticing your new comment if there is a way

2020-11-05 22:35:35 +0200 ha commentato una risposta [Writer] Why while the style is the same (Text body), they appear so differently?

I see, thank you so much!! That was perfectly explained. I imagine there is no way to do that without removing the bold

2020-11-05 22:35:35 +0200 received badge  Commentatore
2020-11-05 22:32:14 +0200 ha accettato una risposta [Writer] Why while the style is the same (Text body), they appear so differently?

I'm giving some style to some debating notes that a friend shared with me but sometimes I find this: when I select the text and the format into Text body ("Cuerpo de texto" in Spanish), it's just partially modified. Some of the text keeps its previous format: Corbel font (12 pts) instead of Liberation Sans (11pts).

I'll leave some screenshots below and a demo ODT file attached.
I'm using LO 7.0.3.1 on GNU/Linux.


Styling ODT file demo.odt

screenshot 1: Properties

screenshot 2: Styles and formats

2020-11-05 21:41:20 +0200 ha posto una domanda [Writer] Why while the style is the same (Text body), they appear so differently?

[Writer] Why while the style is the same (Text body), they appear so differently? I'm giving some style to some debating

2020-10-20 16:55:03 +0200 ha commentato una risposta IDK why FIND() gives me this value when comparing these two tables on LO Calc

Because I had no idea that such tool existed. I should search for some cheatsheet for LO Calc and keep it around when I'

2020-10-20 15:21:05 +0200 ha commentato una risposta IDK why FIND() gives me this value when comparing these two tables on LO Calc

That was it!! thanks a lot! I think LO should have (if it doesn't) some tool to remove latest spaces.

2020-10-20 15:19:14 +0200 ha accettato una risposta IDK why FIND() gives me this value when comparing these two tables on LO Calc

I have two tables:

  • columns A (names) and B (empty)
  • columns C (names) and D (values)

Columns A and B are sorted in a sheet in a way, C and D are sorted differently in another sheet. I want to get the values of column D in B respecting the way is sorted in the first sheet. In order to make it simple here, we'll say they all are in the same sheet but with a different sorting method.

Here's an little example where I removed most of the cells:

| Column A   | Column B | Column C  | Column D |
|------------|----------|-----------|----------|
| SI06SE020  |          | SI06JA038 | 98,66    |
| SI06JA023  |          | MI06JA109 | 96,8     |
| SI06JA038  |          | SI06JA033 | 94,98    |
| SI06JA039  |          | SI06JA107 | 94,91    |
| SI06JA040  |          | SI06JA124 | 94,81    |
| SI06JA124  |          | SI06JA039 | 91,18    |
| SI06SE139  |          | SI06SE140 | 91,28    |
| MI06HU065  |          | SI06SE020 | 86,82    |

As you can see, A2 (SI06SE020) is the same value as the latest of column C.

I'm trying to get D values comparing A with C with Find(), so B2 formula would be =FIND(A2;$C$2:$C$57;$D$2:$D$57). Instead of getting 86,82, I'm getting 94,81 (which belongs to SI06JA039) but have no idea of why.

2020-10-20 15:17:28 +0200 received badge  Domanda gettonata (source)
2020-10-20 14:56:37 +0200 ha commentato una domanda Is there a LibreOffice .odt, .ods viewer for Android?

Definitely Collabora Office for Android. Also AndrOpen Office

2020-10-20 13:39:58 +0200 ha commentato una risposta IDK why FIND() gives me this value when comparing these two tables on LO Calc

Thanks! I tried VLOOKUP before but I got #N/A instead of the result. Even though there's 0 in the last variable of =VLOO

2020-10-20 12:40:37 +0200 ha posto una domanda IDK why FIND() gives me this value when comparing these two tables on LO Calc

IDK why FIND() gives me this value when comparing these two tables on LO Calc I have two tables: columns A (names) an

2020-10-20 11:56:17 +0200 received badge  Domanda notevole (source)
2020-10-20 11:56:17 +0200 received badge  Domande famose (source)
2020-10-20 11:56:17 +0200 received badge  Domanda gettonata (source)
2020-08-10 18:37:22 +0200 received badge  Domanda notevole (source)
2020-08-09 20:08:37 +0200 received badge  Domanda gettonata (source)
2020-08-09 19:54:26 +0200 ha commentato una risposta if cell contains this text then [closed]

Thank you so much! That was a very complete an helpful answer!! :)

2020-08-09 19:52:32 +0200 received badge  Sostenitore (source)
2020-08-09 19:52:29 +0200 ha accettato una risposta if cell contains this text then [closed]

I saw this post but in my case I want to use it with "IF()" (or anything that may give me the result I'm looking for):

Column A has some text | Column B has numbers | for column C, if a cell of column A contains "TJ" within the cell, then write the number this cell has next to it.

Eg:

A | B | C   
--|--|--   
ABC | 5 |    
TJK | 6 | 6   
NGB | 0 |    
CTJ-2 | 18 | 18

EDIT:

What would be the easier way to include another text condition?

=IF(OR(ISNUMBER(FIND("TJ";A1));ISNUMBER(FIND("BLA";A1)));B1;"") maybe?

2020-08-09 19:38:43 +0200 ha modificato una domanda if cell contains this text then [closed]

if cell contains this text then I saw this post but in my case I want to use it with "IF()" (or anything that may give m

2020-08-09 19:24:55 +0200 ha commentato una domanda if cell contains this text then [closed]

Great! edit done! :)

2020-08-09 19:04:56 +0200 ha modificato una domanda if cell contains this text then [closed]

if cell contains this text then I saw this post but in my case I want to use it with "IF()" (or anything that may give m

2020-08-09 19:03:55 +0200 ha commentato una domanda if cell contains this text then [closed]

Thanks =IF(ISNUMBER(FIND("TJ";A1));B1;"") works perfectly! what would be the easier way to include another text conditio