Stel uw vraag

mahfiaz's profiel - activiteit

2020-05-05 14:33:39 +0100 badge ontvangen  Goed Antwoord (bron)
2018-09-26 11:39:00 +0100 reageerde op een antwoord Match Cells conditional format background.

Are you looking for $G$23=M8 ?

2018-09-26 11:37:16 +0100 reageerde op een antwoord Why am I getting ### in some of my cells?

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

2018-09-17 09:09:20 +0100 badge ontvangen  Goed Antwoord (bron)
2018-09-17 07:16:16 +0100 beantwoorde een vraag Match Cells conditional format background.

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

2018-09-17 07:09:44 +0100 beantwoorde een vraag I can't get my Calc-document to sort correct alphabetically.

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

2018-09-17 06:59:37 +0100 reageerde op een antwoord Why am I getting ### in some of my cells?

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

2018-09-17 06:56:03 +0100 reageerde op een vraag How to copy text with numbering?

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

2018-09-17 06:49:53 +0100 reageerde op een antwoord Clear all direct Formatting EXCEPT Italics?

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

2018-09-17 06:25:26 +0100 bewerkte een antwoord selectively clear direct formatting

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

2018-09-17 06:18:09 +0100 bewerkte een antwoord selectively clear direct formatting

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

2018-02-24 14:00:00 +0100 badge ontvangen  Mooi Antwoord (bron)
2016-09-04 07:10:18 +0100 reageerde op een antwoord LibreOffice 5.2.0.4 unbearably slow on Ubuntu 14.04

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

2016-08-15 15:06:46 +0100 badge ontvangen  Tovenaar (bron)
2016-08-14 08:07:57 +0100 reageerde op een antwoord How do I uninstall LibreOffice?

@Steven, just install it again.

2016-08-14 08:05:42 +0100 reageerde op een antwoord LibreOffice 5.2.0.4 unbearably slow on Ubuntu 14.04

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.

2016-08-14 08:02:15 +0100 reageerde op een vraag In Base, my IDE options are greyed out

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

2016-08-14 07:58:28 +0100 reageerde op een vraag In Draw, Export of a table does not work, does not have size of selection

Does it work now in newer versions of LibO?

2016-08-14 07:56:19 +0100 reageerde op een vraag How do I get rid of the little bucket above the fonts

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.

2016-08-14 07:12:56 +0100 reageerde op een vraag in both ods and odt docs/spreadsheets won't accept keyboard input

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

2016-08-14 07:08:43 +0100 beantwoorde een vraag Trying to graph bicycle speed gear ratios.

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

gear ratios.ods

2016-08-13 22:37:05 +0100 reageerde op een antwoord Is there an easy way to find a paragraph mark and replace it with a line ending or a space.

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

2016-08-13 22:17:57 +0100 reageerde op een antwoord Electrical and Fluid Schematic Palettes/Templates

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.

2016-08-13 21:49:43 +0100 reageerde op een antwoord Can I create a video from Impress slideshow?

@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.

2016-08-13 21:28:25 +0100 reageerde op een antwoord Why does LibreOffice produce such bloated .odt files?

@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.

2016-08-13 21:10:20 +0100 bewerkte een antwoord How to remove date stamp from changes and comments?

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()
2016-08-13 21:09:02 +0100 reageerde op een antwoord How to remove date stamp from changes and comments?

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.

2016-08-13 20:35:26 +0100 reageerde op een antwoord Calc file won't open by double-click

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

2016-08-13 19:25:20 +0100 reageerde op een antwoord scanning function freeze.

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

2016-08-13 19:22:14 +0100 reageerde op een antwoord selectively clear direct formatting

@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.

2016-07-29 18:10:18 +0100 badge ontvangen  Geweldig Antwoord (bron)
2015-07-20 08:25:27 +0100 badge ontvangen  Mooi Antwoord (bron)
2014-09-07 11:24:49 +0100 reageerde op een antwoord How to remove date stamp from changes and comments?

What would "this" refer to?

2014-07-27 10:45:45 +0100 badge ontvangen  Mooi Antwoord (bron)
2014-07-14 22:07:32 +0100 badge ontvangen  Mooi Antwoord (bron)
2014-07-13 10:47:39 +0100 reageerde op een antwoord When will LibreOffice have a ribbon UI (as in MS Office 2007-2013)?

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

2014-07-12 23:48:51 +0100 badge ontvangen  Mooi Antwoord (bron)
2014-07-12 19:53:31 +0100 reageerde op een antwoord When will LibreOffice have a ribbon UI (as in MS Office 2007-2013)?

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.

2014-07-07 16:55:50 +0100 beantwoorde een vraag Why does page numbering restart at 1 in the middle of my document?

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)

2014-07-06 21:47:33 +0100 beantwoorde een vraag How do I convert my Microsoft docs to LibreOffice

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...

2014-07-06 15:31:56 +0100 beantwoorde een vraag Why does Calc's LOOKUP function give a wrong answer here?

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 :)

2014-07-03 10:25:05 +0100 reageerde op een antwoord Find/replace only first word in every paragraph

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

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

2014-06-30 09:55:54 +0100 reageerde op een vraag How do I COUNTIF and SUMIF cells whose value is not a specific text?

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

2014-06-23 21:27:58 +0100 badge ontvangen  Goed Antwoord (bron)