m
for the year to date as the various monthly values are entered.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documen
At 22:44 19/07/2014 -0400, James Lockie wrote:
On 07/19/14 21:34, Brian Barker wrote:
At 20:27 19/07/2014 -0400, James Lockie wrote:
I want the years since a date and today. I tried this function:
=YEARS(7/16/2012,TODAY(),1)
but it returns 1900.
Your first argument is 7 divided by 16 divided
TEVALUE("7/16/2012"),TODAY(),1)
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquett
s you expect around the
end of the year and in years with fifty-three weeks. Which years have
fifty-three weeks itself depends on the other definitions.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/g
Save.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http
to tile windows either horizontally or
vertically, and if you have two windows open, this may achieve
exactly what you need on the fly and without any particular care being taken.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
ticked?
Note also that everything on the printed page can be affected (in
your case possibly reduced) by the settings at Format | Page... |
Sheet | Scale. Select "Reduce/enlarge printout" for Scaling mode and
"100%" for Scaling factor as a starting point.
I trust this helps
formula.
And there appears to be no equivalent of that
Options / Preferences setting for table formulae rather than spreadsheets.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lis
files to PDF.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http
At 12:06 09/07/2014 +0200, Ian Whitfield wrote:
On 07/09/2014 11:28 AM, Brian Barker wrote:
Yes: there is the IF() function: is that a close enough equivalent? Just put
=IF(condition;expression-for-true;expression-for-false) .
Your expression for false may well be consecutive double-quote
n. (If there is a figure >0 in column B then calculate column C.
Yes: there is the IF() function: is that a close enough equivalent? Just put
=IF(condition;expression-for-true;expression-for-false) .
Your expression for false may well be consecutive double-quote marks,
representing the null str
ckwise arrow
Note that you need to pay attention to whether any such characters
will be rendered properly in a word processor document on any other
system, no matter how similar. You may have more success by exporting
your document as PDF and distributing that.
I trust this helps.
Brian B
lining, select Single; for Strikethrough, select "With /";
and perhaps for Font colour, select a suitable Grey.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-un
At 00:05 07/07/2014 +0100, Philip Ward wrote:
On 06/07/2014 17:01, Brian Barker wrote:
At 13:12 06/07/2014 +0100, Philip Ward wrote:
... and now i went in to alter the format of the cell ie Date
details "D " giving me "Monday 6 October 2014" but
now want to s
een opened and resaved on a system with locale set to Hebrew.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more:
At 16:54 05/07/2014 -0400, Pikov Andropov wrote:
Brian Barker has written on 7/4/2014 8:11 PM:
What you are doing is really just shuffling your six names.
Well, actually, it's not. :-) I want to create a list of pairs from
a subset of the names in column A.
It is: the list of pai
e one.
;^)
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/
to do to produce
another shuffling is to repeat the sort process, which will use those
new random values.
If you actually need the values in pairs as you have described, you
can use something like
=INDIRECT("B"&ROW()*2-1)&", "&INDIRECT("B"&ROW(
ner table and press Alt+Enter.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List arch
k even at first, or if you want a warning that it
cannot be saved in ODF documents).
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http
the
numerical column, an alternative technique would
be to have another area - perhaps on another
sheet - where a copy with properly formatted
values was created. You could then print just that area or sheet.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@g
that the cursor changes to a vertical line with horizontal
arrows, left and right.
o Double-click.
Or:
o Select the cell with the longest entry.
o Press Alt+Shift+right-arrow.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http
Special... (or Ctrl+Shift+V)
instead of ordinary Paste. In the Paste Special dialogue, ensure that
Paste All is not ticked and then that Formulae is also not ticked.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libr
ocessor. My later suggestions - what you actually asked for - are
almost certainly worse techniques that the simple three-cell table solution.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/g
At 11:59 18/06/2014 +0200, Cley Faye wrote:
2014-06-18 2:37 GMT+02:00 Brian Barker:
At 20:59 17/06/2014 +0200, Cley Faye wrote:
Unfortunately, not directly. And there is (as far as I know) no
simple "viewer" that could be used for this purpose, ...
On the contrary, if the target p
At 20:41 17/06/2014 -0400, Pikov Andropov wrote:
Brian Barker has written on 6/17/2014 8:37 PM:
At 20:59 17/06/2014 +0200, Cley Faye wrote:
2014-06-17 20:44 GMT+02:00 Pikov Andropov:
Can LO produce an executable file from a PowerPoint presentation,
so that no viewer is needed at the time the
simple "viewer" that could be used for this purpose, ...
On the contrary, if the target platform is Windows (but not other
operating systems), it can use the freeware Powerpoint Viewer from Microsoft:
http://www.microsoft.com/en-us/download/details.aspx?id=13 .
Brian Barker
--
To uns
th .ppt but the second with .pptx.
Possible solutions:
o Try saving as .ppt instead of .pptx.
o In any case, pay attention to careful document design in the first place.
But this is all guesswork, of course.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.
paragraph after the
nested table and therefore available space from which to drag.
Instead, your trick of selecting the outer table's cell (including
the nested table) by dragging from that cell to an adjacent cell and
back again is all that is required. That's a much simpler solutio
s procedure was successful in Word and Kingsoft
Writer, so I'm confident that there's a way to do it in LO.
Oh, I wouldn't assume that LibreOffice was like any other product!
But yes: it will usually achieve what you need.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail
that paragraph.
You can access this property through two mean:
- Right click on the paragraph at the top of the new page, select
"Paragraph..."
Exactly: via Paragraph..., not via Edit Paragraph Style... .
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffi
styles.
Alternatively:
o Go to Tools | Customise... | Keyboard.
o Under Functions | Category, select Insert.
o Under Function, scroll down to and select Manual Break.
o Under "Shortcut keys", select your chosen shortcut.
o Click Modify and OK.
I trust this helps.
Brian Barker
-
pages repeatedly as for the spreadsheet case, always omitting
the first page, so as again to avoid the invisible starting value.
After a total of ten copying actions you will have 513 separately
dated pages - nearly seventeen months' worth. Delete the excess.
I trust this helps.
Brian Bark
templates.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List arc
mmendation would be to create a character style with the
properties you need. If you then keep the Styles and Formatting
window open, you can:
o position the cursor where you wish to type,
o double-click the style name in the Styles and Formatting window, and
o type.
I trust this helps.
Br
need the Account Balances and Profit and
Loss statements in the same document.
Combining information from multiple sources can very likely be done
most easily in the intermediate stage in the spreadsheet.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@glo
At 13:02 01/06/2014 +0800, Zonly Ponly wrote:
On Sun, 01 Jun 2014 01:11:36 +0100 Brian Barker wrote:
At 17:34 31/05/2014 -0600, Oogie McGuire wrote:
I have a spreadsheet and the data was originally entered as 4
digits. I need to pass it to a database system that requires 6
digits. I've
o In a new column, enter ="00"&Xn and fill it down the column. You
will now have six-character text values. Again, you could copy these
back over the original values, using Paste Special... and pasting
Text but not Formulas.
I trust this helps.
Brian Bar
fill it down the column.
o Create a visible cell style - perhaps with a coloured background.
Apply conditional formatting, using "Formula is" and
NOT(ISNUMBER(Xn)) - applying your new cell style. Use the Format
Paintbrush to apply this down the column.
I trust this helps.
Brian Barker
that they are using Microsoft Word, you could
teach them how to "unlink fields" in the documents before sending
them to you. That way, you'd preserve any formatting that you *did* want.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreo
in the 'words'.
You will get a more consistent (and therefore neater?) effect by
leaving single spaces between words, but then adjusting letter
spacing. To do this, go to Format | Character... | Position | Spacing
(or right-click | Character... | Position | Spacing), select
Expande
way.
Since when have homographs been a problem? (Oh, and that middle
example should be "led" anyway"!)
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guid
atter solely for printer settings, LibreOffice
- more sensibly, in my opinion - treats page size as an aspect of
page format. If you want to print a 11" x 17" page, you will first
have to set the page to that size at Format | Page... | Page | Paper
format | Format.
I trust this helps.
Br
s are
designed to operate when documents are saved in LibreOffice's native
Open Document Format format. If you save the file in some other
format than .ods, you may be able to bypass the protection.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libre
ill see this only if you click
the help ("?") icon at the left of the address bar.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
P
At 11:22 15/05/2014 -0700, Frank 'CVAlkan' Oberle wrote:
Thanks Brian, but still nothing.
Interesting. Do these techniques not work for others in Impress?
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.or
se Backspace, Delete, Edit | Cut, or Ctrl+X.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundati
Select all the items in each drawing together and use Modify |
Group to group them.
o Right-click the group and go to Convert > | To Bitmap.
o Right-click the group and select Save as Picture... to save a copy
of the group in a suitable format.
o You can now insert that saved file into you
des themselves (which may initially
be a useful guide to which slides the notes belong to). It should be
fairly straightforward to do this.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing
At 19:56 08/05/2014 +0100, Alex Kempshall wrote:
On Thursday 08 May 2014 15:43:43 Brian Barker wrote:
At 14:23 08/05/2014 +0100, Alex McMurchy wrote:
I have a requirement to generate PDF's from
specific set sheets contained in one Calc
document, the document has 85 individual sheets.
trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffic
Adjust the style properties as desired - presumably including
setting Landscape on the Page tab.
o Bring each sheet to the front in turn and double-click the
appropriate style to apply it.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
) keyboard arrow keys not work for you? You should also
find that Tab moves forward in the table and Shift+Tab similarly
backwards. For this reason, if you need to insert a Tab character in
a table cell, you need to use Ctrl+Tab instead of simple Tab.
I trust this helps.
Brian Barker
--
To
. (Documents can have multiple page styles.)
o The material in columns is contained in a section, a structure
which can independently have multiple columns.
o The material in columns is contained in a table.
o The columns were constructed in some other way, perhaps in frames.
I trust this helps.
- and by not interfering, this list preserves this facility
for you as it should.
I ... will NOT participate in a flame war.
No incendiaries here!
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how
t number, but you'd
better check the maths. The remainder of the calculation is left as
an exercise for the reader!
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-list
he right. The cursor will now be in your new
column; press Alt+left-arrow or Alt+right-arrow to change the column
width as desired. You can set the original width of columns inserted
this way at Tools | Options... | OpenOffice.org Writer | Table |
Keyboard handling | Insert cell.
I trust thi
e only difference is that with OLE you can edit the linked
document from the target one, whereas with DDE you cannot. In this
case, it would mean you could edit the spreadsheet contents from
within the text document. But you wouldn't want to do that in these scenarios.
I trust this hel
range,
as you are unlikely to want the intermediate values printed.
I'm attaching (perhaps only for the questioner to receive?) a sample
spreadsheet. The years and book numbers are random, so you can press
F9 repeatedly to see how it operates on different data.
I trust this helps.
Bria
pt the offer to "Update
all links?". Provided the spreadsheet file is closed, the formula
will be recalculated each time.
An alternative is considering whether to construct your entire text
document in the form of a spreadsheet.
I trust this helps.
Brian Barker
--
To unsu
uch sooner.
(Er, no: I am not taking sides. But I do like to see arguments being
based on evidence.)
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines +
the two explicit addressees of your message will
have seen this.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.do
crosoft Word's
"sections", which are rather different: those are unfortunately named
section *breaks* and more akin to LibreOffice's manual page breaks
with a change of page style.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? htt
break.
o Now go to Insert | Manual Break... to reinsert the page break.
Under Type, select "Page break" - but this time, under Style, *click
the down arrow to show a drop-down menu of page styles and select
your "appendix" style from the list*. Only then click
t
Changes instead, which enables you to distinguish the changes you
want and don't want, or to make these changes at an early stage in
the treatment of any document, so that you can undo any unwanted
effect manually.
I trust this helps.
Brian Barker
--
To unsubsc
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoff
lues come from: it may be
easier to import them in a more useful format originally.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Postin
You seem to be writing from a country where the normal fractional
separator would be a comma, not a point. Is this a locale issue?
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lis
rust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.o
responsible for this (other) software got fed up with
seeing so may distorted images - especially of faces and so on - on
web sites and the like that they decided to give in and make it
easier for users not to make that mistake.
Sorry this is no help!
Brian Barker
--
To unsubscribe e
tly used file names
and give you a quick route to your few regularly used files. Note
that you will need to activate this item separately in the separate
components Writer, Calc, and so on if desired.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsub
lob?
Yes, exactly.
Er, the answer to this - as you had previously explained - is actually "No".
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting gui
way...maybe someone is interested in this apparent conflict
between soffice.exe in %path% and Firefox?
Putting a file name there instead of a path is likely to cause confusion ...
The important thing is, the batch script works ...
Good-oh! What you did was a perfectly acceptable alternat
At 16:14 11/04/2014 +0200, Paul Steyn wrote:
On Fri, 11 Apr 2014 09:46:51 +0100 Tom Davies wrote:
I'm not sure if you can use
cd c:
Yes, you can use that to change directory.
Er, no: you cannot. Try it and see.
Brian Barker
--
To unsubscribe e-mail to: users+uns
see?
The Stock chart type will do this for you. You can adjust the width
of the bars.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines
rent pages from the same
text document in different layouts - both of which you can do very
easily in LibreOffice.
Unless I've got this completely wrong, do please take care not to
advertise a prejudice as if it were a genuine fault with the
application which is the topic of this list.
e. Go to Table | Insert > | Table... and
create a table with two columns and (probably) one row. You will
find that the table cells expand as necessary to accommodate your
text - even to additional pages - and that the two columns will
remain independent.
I trust this helps.
Brian Barker
-
ve the images resized automatically.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List
ithout making any visible changes), both of these statements
are exactly what I'd expect and don't seem at all "odd".
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing
At 11:15 27/03/2014 -0400, Virgil Arrington wrote:
Does anyone know of a way to save a Writer document as plain text
and *keep* footnotes?
It's messy, but:
o Export as PDF.
o Open PDF in reader of choice and save as text from there.
I trust this helps.
Brian Barker
--
To unsubscribe e
and column widths when pasting entire
rows or columns, in fact.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.document
Your "mainframe languages" would have had the properties I described.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documen
retrain their staff regularly.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarch
two - in
error - different (though you didn't notice). When you inevitably
need to make changes to your arrangements, you make them in one place
and can be confident that they will be instantly applied everywhere
appropriate.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@gl
separate documents keeping their own
properties, use sections - ticking Link and browsing to the component
document file on the Section tab of the Insert Section dialogue.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org
#x27;s
background colour is a property of a cell style, and it's a cell
style that is applied by conditional formatting. Unsurprisingly, you
can also do it in Excel. As for Gnumeric ...
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://w
pen those
documents, so you should not need to make changes "as well as in each
file" - only perhaps to open those files, accept the offer, and re-save them.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http:
e embarrassed by all this because I had quite a bit of
opposition to using OpenOffice back at the start of this project.
I think we are talking about LibreOffice, in fact. And I suspect
that it will do what you need.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr.
use explicit page breaks (possibly included as a paragraph or
paragraph style property)? Better the latter.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscri
hieve
her purpose?
Yes. At least, it suppresses any display of time data - and thus the
presence of any such data in what you save to CSV.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-li
n are of the same type or format,
of course.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Neti
Formulas *not* ticked.
o Now format the new date values as desired.
Oh, but I see you've beaten me to this ...
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelin
At 17:48 17/03/2014 +, Budgie Noname wrote:
On 17/03/14 13:25, Brian Barker wrote:
At 11:43 17/03/2014 +, Budgie Noname wrote:
In short I am having to "massage" a .csv file exported from one
system before importing it into an accounting system. The
accountant wants a "
At 13:53 17/03/2014 +, Budgie Noname wrote:
On 17/03/14 13:25, Brian Barker wrote:
At 11:43 17/03/2014 +, Budgie Noname wrote:
In short I am having to "massage" a .csv file exported from one
system before importing it into an accounting system. The
accountant wants a "
ou ought to want to apply a character style
instead, but I don't see any obvious way to do this.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how
an easier way. When you open the CSV file, you
should see the Text Import dialogue. Under Fields, click in the date
columns and then select Text from the drop-down menu against "Column
type". The dates will be imported as text and you will not need the
above workaround.
I tru
ther than
the automatic effect you are seeking, but once you have done it, the
row will respond automatically to future changes - as you wish. If
instead you drag the lower row edge to expand a cell manually, you
will be setting a row height and spoiling the effect you desire.
I trust th
At 10:18 16/03/2014 +0100, Lorenzo Noname wrote:
Il giorno 15/mar/2014, alle ore 20:56, Brian Barker ha scritto:
At 17:25 15/03/2014 +0100, Lorenzo Noname wrote:
a spreadsheet has thousands of lines and
hundreds of columns. Most users (like me)
don't need that many cells. Is there an
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreof
At 15:09 10/03/2014 -0700, J. Van Brimmer wrote:
On Mon, Mar 10, 2014 at 1:40 PM, Brian Barker wrote:
At 13:25 10/03/2014 -0700, J. Van Brimmer wrote:
I'm using LibreOffice 3.5.4.2 on Debian Linux. After I create a
footnote on a page, say page 1, and create a footnote, let's say
Fo
701 - 800 of 1406 matches
Mail list logo