Not to my knowledge. I really doubt it.
If you want a single print maybe you could add Sheet 3 and set up
formulas to pull data from 1 & 2, then print only 3?
On 9/18/25 09:02, Craig Lister wrote:
Consider the following sheets that are within the same Calc file-
Sheet 1
Sheet 2
Can Sheet 2
Better Solution? Use REGEX to strip all characters except numbers and
period.
To make relatively bullet-proof and not show errors it's probably best
implemented in 2 cells.
My Example:
Cell E61: =REGEX(C61, "[^0-9.]", "", "g")
Cell F61: =IF(E61<>"", VALUE(E61), 0)
Could be wrapped
The "issue" is visible / replicate-able on my computer.
Your problem is your input parameter, you have: =ISNUMBER(A1:C1)
A1:C1 references a RANGE, but the ISNUMBER function expects a VALUE, or
a single cell reference.
If I enter =A1:C1 in any cell in columns A-C it shows TRUE, but by
cleari
Sorry, error in prior reply. I meant you can format to display 0
decimals (or 2 decimals). You need a Cell Style for each format.
On 4/15/25 18:48, Java Joe wrote:
It will not actually truncate the values to 0 decimals, but you should
be able to format them to display only 2 decimals
I think you can do what you need with Conditional Formatting.
It will not actually truncate the values to 0 decimals, but you should
be able to format them to display only 2 decimals.
You need to create a named Cell Format for each display type, then use
Conditional Formatting to set the desi
I haven't been reading this thread in-depth, but I think the formula
you're looking for is =SUMIF
Read the help manual documentation for it.
On 2/7/25 21:18, Brian Barker wrote:
At 15:42 07/02/2025 +, Wade Smart wrote:
What I have unsuccessfully been trying to do is. SUM(CD6:CD15) + If
wit
If you're referring to Writer, then the option you want is probably Menu
> View > Images & Charts. That's where it is in version 7.4.7.2, if
you have different version it's possible it may have a different name.
On 1/13/25 07:15, John Thompson wrote:
Dear Sir/Madam
I have an issue currently in
Your header address doesn't need to be a special Style. I always just
type it up, manually format and align the text as desired. But add
additional lines that are left aligned and default style & format before
you start formatting the header, then you can move down and continue typing.
You can a
Why doesn't searching within the spreadsheet work for you?
The Find bar (Ctrl+F) only works on the current sheet, but if you use
the Find & Replace dialog (Ctrl+H) there is an option for "All Sheets"
that allows you to search across the entire file. And yes, you can use
Find & Replace to find som
It depends on the Operating System and LO Version.
You should be able to see where it's storing the config files by opening
Menu > Tools > Options and checking the Paths section (under LibreOffice).
My LO 7 install on Debian is storing user config files at
~/.config/libreoffice/4/
On 11/13/24
You will need to research documentation for mariadb syntax / functions,
I'm not familiar with it.
Base query editor will complain on SQL that is non-compliant to hsqldb,
but there is a "Passthrough" (or maybe "Native SQL") option on the query
editor that you can use to silence the Base parser and
Per my experience the - signs are likely null value. A boolean control
cycles through True / False / Null unless you specifically disable null.
On 10/30/24 11:25, Harvey Nimmo wrote:
Interestingly, exporting the 'virgin' report file as pdf retains the
'tick'/blank/minus symbols.
--
To unsubsc
I have not tested, but would suspect it is evaluating the length of the
formula rather then the length of the content the formula produces.
If your data source is a query it should be possible to produce the
string you want in the query, then just reference the field instead of
using a formula.
On 10/9/24 00:49, Sharon Kimble wrote:
I'm trying to construct a spreadsheet which will track my writing goals
for a 90-day period and is of this format '=SUM(D17/76)' and the cell
beneath it is '=SUM(D18/75)'.
So how can I get it such that the first figure is increasing, and the
second figure i
I think the basics of what you're doing is correct, it should work.
Opening a new Calc file (using LO Community 7.5.8.2 on Debian):
1. Entered some text in Sheet1.A4, and named that cell via Name Box
2. Added Sheet2, and created a Hyperlink using Ctrl+K
1. Select Document from link options
LibreOffice is not suitable for tasks like this.
As you were told before, use a calendar app. You have gmail, therefore
you have a calendar available to use.
On 8/10/24 16:06, charles meyer wrote:
Hi John and Phil,
I'm trying to do this with an Excel spreadsheet.
I've inputted all my data r
Different databases have different ways of implementing Auto-Increment
or Serial numbers.
I expect this to be related to the database you're using (Mariadb), a
Base compatibility issue but not really a bug.
I have no experience with Mariadb, but expect you can resolve your
problem by running the
Great solution, much better then mine.
Joe
On 7/15/24 08:01, lo.harald.ber...@t-online.de wrote:
Hi Blaine,
If I had to do it, I would proceed as follows:
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to
The problem is how to anchor an image so it doesn't float around with
the text.
Drag image(s) from Gallery or File Browser onto the document.
Right-click image and select Properties. On the Position & Size tab
select the Anchor to Page option.
Resize and position image as desired.
Repeat for
19 matches
Mail list logo
