We will be migrating from Ask to Discourse on the first week of August, read the details here

发起问题

Przemo 的档案 - 活动

2021-05-14 21:25:39 +0200 获得奖牌  热门的问题 (来源)
2021-05-14 17:46:48 +0200 作最佳回答 How to set Calc tab colour based on cell content?

I want to set tab colour based on value from a cell. Same thing like conditional formatting for cells, but for tab. For example I have a value in cell A1: if the value is below zero I want that tab to be red, if it's above zero the tab colour should be green. If zero - grey.

2021-05-14 17:45:20 +0200 修改回答 How to set Calc tab colour based on cell content?

Macro that iterates over all sheets and sets tab colour to red or green base on value of A1 cell. sub set_tab_colour

2021-05-14 09:46:40 +0200 评论回答 How to set Calc tab colour based on cell content?

I agree. That was just a proof of concept. I'll improve the code using your suggestion.

2021-05-13 23:31:23 +0200 获得奖牌  受欢迎的问题 (来源)
2021-05-13 21:56:27 +0200 评论问题 How to set Calc tab colour based on cell content?

I failed with the dispatcher method, but I found something else...

2021-05-13 21:55:58 +0200 回答问题 How to set Calc tab colour based on cell content?

Sub set_tab_colour_by_cell_value() cell_location = "A1" ' cell value to be used to set the tab colour active_she

2021-05-13 21:55:24 +0200 评论问题 How to set Calc tab colour based on cell content?

Just because I allowed a possibility that there is a function to do it without a macro. Thanks for help!

2021-05-13 18:45:34 +0200 评论问题 How to set Calc tab colour based on cell content?

It' a 16 tab interlinked spreadsheet - I don't want to do it manually every time I change something, so macro is probabl

2021-05-13 18:19:01 +0200 问了问题 How to set Calc tab colour based on cell content?

How to set Calc tab colour based on cell content? I want to set tab colour based on value from a cell. Same thing like c

2021-03-25 11:14:31 +0200 获得奖牌  分类学者
2021-03-24 15:48:46 +0200 获得奖牌  批评家 (来源)
2021-03-24 15:44:38 +0200 评论问题 how do I share a libreoffice file with friends

Please provide what version of MS Office your friends use. Some older versions of MS Office don't support the ODF

2021-03-08 10:58:15 +0200 评论问题 why libraoffice not support chemistry markup language?

LibraOffice or LibreOffice,? Both exist, but they are not the same thing. This site is about LibreOffice.

2021-03-04 16:33:03 +0200 回答问题 Slow bootup during computer startup

Slow disk or other activities in parallel. Second start is probably from cached memory, so it's much faster. It has noth

2021-03-04 13:35:38 +0200 评论回答 Why ask.libreoffice is not available in language X? How can I help to create it?

Nothing came back so far. Edit: Just got a reply - watch the space. There are some big changes in the pipeline.

2021-03-04 09:23:20 +0200 评论回答 How to calculate the tangent of a curved line in LibreOffice Calc

@mab a and b are constants describing tangent line at the desired point.They are calculated, so you can drag the calls i

2021-03-03 16:16:29 +0200 评论问题 How to calculate the tangent of a curved line in LibreOffice Calc

@Opaque you can calculate local slope and shift the tangent line using local value - see my answer

2021-03-03 16:15:16 +0200 回答问题 How to calculate the tangent of a curved line in LibreOffice Calc

I''m not sure if there is a LO solution to this. A math solution attached. Tangent line at 0.7, but it easy to adjust by

2021-03-03 13:37:04 +0200 评论问题 How do I make a button in Writer that will save and close the document?

For key combination: use AutoHotKey

2021-03-03 13:25:56 +0200 评论问题 Change font size whole sheet Libra calc?

Libra or Libre? Libra is MS child, but you use linux?

2021-03-03 13:25:08 +0200 评论回答 Change font size whole sheet Libra calc?

Please edit your original post instead of using "answer"

2021-03-03 13:18:38 +0200 回答问题 How do I use google contacts as an addressbook.

You can export contacts as vcf file from google, use a online/offline converter to ods or csv and import into LO. Thunde

2021-03-03 12:50:59 +0200 回答问题 Why is everything a hyperlink after inserting a link?

Select the text that should not be hyperlink, right click, "Remove hyperlink". Maybe the closing bracket after the hyper

2021-03-01 19:55:49 +0200 评论问题 Libra office impress

They even sell LibreOffice for a tenner: https://www.microsoft.com/en-ie/p/libreoffice-vanilla/9npr3bznj4dm?activetab=pi

2021-03-01 15:19:21 +0200 评论问题 Libra office impress

Where is the file and where are the images? it's not clear if you embed images in link them. Check page 6 here: https://

2021-03-01 15:15:08 +0200 回答问题 Libra office impress

Most likely it's OneDrive problem not LO problem.

2021-03-01 15:11:13 +0200 评论回答 Libra office impress

Please post it as comment to the original question, not as an answer

2021-03-01 14:17:21 +0200 评论问题 Why ask.libreoffice is not available in language X? How can I help to create it?

OK, thanks! I can't edit it...

2021-03-01 14:00:31 +0200 获得奖牌  著名问题 (来源)
2021-02-28 22:04:46 +0200 获得奖牌  热门的问题 (来源)
2021-02-28 17:28:34 +0200 评论问题 LOCATE on firebird generates unknown function

OK, anyway it works now.

2021-02-28 17:27:40 +0200 评论回答 Why ask.libreoffice is not available in language X? How can I help to create it?

Nothing came back so far.

2021-02-28 17:26:33 +0200 修改问题 Why ask.libreoffice is not available in language X? How can I help to create it?

[ask.libreoffice] Why ask.libreoffice is not available in language X? How can I help to create it? Why ask.libreoffice i

2021-02-28 17:26:08 +0200 修改问题 How can I flag content for moderators?

[ask.libreoffice] How can I flag content for moderators? How can I flag content for moderators? Help [1] mentions it, bu

2021-02-28 11:29:48 +0200 获得奖牌  受欢迎的问题 (来源)
2021-02-27 23:12:52 +0200 评论问题 LOCATE on firebird generates unknown function

I think it depends on the karma. I've fixed the title.

2021-02-27 23:12:04 +0200 修改问题 LOCATE on firebird generates unknown function

LOCATE on HSQLDB generates unknown function Edit: WARNING: The title is misleading! I don't use HSQLSB, but I can't edit

2021-02-27 23:10:48 +0200 修改问题 LOCATE on firebird generates unknown function

LOCATE on HSQLDB generates unknown function Edit: WARNING: The title is misleading! I don't use HSQLSB, but I can't edit

2021-02-27 18:28:13 +0200 作最佳回答 List of SQL functions in HSQLDB embedded database?

Is there a list of SQL functions that are supported by the HSQLDB embedded database engine? I'm having problems even with functions like CONCAT.

P.S. I want to do a field split from one field containing "1/2016" to 2 fields with "1" and "2016", so I'll need functions like TRIM and LOCATE

The HSQLDB embedded database, fedora linux 33 or windows 10, LO 7.1

Update1: Column is TEXT [VARCHAR]

Update2: version info:

HSQL Database Engine 1.8.0.10
Sun Sep 01 22:10:46 IST 2019
version=1.8.0
hsqldb.cache_version=1.7.0
hsqldb.original_version=1.8.0
hsqldb.compatible_version=1.8.0

Update3: the data is in format: number/year. The number is 1 or 2 digits, the year is always 4 digits. No leading/trailing spaces.

Update4: I use the same ods file on 2 systems: windows 10 and linux fedora and I wrongly assumed that if I see HSQLDB on windows it's the same on linux...

2021-02-27 18:27:56 +0200 修改问题 List of SQL functions in HSQLDB embedded database?

List of SQL functions in HSQLDB embedded database? Is there a list of SQL functions that are supported by the HSQLDB emb

2021-02-27 18:26:38 +0200 评论问题 LOCATE on firebird generates unknown function

@Opaque Thank you! - thant's another lesson for me! I use the same ods file on 2 systems: windows 10 and linux fedora an

2021-02-27 18:26:19 +0200 评论问题 LOCATE on firebird generates unknown function

Thank you! - thant's another lesson for me! I use the same ods file on 2 systems: windows 10 and linux fedora and I wron

2021-02-27 18:25:58 +0200 评论问题 LOCATE on firebird generates unknown function

Thanks you! I use the same ods file on 2 systems: windows 10 and linux fedora and I wrongly assumed that if I see HSQLDB