Moshpirit's profile - attività

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

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?

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

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

I see, thanks!

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

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

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

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

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

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

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.

Definitely Collabora Office for Android. Also AndrOpen Office

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

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

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

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?

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

Great! edit done! :)

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

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