質問する

Thibault's profile - activity

2018-01-20 20:37:30 +0200 バッジを受け取った  人気の質問 (source)
2018-01-20 20:37:30 +0200 バッジを受け取った  有名な質問 (source)
2018-01-20 20:37:30 +0200 バッジを受け取った  卓越した質問 (source)
2017-08-09 18:40:47 +0200 バッジを受け取った  有名な質問 (source)
2016-08-27 08:25:09 +0200 バッジを受け取った  卓越した質問 (source)
2016-08-19 06:50:29 +0200 バッジを受け取った  人気の質問 (source)
2016-05-09 18:24:45 +0200 質問をする How to make multiple pages of labels

Hi

I want to make 1 document with 2 pages of labels (each label is different). But I only seem to be able to make 1 page of labels). Is there a setting that I'm not seeing or something?

thanks Thibault

2016-04-07 19:56:52 +0200 質問に回答する How to download without bittorrent/p2p

This is a link to the official version of the actual website (not a mirror): http://download.documentfoundation.or...

does this work?

EDIT: Can you see this page? http://download.documentfoundation.or... if yes, does clicking on your country's HTTP work?

2016-03-15 08:20:22 +0200 バッジを受け取った  編集者 (source)
2016-03-14 11:41:45 +0200 質問をする Filter doesn't update when formula changes data

Hi,

The calc file that I'm having trouble with is for keeping track of changes in stock of products (up or down). I have a formula in column D that checks if the user has put a product name in column A on the same row. If that's not the case. It should show the total of all the prices. (It check if the cell in the column A above the current row isn't empty so that it only shows the total once in the column).

Problem is that when I try to export this as a pdf I don't want it to show all the rows that have no products in them. (It currently does show them simply because there is a formula inside of every cell in Column D even if the result is " ".

My attempt was to let it the result be 'DONTPRINT' if it should be blank and have it be filtered out using a 'standard filter' and this works. But when I try to add another product it doesn't update. If I put something in A29 for example. The totaal should move down one row but now it disappears because the filter hid the row below it.

I hope you understand what I mean. If not. Feel free to comment.

PS. Here is a video of what happens on my computer. Please put annotations on so you can see my commentary https://www.youtube.com/watch?v=isLcS...

ALSO I just noticed that the total at the bottom doesn't update for some reason

Thanks in advance!

See example file from video

Version: 5.1.0.3 Build ID: 5e3e00a007d9b3b6efb6797a8b8e57b51ab1f737 CPU Threads: 8; OS Version: Windows 6.2; UI Render: default; Locale: nl-BE (nl_BE)

2016-02-29 17:19:49 +0200 バッジを受け取った  有名な質問 (source)
2016-02-18 15:01:41 +0200 質問に回答する Calc on Windows 10 and Linux

The files should work the same on mac, linux and windows. You will need to install Libreoffice as the Ubuntu version on your laptop though. If you only want calc you can install it by typing the following into the terminal:

Sudo apt-get install libreoffice-calc

EDIT Ubuntu comes with Libreoffice by default so you'll already have Calc. Try to make sure that your windows version and your Ubuntu version have the same Libreoffice version though. If you need to update the Libreoffice version on Ubuntu to 5.1 for example do the following:

sudo add-apt-repository ppa:libreoffice/libreoffice-5-1
sudo apt-get update
sudo apt-get upgrade
2016-02-16 14:39:29 +0200 コメント付き回答 Is moderation killing Ask LibreOffice?

When a comment or post is in the moderation queue and I change something, does it get pushed to the bottom of the list again?

2016-02-16 14:39:22 +0200 質問に回答する Language display for recent document list

I don't have much experience with foreign languages symbols but I found this which might be useful to you: https://ask.libreoffice.org/en/question/15879/chinese-characters-show-unreadable-square/?answer=15885#post-id-15885

2016-02-16 14:39:18 +0200 質問に回答する Is moderation killing Ask LibreOffice?

I agree. When looking at websites like reddit for example which also relies on voting and moderation. The mods only have to come in if they say something that is against the rules. I was going to say it may have something to do with spam. But they've got Google's reCAPTCHA which I'm pretty stops 99% of all spammers.

If posts automatically got published instead of going trough a mod queue that might indeed faster support. Another advantage over Office. I have asked multiple friends who all have own Office 2003,2007,2010,... and then have NEVER EVER contacted Microsoft for support. Seems weird that you pay for, pretty expensive, office suite and don't even get support for it. If new users got <24 hours support that would SUPER convenient for many people!

Original date I made this answer: 2016 02 16 08:25

2016-02-16 14:31:48 +0200 質問に回答する Not save PrinterName?

Hi,

The only way I know how to do it is a bit complicated. I made a very quick youtube video showing how to do it: https://youtu.be/ntSOVn_LUBc (sorry mouse was acting weird during recording)

Basically you have to download this program and install it: http://archive.editix.com/download.html

Once it's installed, open it and go to file -> open and select 'all files' instead of 'xml files' then select your libreoffice office document and open it.

On the left you should see a file called 'settings.xml', double click on it. Press Ctrl+F and search for 'PrinterName' and press enter. Then use the right arrow key on your keyboard and keep pressing it until you see the name of your printer. It should look something like this:

<config:config-item config:name="PrinterName" config:type="string"/>THIS IS YOUR PRINTER

Just delete the name of your printer and press Ctrl +S to save the file.

Now you can exit the program and the file shouldn't contain your printer name anymore. Don't open it though because that might add the printername again.

If I didn't explain it well, or you have questions, feel free to ask :-)

2016-02-16 08:26:35 +0200 バッジを受け取った  オーガナイザー (source)
2016-02-15 18:13:51 +0200 バッジを受け取った  卓越した質問 (source)
2016-02-15 12:08:55 +0200 コメント付き質問 Give Feedback link not working

When I try to click on the 'give feedback' button it shows the right page. I didn't a feedback but I can see the page so looks good for me. Windows 10 64-bit (Chrome Stable)

2016-02-15 12:08:49 +0200 コメント付き回答 Libreoffice writer Macro searching document

Btw, is there actually a way to use a BASIC Macro to click the button 'Synchronise Labels' when creating labels in Writer? Because if there is that's what it should do before showing the print preview. I didn't think there was a way to do that so I didn't think about asking.

Thanks for the updated script Again!

2016-02-15 12:07:42 +0200 コメント付き回答 Libreoffice writer Macro searching document

I already have XD. Thank you very much, this is exactly the macro I was looking for. Thank you again for making my switch to Libreoffice easier!

2016-02-10 16:18:55 +0200 バッジを受け取った  学者 (source)
2016-02-10 01:58:07 +0200 バッジを受け取った  卓越した質問 (source)
2016-02-09 17:30:23 +0200 コメント付き回答 Libreoffice writer Macro searching document

This is perfect! I'm trying to also make a print preview show up when it didn't find anything. I found "uno.PrintPreview" but I'm not sure how to use it. Could you maybe change the script so it shows a print preview when it didn't find 'xx'. Thanks btw for the previous script, can I donate to you or something?

2016-02-09 15:06:23 +0200 バッジを受け取った  人気の質問 (source)
2016-02-09 14:28:35 +0200 バッジを受け取った  熱心な人
2016-02-08 14:19:38 +0200 質問をする Libreoffice writer Macro searching document

Hi,

I'm trying to create a macro that searches my document for "xx" and if it's found one or more times it should show a messagebox.

Using the script recorder I recorded this but don't know how to continue...:

   REM  *****  BASIC  *****



sub Main
rem ----------------------------------------------------------------------
rem define variables
dim document   as object
dim dispatcher as object
rem ----------------------------------------------------------------------
rem get access to the document
document   = ThisComponent.CurrentController.Frame
dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")

rem ----------------------------------------------------------------------
dim args1(20) as new com.sun.star.beans.PropertyValue
args1(0).Name = "SearchItem.StyleFamily"
args1(0).Value = 2
args1(1).Name = "SearchItem.CellType"
args1(1).Value = 0
args1(2).Name = "SearchItem.RowDirection"
args1(2).Value = true
args1(3).Name = "SearchItem.AllTables"
args1(3).Value = false
args1(4).Name = "SearchItem.SearchFiltered"
args1(4).Value = false
args1(5).Name = "SearchItem.Backward"
args1(5).Value = false
args1(6).Name = "SearchItem.Pattern"
args1(6).Value = false
args1(7).Name = "SearchItem.Content"
args1(7).Value = false
args1(8).Name = "SearchItem.AsianOptions"
args1(8).Value = false
args1(9).Name = "SearchItem.AlgorithmType"
args1(9).Value = 0
args1(10).Name = "SearchItem.SearchFlags"
args1(10).Value = 0
args1(11).Name = "SearchItem.SearchString"
args1(11).Value = "xx"
args1(12).Name = "SearchItem.ReplaceString"
args1(12).Value = ""
args1(13).Name = "SearchItem.Locale"
args1(13).Value = 255
args1(14).Name = "SearchItem.ChangedChars"
args1(14).Value = 2
args1(15).Name = "SearchItem.DeletedChars"
args1(15).Value = 2
args1(16).Name = "SearchItem.InsertedChars"
args1(16).Value = 2
args1(17).Name = "SearchItem.TransliterateFlags"
args1(17).Value = 256
args1(18).Name = "SearchItem.Command"
args1(18).Value = 0
args1(19).Name = "SearchItem.SearchFormatted"
args1(19).Value = false
args1(20).Name = "Quiet"
args1(20).Value = true

dispatcher.executeDispatch(document, ".uno:ExecuteSearch", "", 0, args1())


end sub
2015-12-30 02:07:42 +0200 バッジを受け取った  人気の質問 (source)
2015-11-23 16:25:09 +0200 質問に回答する In Write how to insert check boxes
2015-11-16 18:34:27 +0200 質問をする Why can't I export in Writer and Draw to PDF/A ISO 19005-3

Hi

I'm trying to edit a pdf and save it as PDF/A but With PDF/A 1 the layout changes too much. And I wonder if it supported ISO 19005-3 (PDF/A 3) it might not change the layout that much.

Thanks