Questions tagged [openoffice]

Open source application suite that includes Writer, Calc, Impress, Base, Draw and Math

Filter by
Sorted by
Tagged with
0 votes
2 answers
32 views

Corrupted ODT/DOC files in Raw form -- How do I get the text?

I have an old hard drive I had professionally recovered, and they were only able to give me the files in code that looks like this: talledBannerText{\VSI_MS_Sans_Serif16.0_1_0}[ProductName] ¼³Ä¡...
user avatar
  • 103
1 vote
1 answer
47 views

Timestamp (date/time) system used by LibreOffice Calc / OpenOffice Calc spreadsheet applications?

What system does LibreOffice Calc / OpenOffice Calc use to represent timestamps (dates/times) as numbers? It's apparent that they don't use the standard integer epoch times that are common in computer ...
user avatar
4 votes
1 answer
456 views

Issue with IF statement in Libreoffice Calc

Here is the statement =IF(L7>7,"$500",IF(L7>11,"$1200",IF(L7>15,"$2000",$0))) I simply need this to resolve a value based on the set conditions. I've tried ...
user avatar
  • 43
0 votes
0 answers
31 views

Find one value and replace value inside quotes within the same row

I translated values for a JS calculator but the script that I am using treats the option value the same as a value inside a parenthesis. Currently have it on notepad ++ but can migrate to anything ...
user avatar
0 votes
0 answers
22 views

How to call from OO Basic the print menu (with preview) in LibreOffice with preset values?

We have an example code like this: Sub TPrint(Optional PrintedDoc as Object) ' For testing on already open document: If IsMissing(PrintedDoc) Then PrintedDoc=ThisComponent DocFrame=PrintedDoc....
user avatar
  • 21
0 votes
0 answers
23 views

How to convert DOC with integrated ODS into Word with Excel (multiple files)

I'm facing some convert problems. I have OpenOffice, and I've created several .doc files (bills). Each file content is different. In these .doc files, I've integrated an ODS tab, which calculates ...
user avatar
  • 101
0 votes
0 answers
138 views

Can I attach (embed) a file to a pdf using LibreOffice/OpenOffice such that it appears in the "Attachments" tab in Acrobat Reader?

With Adobe Acrobat Pro DC, which is paid software, one can attach files to a pdf, and they nicely display in the Attachments tab of the Reader when the pdf is opened: link to image. Is it possible to ...
user avatar
0 votes
2 answers
43 views

I cannot recognize what type of formatting element it is in this Word document and how to get rid of it

I have got a big Word document that contains what I believe are input forms. How on earth can I delete them without deleting the table cells and what kind of formatting is this? And this is not the ...
user avatar
0 votes
1 answer
37 views

Where is the bundled `python` executable in OpenOffice, in general?

As described in the Apache OpenOffice wiki, OpenOffice should be bundled with its own version of Python, which on Windows is located by default at C:\Program Files\OpenOffice.org <version>\...
user avatar
0 votes
3 answers
96 views

Turn a row's background black if cell has #VALUE! - OpenOffice Calc

I'm currently playing around with formulas and made one that works perfectly for me. Some row will get the value #VALUE! due to them being empty when imported and I am trying to make the whole rows ...
user avatar
0 votes
1 answer
228 views

Extract string after a delimiter like "/ " OpenOffice Calc

I have a file that converts inputs for me into an SKU-number (Stock Keeping Unit). The names and attributes I have are in one line and one cell like so: Temperature Displaying Smart Ring / Rose Gold – ...
user avatar
1 vote
0 answers
103 views

How to change the app associated to a protocol to one that doesn't appear in the available app list?

I want to change the app associated to the 'ms-word' protocol to Apache's OpenOffice (reasons for doing so can be found here). However, when I go to the Choose default apps by protocol menu, and try ...
user avatar
0 votes
0 answers
173 views

Can't Open Password-Protected Word Document With LibreOffice Writer

I have a .doc document that I can't seem to open properly with LibreOffice. The only content is some text noting that I need to open it with MS Office: This document has been protected. Please use ...
user avatar
  • 312
0 votes
3 answers
81 views

How to open .XLS in excel viewer without changing default program?

I have two excel .XLS files. We need one of the files to be opened using Excel Viewer and the other is being opened using OpenOffice. the file using excel viewer cannot be edited hence using the ...
user avatar
1 vote
0 answers
13 views

Searching indexed spreadsheets from Windows 10 explorer “search”

I have a client that used to use Windows 7, and was able to search directly from the Windows explorer (start menu) to find spreadsheets by searching a number that was on column B within. Now that they'...
user avatar
0 votes
1 answer
19 views

How to make Open Office Writer correct spelling?

It will not automatically correct spelling. Instead it underlines bad words in red. How do I automatically correct spelling?
user avatar
  • 674
0 votes
0 answers
46 views

Mac Big Sur repeatedly tries to open "Open Office" for no obvious reason. I suspect malware

Something is periodically (every hour or so) trying to open "OpenOffice" while I'm working in other apps. Because OpenOffice was previously downloaded onto my machine, I get a warning about ...
user avatar
  • 103
1 vote
2 answers
59 views

Excel formula help please?

I'm hoping someone can help me figure this out as I am frying my brain with this. I am trying to figure out how to input the formula so if and when numbers are entered, the total is shown. Like for ...
user avatar
0 votes
1 answer
13 views

OpenOffice Macro - How to append text to "Author" field

currently I have an OO macro that processes a document and then sets the "Author" by using: oDoc.getDocumentProperties().Author = cAuthor However that replaces any existing text in that ...
user avatar
  • 1
1 vote
0 answers
56 views

OpenOffice Calc: Is it possible to create conditional formatting to highlight a row based on checkmarks?

This is kind of a two-part question. Is it possible to create conditional formatting to highlight an entire row with a certain color based on whether the checkmark object in the row is selected? For ...
user avatar
0 votes
1 answer
32 views

XLS: 'if statement' calculation

I have a cell B19 which consists of taking the value of another cell and dividing it by 5: =B15/5 However I'd like to change it so that it only divides it by 5 if the B15 is more than 1000... and for ...
user avatar
1 vote
1 answer
75 views

How prevent objects from snapping back into position in LibreOffice Writer?

How can I disable this super-annoying "feature" causing objects (e.g. a drawn rectangle) to snap back into its original position when doing drag & drop? I simply want to translate a ...
user avatar
  • 1
0 votes
0 answers
25 views

Can OpenOffice Calc AutoInput reference data on a different sheet?

I've set up a spreadsheet in OpenOffice for project estimation at a contractor. The first column is a description of the item or service that I'm adding into the price. Since there are many commonly ...
user avatar
1 vote
1 answer
1k views

How can I escape commas in a CSV file?

I thought there were two ways to do this: either enclose the field containing the comma in quotes, or place a backslash before the comma. However neither of these is working; when I load up the CSV ...
user avatar
  • 429
0 votes
0 answers
84 views

OpenOffice: different font weights

I'm using OO for Mac, although I've had this same problem with LibreOffice and I think maybe MS Office too. And the problem is that, for fonts that have a lot of different weights, I can only use ...
user avatar
1 vote
0 answers
19 views

How do I turn off autoformat OpenCalc / OpenOffice Spreadsheets

Without context and background: Read the title, How do I turn off AutoCorrect in OpenCalc, specifically time, preferably turn off all AutoFormat. I am using a spreadsheet to track how fast my online ...
user avatar
0 votes
1 answer
431 views

Mime type of MS Office documents saved from OpenOffice etc. is not recognized in Debian 9

Just today I faced the problem that document created by OpenOffice package and saved in XLSX format, recognized in Debian 9 as octet-stream instead of valid MS Office format: root@linux# file -b --...
user avatar
  • 1,647
1 vote
1 answer
47 views

Can I get this Perl command on Windows to not generate dates with apostrophes in LibreOffice?

Based on the help I got on this question, I have this Perl command that I run in Windows 10 PowerShell: ls |% { $_.Name } | perl -pe 's/(.)(.*)_(\d{4})(\d{2})(\d{2})_(\d+).jpg/\u$1$2,$3-$4-$5,$6,$&...
user avatar
1 vote
1 answer
122 views

Is it possible to combine two IF(AND functions into one? (OpenOffice Calc 4.1.7)

Is it possible to combine two IF/AND functions into one? (OpenOffice Calc) I have two IF/AND functions that work perfectly well, however I need them to both work on the same line. Is there anyway to ...
user avatar
0 votes
1 answer
267 views

How to Install LibreOffice Python on MacOS

I'd like to use Python to manipulate LibreOffice documents using the UNO API. I have LibreOffice 6.3.4.2 and Python 3.7 on MACOS (OS X). I find doc which says UNO is available in the Python shipped ...
user avatar
1 vote
1 answer
220 views

How to copy a new line from libreoffice calc to txt?

I have the following function in cell 'B2' a libreoffice calc document: =CONCAT(A1,CHAR(10),A2,CHAR(10),"end") Which, with in cell A1="function plotName = getPlotName(plotData)" and A2=" plotName ...
user avatar
  • 353
0 votes
0 answers
83 views

Excel turns my floats into integers

The following is part of the output of a code I have written. When I open it with excel part of the floats turn into integers while others remain. Wrong: Correct: When I sort them in ascending ...
user avatar
0 votes
1 answer
713 views

I can't uninstall open office 4.1.7

I just got a brand new laptop. I install open office but could not make it run. So I try to uninstall it. But I can't do that either. :( When I try using the Windows remove program option from the ...
user avatar
0 votes
1 answer
282 views

ssh X11 forwarding from multiple clients simultaneously always opens openoffice windows on the same screen - bug or feature?

Situation: Three "computers": A. a desktop with its own display B. a virtual machine on A (kvm) C. a small PC with its own display I generally work on A, ssh -Y to B from A, work with firefox --...
user avatar
0 votes
1 answer
273 views

How can I stop Open Office Calc from changing the data?

I am using Apache Open Office Calc to view CSV data. I just noticed that Calc rounds the data on saving, reducing its precision, or at least I think that's what's going on. I show below the same data ...
user avatar
  • 263
1 vote
0 answers
117 views

Adding language (Dutch) to LibreOffice Writer

I'm having trouble doing a spelling check in LibreOffice (in Dutch). It supposed to come with the package but it doesn't show in my screen (see image: no abc mentioned before 'dutch'). I tried: ...
user avatar
  • 111
1 vote
1 answer
346 views

LibreOffice fails to export PDF containing arabic letters

I used LibreOffice to write an arabic document. When exporting this document to PDF through the LibreOffice "File -> Export...", I get an unexpected result: the PDF is different from the original ...
user avatar
  • 11
1 vote
0 answers
36 views

Widowed pilcrow (non printable ¶ at line begining) in LibreOffice

I'm struggling with widowed pilcrows (i.e. non-printable ¶ at beginning of lines). This happens only in footnotes, on page-breaks, and it adds a space between the footnote's rule and the first ...
user avatar
0 votes
1 answer
53 views

Stop OpenOffice from removing decimal places

In a table-cell when I type 1.00 and move the focus from the cell OpenOffice removes the decimal places from the number and makes it 1! Why is this happening? How do I stop this from happening?
user avatar
  • 204
0 votes
1 answer
25 views

How to order column in open office

I have a column like this RA1 RC4 RJ9 RA3 RA2 RA10 RD14 RA11 and I want to get RA1 RA2 RA3 RA10 RA11 etc.. Not RA1 RA10 RA11 RA2 etc... There's any way to change the behavior?
user avatar
  • 621
1 vote
1 answer
339 views

How to Use KDE File Chooser In Libreoffice 6.2.2.2?

I changed the file chooser a while back because my version of Libreoffice Writer crashed all the time when I would go to choose a file. There have been a few versions between then and I would like to ...
user avatar
1 vote
1 answer
339 views

OpenOffice Calc import special characters in CSV incorrrectly?

I'm trying to import a CSV file to OpenOffice Calc, but the program is reading special characters incorrectly. For example, one of the fields in the CSV is "Puma La Cerámica", but Calc imports it ...
user avatar
  • 521
0 votes
1 answer
325 views

How to Remove Paragraph Breaks in openoffice

I am using openoffice 4 and i have a Paragraph Breaks between two pages and i want to avoid it
user avatar
0 votes
1 answer
118 views

Calc pie chart for 25000 rows with long tail

I have a file that contains 25,000 rows, each row containing a number, looking like this: 4000 3000 1500 700 ... 2 1 1 1 From this I want to make a pie chart. The first few pie parts will be ...
user avatar
0 votes
0 answers
31 views

Merge ttwo tables using order id number where one table has multiple rows with the same id number

I'll first explain what I'm trying to accomplish then give the table details. I'm trying to export sales data from my website and organize it by order id number so I can easily see which orders were ...
user avatar
  • 1
2 votes
0 answers
47 views

How get text lines larger than 69cm?

I’m using Apache OpenOffice 4.1.6 and I want to convert a text file to ᴘᴅꜰ without automatic line returns. In practice this requires using very wide page sizes. I enabled landscape mode set page as ...
user avatar
  • 1,690
0 votes
2 answers
309 views

Calc print several sheets in same page

I have a Libreoffice Calc spreadsheet that holds around fifty sheets (each one with no more than a dozen valued rows); this is good for data organization — each sheet holds a sequence of events ...
user avatar
  • 185
0 votes
2 answers
2k views

OpenOffice/LibreOffice Calc how to not print column but show it in sheet?

I have a column with hyperlinks to other parts of the same spreadsheet and I want this column to be visible inside the program, but hidden when printed: it should not take up space. The only solution ...
user avatar
  • 185
0 votes
1 answer
2k views

What to Save As when exporting Visio .vsd to OpenOffice or LibreOffice to minimize differences?

I have a Microsoft Visio Pro. 2010 file (.vsd), and I want to work with it in LibreOffice (or OpenOffice, as a secondary option). When I import the .vsd file to LibreOffice, there are many ...
user avatar
  • 149
3 votes
1 answer
447 views

Opening a .doc file, which is actually an HTML file, as a .doc file

My software generates .doc files which are actually HTML files but with the ".doc" extension. When I open them in Microsoft Office they open as a .doc file and the user does not know that it is ...
user avatar
  • 700

1
2 3 4 5
12