질문하기

Chris Vella's profile - activity

2017-03-17 23:03:06 +0200 받은 배지  유명한 질문 (source)
2016-10-31 14:34:22 +0200 받은 배지  주목할 만한 질문 (source)
2016-10-30 22:28:27 +0200 받은 배지  인기있는 질문 (source)
2016-10-29 18:32:53 +0200 질문하였습니다 Transform manual formatting into styles

It happens frequently that someone who does not know how to use styles, writes a long document using solely manual formatting.

Is there a way to "scan" the document for similarly formatted text and create styles and assign style automatically to the different parts of the document?

2016-03-01 16:38:46 +0200 받은 배지  선각자 (source)
2015-11-03 21:13:01 +0200 으뜸 답변으로 표시됨 Joining subsequent paragraphs with same style

I have a document with a series of paragraphs with the same style.

I would like to replace the paragraph marks with line breaks to join the paragraphs having the same style into one.

The reason being, I want to be able to set spacing above and the below the paragraphs when the style changes only.

How do I go about it?

2015-11-01 13:04:33 +0200 받은 배지  유명한 질문 (source)
2015-10-29 16:06:26 +0200 으뜸 답변으로 표시됨 Writer smart automatic formatting

Is there a smart way (extension, macro, etc) to apply automatically header paragraph styles to a Writer document where header where manually formatted using bold, indents and numbering for example?

The reason for this is to be able to create a table of contents.

2015-10-26 19:58:27 +0200 으뜸 답변으로 표시됨 How do I export a clean html file?

The Save as HTML option in Libreoffice produces an html file with a lot of markup. Is there an easy way to export a cleaner html file for the production of an epub or for web publishing? How do I clean an HTML produced by Libreoffice?

2015-09-11 18:24:20 +0200 받은 배지  유명한 질문 (source)
2015-04-23 18:16:09 +0200 받은 배지  유명한 질문 (source)
2015-02-17 08:41:00 +0200 받은 배지  주목할 만한 질문 (source)
2015-02-17 08:41:00 +0200 받은 배지  인기있는 질문 (source)
2015-02-10 14:39:50 +0200 받은 배지  훌륭한 질문 (source)
2014-10-16 21:31:02 +0200 받은 배지  주목할 만한 질문 (source)
2014-10-16 19:16:34 +0200 받은 배지  인기있는 질문 (source)
2014-10-16 18:35:06 +0200 코멘트달린 답변 Formula to display "October/November"

That would return the present month and not the month of the date in C2 or O2. Also, if there's overlap the formula would return "1".

2014-10-16 18:33:06 +0200 질문에 답변하였습니다 Formula to display "October/November"

I found a solution myself with the following formula:

=IF(MONTH(C2)=MONTH(O2),TEXT(DATE(YEAR(C2),MONTH(C2),DAY(C2)),"mmmm"),CONCATENATE(TEXT(DATE(YEAR(C2),MONTH(C2),DAY(C2)),"mmmm"),"/",TEXT(DATE(YEAR(O2),MONTH(O2),DAY(O2)),"mmmm")))

This seems too cumbersome but it is functional.

2014-10-16 16:34:48 +0200 코멘트달린 답변 Formula to display "October/November"

MONTH(C2) & "/" & MONTH(O2) returns "10/11" not "October/November".

2014-10-16 16:20:27 +0200 질문하였습니다 Formula to display "October/November"

I have a sheet with 7 columns, one for each day of the week showing only the day value. I also have a cell which shows the month in text format example "October". I wish that in those weeks which overlap between two months, the value of this cell changes to "October/November".

I managed to write a formula that determines if there's overlap or not =IF(MONTH(C2)=MONTH(O2),C2,1) where C2 is Monday and O2 is Sunday. I am unable to set the value to the combination of the two (with what should I replace the 1 above?).

2014-08-02 11:33:42 +0200 받은 배지  유명한 질문 (source)
2014-08-02 11:33:42 +0200 받은 배지  주목할 만한 질문 (source)
2014-08-02 11:33:42 +0200 받은 배지  인기있는 질문 (source)
2014-08-02 09:09:39 +0200 받은 배지  좋은 답변 (source)
2014-08-02 03:56:41 +0200 받은 배지  훌륭한 답변 (source)
2014-08-01 21:43:05 +0200 질문에 답변하였습니다 Why is the V4.3 .deb file not one installable unit?

All you have to do is to open a terminal window and go the the folder where you put the .deb files with cd folder/containing/the/files.

Then run: sudo dpkg -i *

It will install all files.

2014-07-31 18:49:14 +0200 질문하였습니다 How do I tell Calc not to print the background colour of cells?

I have a spreadsheet with colour-coded cells (some cells have a background colour).

I want these colours to show on screen but not print. I cannot find this option anywhere.

I have an HP Laserjet P1002.

Operating System: Ubuntu 14.04.

2014-04-04 22:47:49 +0200 받은 배지  주목할 만한 질문 (source)
2014-04-04 22:47:49 +0200 받은 배지  유명한 질문 (source)
2014-04-04 22:47:49 +0200 받은 배지  인기있는 질문 (source)
2014-02-01 22:50:31 +0200 받은 배지  훌륭한 질문 (source)
2014-01-31 14:27:13 +0200 질문에 댓글을 달았습니다 How can I create books through py-uno?

It is not clear what your question is about. Libeoffice can do all of the above. If you're after scripting to create a document prepared for book publishing, maybe this is not the best site to get help. Why not try http://libreofficeforum.org/ ?

2013-11-03 02:38:46 +0200 받은 배지  주목할 만한 질문 (source)
2013-11-03 02:38:46 +0200 받은 배지  인기있는 질문 (source)
2013-11-03 02:38:46 +0200 받은 배지  유명한 질문 (source)
2013-10-23 16:58:28 +0200 받은 배지  유명한 질문 (source)
2013-10-22 23:55:15 +0200 받은 배지  유명한 질문 (source)
2013-10-18 00:29:26 +0200 으뜸 답변으로 표시됨 how do I merge columns in Calc?

I would like to paste the contents of two columns into one column with just a space or a dash in between in between. How do I do that?

2013-10-18 00:07:51 +0200 으뜸 답변으로 표시됨 Error in writing sub-document content.xml

I'm trying to save a 4 page file which contains different formats and comments with Libreoffice writer 4.0.

I'm getting an error message:

Error saving the document Document name:
Write Error.
Error in writing sub-document content.xml
2013-10-01 20:03:34 +0200 으뜸 답변으로 표시됨 How do I keep a part of my user profile?

I have a problem with Libreoffice find and replace. I discovered that there is something in my user profile which is causing this problem because renaming the ~/.config/libreoffice folder (I'm on Linux) solves the issue.

Is there a way to keep only the custom settings, words added to the dictionary and delete the rest?

2013-10-01 20:03:02 +0200 으뜸 답변으로 표시됨 Merge multiple csv files removing duplicates

I have a series of backups of a csv file. I would like to merge them in a single spreadsheet, removing the duplicate entries.

Is there an easy way to do this in Calc?

2013-10-01 20:00:26 +0200 으뜸 답변으로 표시됨 Search for text in odt files in a folder

Is it possible to search for a text string in a series of odt files in a folder all at once?