Questions tagged [OpenOffice] (31)

1
answer

How to create a conditionally-dependent cells in Calc?

There is a table consisting of two columns "name" and "quantity". How to make another table(m. b. and from another file) found in the first table, a certain "name"(or better the key word) and take the corresponding "number"?
elroy_Nitzsche asked April 8th 20 at 17:49
1
answer

How to make it in OpenOffice?

option 2ZH itself OpenOffice to edit the page settings and save as default.
emilie_Runte asked April 3rd 20 at 17:34
1
answer

How to fix the page orientation?

anyone knows of OpenOffice on Ubuntu now makes the first page 1 and the rest of the landscape two pages on one. How to fix?
hettie.Dibbe asked April 3rd 20 at 16:43
0
answer

In openoffice write only those rows that exist in another table openoffice?

Table 1 is a list of products with columns: "SKU", "product description"(in the table 1200 lines) The table has 2 columns: "SKU" and "product price".(there are 530 lines) Task: table 1 leave only need 530 lines with articles which are in vol. 2, delete the rest. Know that this is a simple VLOOKUP or VLOOKUP (in my case), a...
Alford.Becker asked March 31st 20 at 15:02
2
answers

How to merge data from excel / csv cells into one?

On the server in the folder imgs have a bunch of folders with pictures of the product. Each folder name = article product. In each folder there is an image 1.jpg There is a table to import, where it is necessary to prescribe to every article the way to his photos: 2 columns with data (article and link to photo)table Articl...
moshe_Veum asked March 31st 20 at 14:55
0
answer

Why opens a new blank file in OpenOffice?

Edited the file ekselevskoy file in OpenOffice. Periodically maintained. For unknown reasons, OpenOffice started to fail and ceased to open a new file. I shut down and rebooted the computer. After this the file that I edited before the reboot, was open but completely empty. Thus weighs 200KB. Tell me what the problem and wh...
Celestine asked March 29th 20 at 21:17
1
answer

How to wrap a line in OpenOffice?

How to find and wrap the line in bold (or other formatting) text in brackets. Example: text -> (text). Put the search in bold format, replace $ (regular expressions included), but when you click replace all, writes that the word replaced, but nothing changes.
Pinkie asked March 24th 20 at 10:27
2
answers

Which office product works effectively with large tables and supports different formats?

Sometimes you need to process large csv files, is that the spreadsheet file from Microsoft, Google, Apple. What is better to do? Libreoffice - eats a lot of RAM, slow does everything on one core. For csv files bigger than 100-200 MB is not suitable. Microsoft Excel 2013 - is significantly faster on larger volumes than Libre...
ova_Baumbach asked March 24th 20 at 09:50
1
answer

Why not open the OpenOffice files on a network drive when connected via WiFi?

Why not open the files in OpenOffice (Windows 10)on a network drive when connected via WiFi. Cable all without problems.
Cielo_Schaefer asked March 18th 20 at 22:23
0
answer

How to create a button in a table cell Openoffice Сalc and hang on to it a function (a macro)?

Please help to create a button in a given cell is the simplest example (I will continue to deal himself). Tortured Google -- nothing clear was found. Version Of Office 4.1.6. This: 1) the cells in row A contain either numbers or empty; 2) cell B1 contains a real number b, B2 contains a natural number n. Required: create in ...
Coby.Walt asked March 17th 20 at 12:13