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

发起问题

Kamil Landa 的档案 - 活动

2021-06-20 09:59:05 +0200 评论回答 Change borders around selected cells

It seems it is "insidious" bug. Link to the bugzilla with this bug https://bugs.documentfoundation.org/show_bug.cgi?id=1

2021-06-18 09:31:41 +0200 回答问题 Proč je můj LibreOffice (7.0) calc tak droboučký a nečitelný?

Ten downgrade moc nepomůže neboť zůstane zachován uživatelský profil. V nouzovém režimu lze resetovat i celý uživatelský

2021-06-18 09:21:49 +0200 修改回答 Najednou je vše jen stránka č. 1

Co aktualizace Rejstříku - pravým myšítkem kliknout na ten Obsah a dát Aktualizovat Rejstřík. Nebo z menu Nástroje/ Ak

2021-06-17 16:05:19 +0200 回答问题 Najednou je vše jen stránka č. 1

Co aktualizace Rejstříku - pravým myšítkem kliknout na ten obsah a dát Aktualizovat Rejstřík. Nebo z menu Nástroje/ Ak

2021-06-14 16:39:05 +0200 修改回答 How can I prevent user input during macro execution?

And what to add the Progressbar to the main loop in the macro? Sub ProgressBarExample 'show progressBar in some loop

2021-06-14 16:30:25 +0200 修改回答 How can I prevent user input during macro execution?

And what to add the Progressbar to the main loop in the macro? Sub ProgressBarExample 'show progressBar in some loop

2021-06-14 16:28:42 +0200 回答问题 How can I prevent user input during macro execution?

And what to add the Progressbar to the main loop in the macro? Sub ProgressBarExample 'show progressBar in some loop

2021-06-14 12:40:29 +0200 回答问题 Icons are not displayed in calc from my extension

If you use some non-english localization for LibreOffice, you can try to set the empty parameters 'lang' in the .xcu &am

2021-06-13 18:41:29 +0200 回答问题 [ANSWERED]How to open a file in a reduced window every time.

It is possible via macro, set your own coordinates in the line: oWindow.setPosSize(...) in the Sub openInDefinedWindow

2021-06-10 12:50:54 +0200 评论回答 I need a macro that will replace a number in a cell with a new total.

Or maybe use for example convert to long like this: data2(i)(0)=CLng(data1(i)(0))+CLng(data2(i)(0))

2021-06-10 12:50:14 +0200 评论回答 I need a macro that will replace a number in a cell with a new total.

Or maybe use for example convert to long like this: data2(i)(0)=CLng(data1(i)(0))+CLng(data2(i)(0))

2021-06-10 12:01:17 +0200 回答问题 I need a macro that will replace a number in a cell with a new total.

Sub sumFromCells 'make sum from two ranges and put it to the second range dim oDoc as object, oSheet as object, data

2021-06-06 15:36:24 +0200 回答问题 When a user clicks 'save' button, I need to do some validation in macro, if it's invalid, then cannot save the document. How can I prevent saving using a macro?

You can make own 'save button' and assign to the one the macro like this Sub saveWithCondition dim oDoc as object,

2021-06-06 11:56:23 +0200 回答问题 How can one "search and replace" (in calc) an empty cell with the number 0?

Select some cells (you can use multiselection) and then the macro zeroToEmptyCells will put zeroes to the empty cells in

2021-06-04 17:06:26 +0200 修改回答 Reading a cell in sheet1 writing the value in sheet2

I don't understand poerfectly what you want, something like this? osheet2.GetCellByPosition(c1,r1).String = osheet1.Get

2021-06-04 17:04:49 +0200 回答问题 Reading a cell in sheet1 writing the value in sheet2

for example: osheet2.GetCellByPosition(c1,r1).String = osheet1.GetCellByPosition(c2,r2).String the same with Value/F

2021-06-03 11:12:35 +0200 修改回答 Nelze spustit Libre Office :-/

Mně ještě napadá jestli to neblokuje nějaká systémová ochrana a pak tedy zkusit spustit Libre jako správce (třeba pravým

2021-06-02 08:54:16 +0200 评论问题 kde je chyba ak mi program vobec nejde spustit?

Ještě je možnost spustit celé Windows v nouzovém režimu a v tom Libre v nouzovém režimu, viz. https://ask.libreoffice.o

2021-06-02 08:53:54 +0200 修改回答 Nelze spustit Libre Office :-/

Mně ještě napadá jestli to neblokuje nějaká systémová ochrana a pak tedy zkusit spustit Libre jako správce (třeba pravým

2021-06-02 08:53:12 +0200 评论回答 Po aktualizaci Windows 10 nejde spustit LO

Ještě je možnost spustit celé Windows v nouzovém režimu a v tom Libre v nouzovém režimu, viz. https://ask.libreoffice.o

2021-06-01 09:31:26 +0200 评论问题 Libre Office 7.1.3.2 only works in safe mode. deleting profile does not work

Maybe you need to install the optional MS patch https://libreoffice-dev.blogspot.com/2021/03/microsoft-gave-us-fix-for-

2021-05-31 20:28:01 +0200 回答问题 How can I add or remove fonts?

In the Windows 10 settings. Find fonts in the searchbar (in menu Start), it will show you the item with settings for the

2021-05-31 20:20:53 +0200 回答问题 append the output and export to pdf

My minimalistic version :-) C:\fakepath\exportRange-minimalist.ods

2021-05-31 12:57:51 +0200 评论回答 append the output and export to pdf

Under Win sometimes I used Free PDF Tools http://www.pdfill.com/pdf_tools_free.html

2021-05-31 12:57:32 +0200 评论回答 append the output and export to pdf

Under Win sometimes I used Free PDF Tools http://www.pdfill.com/pdf_tools_free.html

2021-05-31 12:51:29 +0200 修改回答 append the output and export to pdf

Update: I think I understood badly your ask. It seems you need to export the same range repeatedly, and no to export the

2021-05-30 20:39:26 +0200 评论回答 key to toggle toolbar

There is a name "PDF English Macro Document" for the "Useful Macro Information" in the Andrew's site. Direct link https

2021-05-30 19:06:45 +0200 评论问题 Counting duplicate numbers in various rows on a sheet

I can imagine it is possible to do it with a macro, but if there are tens or hundreds of thousands of lines in the sheet

2021-05-30 18:57:20 +0200 修改回答 append the output and export to pdf

Copy the ranges is not so hard, but I know nothing about the structure of your Calc document. It is possible to put rang

2021-05-30 15:44:22 +0200 回答问题 append the output and export to pdf

Copy the ranges is not so hard, but I don't know nothing about the structure of your Calc document. It is possible to pu

2021-05-29 20:59:49 +0200 回答问题 How to locate direct formatting

Maybe with the extension AltSearch https://extensions.libreoffice.org/en/extensions/show/alternative-dialog-find-replace

2021-05-29 20:57:01 +0200 回答问题 How to locate direct formatting

You can use the extension AltSearch https://extensions.libreoffice.org/en/extensions/show/alternative-dialog-find-replac

2021-05-28 17:03:50 +0200 回答问题 Save Calc CSV as Displayed Ignoring Hidden Rows and Columns

This macro will do copy of the active sheet and in this copy it removes the hidden rows or rows with zero height, and th

2021-05-28 16:22:56 +0200 回答问题 Save Calc CSV as Displayed Ignoring Hidden Rows and Columns

Ctrl+A, Ctrl+C and then Ctrl+V to the new sheet -> it copies only visible data.

2021-05-28 15:36:51 +0200 评论问题 append the output and export to pdf

Hello, please share all your macro code for export - update your ask. I think I can to modify it to copy/paste the range

2021-05-28 12:52:11 +0200 回答问题 can I open impress from a BASIC macro in calc?

Test this macro, change constants at the start to your usage: Sub editPresentation 'duplicate the i-page in the present

2021-05-27 21:25:08 +0200 回答问题 Trying to selectively show/hide rows based off cell value via basic macro

You can also use method goToEndOfUsedArea to get the count of used rows in the sheet Sub hideRows 'hide the rows as per

2021-05-23 17:40:44 +0200 回答问题 shortcut to change language [None] in a macro

Sub setNoneLanguage 'set the language [None] for current selection dim oDoc as object, oSel as object, oLocale as ne