[libreoffice-users] Re: Page formatting in writer goes nuts

[Denis Navas Vega]

The problem that several pictures change its place, remember me how the 
images are placed in text with the program LaTeX. That program is famous 
for being the first program (since 1979) that was able to diagram 
automatically text.


LaTeX has rules of how many diagrams are allowed in a page accounting 
the space that uses. Generally moves the graphics (or float objects) 
downstream in the text until fits acording to rules to position galleys 
of text and floating object.


LibreOffice and MS Office too, has also problems related to image 
positioning and with both programs I have reached that is preferable to 
have images not surrounded by text and positioned between paragraphs, 
fixed or anchored to characters. That's not the way as MS Office works 
by default, but that can be changed in program's options. LibreOffice by 
default anchor the images to the paragraph, which is good, but the 
figure frames allows text flowing around the image. But if you insert 
the image and not instruct LibreOffice to add a frame, will add it 
anchored to a character.





---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus



--
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/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: example convenience of calc

[Denis Navas Vega]

El 2016-08-26 a las 05:03, message escribió:

Readers,

Useful to be able to type in the command line:

libreoffice --calc --nologo
https://www.gov.uk/government/uploads/system/uploads/attachment_data/file/450279/Progress_8_2015_opt_in_schools_final_list.ods


Then the spreadsheet appears directly from the web server!

Looks good with the 'load url bar' view of the url in the menu bar too,
like a web browser! :)



I have to use 'soffice' instead of 'libreoffice'

---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus



--
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/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Calc will not save files on a Windows 10 machine

[Denis Navas Vega]

Several ideas that might help.

A downloaded file receive a "blocked" attribute. I ignore if that 
propagates to files that the instaler expand and copy.


The second thought I had is that you are using a portable installation, 
that you can test it on Windows 7.


I remember that some operations require java and for portable programs 
is preferable portable java. That is true for the assistants (letter, 
fax, agenda, presentation ...) and for the options on the start up panel 
"Writer Document", "Calc book", etc for new documents. But the menus 
(file - new - type of document) works well without needing java.


Also, LibreOffice web page warns about the compatibility of 32/64 bits 
versions with processors of 64 bits. Is your version compatible?


Windows 10 has also preference to MS software and probably and have been 
mentioned that alternative software rutinously are having problems with 
Windows 10.




---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus



--
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/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Calc will not save files on a Windows 10 machine

[Denis Navas Vega]

Can you test the same version and same file, in your Windows 7 machine?

Windows is prone to introduce incompatibilites ex-professo.

---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus



--
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/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: copying down references to other cells turns text to UPPERCASE

[Denis Navas Vega]

El 2016-06-01 a las 06:08, m.a.riosv escribió:

I can't reproduce with Version: 5.2.0.0.alpha1+

But as it happens from row 100 looks as an OpenCL issue, please test
disabling it:

Menu/Tools/Options/LibreOffice/OpenCL

The number 100 is set up in:
Menu/Tools/Options/LibreOffice calc/Formula - Custom

Miguel Ángel.



--
View this message in context: 
http://nabble.documentfoundation.org/copying-down-references-to-other-cells-turns-text-to-UPPERCASE-tp4184881p4184992.html
Sent from the Users mailing list archive at Nabble.com.



I have disabled OpenCL and reproduced the reported problem.

---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus



--
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/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: copying down references to other cells turns text to UPPERCASE

[Denis Navas Vega]

I can confirm it also occurs in version 5.2.2, Windows 7, 32 bits, 
starter edition.


---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus



--
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/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Regional Language Support

[Denis Navas Vega]

El 2016-05-25 a las 23:26, Ankan escribió:

Hello, Luca Daghino

   All screenshots are attached herewith. Lenevo thinkpad, WIndows 7 prof,
latest Libreoffice version as on 26-05-2016 i.e. 5.1.3.2 are the asked
details. Tell me if you need any other info.







--
View this message in context: 
http://nabble.documentfoundation.org/Regional-Language-Support-tp4184438p4184458.html
Sent from the Users mailing list archive at Nabble.com.

Screenshot2 looks like the font is not capable to display the characters 
you are writting.


---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus



--
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/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Calc F2 cursor trail between brackets of function

[Denis Navas Vega]

El 2016-03-15 a las 14:35, libreoffice-ml.mbou...@spamgourmet.com escribió:

Bruce Hohl wrote:

When in Calc while editing a formula (within the cell via F2) with
characters between brackets like: =SUMIFS*(*
$TB_data.C$8:C$32,$TB_data.D$8:D$32,A36*)* or =*(*A1+A2+A3*)*.

If the arrow keys are used to moved left and right, while moving past the
character within brackets a cursor trail is displayed like this:

SUMIFS($|T|B|_|d|a|t|a|.|C|$|8|:|C|$|3|2|,|$|T|B|_|d|a|t|a|.|D|$|8|:|D|$|3|2|,|A|3|6).

The first use of F2 editing is OK but subsequent uses display this
behavior.

When you get to the closing bracket the cursor trail disappears.  Or
if you
minimize then restore the window the cursor trail disappears.

It seems to happen only within brackets, seems to be a failure to refresh
while within brackets, impacts Linux & Windows versions, and this display
error was not always present.  This behavior is described in bug 67787
from
2013-08-05.

I believe it may be related to the bracket matching (high lighting)
feature
that was introduced a few years back.  Does anyone recall which version
added that feature or know anything about this feature?

I find this super annoying and would like to improve the bug report.  If
related to bracket matching I'd rather that be disabled versus a cursor
trail rendering F2 in cell editing useless. It also makes LO look
unpolished.


I wonder if this may be related to using OpenGL for rendering, which has
apparently been enabled by default from version 5.0.2 onwards. It should
be possible to disable via Tools > Options > LibreOffice > View. It may
need a restart of LibreOffice (including the Quickstarter if you use
that) to take effect.

If that resolves the problem, it's probably worth noting on the bug
report, along with the info about your graphics card as described at
. Some of these rendering
problems only occur with OpenGL, and only with certain graphics cards.

Mark.




This problem hapen to me, before OpenGL was included in the option panel.

---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus



--
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/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Calc cell formats

[Denis Navas]

El 2015-10-03 a las 04:03, Andreas Säger escribió:

Am 03.10.2015 um 04:23 schrieb Thomas:



If you want to enter any kind of date on the num pad, the following used
to work with all types of spreadsheets, including LO 3.5, but LO 3.6
messed it up.
20/ --> this month's 20th day
20/7 --> this year's 20th of July
7/20 --> same in US context
The appearance of that entry is completely unrelevant as long as you
entered the correct value which is 42205 in case of 20 July 2015. You
can format that value any way you want but it has to be the correct
number. LO introduced that idiotic "date recognition pattern" in the
language options which may make everything more complicated than the
above simple entry pattern.



I disagree with that opinion.  It is a great thing that the user can 
adjust the pattern of characters of an date.  I prefer to use the

ISO system, but receive dates formated with the american system.


--
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/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Unable to Protect/Unprotect cells in Libreoffice 5

[Denis Navas]

El 2015-08-28 a las 05:17, Tanstaafl escribió:

On 8/28/2015 1:44 AM, Denis Navas denis.na...@gmail.com wrote:

I copied a table from calc to write.


This bug isn't about embedded spreadsheets, it is about WRITER TABLES.
They are two totally different things.

To reproduce:

1. Open new blank Writer document.
2. Click on the Table menu, click on 'Insert Table'.
3. Click inside a cell.
4. Click the 'Table' menu, click on 'Protect Cells'

Now try to unprotect the cell you just protected. There is no way to do it.

Protecting/Unprotecting the entire Table using the Navigator does NOT
unprotect the cell that you protected.



I copy the table from calc and asted as rtf on writer, as I reported.

What's important I believe, is that I am working on Windows.

--


Denis J Navas


--
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/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Unable to Protect/Unprotect cells in Libreoffice 5

[Denis Navas]

El 2015-08-27 a las 08:26, Tanstaafl escribió:

On 8/27/2015 10:01 AM, Mike Scott v...@scottsonline.org.uk wrote:

But I think you may have misread my note.


Nope...


If you R-click the table *in the navigator* (use F5) there's a
Table|Unprotect option. It only appears though if the table does have a
protected cell. At least here and I have just checked it.


That is what I did, and you are correct that the choice is there.

But my point was that it did not unprotect the cell. It allowed me to
unprotect the entire Table, but the cell was still protected.

So, it doesn't 'work' as a workaround.

Also, Cor just confirmed that they intentionally (WHY???) removed the
context menu, but that there is a bug in that there should be an option
to unprotect the cell from the Table Menu.

Now to go open a bug/feature request to bring back the most useful
context menu choice for this...



I copied a table from calc to write.  Protected the calculated data of 
two columns and unprotected with the procedure sugested by Mike Scott.


I repeated the protection, protecting first the last two columns and
later, the whole table. After that, I desprotected all the cells,
including the cells in the first two columns, following the
procedure of Mike Scott.

Two observations:

- I use LO version 5.0.0.5 on Windows 7 starter (with SP1).
- I was working in high contrast mode
  (black background - white letters). When I selected the whole table
  only the unprotected cells where selected. Even more, if I wanted
  to select cells from the last two columns, was not possible.
  I supossed, because where protected.




--


Denis J Navas


--
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/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: LibreOffice Compatible Outliner

[Denis Navas]

Is preferable a small program for the outline, because LibreOffice can 
not manage outlines.


I have used tree programs for that purpose:

1)  A text editor, with the ability to indent/unindent and to move
lines up and down. That's was one of the outline software you
describe. Also, can work in utf-8. An example: notepad2

2)  Freeplane (a mind map software), can export a tree to odt.

3)  You can use also,tkoutline (bthe...@users.sourceforge.net,
http://tkoutline.sourceforge.net), which is a little simple
but gets the work done.

Have a nice day



El 2015-07-24 a las 15:20, anne-ology escribió:

I may or may not be understanding your question;
   but if you're referring to the document adding the Roman numerals
... numerals ... letters to form an outline;
  LO does this -  so do other programs.

But I would not recommend any of them since these computer-generated
outlines don't fit with the way I was taught to make one;
   these computer generated spelling programs irk me as well  ;-)

Well, maybe I'm set in my ways,



From: H age...@meddatainc.com
Date: Fri, Jul 24, 2015 at 1:32 PM
Subject: [libreoffice-users] LibreOffice Compatible Outliner
To: LibreOffice Mailing List users@global.libreoffice.org


I am using LibreOffice on Linux and very happy with it. Often, however, I
would like to use my Android tablet, or even phone, to draft an outline of
a document that I would later develop further on my desktop.

Ideally, a simple application such as an outliner would be ideal and I
remember such DOS programs such as PCOutline etc. that existed for this
purpose. They were very simple and efficient to use and served very well.
Simple key strokes for all key features.

Does something like that exist today? Ideally for both Android and Linux
and utilizing the LibreOffice format so that outlines created could be
seamlessly imported into LibreOffice.

Thank you.




--
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/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: customise character order for comparisons?

[Denis Navas Vega]

El 2014-11-13 a las #4, Gary Collins escribió:

Hi,this is a bit of an unusual request , I know, but I'm wondering if it is possible to 
define a custom order for characters when comparing strings. I'm studying some ancient 
languages where the transcription alphabets use a mixture of standard English 
characters (but not necessarily in the same order they are found in the English alphabet) 
interspersed with Unicode characters to give things like accents or like dots (or other 
additions) underneath the letters. I'd like to create a dictionary list, probably in calc 
in the first instance with words and synonyms, and be able to sort either on the English 
column or on the 'other language' column. Is this sort of thing going to be possible? Or 
would I have to write some (possibly fairly complex) Basic (or whatever) code to do 
it?Thanks,/Gary



I suggest you visit the web site of SIL. Its an organization devoted to 
the languages of the world.  Have some tools that support how to 
represent scripts.


I also suggest you, to take a look to LaTeX.  It is completely capable 
for languages, academic work, building diccionaries and using tailored 
fonts.




--

Saludos

Denis J Navas


--
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/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Printer Page/Paper Size?

[Denis Navas]

El 2014-05-21 07:27, Jim Seymour escribió:


Interestingly: I can go to Printer Settings..., Properties... and
set the page size to 11x17.  And it sticks.  But Print - Properties
keeps reverting to 8.5x11.

I've tried upgrading to 4.1.6.  No help.  I deleted C:\Documents and
Settings\username\Application Data\LibreOffice (and OpenOffice).  No
joy.


I usually print to pdf and use it later, to print phisically.

I tried both methods: i) Printer settings, properties and ii) Print, 
properties and both worked.


What I did:

First, I set the document page size to folio.
Second, I set the phisical page size to folio.

I saved, closed the program, loaded LO, loaded the file, and the 
settings persisted.






--
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/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: copy paste into Thunderbird

[Denis Navas Vega]

El 2014-03-12 01:51 a.m., Dave Barton escribió:

Thomas wrote:

Good afternoon
I recently upgraded to LO 4.2.xx
As far as I can recall, I have NEVER had any problems selecting text
portions (or all of it) in LO and then copy that portion into a TB mail.
However, no matter what I try now, this does NOT work.
NOTHING happens.

But the same procedure works, using Openoffice Write, MS Word, text
editors (naturally), even copying from PDF files works ...

So, what is this all about?
How is this supposed to be fixed?

Thank you.
Thomas


Works for me in 4.2.2.1 on Win 7 x64 no matter which paste option I use
in Thunderbird.

Dave





Can be copied from LO to WordPad and from there, to Thunderbird. But, as 
has been informed, can not be copied to Thunderbird from LibreOffice.


I am using Windows 7 starter with service pack 1 and LibreOffice 4.2.1.1.




--
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/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Calc cross-sheet issue with COUNTIF and AVERAGEIF...

[Denis Navas Vega]

El 2014-01-05 12:26 a.m., Hylton Conacher (ZR1HPC) escribió:

On 05/01/14 02:10, Ryan Ashley wrote:

I have developed a spreadsheet which contains a sheet for the cover and
basic information as well as one sheet for every month. There is a cell
with a number on every sheet at location H35. I want the average of all
of those which are not zero on the first sheet. I initially tried using
AVERAGEIF(January.H35:December.H35, 0), but it keeps giving me
error 504. I then tried the formula below, which uses COUNTIF, but the
part with COUNTIF in it causes a 504 also. If I cannot use COUNTIF or
AVERAGEIF, how do I get an average of cell H35 on each sheet where H35
is greater than zero?


It certainly sounds like a bug however that being said, but perhaps your
AVERAGEIF formula needs work.

Unfortunately my older version of LO does not have AVERAGEIF so I cannot
check the syntax. Perhaps
http://www.libreoffice.org/get-help/documentation/ will have the
answer for you.

Post the answer here or the bug number on this thread.

Hope you come right.

Hylton


i will suggest SUM and COUNTA, but this last function does not actualize 
inmediately its value when its source data change, if the change hapens 
in any sheet not containing COUNTA. The solution is save and reopen the 
worksheet.





--
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/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Calc, paste special, transpose and link

[Denis Navas Vega]

El 2014-01-01 04:42 p.m., IGraham escribió:

How i managed to do it before I've no idea ? - the brain cells must be even
more diminished than i thought

however this worked
=TRANSPOSE(the cells) then press SHIFT CONTROL ENTER

thanks for looking at the problem people and apologies for distracting you
from your new year celebrations



-
IGraham

W764  LibreOffice 4.1.0.4
--
View this message in context: 
http://nabble.documentfoundation.org/Calc-paste-special-transpose-and-link-tp4090407p4090468.html
Sent from the Users mailing list archive at Nabble.com.



I didn't know of TRANSPOSE.  I used it *without* Ctrl+Shift+Enter and it 
transposed the complete matrix and automatically included { and }.



--
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/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Issues downloading LibreOffice Portable

[Denis Navas Vega]

Portable LibreOffice works fine and don't have any language problem. 
The web site offers two variants.  One with a restricted assortment of 
languages (that you mentioned) and another one with all the languages.


At installation time you are asked to select a language.  On second 
start, LO deletes the unneeded languages, except those languages that 
comes with the software and are global extensions.





--
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/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: How do I set default date format in Writer?

[Denis Navas Vega]

Is not my purpose to start a lengthy discussion, but I must share with 
all of you my opinion.


It is desirable that the user shall have a way to configure the date 
insertion.  If that's not possible, it means that it must be input by 
hand every time is needed.


The second reason for a configurable date format is because some of my 
writings are done with markdown, converted to odt or docx with Pandoc.


Under this mechanism, the final date is allways an abbreviated date that 
not allways have the same meaning for someone from a different culture.







El 2013-12-03 08:48 a.m., anne-ology escribió:

Wow, they're in a nether world without any calendar  ;-)

the robots are coming ... the robots are coming ... oops, the robots
are here  ;-)




From: tk toki.kant...@gmail.com
Date: Mon, Dec 2, 2013 at 11:07 PM
Subject: Re: [libreoffice-users] Re: How do I set default date format in
Writer?
To: Denis Navas Vega denis.na...@gmail.com
Cc: users@global.libreoffice.org



anne-ology  wrote:


   Just curiously wondering how many seconds would be saved by not

merely typing the date into document  ;-)

This is for those who do not know what today's date is.

jonathon
--
Sent from the eating establishment at the Far side of the Universe, at the
begining of Time, and at  the end of Space.





--
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/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: How do I set default date format in Writer?

[Denis Navas Vega]

El 2013-11-30 12:03 a.m., fos escribió:

How can I set the date format in Writer so that whenever I select
INSERT-FIELDS-DATE it will insert a hard
December 31, 1999 (for example) instead of the 12/31/99 which is totally
inappropriate for correspondence.


I wish too, have a configurable date format.  I inspected a document 
created with the following ad-hoc date format:


domingo, 1 de diciembre del 2013

The date is registered with the following local style, not available in 
the style list.


  number:date-style style:name=N106
   number:day-of-week number:style=long/
   number:text, /number:text
   number:day/
   number:text de /number:text
   number:month number:style=long number:textual=true/
   number:text del /number:text
   number:year number:style=long/
  /number:date-style

The date field can't be saved in his fixed format as an automatic 
replaceable string of characters.  I guess that the best approach is 
have a macro that inserts the date with the desired format and this 
macro is run when we create a paragraph with a style 'date', for instance.





--
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/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Web layout crashes LO - update

[Denis Navas Vega]

I must say, that I have verified with a 30 pages document, that changing 
to web view, adding some text, closing and reopening, LO returns to the 
place where the cursor was before the close.


I am using LO 4.1.3.2 in a Windows 7 machine.

El 2013-11-24 10:50 p.m., Denis Navas Vega escribió:

El 2013-11-24 06:50 p.m., Thomas escribió:

LO 3.6, Win XP x2/ Win 7 x1 (total 3 machines, 2 desktops, 1 note PC)

I am working again on a book. The current file contains 1 picture and
has 260 kb. If I remove the picture, that shrinks to 60 kb. (When I
asked the last time, I had a file: 200 pages + 70 pictures = 50 MB, or
using grayscale pictures 15 MB. At that time I was told to change the
memory settings. Did not work.)

When I switch from View - Print layout to Web layout and try to use
ANY key, like moving through the document (the stupid thing always jumps
to the top of the document and I HAVE to move!), it ALWAYS, as in 100%
of the cases, crashes LO. I tried this on three different computers with
all sorts of differenct settings, operations etc. The result is ALWAYS
the same.


Good morning
No answers to my last post at all probably means, I am the only one
having this problem.

I tried some other things.
1) I opened the file using Open Office. - No problem even without
tweaking the memory settings.
2) I opened the file on a machine running Ubuntu. - No problem.

Does this give anybody a clue as to what might need to be changed
somewhere?
Thank you
Thomas




I had a similar problem with a rather small document, but with figures.
Was an annual memoir.  I changed my view to web document and this slow
down my work.

I have never tried again this feature.

To work with a great amount of figures I suggest to link instead of
insert the figures.  That way, they remain outside the document instead
in its interior. They could be placed inside a 'images' folder.






--
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/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Feature Request - Categories for special characters

[Denis Navas Vega]

Try the program babelmap from www.babelstone.co.uk/software/babelmap.html

With this program you can view all the unicode planes that a font has 
and can use virtual fonts that are a mixture of several fonts.


A companion of this program is BabelPad, which allow you to write in any 
unicode script.


These are specialized programs freely available.




--
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/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Libreoffice 4.1.3.2 slow

[Denis Navas Vega]

It is slow opening a 42 MB calc file; last 10 min.

It is slow too, specifying a crosstab table.

I don't know if the previous version could be faster than the actual 
version, but it speed is impractical.




--
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/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: CALC convert text to numbers

[Denis Navas Vega]

El 2013-11-14 05:07 p.m., mariosv escribió:

I have forgot in my previous post, another option:

First copying the text to convert [Ctrl+c].

 From the right-arrow in the icon. selecting unformatted text, we get the
same option as importing csv files.

http://nabble.documentfoundation.org/file/n4083240/Captura.png

Miguel Ángel.



--
View this message in context: 
http://nabble.documentfoundation.org/CALC-convert-text-to-numbers-tp4082413p4083240.html
Sent from the Users mailing list archive at Nabble.com.



That's a nice solution.


--
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/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: CALC convert text to numbers

[Denis Navas Vega]

The only way I have to know that the numbers are in reality text, are 
that they are originally left aligned.  Numbers are right aligned.


In other matter, I get the ' when I apply a number format to a cell 
previously formatted as text.  If I edit it (F2) I can reach the ' and 
edit it by hand.  This is really slow and not practical.




El 2013-11-17 02:54 p.m., Oogie McGuire escribió:

I'm with Charles on this one. I was the OP on the problem.

Nearly all of my issues are because I have my LO spreadsheet and then a CSV 
file. If I open the CSV file in LO it looks fine. I can't just import it into 
my existing spreadsheet because the data in it need to go into small subsets of 
my big spreadsheet. So I typically copy and paste groups of cells as required.

What I am used to doing in Excel is copy everything in, then format the cells 
to be numbers and they are converted to numbers and my formula work.

Or if I know they are text (but there is ABSOLUTELY NO WAY TO SEE THAT IN LO) I 
can do a paste special and that also works in excel and prevents the additional 
step of formatting the cells back to numbers.

All the discussions about the leading apostrophe are great but I still can't 
see it in LO nor can I remove it.

Yes, I got around the problem this time by creating a dummy column as described 
many messages ago, but the fact remains that it is neither easy to change nor 
easy to see when numbers are formatted as text in LO and coming from MsOffice 
this causes lots of problems.

On Nov 17, 2013, at 12:49 PM, Charles Smith c...@chucsmith.org wrote:


Hello,

I can only speak for myself, but numbers get formatted as text in two ways:

1. Import of a tab delimited or csv file.

2. Spreadsheets sent to me from other users who have imported such files.

Usually I format the import to avoid the problem, but if I just double click a 
csv file, it opens with the numbers formatted as text. Visually this is not a 
problem. But if I then decide I need to edit the sheet I either have to 
reimport it or reformat the numbers.

Hope this explains how it happens to me.

Charles

Sent from my iPod Touch

On Nov 17, 2013, at 12:16 PM, James E Lang jim+...@lang.hm wrote:


I've been following this debate with great interest.

One big question comes to mind: Why would someone use the apostrophe construct in the first place 
if he intended to perform arithmetic calculations using the cell content? I understand ending up 
with a text string rather than a number by forgetting to use VALUE() on a substring in a formula 
but even that seems to fall into the category of a cockpit error rather than an 
aircraft design flaw as is being implied on one side of this debate.



--
Jim


--
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/users/
All messages sent to this list will be publicly archived and cannot be deleted


--
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/users/
All messages sent to this list will be publicly archived and cannot be deleted




Eugenie (Oogie) McGuire
Desert Weyr http://www.desertweyr.com/
Paonia, CO USA






--
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/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: CALC convert text to numbers

[Denis Navas Vega]

El 2013-11-10 07:40 p.m., Paul escribió:

On Mon, 11 Nov 2013 02:56:51 +0200
Ady ady...@hotmail.com wrote:


As a simple user, I see this hidden addition of the initial single
quotation mark as a _BUG_, and as one of those basic features that
work poorly in LibreOffice Calc than in several other spreadsheet
tools. I don't know if this behavior can be corrected or improved.


As far as I understand it, the hidden initial quotation mark is what
marks the contents of the cell as text. This is the same in MS Excel,
IIRC. So basically, this isn't a bug, but intended behaviour, to give
you a way to specify that a number should be interpreted as text and
not as a number.

For example, if you enter 0283, the leading zero will always be
stripped, because it is interpreted as a number and the leading zero is
superfluous, but if you enter '0283, then this means you have entered
a text string and the leading zero is kept. The format of the cell
doesn't change this behavior, it only changes the *display* of the
contents, not the interpretation of the contents. At least, as I
understand it.

Paul



Paul,

The problem is with the symbol ' It can't be searched and replaced. 
That's why Ady consider it a bug.


The only solution, which I used yesterday, is multiply by one.

More than a bug, we must consider it an incomplete implementation of the 
meaning of ' to accept figures as text. The operator should be reachable 
from Calc interface and not hidden.







--
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/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: CALC convert text to numbers

[Denis Navas Vega]

El 2013-11-11 01:46 p.m., Paul escribió:

On Mon, 11 Nov 2013 11:30:11 -0600
Denis Navas Vega denis.na...@gmail.com wrote:


The problem is with the symbol ' It can't be searched and replaced.
That's why Ady consider it a bug.



The only solution, which I used yesterday, is multiply by one.



I still don't understand what that is supposed to do. It sounds like a
kludge to me. The text string is a text string, I'm not sure why
anybody would think multiplying a text string by 1 would give you a
number.




Paul



Paul,

Make this test.

1. Open a new worksheet.  Format some cells, say from A5:A10 as text. 
Write some numbers on those cells.


2. Copy those cells to other column, say to C5:C10 and format as number 
(format @). You will see that the cells now shows an ' before the numbers.


3. Write a formula in other cell, multiplying with 1, for instance, E5=C5*1

Now check the cell and you will discover that you have a number.

Therefore, those numbers with ', that in reallity are text, can be 
multiplied by 1, to transform it to a number.


As a side note, I was not able to use the method of copy -- paste 
multiplying by one.







--
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/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: CALC convert text to numbers

[Denis Navas Vega]

El 2013-11-11 04:00 p.m., David Gast escribió:

Spreadsheets use the MVC (model view controller) paradigm.  That means
that the model (how the data are actually stored) and how you view
the data are separated.  You can take a number like 4.5 and view it
as a date, a date and time, a real number, etc.  You can easily compare
dates because they are stored as numbers, not character strings like
Monday, Nov. 11. Further, you can easily send your spreadsheet to
someone who only knows some language you have never heard of and s/he
can open it and display and compare the dates in whatever language
s/he has set.

The best way to see if a cell contains a number, text, or a formula is
to use View - Value Highlighting (F8).  (Does Excel even have this
feature?  If so, it must hidden in the ribbon somewhere.)  A zero as
text has the ASCII value 48; as a number, the value is 0, so text and
numbers are not equal.  OpenOffice used to generate errors if one
improperly tried to add text and a number, for example.  Along the
way, that behavior was modified to emulate Excel.  (I prefered the
old way along with the fact that either OOo or gnumeric or both used to
evaluate -1^2 correctly--the mathematical answer is -1, not 1.)

I just checked using Excel 2010, if you change the format (the view) of the
cell, the underlying representation (the model) does not change.

1. Type '123 in a cell, say A1
2. Right click and choose Format Cells, then Format as a number.
   (That is, change General to Number.)

The entry is still text.  You can confirm because =sum(A1) yields 0.
Note: =A1+0 yields 123. (Also the text is still left justified.)

That is, there is no conversion.

Best regards,

David Gast


From: Oogie McGuire [oog...@desertweyr.com]
Sent: Monday, November 11, 2013 09:17
To: Joel Madero
Cc: Brian Barker; users@global.libreoffice.org
Subject: Re: [libreoffice-users] CALC convert text to numbers

For me dealing with an extension, installing it, making sure it doesn't 
conflict with something else was more effort than creating a column, using 
Value() and then pasting special.

What's a problem is that in Excel even though it also uses the leading ' to 
format text as numbers, if you change the format of a cell the conversions 
happen without any problems. I want that same behavior in Calc because to me it 
makes sense that the cell format should be the controlling factor for what type 
of data is in a given cell.


On Nov 10, 2013, at 7:43 PM, Joel Madero wrote:


Why is everyone straying away from the fact that there is a simple extension 
developed by Cor (one of our brilliant devs) which accomplishes all of this? 
Just curious if there's a benefit to doing these formula techniques instead of 
just pushing a button on a nice gui


Eugenie (Oogie) McGuire
Desert Weyr http://www.desertweyr.com/
Paonia, CO USA


--
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/users/
All messages sent to this list will be publicly archived and cannot be deleted







With Excel 2010 I made the following test, that contradicts your assertion.

A)  Write just:  123--  That's a number (just to compare).
B)  Write : '123--  That's text.  Sum(cell) is equal to cero.
C)  Multiply:   In another cell write a formula that
references '123 address and multiply by 1.
You get a number!

Check it.





--
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/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: paste special problem

[Denis Navas Vega]

El 2013-11-10 01:59 p.m., Tanstaafl escribió:

On 2013-11-10 1:26 PM, yahoo-pier_andreit pier_andr...@yahoo.it wrote:

On 11/10/2013 06:00 PM, Tanstaafl wrote:

I have been having serious problems with 'Paste Special' working, then
not working, then working again, on many different spreadsheets (most if
not all created a long time ago, some as old as Openoffice 1.x)...

It is extremely annoying, and sometimes even prevents me from getting
something done.

Been meaning to post a bug, but the problem is, I have not found a
reliable way to reproduce it...



now for me is extremely reproducible, it never works:-) :-) :-) :-)
now paste special and alsoo simple paste doesn't works, they paste
only values, not formula or other
I don't know how to come back to a working situation.
may be it could be some config file to delete, but I cannot find it,
in my /home I found a ./libreoffice folder, I renamed it but nothing
change:-) :-) :-)


The very first thing I tried was deleting the .config and letting LO
create a new one... no joy...



In Windows, I have had a different but probably connected problem.  I 
copy from an application to paste in LO Calc, but the menu is greyed. 
That is, like when I have not copy anithing yet, but in reality the copy 
was done.


What works me is close and reload LO.  Then, I can copy and paste again.




--
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/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: 64 bit

[Denis Navas Vega]

El 2013-11-05 05:51 p.m., Pedro escribió:

krackedpress wrote

The next thing people will insist on is LO being designed to run on all
2, 4, 6, or even 8 cores of the CPU at the same time to make it even
faster.


Do you really think it makes sense that Calc and Base are not prepared to
use all the computing power available?

Why do you think TDF and AMD are trying to bring GPU calculation to LO?
Because Calc (I haven't even tried Base...) is absurdly slow!

A heavy calculation spreadsheet I have takes 50 seconds to open in Excel
2010 and takes more than 10 *minutes* to open in Calc! (both 32bit versions)

No wonder Kohei Yoshida (one of, if not *the* main Calc developer) said
recently (August 2013):  You can’t compare Calc with Excel yet. They are
still miles ahead of us.

When Calc is able to use all cores and threads and eventually 64bit
operations then it might be on par...

Why do you assume the OP isn't doing number crunching?



--
View this message in context: 
http://nabble.documentfoundation.org/64-bit-tp4081444p4081605.html
Sent from the Users mailing list archive at Nabble.com.

I won't insist on 64 bits, because I use machines that work on 32 bits, 
but the affirmation that Excel is more faster than Calc is true.  I have 
been working the last six weeks with databases from a census, and can 
confirm the following:


-- Calc is really slow with lots of data.  When the book requires more 
than 384 MB of memory, it slows down to an impractical speed.  Days ago, 
I spent the whole day building a crosstab.


Open/Save is really slow and does not help a different file format to 
speed up things.


Another difficult thing, is with sorting and filtering.  Is slow too.




--
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/users/
All messages sent to this list will be publicly archived and cannot be deleted