I often use defined name CRLF in Excel like below images. The formula is
=CHAR(13) + CHAR(10). This method cannot be correctly imported from Excel
to LibreOffice.
Here are summarized images.
http://nabble.documentfoundation.org/file/n4118441/CRLF.png
TomD wrote
The Doc, Xls, Ppt files all used to have this problem too but now that MS
have stopped developing it so much and moved to developing their newer
formats it's finally these older formats that ARE good for sharing between
different programs.
The old MS Binary specifications last had
Owen Genat wrote
The old MS Binary specifications last had an update of significance
(change in technical nature) on 2014-04-30 (XLS) and 2012-01-20 (DOC and
PPT).
Oops. I am already out of date. The DOC and XLSB specifications had a major
update 2014-07-31.
-
Best wishes, Owen.
--
View
Hi Guys,
Is there any way to split a primary (one that has not been 'merged'
previously) cell? I can't seem to find such an option. If there is no
current option then is it technically possible to do so?
Paddy
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
Hi @katsum,
works for me as I think it must be expected, with:
Win7x64, LibreOffice 4.2.6.5 / 4.2.7.2 / 4.3.0.4 / 4.3.1.0.0+ /
4.4.0.0.alpha0+
I don't remember any option to change this behavior, but maybe there is any.
Try resetting the User Profile
Pat,
why do you need to split a cell? What data does it contain and what do you
need to do with these data?
Nino
Am 10.08.2014 13:25, schrieb Pat Brown:
Hi Guys,
Is there any way to split a primary (one that has not been 'merged'
previously) cell? I can't seem to find such an option. If
Thanks for your reply. I have tried the User Profile matter, but it doesn't
work.
After that, I have found out the solution for this problem.
Tools - Options
- LibreOffice Calc - Formula
-- Recalculation on file load - Excel 2007 and newer:
Always recalculate (from Never recalculate)
--
Thanks Alan. I need to split a single cell and work with it as two cells
(i.e. text as well as background and cell borders). Maybe the only way to
do this is to merge two columns and then split the one cell that I need to
work with. This is rather ham-fisted but may be the only solution.
On 10
Nino, I am creating a geological time-line in Calc. Working across the
sheet I am dividing the cells into periods. There are five different sets
of periods. I find, after I have started, that I need to create smaller
units than one cell. If I could split this cell it would work for me.
Otherwise I
Good, that you have found a solution.
And thanks for share it.
Miguel Ángel.
--
View this message in context:
http://nabble.documentfoundation.org/Defined-name-CRLF-Newline-cell-in-Excel-cannot-be-correctly-imported-tp4118441p4118470.html
Sent from the Users mailing list archive at
On that note then, I'd like to record that as an ex-Excel guru and
Office trainer, I am permanently delighted by the quality and stunned by
the price of LibreOffice.
There may be no such thing as a free lunch in Economics, but in the IT
world, LO (and of course oOo) are the closest things to a
On Thu, 07 Aug 2014 18:10:50 +0200
Errol Goetsch er...@xe4.org wrote:
[snip]
Thank you to the developers who have given so much to so many for
so little.
[snip]
Hear, hear!
Regards,
Jim
--
Note: My mail server employs *very* aggressive anti-spam
filtering. If you reply to this email and
+1
On Aug 10, 2014 7:19 AM, Jim Seymour jseym...@linxnet.com wrote:
On Thu, 07 Aug 2014 18:10:50 +0200
Errol Goetsch er...@xe4.org wrote:
[snip]
Thank you to the developers who have given so much to so many for
so little.
[snip]
Hear, hear!
Regards,
Jim
--
Note: My mail server
Hi :)
I didn't mean that Italo was wrong, just that it was possibly a bit geeky
(and that wasn't a disadvantage because he put it so well).
Where MS might be updating their doc, xls etc formats at least they have
hopefully stopped doing different versions for different versions of their
program.
Hi :)
+1
Also a big thanks to everyone else who helps or has helped, especially
those who seldom get any recognition.
Regards from
Tom :)
On 10 August 2014 15:32, J. Van Brimmer jerry...@gmail.com wrote:
+1
On Aug 10, 2014 7:19 AM, Jim Seymour jseym...@linxnet.com wrote:
On Thu, 07 Aug
At 13:25 10/08/2014 +0200, Pat Brown wrote:
Is there any way to split a primary (one that has not been 'merged'
previously) cell? I can't seem to find such an option. If there is
no current option then is it technically possible to do so?
This wouldn't really make sense. One of the principal
Am 10.08.2014 15:10, schrieb Pat Brown:
Nino, I am creating a geological time-line in Calc. Working across the
sheet I am dividing the cells into periods. There are five different sets
of periods. I find, after I have started, that I need to create smaller
units than one cell. If I could split
On 10/08/14 03:01, Owen Genat wrote:
Please refer my clarification to Italo's information up-thread. The
Transitional and Strict formats are both defined in ISO/IEC 29500.
In ISO/IEC 29500 there is only one transitional definition, while
Microsoft has produced three different transitional
On 10 August 2014 14:20, Nino Novak nn.l...@kflog.org wrote:
Pat,
why do you need to split a cell? What data does it contain and what do you
need to do with these data?
Nino
On 10-8-2014 15:10, Pat Brown wrote: Nino, I am creating a geological
time-line in Calc. Working across the
sheet
At 11:49 10/08/2014 -0400, Robert Funnell wrote:
On Sun, 10 Aug 2014, Brian Barker wrote:
At 13:25 10/08/2014 +0200, Pat Brown wrote:
Is there any way to split a primary (one that has not been
'merged' previously) cell? I can't seem to find such an option. If
there is no current option then
On Aug 10, 2014, at 7:10 AM, Pat Brown mistyha...@gmail.com wrote:
Nino, I am creating a geological time-line in Calc. Working across the
sheet I am dividing the cells into periods. There are five different sets
of periods. I find, after I have started, that I need to create smaller
units
On Sun, 10 Aug 2014, Brian Barker wrote:
At 11:49 10/08/2014 -0400, Robert Funnell wrote:
On Sun, 10 Aug 2014, Brian Barker wrote:
At 13:25 10/08/2014 +0200, Pat Brown wrote:
Is there any way to split a primary (one that has not been 'merged'
previously) cell? I can't seem to find such an
I havne't used Base, but I have taken a very complex spreadsheet and designed
an SQL database from it when it became unwieldy. Key things I'd suggest, more
tables is not bad, in fact the more the better if it clearly separates data
into one table. Do not duplicate data. If you have a field
Really good suggestions!
On Sun, 10 Aug 2014 10:50:48 -0600
Oogie McGuire oog...@desertweyr.com wrote:
Do not duplicate data. If you have a field whose contents are
duplicated then that really probably needs to be a separate table.
Yes, true. Note that if a field is duplicated, is suggests
So - I've started with the previous suggestions and am hesitant to
change now (put in about 5 hours over the past couple days to learn by
doing).
Attached is what I have so far. It's pretty basic but just two tables
(as you can see) and a form which I made to my likings.
Suggestions
At 12:41 10/08/2014 -0400, Robert Funnell wrote:
On Sun, 10 Aug 2014, Brian Barker wrote:
At 11:49 10/08/2014 -0400, Robert Funnell wrote:
On Sun, 10 Aug 2014, Brian Barker wrote:
At 13:25 10/08/2014 +0200, Pat Brown wrote:
Is there any way to split a primary (one that has not been
'merged'
Hi All,
So I went back to planning stage. Link to what I think might work -
hoping to get the planning stage done today so I can start actually
putting together the db - I have 3 days off so now's a good time for me
to get the basic structure together :) Thanks in advance!
Joel,
The NumberOfBooksByAuthor and ReadBooksByAuthor fields are unnecessary.
They can be derived from a simple query for a report.
Since there has to be a one-to-one relation between the ReadStatus table
and the BookInformation table, you might as well merge them. When you do
merge them, a
It looks like each book should only have one of the ReadStatus flags
set, so I'd make that an enum field on the BookInformation table, with
possible values of Not Read, Reading and Read. You can set the
default value for the field to Not Read so a new record will be set to
that status if no
Hi Joel,
On Sun, 10 Aug 2014 16:02:04 -0400
jomali jomali3...@gmail.com wrote:
Joel,
The NumberOfBooksByAuthor and ReadBooksByAuthor fields are
unnecessary. They can be derived from a simple query for a report.
Agreed.
Since there has to be a one-to-one relation between the ReadStatus
On Sun, 10 Aug 2014 21:30:18 +0100
Mark Bourne libreoffice-ml.mbou...@spamgourmet.com wrote:
It looks like each book should only have one of the ReadStatus
flags set, so I'd make that an enum field on the BookInformation
table, with possible values of Not Read, Reading and Read. You
can
Not sure; it's just a possibility to rule out. One possible explanation
is that the seemingly stuck key doesn't have any effect in other
applications you use. In Gnucash, Shift+Arrow keys or Shift+Click just
moves the selection - the same as just pressing the arrow keys or
clicking without
Thanks all - I have enough to do something - probably won't be perfect
but will work for my needs. As for importing the data - not horribly
concerned about this. Very worse case I'll manually enter which won't be
too horrible in my case (really only about 250 entries to put in). More
concerned
I am still using the 3.xx version of LO that came with Ubuntu 12.04 and
haven't been on the main LibreOffice site for some time. I've been
reading the naming discussion (Fresh/Still etc) and decided to look at
the site. While there I stumbled across Acces2Base. I've always
thought writing
Paul wrote:
On Sun, 10 Aug 2014 21:30:18 +0100
Mark Bourne wrote:
It looks like each book should only have one of the ReadStatus
flags set, so I'd make that an enum field on the BookInformation
table, with possible values of Not Read, Reading and Read. You
can set the default value for the
On Aug 10, 2014, at 3:48 PM, Mark Bourne
libreoffice-ml.mbou...@spamgourmet.com wrote:
you wouldn't generally add or remove status options (and the application may
assign special meaning to certain statuses, so it may be critical that a
specific set of values is defined). Then again, in
On Aug 10, 2014, at 4:26 PM, Paul paulste...@afrihost.co.za wrote:
Yeah, being able to change these values later is one of the main
reasons to use a separate table. Clients almost *always* end up adding
or removing some of these.
Also, when you have specific functionality tied to some of
Gah - I just realized that I think I have to separate date read from
the book info. Reason being that if I read a book 2-3 times and want to
track the dates then I have to have another table. With this, I'd do a
one to many relationship between the book information and the read date
tables,
One reason to keep all the tables separate is to facilitate adding things to
them later. Also localization for other languages and to keep entries exact so
searches are easier to do. Solves issues with How did I spell that? problems in
queries
To my mind the only thing that belongs in a table
On Sun, 10 Aug 2014 16:48:31 -0600
Oogie McGuire oog...@desertweyr.com wrote:
We agree G I think my comments passed yours in the mail.
I hadn't done any relational database work until this current big
project, thats why the database design book I recommended was so
critical. It got me
Hi Joel,
On Sun, 10 Aug 2014 15:49:25 -0700
Joel Madero jmadero@gmail.com wrote:
Gah - I just realized that I think I have to separate date read
from the book info. Reason being that if I read a book 2-3 times and
want to track the dates then I have to have another table. With this,
I'd
I apologize for taking your message the wrong way;
and I thank you for this explanation.
Friends :-)
From: Charles-H. Schulz charles.sch...@documentfoundation.org
Date: Sat, Aug 9, 2014 at 10:22 AM
Subject: Re: [libreoffice-users] query ...
To:
Thanks Jim for introducing this topic.
A small company I know is using an ACCESS DB with macros exporting certain information into EXCEL
spreadsheets. This ACCESS DB is currently preventing the company to change over from MSO to LibO
and Linux.
A 2 step approach is discussed: First to
I decided to do the smart thing and diagram it out - the diagram isn't
perfect (looks wise) but I hope that I can get a +1 before actually
making the databases.
Note: I decided to put rankings with date read table, this way I can
have different rankings for the same book (for each instance
On 8/10/2014 9:50 AM, Oogie McGuire wrote
If I were doing your system I'd do the following:
Book table
Title
number of pages
Foreign key links to an authors table and a series table
boolean read or not or else a link to a table read status see below
Authors
Good morning
I am trying for years already to get friendly with linux, but have not
much luck with it.
Right now, I am (again) experimenting.
A new installation of (X)ubuntu 14.04 on two different machines comes
with LibreOffice.
However, the shortcut keys I am used to are different or
On 08/10/2014 08:02 PM, rost52 wrote:
Thanks Jim for introducing this topic.
A small company I know is using an ACCESS DB with macros exporting
certain information into EXCEL spreadsheets. This ACCESS DB is currently
preventing the company to change over from MSO to LibO and Linux.
A 2 step
On 8/10/2014 6:48 PM, Joel Madero wrote:
I decided to do the smart thing and diagram it out
Potential issues with the author field:
Book One: Author A Author B;
Book Two: Author B Author A;
Book Three: Author A Author C. Author C is really Author B, but has
had a name change;
Book One,
I'm not horribly worried about name changes ;)
Best,
Joel
On 08/10/2014 07:21 PM, jonathon wrote:
On 8/10/2014 6:48 PM, Joel Madero wrote:
I decided to do the smart thing and diagram it out
Potential issues with the author field:
Book One: Author A Author B;
Book Two: Author B Author
On 10 August 2014 21:13, Thomas ny...@hb.tp1.jp wrote:
Good morning
I am trying for years already to get friendly with linux, but have not
much luck with it.
Right now, I am (again) experimenting.
A new installation of (X)ubuntu 14.04 on two different machines comes
with LibreOffice.
On 8/8/2014 11:15 AM, Pikov Andropov wrote:
MSO 2013 is incompatible with itself
I think he meant that MSO 2013 isn't fully compatible with MSO2010 o
No.
I meant that MSO 2013 is completely, utterly, and absolutely
incompatible with MSO 2013.
Likewise, MSO 2010 is completely,
Hey Jonathan,
responded in line but the gist is - this is a hobby and I'm not going to
spend hours and hours thinking about corner cases/etc... if a book has
multiple authors, I'll pick one, if it belongs to multiple series, I'll
pick one, if it's a spin off to a main series, I'll just track
52 matches
Mail list logo