mahfiaz's profiel - activiteit

Are you looking for $G$23=M8 ?

It's a cell what contains a string, the string could be empty as well. Click on cell, type ="" and press Enter.

Use the following formula for conditional formatting: =MATCH(G23;$Sheet1.$M$8:$M$17;0)

This is a bug. If field format is text, it should be sorted as text value. As a workaround you could: Start writing t

@PKB_68, if it shows #VALUE, it means the calculation in that cell could not be completed, e.g you tried to calculate wi

Does it work if you copy to Notepad or any other text editor? (works for me in 6.0.3.2)

For bold search for attribute "Font weight" and use character style "Strong emphasis".

EDIT There is a much easier way to achieve this, answered by @pierre-yves-samyn: https://ask.libreoffice.org/en/questio

EDIT There is a much easier way to achieve this, answered by @pierre-yves-samyn: https://ask.libreoffice.org/en/questio

There are a few specific bugs which cause slowdown, e.g this, maybe your case is similar? https://bugs.documentfoundation.org/s...

@Steven, just install it again.

I am surprised as well. My best bet is that you had a program using full CPU until the restart. Use system monitor to see which one.

Have you tried following a guide in wiki or somewhere? Google for libreoffice base how to

Does it work now in newer versions of LibO?

No idea what and how is happening. Try saving the document and opening it again. If the problem returns, then maybe screencast would help to understand, what is happening.

Is the document opened read-only? (e.g directly from mailbox or unwritable drive)

I think easiest is to not explain but show. See the attached file.

gear ratios.ods

@larrybradley, you must check "Regular expressions" in search and replace dialog.

rm -r /

This is paranoia mixed with half-truths. As you can see even my comment contains malicious code. Is your computer ruined now? Extensions DO matter.

@Raghav, how long did it take for you to compose any meaningful 100-slide presentation, I bet it's far longer than 8 minutes 20 seconds? That said you could make the slides advance automatically, leave it to be, go grab a coffee or get a powernap and voilá, it's done.

That said, if those 100 slides are just images (you are making a slideshow), then there are far better tools with Ken Burns' effect and stuff. I leave googling these as an exercise of the reader.

@benny, not that I know of. Nowadays pretty much nobody cares about file sizes below few MBs. If you archive a lot of ODT files you could remove the thumbnail for yourself.

Also fun fact: unzipped (e.g TAR-ed) ODT would actually compress better if you compressed more than one file like this.

Unzip a .odt file, it contains content.xml file. A comment looks like this:

<office:annotation office:name="__Fieldmark__1_514712390">
  <dc:creator>John Smith</dc:creator>
  <dc:date>2014-05-29T14:38:39.846905891</dc:date>
  <text:list text:style-name="">
   <text:list-item>
    <text:p text:style-name="P2">
     <text:span text:style-name="T1">A comment text.</text:span>
    </text:p>
   </text:list-item>
  </text:list>
</office:annotation>

Now all you need to do is replace all <dc:date>2014-05-29T14:38:39.846905891</dc:date> with a dummy date, e.g 2000-01-01T12:00:00.0 and save it back to original .odt file. Or why not use the date when document was created (in meta.xml): <meta:creation-date>2014-05-29T14:38:30.386644381</meta:creation-date>

The following python script does it for you and renames the file as name-clean.odt:

#!/usr/bin/python

import glob, re, os, sys, zipfile

for pattern in sys.argv[1:]:
    for filepath in glob.glob(pattern):
        dirname, basename = os.path.split(filepath)
        root, ext = os.path.splitext(basename)
        newname = '%s-clean%s' % (root, ext)
        outpath = os.path.join(dirname, newname)
        zin = zipfile.ZipFile (filepath, 'r')
        zout = zipfile.ZipFile (outpath, 'w')
        for item in zin.infolist():
            if item.filename == 'mimetype':
                zout.writestr(item, zin.read(item.filename))
        for item in zin.infolist():
            if item.filename == 'meta.xml':
                data = zin.read(item.filename)
                # Find the document creation timestamp.
                timestamp = re.search(r'<meta:creation-date>([^<]+)</meta:creation-date>', data).group(1)
        for item in zin.infolist():
            if item.filename == 'content.xml':
                data = zin.read(item.filename)
                # Replace all occurrences of date in <dc:date>
                data = re.sub('<dc:date>[^<]+</dc:date>', '<dc:date>%s</dc:date>' % timestamp, data)
                zout.writestr(item, data)
            elif item.filename != 'mimetype':
                zout.writestr(item, zin.read(item.filename))
        zout.close()
        zin.close()

It warns that file named mimetype is already in the zip (it was added on line 15, because mimetype file has to be the first in zip). It means the zip is kind of malformed, (contains two files with the exact same name). It is no problem for any viewers I have used nor for LibreOffice.

To get rid of the warning you could change line 18 from else: to elif item.filename != 'mimetype':

I did this change in the script above.

Would installing the regular (non-portable) version work?

Hey, if it still happens for you, please write a proper bug report at bugs.libreoffice.org

@darioshanghai, no not a mistake at all. $0 returns the whole match, while $1 is just the first group, which means anything inside first pair of parenthesis (). So if your search is (.*) not .*, then it will work just fine. Although for this case using .* and $0 would be 2 characters shorter.

What would "this" refer to?

@Xanderxavier, you exclude people who switched to LO especially because they do not want the ribbon.

As you can see there are quite some people who are happy with the usual UI or even in favor of it. So to paraphrase your standpoint, then how could some people so stubborn to keep demanding a ribbon interface if there are number of problems with it.

Also, we are sorry to see you leave, but right now if you really like the ribbon, spend some bucks and buy a copy of MS Office.

If you really would like ribbon or why not something better on LO, then contact the design team and start a kickstarter.

This happens if you insert a special page break with page number change. See Insert → Manual break (this is how to make such a break).

Now just delete that page break and insert a new one. To do so, go to the very start of the new page and delete with the backspace (deleting to the left). This should delete the break. (Thanks, Lancer for pointing this out)

They didn't. You probably reinstalled MS Office or somehow answered yes to a question if you want Excel always to open your .ods documents. To change it back, see the last comment on this question by @John.bandaru : http://ask.libreoffice.org/en/questio...

As already mentioned but not exactly stated: You should either sort your data or use HLOOKUP or VLOOKUP with sorted parameter set to 0 (unsorted). Or if you like, you could use OFFSET and MATCH for the very same purpose (again, match with type 0).

So how do LOOKUP and friends work with (supposedly) sorted lists? It goes value by value until the next value is larger than the search criterion. It has one important benefit, your list might contain values 1, 2, 3, 4, 5 and when you search for 3.5 you get 3. With unsorted search it requires exact match and 3.5 would match nothing from this list.

So let's say that your data is 1, 3, 5, 2, 6, 8. When you search for 2, you get 1. When you search for 7 you get 6 and when you search for 5.5 you get 2. Unsorted search is fun :)

\w+ does not need surrounding [] (although they don't hurt).

Also, regex searches work just fine in Calc as well.

The cells which contain functions probably have boolean type. Everything except 0 is True.