[libreoffice-users] Labelfile: inserting a label in between

2016-02-04 Thread Niels
Another problem is creating a new page in a label file. Apologise if 
this question belongs to the stupid ones.
After the last label of a page has been filled in, how can I proceed to 
a new page? I tried many commands and looked in the toolbars for 
something useful, but did not find anything.

I have to include a lot of address labels.

Thanks for your help,
Niels

--
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] Pasting Tabular Data Into Calc From An HTML Source

2016-02-04 Thread James E. Lang
LO 4.4.7.2

I receive reports a regular basis from a pizza delivery driver who sends them 
from his iPad. A 
raw data dump of the HTML part of a sample report with customer identifying 
information 
replaced by "Address 1" and "Address 2" will be pasted below my signature.

Receiving this report via Pegasus Mail I have two potentially useful ways to 
paste the content 
of these reports into LO Calc (HTML and RTF). Each of these has a issue though 
I can work 
with the RTF method far more easily than the HTML method.

My problem with the HTML method (which, by the way, also exists with tables of 
data copied 
directly from my power company's web site) is that the header row () 
contains a colspan 
attribute that is misapplied by LO. In this  row the first (and only) field 
is not merged 
across any columns to its right but it should be merged across 14 additional 
columns. In the 
first row below that the first field is not (nor should it be) merged at all 
but in the next four 
rows the first field is erroneously merged progressively over 15, 29, 43, and 
57 columns. The 
first (and again only) field in the second table's  row is merged across 71 
columns 
instead of 11. The first field of next row is merged across the same 71 columns 
though it 
should not be merged at all and on the remaining two rows the first field is 
erroneously 
merged across 81 and then 91 columns.

Has anyone else experienced this anomaly? 

I don't know how LO determines what is a numeric field amd what is a textial 
field when 
pasting from the clipboard by my problem with the RTF method is LO gets it 
backward. Cells 
that received numeric fields get formatted as Category Text with Format @ and 
those that 
receive textual fields get formatted as Category Number with Format General. 
This means 
that if I subsequently enter a formula [e.g. =SUM(A5:A15)] where a numeric 
field (e.g. 5 or 
$7.52) had been that formula gets interpreted as text instead of being 
interpreted as a 
formula. The values in A5:A15 (which were also pasted from an HTML source) are 
zero since 
they are formatted as text so the formula can not work anyway. This is not 
theory. I stumbled 
upon this when i tried to shift some columns without retaining their former 
location info (Copy, 
Del, Pas
Can anyone else verify this?

Are there any bugzilla reports regarding any of these issues? Into how many 
bugzilla reports 
should I break this down? [HTML -- 1? or 2?. RTF -- 1? or 2? Inability to enter 
a formula that 
is recognized as such into a Category Text Format @ cell -- ?] I see the 
possibility of possibly 
as many as five separate bugzilla reports but I don't look forward to 
submitting them.

--
Jim

=== Start of the source HTML data =
Pizza Deliver=
iesCHKTicketWhereWhenLastPriceCashCard=E2=88=86 paypayreconcilia=
tiontipincome=
OrdersNote812718Address 1=
 2/3/16, 8:54 PM1$54.4=
7$59.47$5.74-$10.74$5.00$10.741<=
td nowrap=3D""><=
/td>812719Address 

Re: [libreoffice-users] Problem with Document- Bad Behavior

2016-02-04 Thread Tim Lloyd
Hi, attachments are cropped off messages to this list. If you post via 
the nabble forums I believe your document will pass through


http://www.libreoffice.org/get-help/nabble/

Cheers

On 05/02/16 10:54, rgarc...@openmailbox.org wrote:

Greetings.

This document gets a blinking white box on pages 60-63,
but i don't know if this a bug or a error in the file structure.

Document exported from Google Drive (It was uploaded as PDF) as .docx .

Tested on:
- LibreOffice 5.0.3.2 (Fresh) on Linux Ubuntu
- LibreOffice 4.4.7.2 (Still) on Windows 7 64-bit

Thanks for your Help.



--
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] Calc issue: display wrong values until double clic

2016-02-04 Thread Xbot
Hi,

I've a display bug with a xlsx file opened with LO: 
how it is displayed in Libreoffice (5.0.5.1, 5.0.4.2 and 4.4.1.2): 
https://i.imgur.com/5cGNup2.png
how it should be displayed, with the right number (see "Prix HT" colomn: 
https://i.imgur.com/rmgPPv1.png
how to reproduce that bug: double clic on numbers from that colomn to display 
the right values (prices).
the xlsx file: 
http://demo.ovh.eu/download/51953287813338dbf5a3f6b892b70c5e/2.xlsx

Why is it buggy? How to fix it? How to avoid having false numbers displayed?


Thanks for your kind help,
Best regards









-- 
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] regcompare will be replaced by unoidl-check in LO 5.2 SDK

2016-02-04 Thread Stephan Bergmann
Just a heads-up; see 
.


--
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] Problem with Document- Bad Behavior

2016-02-04 Thread rgarcia7

Greetings.

This document gets a blinking white box on pages 60-63,
but i don't know if this a bug or a error in the file structure.

Document exported from Google Drive (It was uploaded as PDF) as .docx .

Tested on:
- LibreOffice 5.0.3.2 (Fresh) on Linux Ubuntu
- LibreOffice 4.4.7.2 (Still) on Windows 7 64-bit

Thanks for your Help.
--
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



Re: [libreoffice-users] Uninstalling incompatible extension

2016-02-04 Thread Piet van Oostrum
jwkokc wrote:

 > After installation of version 5.03, I found that the 'AltSearch" extension
 > that I had installed for version 4.x is apparently incompatible with the
 > newer version, but I have not yet located any instructions for removing such
 > an extension. Now, each time I save a document while exiting from Writer, I
 > get an error message that files are damaged and will be reconstructed next
 > time I open them.
 > 
 > No damage is evident, and no files are listed in the message. I renamed my
 > user profile as per the on-line instructions, and the message went away, so
 > I presume it's connected somehow to the presence of the incompatible
 > extension. However I have customized my system to such an extent that I need
 > to return to the original user profile to be able to work comfortably.
 > 
 > Is there a process for removing such material, or must I bite the bullet,
 > blow away my entire installation (which is on Xubuntu 14.04.3) and install
 > version 5 anew from the PPA?

Tools > Extension Manager... should give you the option of removing the 
extension. I also noted that the extension gave problems (Basic runtime 
errors), but when I don't use it, it doesn't do any harm for me.
-- 
Piet van Oostrum 
WWW: http://pietvanoostrum.com/
PGP key: [8DAE142BE17999C4]


-- 
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] Labelfile: inserting a label in between

2016-02-04 Thread Niels

I have a labelfile and can insert add new labels easily.
But I want to insert a label between two existing labels and do see any 
way how to do that. I tried ctrl-enter, shift-enter, and many more 
combinations. I did not find any relevant command in the toolbars.

Could anyone give me a hint how I should proceed?

Thanks for your help,
Niels

--
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


Re: [libreoffice-users] Uninstalling incompatible extension

2016-02-04 Thread Jim Kyle

On 02/04/2016 03:18 AM, Piet van Oostrum wrote:

jwkokc wrote:


Is there a process for removing such material, or must I bite the
bullet, blow away my entire installation (which is on Xubuntu
14.04.3) and install version 5 anew from the PPA?


Tools > Extension Manager... should give you the option of removing
the extension. I also noted that the extension gave problems (Basic
runtime errors), but when I don't use it, it doesn't do any harm for
me.

Apparently I did manage to remove it somehow along the way; the 
Extension Manager no longer shows it at all, and it's not showing in the 
Edit menu either. What I had thought was its toolbar icon was in fact a 
different tool entirely!


I did note that several of the Language Tools that I've installed in 
addition to those built in do NOT have "remove" buttons in the manager 
dialog, however, and that the sole update that's shown when I "check for 
updates" runs continually at 100% CPU usage but fails to complete within 
5 full minutes, so something is definitely amiss with this installation. 
Perhaps I *do* need to bite the bullet and start over, installing from 
the PPA then customizing


Thanks, everyone, for the responses!

--
Jim Kyle

--
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] calc slowing to a crawl

2016-02-04 Thread John R. Sowden
I have a spreadsheet that is about 500 rows long and about 20 columns 
wide. Column 1 is a date column.
I do not process the date in any cell formulas.  When I hit December, 
about half way through the 500 rows, it tales about 15 seconds to enter 
a number in a blank field.  This is new, as I have been using something 
similar for about  10 years.  Even scrolling without entering data 
causes the sheet to come to a crawl.


Any thoughts?  I noticed today at the bottom of the page, I added some 
lines and it showed the lines being 1024 columns long.  Can this be 
shortened?  Couldn't find anything in options.


Oh yes, xubuntu 15.04, 4 GB RAM, LO version 5.0.4.2

John


--
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