Hello,
In the Edit menu, there is a Find... selection just above the Find and
Replace selection. Find just pops a small toolbar at the bottom of the
screen, while Find and Replace pops a full panel. You can use either to
locate your words (for the Find toolbar, type your word in the text
field and
Hello,
In the Find and Replace dialog, you can replace fonts and other
formating. Call for the panel (Edit > Find & Replace, or CTRL-H), and
click in the "Find" text area with no text, and then select Format... .
From there, select the font you want to replace from the Font tab; hit
OK. Then click
Hi,
I see similar issues. This workbook uses matrix formulas which have not
been always 100% portable from Excel to Calc when I tried to use them.
Unfortunately, unless all the formulas are re-done, it may not be
possible to repair the document and I think that using another template
may prove eas
Hi,
I saw the font is Arial. Are you sure you have the same font installed
on all your platforms? You could be experiencing some font substitution
which renders the document with a similar but different font.
Regards,
Rémy.
Le lundi 14 octobre 2024 à 10:06 +1300, Steve Edmonds a écrit :
> Hi.
> I
Hello,
If your list is in a column, you can use the ROW() function to figure
out on which line you are. For example, if the first entry is in cell
B2:
Formula in cell B2: =sum(D2/(90-row()+row($b$2))
If you now drag this to cell B3, the formula will be converted to
=sum(D3/(90-row()+row($b$2))
Greetings,
If you go in Tools > Options... > Load/Save > General, there is a
setting to save auto recovery information. If LO crashes, you can then
recover a portion of your work when you restart.
This might help a bit if you are subject to crashes. Just note that if
your document is large, the
Hello,
You can download the font from various websites:
http://dafontfamily.net/brandon-grotesque-font-free-download/
http://www.dafontfree.io/brandon-grotesque-font-free/
Once you have downloaded and installed the font, you will be able to
use it in LO. Note that some sites only offer version
Hello,
It is not possible to see images on this list. If you e-mail me the
image directly, I will see if I can help you.
Regards,
Rémy.
Le mardi 19 mars 2024 à 23:07 -0300, Enzo Hirosse a écrit :
> Hello! I was using LibreOffice Writer and got stuck in a problem
> while
> using the charts, I don't
Greetings,
Your easiest solution is sections. To create them, highlight the text
you want to place in columns and then use Format > Columns... Enter the
number of columns you want, with optional spacing (I suggest 0,1 cm),
and the format of a separator line if you want. Then hit OK. You can
force
Hi,
You can use the SUMIF function to have the ResSh1 and ResSh2 of final
to be updated each time you make an entry. If you only have one "Smith"
per table, you can use VLOOKUP to fetch the $7 value for Smith. You
will use these functions to find the "Smith" values in each of your
smaller tables.
Hi,
You can activate the footer in the page style. If you then go in the
footer area and insert the page number where you want it (there are
also some tab stops on the left, in the middle, and on the right of the
page which can help you position your page number easily).
As far as having to chang
Hi,
You could name the location of the data on each sheet with a name
created in a way that makes it easy to figure out the name from the row
number. You can then use the INDIRECT() function to retrieve the
information you want.
For example, on the second sheet, the name of the range could be
Sour
Greetings,
If you are looking for the maximum value, would the MAXIFS() function
work for you? If you are trying to populate the data in your secondary
sheet, with date values in column A, the formula to use in column B2 of
the secondary sheet would be:
=MAXIFS(Sheet1.M:M,Sheet1.C:C,"="&A2)
Then
Greetings,
You can start on the second page by editing the default page style if
your document has consistent page setup. You can do this with Format >
Page Style...
From there, go on the Footer tab, and select Footer ON (or
Header/Header ON if you want to place the page number on the header)
and
Greetings Thomas,
On Linux, I can duplicate this behaviour when I select the "Cell
Styles" box on the dialog. Is yours selected?
I hope this helps.
Rémy.
Le jeudi 27 octobre 2022 à 18:49 +0900, Thomas Blasejewicz a écrit :
> Good evening
> I just came across something I do not understand (and s
Greetings,
You can do this with a set of VLOOKUP() functions. I started by
creating a table of values like so:
Ref Value B C D E F G H I 1 6 10 16 28 38 46 60 80 2 12 20 32 56 76 92
120 160 3
Greetings,
To insert a character using a number sequence requires the use of the
ALT+code combination, not the CTRL+code combination. In WORD, typing
ALT+61692 does insert a checkmark. However, in most other applications
(such as Notepad, Excel, WRITER) typing this sequence is identical to
typing
Hello,
You can convert the formulas to only keep the values by doing a
copy/paste special where what you will keep are only the numbers. To
do: select the cells, copy (CTRL-C or Edit > Copy) and then paste
special (Edit > Paste Special), and select to keep only the numbers.
You may be prompted to
Hello,
There are ways of doing this without scripting, but if your entries
contain text, then scripting may be required, because my method of
sorting/removing duplicates requires the RANK() function and this
function only works with numbers. If your cells do contain text and the
lengths are short
Hello,
Regular expressions are a shorthand way of specifying strings against
which to match an input. In the COUNTIF(), MATCH(), VLOOKUP(), etc.
functions, when you provide a regular expression, you are asking to
compare your input to a summary version of what you are looking for.
For example, the
Greetings,
The semicolon is used as my separator because my locale (Canadian
French) wants decimal commas.
In such a case, the list separator is changed to the semicolon to
remove the chance of conflict between a number (1 1/2 is written as 1,5
and not 1.5) and its position in the list. The same a
Greetings,
The management of sheet names works in the same way as cell addresses.
Whenever you give a cell address (like A3), a copy/paste of the cell to
the next cell to the right will transform A3 into B3. To prevent that,
you place a "$" sign in front of the column address, like: $A3. You can
a
Hello,
I created something that ressembles what Johnny created, and I
understand your data is formatted like so:
Data1 Data2 blank Data3 Data4 blank Data5 Data6
You want Data6 to be the maximum of Data2 and Data4 (and possibly more
columns as well), and you want to have Data5 equal to the date on w
Greetings,
Not sure I understood exactly what you want, but this is the best I can
come up with (2 possible options):
f = { alignl { phantom { h } ` v phantom { %pi } } } over { { h }
times { %pi } times { { DAP^2 } over { 4 } } }
newline
f = matrix { v # phantom { a } # phantom { a } } over { ma
Hi,
The comment probably has been deleted with "Track Changes" ON (record
mode). The X on top of it indicates the comment is actually not there
anymore. You can select it (click on it), then go to the Edit menu >
Track changes > Accept and that should delete the comment.
I hope this helps.
Rémy.
L
Hi,I don't know if it is significant, but on Fedora 32 (LO7.0), I get
the same behaviour. I was able to trace this back to the font Noto
Emoji Color (this is the font reported in the PDF document) which,
though installed correctly, does not show in any output document, nor
does it display in the Fo
Greetings Marianne,Things have changed a lot since the version you are
using, and it may be difficult to provide the information you are
looking for. I did a bit of digging, and I managed to find this
document:
http://wiki.documentfoundation.org/images/b/bb/CG3403-ChartsAndGraphs.pdf
which comes f
Hi Regina,I found your issue: the indent on your cells (like F3) is
223pt which places the text more or less 3 inches (7.9cm) to the right
of the cell. This seems to be something that was done as formatting to
the cells individually because the Default style calls for a zero
indent. Looking at your
Hi,It is a bit hard to guess what is going on without actually seeing
the file. Can you e-mail it to me?Two things come to mind:-
Calculations are in manual mode and the cells are not re-calculated.
You can see the status in Data > Calculate (or try F9 to force
recalculation)- Conditional formattin
Greetings,
You can use a section to do that in WRITER. The easy way to start is to
highlight the text and then Insert > Section. In the section
configuration, there is a conditional "Hide" you can use. For example,
I created my wide's course material using WRITER and I use a variable
named "User";
Greetings,
I do this to get my tables the way I want them to be.
1) Normally, table content has the style "Table Contents" assigned to
it. Edit that style (View > Styles, then right click on Table Contents
and select Modify... in the style list) and make sure the spacing
before and after the parag
Hi,Even more simple:Just create a number format equal to 'nnn" "d'
(without the single quotes) and set the content of the cell to
$January.A5. The nnn is the day of the week and the d is the day in the
month in a date format.
The only thing to remember is that the "d" is valid for English-similar
.
Le jeudi 19 novembre 2020 à 12:59 +1000, Michael D. Setzer II a écrit :
> On 18 Nov 2020 at 19:23, Remy Gauthier wrote:
>
>
>
> Subject: Re: [libreoffice-users] Easily format cells to
> bold and a
> certain
>
Hi,
I am assuming your dates are in column "A", and the data in columns B
and next. You can easily do this with conditional formatting:
1) Select your dates and data
2) From the Format menu > Conditional
3) On the Conditional Formatting panel, in the first drop-down, select
"Formula is"
4) Enter t
Hello.
You can highlight the column and select Format > Conditional >
Condition > [Cell Value] [is duplicate] (from the drop downs) and
select a style to apply (Warning is probably a good one). This will set
all duplicate entries in that style (if you selected Warning, the text
will be red).
You c
Hello,
Really interesting. For me (LO 7.0.2.2 on F32), a right-click in the
ruler brings up a menu allowing the selection of the measurement units
(or change the type of stop when I click directly on a tab stop), and I
always needed to use left-click to insert a tab stop - never right-
click.
Rém
Greetings,
This is something LO does differently from Excel. When you copy a sheet
in Excel that references another sheet, the source sheet used for
calculations (like Sheet2!A3) remains the same. However, in LO, the
sheet reference is converted in a way similar to copying a formula on a
sheet: a r
Hi,
We used Scribus for a newsletter. Only complaint: we found Scribus had
a rather steep learning curve.
Rgds,
Rémy.
Le dimanche 27 septembre 2020 à 17:36 -0400, charles meyer a écrit :
> This would suggest that Libre Office 7 supplants MS Office 2019.
>
> But, what LO application does what MS Pu
Hi,
In the Drawing Toolbar of Draw, there is something called the
"Explosion" in the "Stars and Banners" which you can use as starburst.
For the thought baloon, there is a "Cloud" in the Callouts. You can
access those from the toolbar or from Shape > Insert > Callouts >
Cloud; and Shape > Insert >
Hi,
You need to add a new keyboard shortcut. To add, go Tools >
Customize... > Keyboard tab. In the bottom portion of the panel, select
the Edit Category, and then the "Delete Rows" line in the Function
list. Then highlight a suitable keyboard shortcut in the Shortcut Keys
area (maybe Ctrl+Delete)
Hi,
Does not seem to work with something like file://./abc.xyz either.Rémy.
Le samedi 19 septembre 2020 à 15:33 +0100, Dave Barton a écrit :
> I am trying to create a Writer document with a number of links to
> filesin the same directory as the odt file itself. Using absolute
> pathseverything work
Hi,
I have a master document that contains 9 sub-documents and various text
sections. In one of the text sections of the master document, I need to
reference a table located in one of the sub-documents. Since the text
section is in the master document, as I edit the master document, I
just insert
Hello,
An answer your V/HLOOKUP question:
HLOOKUP searches for a value on a row (Horizontally) and then goes down
to fetch the corresponding entry on a lower rowVLOOKUP searches for a
value in a column (Vertically) and then goes across to fetch the
corresponding entry on a column to the right
In th
Hi,
You can set the black background on the page itself. To set that: Page
-> Properties -> Background tab.
You can also set the black background on shapes. To set globally, the
easy way is to edit the "Graphic" style. Format -> Styles -> Manage
Styles, right-click on the Graphic style, select Mod
Hello,
Some things to check:
- The style you are using has spell checking enabled (the language is
on the font selection tab)
- The font you have selected also enabled spell checking (same thing:
font selector panel)
- In the options, spell check is enabled to check as you type
- In the Tools me
Hi,
If it's just showing, using a numbers format defined as [m] ("m"
between square brackets) will do the job. Since it is time, there
should be no decimal minutes to show and this format should work out.
Using this format will also allow you to continue making operations
with the time values witho
Hello,
First you must make sure your "Text Body" style is configured with
Liberation Serif 12. Then you have a few options:
Option 1: Select the text in Arial Unicode MS 11 and remove the direct
formatting (Format -> Clear Direct Formatting). If you are brave
enough, you can select the entire text
You can find an image by using the navigator (the compass-shaped icon
on the side bar). There is an "Images" selection that opens, and you
get the list of inserted images in your document. Double-clicking on an
entry selects the image and brings you there.
The funky behaviour you are describing abo
Hello,
Not sure on how to reproduce what you see in your environment. We are,
however, using versions that are not that far apart (6.4.4.2 on Fedora
downloaded from LO). I did the following:
- Insert an image
- Set the anchor to "Anchor as character"
- Right-click on the image, then select Inser
Hi,
If your goal is to only display the values according to a uniform
convention, you can define a cell numbering format that reverses the
display when compared to a "normal" display for the cells that contain
reverse-convention values. Something like this:
[<=0]# ##0;[>0]-# ##0;Standard
This wi
Hi,
Instead of just putting a superscript 1 to refer to the footnote, use
Insert -> Cross-Reference -> Cross-Reference, then Type is Footnotes,
Insert reference to is Reference, and then select your footnote. Using
this method, your text will be correct if the footnote number changes.
And apply Mi
Hi,
You could overlay a circle (Insert -> Shapes -> Basic Shapes) of the
correct size over the form and delete it before you print. Just make
sure you write in the frame and not in the circle.
I hope this helps.
Rémy.
Le jeudi 11 juin 2020 à 09:41 +0100, Budge a écrit :
> I am trying to print C
Hi,
Not sure if that will work for you, but you can try this:
1) Create your new document2) Select the top-left frame (single click
on the border)3) Go Format -> Frame -> properties4) Go to the Borders
tab, and then set the internal border to 0,1cm on all sides
In my version, this sets the border f
Hi,
The header is attached to the page style you are using. For a given
page style, the header will be the same. I think you are looking for a
function similat to MS-WORD where you can link consecutive headers and
footers to have them "copied" from one section to the other, when pages
are separate
Hello,
I just realised I messed up since I did not think about the
units.Considering:
1 GB = 1024 MB1 MB = 1024 KB
you can change the formula like this:
=SUM(IFERROR(VALUE(SUBSTITUTE(A2:A29,"
KB","")),0),IFERROR(VALUE(SUBSTITUE(A2:A29,"
MB",""));0)*1024,IFERROR(VALUE(SUBSTITUE(A2:A29,"
GB",""));0)*
Hi,
If your values takes up, for instance the range A2 to A29, you can
enter this formula as an array formula:
=SUM(VALUE(SUBSTITUTE(SUBSTITUTE(A2:A29," KB","")," MB","")))
The only trick is to hit CTRL-SHIFT-ENTER instead of just ENTER at the
end of the formula entry: if you only use ENTER, this w
Hello Steve,
You cannot attach files to your emails to this group since they do not
get relayed. Your only option is to attach it to a topic on LO's nabble
site (
http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html
). You could also send it to me directly and I'll have
Greetings,
I do not know how to achieve what you are looking for directly.
However, you can use something like this, supposing you want to display
the date of January 21, 2020:
Content of call A1: =DATE(2020;1;21) - cell format is "J
"Content of cell B1: =SUBSTITUTE(TEXT(A1;"J
Hi,
Just a thought: are the fonts that are defined in the styles installed?
It sounds a lot like font substitution playing tricks on you. This
would explain how you try to apply a style and nothing happens.
I hope this helps.
Rémy.Le vendredi 10 janvier 2020 à 12:29 +0100, Pieter van Oostrum a
écri
Hi,
I tried the slide transitions you mention (dissolve - both fine and
standard, and fade - with both offered variants) and I cannot see the
effect you are describing. If it can help, this is my running
environment:
Libre Office Version: 6.3.3.2, installed from the LO Web site - not the
distribu
Greetings,
I tried this in calc (which I am assuming you are using), and it seems
to work for what you describe:
[<>""]-@
The interesting thing is that calc changed it afterwards to
[<>0]-@;Standard
but it still seems to work.
I hope this helps.
Rémy.
Le mercredi 15 mai 2019 à 15:17 -0700,
Hi,
I am assuming you are using Calc. There is no formula to do this: it is
a cell formatting accessible via Format -> Cells... -> Numbers Tab,
then go to the "Fraction" category. There you can select the # ???/???
format which will do what you are looking for.
I hope this helps.
R??my.
Le jeudi
Hi,
I opened a bug about this yesterday (bug 124864). I have been
experiencing this since 6.2.2 on Linux Fedora, and the only possible
resolution I found was to stick with using 6.2.1, downloaded from the
LO site. Hopefully this will work for you as well.
Rémy.
Le dimanche 21 avril 2019 à 20:56
Hi,
I never was able to mix text and numbers on a single graph, so placing
the event as part of the data may not work. There is a workaround,
though. Plot your data points without placing the event text in the
data, but a corresponding event value (or some acceptable in-between
value). Then, go to
Hi,
I am using 6.2.1 and, like you, Format > Image > Properties >
Transparency does nothing to the picture. However, if you go on the
side pane, select the properties and play with the Image (not area)
transparency there, it works fine. Note that Format > Image >
Properties > Transparency brings y
Hi,
Instead of using text marks, you can also do the search and replace and
after place your cursor where you want the line breaks to be and type
Enter. This will cut the line without inserting an end of
paragraph.
Rémy.
Le vendredi 12 avril 2019 à 20:50 -0700, V Stuart Foote a écrit :
> If you t
Hi,
There are two ways to fix your problem:
1) Insert cells to place the new entries at the top, above cells A2-B2
, which will move down the reference of the last cell automatically.
The new cells must be in the range of the search array (if you insert
above A1, the search array reference will b
Hello,
I installed the latest version (6.2.2) of LO taken from the LO WEB site
(6.2.2) on a Fedora 28 desktop last week. I downloaded the RPMS for the
version itself, the French language pack and the online help for both
English and French and installed everything. Since then, whenever I
would nee
Hello,
A template contains the starting point of a document (or spreadsheet):
anything in the template will be copied to the new document (or
spreadsheet) when you create it - this is why you see the WCA numbers
in new spreadsheets created from that template. You should update your
template to have
Hi,
Not sure for 6.2 (I am currently using 6.1), but you can set the page
numbering like this:
- Insert Field -> Other fields -> Document Tab -> Select page and its
format on the right
- Styles -> Manage Styles -> Page Styles -> Select the current page
style, then right-click -> Modify -> Page Ta
Hi,
I am assuming you want ot use the pen during a slideshow. To clear the
pen marks on a slide, there is a selection when you right-click on the
slide (Erase all ink on slide), but to my knowledge, to erase the ink
from all slides at the same time, you must end/restart the slideshow.
I hope this
Hi,
If you apply any style that has borders re-defined in any way
(including "no borders"), setting the cell style will override whatever
settings you previously made. I did a few tests and if, in your style
definition you only change - for instance - the background color, then
the borders that we
Hi,
You could also have a look here:
http://www.linuxlinks.com/plottingtools/
Rémy.
Le vendredi 04 janvier 2019 à 22:05 +, Dave Howorth a écrit :
> On Fri, 4 Jan 2019 18:54:47 +0100
> Regina Henschel wrote:
>
>
> Hi Dave,
>
> Dave Howorth schrieb am 02-Jan-19 um 18:12:
>
> [..]
>
> M
Hi,
I can edit styles in Writer, Calc, and Impress without problems, both
from the side panel or from the style name drop-down.
Version: 6.1.4.2
Fedora 28
Sorry!
Rémy.
Le mardi 01 janvier 2019 à 19:03 +0100, Johnny Rosenberg a écrit :
> Am I the only one who can't edit styles?
> I right click
Hello,
I do not seem to see this problem with LO 6.1.3 (on F28). However,
please note that in DRAW there is a scaling setting (Tools > Options >
LibreOffice Draw > General that changes the units of the ruler and
position of objects. Could that be set to something else besides 1:1?
I hope this hel
Hi,
It almost looks like if the "Monthly car payment" string was displayed
using the date format of the A1 cell. What are the language and formats
used in the A1 and B1 cells?
Rémy.
Le mercredi 21 novembre 2018 à 20:05 -0500, James a écrit :
> I use lubuntu-18.10.
> Sometimes, a letter gets corru
Hi,
To answer your question about the CONCATENATE("<>","Y"), I am looking
for something that is not explicitly marked as reconciled (not "Y").
This test will mark as not reconciled all entries having an "N" (or
anything else for that matter) and all blank entries (a blank cell
obviously not being e
Hi,
I believe you had a similar (if not identical question) which you
posted back on September 27th (topic: IF doesn't respect AND - http://d
ocument-foundation-mail-archive.969070.n3.nabble.com/IF-doesn-t-
respect-AND-td4249584.html). At the time you had uploaded a file to
Google and I had offered
Hi,
Thank you all. I will wait for the next version.
Regards,
Rémy.
Le mercredi 31 octobre 2018 à 16:20 +0100, Ricardo Berlasso a écrit :
> El mié., 31 oct. 2018 a las 13:40, t.com>
> escribió:
>
> > Remy Gauthier wrote:
> > > Hi,
> > >
> > > I h
Hi,
I have been trying to experiment with the "spell out" numbering styles
in Writer. To setup my document, I went to Tools -> Chapter Numbering,
and selected "One, two, three..." for Numbering with Heading 1 at level
1, and "First, Second, Third" for Numbering with Heading 2 at level 2.
I then we
Hi,
n the Drwing toolbar, there is a select tool (white arrow). Select that
and draw a selection area around your floating frame (click-drag). This
should select the frame; at that point, hit "Delete".
I hope this helps.
Rémy.
Le lundi 15 octobre 2018 à 15:44 -0700, John Jason Jordan a écrit :
>
Hi,
The most simple approach is to have another sheet where you perform the
actual match of room and code. You then concatenate the results of the
multiple (or single) matches and display that result on your page. You
would need to know in advance what is the maximum number of room
references your
Hi,
Not really a fix, but something you could try...
You can add an auto correct entry that will transform a sequence of,
for example "a to "A (you would also need to add all the letters). For
the closing quote, the sequence would be ." a which would become ." A.
Since it is auto correct, you wou
Hi,
If you can sort your data, you can use the "MATCH()" function to look
for that date. If column "A" contains the dates sorted in ascending
order, this formula will return the latest date which is less than
"TODAY" (if you remove the "-1", then it will be for less than or equal
to "TODAY"):
=IN
Hello,
Your «Titre 3» style has a forced page break before, with a setting of
the page number to 5. Removing the setting makes the page number
correct again. The setting is part of the style, so Display Styles
(F11) > Find «Titre 3» in the paragraph styles > Text Flow
(Enchaînements) > Unset the p
Hi Hylton,
You can transform your fomula in C3 of your Summary sheet like this:
=SUMIFS(Data.C$3:Data.C$1000,Data.$A$3:Data.$A$1000,CONCATENATE("=",$A3
,"*"),Data.$F$3:Data.$F$1000,CONCATENATE("<>","Y"))
This formula will add the values in the data column, provided the RECON
is not "Y" (which is wh
Hi,
I have a spreadsheet that contains Canadian weather data since 1953
(more or less) for 25 weather stations. For each station, there are 28
columns and about 11000 rows of data, with one station per sheet. On
top of that, there are some other sheets that I use to mine into the
data. For good mea
Le dimanche 23 septembre 2018 à 16:14 +0200, Ricardo Berlasso a écrit :
> El dom., 23 sept. 2018 a las 16:07, Peggy (<33mar...@gmail.com>)
> escribió:
>
> > I've tried several ways after searching, including one that's
> > supposed to
> > be for the latest LibreOffice. It's writer I want to change
Hello,
I am not sure I understand your question. However, when you open the
Find and Replace panel, there are a "Find Next", "Find Previous" and
"Replace" buttons that enable you to locate the next instance of the
string to replace (or the previous); if you hit "Replace" at that
point, the replace
Hi,
Did you "add" the Java JRE in LO? You need to go to Tools -> Options ->
Advanced and add the path to the JRE there.
I hope this helps.
Rémy.
Le vendredi 31 août 2018 à 18:31 -0400, Peggy a écrit :
> I installed JRE several days ago and have closed Libre Office, but I still
> get this messag
Hi,
You could insert a 1-inch header that is empty. You can alter the page
style or directly format the page:
Format -> Page -> Header, then:
- Header ON
- Autofit height: OFF
- Height: 1 inch
Note that I am using LO 6.0, so it might be slightly different for you
but I think that those settings
Hi,
The language is taken from the language associated with your character
formatting (Format -> Character). In my version (LO 6), when the
language on the font tab is set to None, I get the behaviour you are
describing. You can change this by editing the associated style(s) and
set the language y
Hi,
There seems to be an initialization problem with your chapter
numbering. In Writer, chapter levels and their numbering are defined in
Tools -> Chapter Numbering. On that panel, you can define the style of
the paragraph level (usually Heading 1 to Heading 10 or whatever works
in your language) a
Le samedi 02 juin 2018 à 11:34 +0200, David Rakidzija a écrit :
> Hi,
>
> what's the best way to insert long comments into calc? A floating window that
> does not interfere with the spreadsheet itself would be best.
> 1. the built in commentary for cells seems to be buggy, sometimes wound't
> di
Hi,
If it is pure display you are looking for, then the difference in days
is:
=INT((A2+B2)-(A1+B1)) with a numbers display format (such as # ##0)
the difference in hours is:
=(A2+B2)-(A1+B1) with a display format set to [h]
You can be a bit fancy and set the # days format to be # ##0" days" and
th
Le lundi 30 avril 2018 à 21:53 +, Virgil Arrington a écrit :
> On 04/30/2018 05:49 PM, Ben Oliver wrote:
> > On 18-04-30 21:43:00, Virgil Arrington wrote:
> > > This is intriguing. I just looked over my options with LO 6.0.3
> > > in
> > > saving as a PDF and I don't easily see any method of sa
Hi,
If I understand your question correctly, you need to be able to
"automatically" index in your data matrix, for total sum and number of
days. To achieve this, I would change the worksheet in the following
manner:
Formula in D2: =SUM(OFFSET(D3;0;0;MATCH(TODAY()-1;$C$3:$C$368;0);1))
This formula c
Hi,
Would this be the Slide... Insert Slide from file?
I hope this helps.
Rémy Gauthier.PS: Not sure my last message went through (mixup of
sender address). Sorry if it came twice.
Le samedi 31 mars 2018 à 22:04 +0200, Regina Henschel a écrit :
> Hi,
>
> some feature have moved. Do you remember, i
Have you tried using Right-click -> Edit comment? When you do this, the
cursor is placed inside the comment and you can easily navigate in it.
At that point entering CTRL-A will select the entire comment text. I
tend to agree with you that accessing the comment text by clicking in
the comment when
Hi,
This problem seems to have been observed not so long ago:
http://ask.libreoffice.org/en/question/63369/repair-corrupt-odb-file/
The fix that is mentioned in that post is there:
http://forum.openoffice.org/en/forum/viewtopic.php?f=83&t=17567
Not sure if the proposed solution will help, but it
1 - 100 of 165 matches
Mail list logo
