Sorry, not that I know of.

Are these hyphenated with a hyphen character, or with a "soft" (discretionary) hyphen?

One approach might be to remove all the hyphens (hard or soft), then allow OO Writer to do its automatic hyphenation.

I've seen similar reports recently; I don't remember seeing any resolution.

Are you still using OO version 3 (shown in your forum signature)?

That old thread is slightly wrong. OO only recognizes command line options that start with a single hyphen, -headless; the double-hyphen options are ignored. Libreoffice uses the double hyphen options. But, even using the single hyphen options, OO (both 4.1.3 and 4.1.5) does not work for me. It just...

... want to create cell that makes the check number todays date with a following number corresponding to how many checks I have written that day. ... You can do what you asked, but it won't be what you want. TODAY() produces a result that will be calulated, and potentially change, each time you ope...

So, if you do View > Nonprinting characters: ON, each line ends with a paragraph break, ¶, or line break (down+left arrow symbol). Is that right?

Is there any indication in the text of actual paragraph breaks? An empty line, or indented first line?

Greetings and welcome to the community forum!

What did you try so far? What steps?

What kind of computer are you using? Windows? Mac? Something else?

Did you try the "Edit" button on the toolbar? (The button has a pencil icon on my system.)

That should allow you to save an editable copy of the document.

... So many features of OOCalc are the same as Excel that I just assumed... Calc tries to avoid being gratuitously different from Excel; this is one glaring exception. There is some justification for it, in that some locales use comma as their decimal separator, but LibreOffice allows entry of form...

... It doesn't look to me as if there are mismatched brackets. ... There aren't. It's a parsing error caused by using commas between function arguments, where Calc expects semicolons. How do I edit the formula? Click on any cell in the array result Press Ctrl+/ (select entire array result) Press F2...

Greetings and welcome to the community forum!

Sorry, OO does not open xml files except as plain text.

Wallaceman105 wrote:Really? I've never run into an issue with other spreadsheet software doing this, ...

I misunderstood what you want. I thought you wanted to record more than one date in a cell. As long as you only need one date per cell, it's manageable.

Greetings and welcome to the community forum! The phantom character is an apostrophe, single quote, not the "backquote". It has a special purpose when a value is entered in a cell: it signals to Calc that the value being entered should be taken as literal text and not interpreted as a nume...

So this won't work if there are multiple different dates going in that column? For numeric data that you want to do any kind of formatting or analysis with, no. Spreadsheets assume only one value in any single cell. If you want to have multiple dates in a single cell, they will have to be plain tex...

This works for me with your example: Edit > Find & Replace Search for: (?<=\w)î(?=\w) Replace with: â Options/Regular expressions: ON Click Replace All The patterns around the î are "lookbehind" and "lookahead" elements that require a "word" character, \w, before an...

... occurrences of a space that less than or greater than 2, but not exactly two Sorry, I'm not sure I understand what you're doing/looking for. Two what? Maybe you mean two spaces in a row? If so, you can match either one space, or more than two spaces, with something like Edit > Find & Replac...

The two numbers are not part of the chart but are attached to the chart object. This is why they disappear when the chart is activated. They may have gotten there by pasting data unintentionally onto the object rather than onto the sheet. To remove the text, select the chart object (one click on it—...

Greetings and welcome to the community forum! Maybe something like A1:=NOW() =IF(MEDIAN(A1;TODAY()+TIME(18;0;0);TODAY()+1+TIME(5;0;0))=A1;150;120) A1 holds the current date and time; MEDIAN returns the middle of the three values. Note: NOW() is in a separate cell, since two NOW()s in the same formul...

... So after following the procedures noted above AOO is working probably for all versions but 4.1.5 is what is installed currently for me. With these tweaks, does OO display the standard gtk UI on your system? For me, the last few versions of OO have stopped working with the standard gtk UI elemen...

No apology needed. Good to know it worked for you. The most straightforward plan would be to have the numbering include a line break (Shift+Enter) between the number and the start of the paragraph. While OO will accept that in the document data, there's no universal way to configure it from the norm...

The online help includes the formula implemented, shown in mathematical notation. That doesn't tell you how the code works, but it does allow you to compare OO's definition with other published works.

... the fields display on my label sheet when I create it, but the data is not being pulled from the original source. ... OO does not actually merge the data when you're editing the Writer document. You'll only see the field names until you do File > Print ... At that point it will ask whether you ...

... There are no fields displaying in the database field drop-down box to move over to your label sheet. Oh, I see now. I've never used that part of the New > Labels dialog window. I always leave that blank and add the fields to the labels working in the Writer page. OO Sometimes has trouble keepin...

Bob Ring wrote:... when I select the database to select fields for the labels, no fields are displaying.

Sorry, I'm not sure I understand what you're doing/looking for here.

Can you describe the steps you're following and what actually happens, compared to what you expected to happen?

[Split from viewtopic.php?f=50&t=16513]

Sorry you haven't yet received any suggestions—have you made any progress on your own?

If you have formatted the cell as text, then Calc will not recognize the formula when you enter it—it will take it as literal text, and that's all you'll see displayed.

Change the cell format back to "Number/General" or some other numeric-capable format and re-enter the formula.

Greetings and welcome to the community forum!

Try Tools > AutoCorrect Options > Localized Options > Single quotes/Double quotes > Replace: ON

If it's still not working, make sure Format > AutoCorrect > While typing: ON (checked)

Sorry. It seems there is no document content data in the archive: the "content.xml" file header is there, but there is no data.

Seems to work fine here. It might help if you can tell us what text is entered in the "Search for" box. Unless you need to search for patterns (a wildcard like *, for example), you probably want to make sure Edit > Find & Replace > More Options > Regular expressions is OFF. In fact, I ...

Greetings and welcome to the community forum! I believe this is a long-standing problem with exporting content from OO Draw. The only workaround I know of is to include an invisible (or background color) shape behind all the shapes you want to export. You can size this object to provide whatever bor...