[libreoffice-users] [LibreOffice Bugzilla Migration] Starting shortly! Bugtracker will down for a few hours

2015-01-24 Thread Robinson Tryon
Hi all,

It's that time!  We're just about to migrate Bugzilla from
Freedesktop.org to TDF infrastructure.

For up-to-date information about the migration, join the
#libreoffice-qa IRC channel on Freenode and say hi!

For general information, see
https://wiki.documentfoundation.org/QA/Bugzilla/TDF_Bugzilla_Proposal/Migration_Userguide#Guide


KEY DETAILS:

- Migration Date: January 24th, 2015 at 15:00 UTC

- Migration Duration: Approximately 4-6 hours

- New URL: https://bugs.documentfoundation.org/


Once the migration is complete, I'll send out another email letting
you know you may once again ply us with myriad bug reports :-)

Cheers,
--R

-- 
Robinson Tryon
QA Engineer - The Document Foundation
LibreOffice Community Outreach Herald
qu...@libreoffice.org

-- 
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: Printing from Linux, Kubuntu/Ubuntu

2015-01-24 Thread CVAlkan
Hi Pertti:

I also am one of the old crowd, so I understand.

The database question is probably going quite off-topic (although still part
of this forum), so I'll just make a few comments.

The first is that, since you are already running LibreOffice, can I presume
that you've looked at its Base component. If you notice, there are lots of
discussions about that on this forum, so you should have little problem
getting answers to most questions. The manuals for all the components of
LibreOffice are also available for free download, so that is a plus as well.

I personally don't use Base, as I'm an old database person and prefer to use
real database management products. Although most of these cost actual
money, a few of them have free personal-use products. If you go to
http://www.antikytherapubs.com/ and click on the Oracle Installation
Tutorial for 64 bit Ubuntu you'll find a pdf I put together on how to
acquire, load, and use Oracle XE (the personal version) on Ubuntu (it's
actually intended for Red Hat Linux, but isn't at all difficult to get
running on Ubuntu). If you're looking to dig in to relational theory and
all that good stuff, Oracle is a much better choice than some of the
personal products out there.

Good Luck keeping the brain cells functioning, and let us know how the
Printer situation turns out ...

Frank



--
View this message in context: 
http://nabble.documentfoundation.org/Printing-from-Linux-Kubuntu-Ubuntu-tp4136908p4137319.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] Help with writer files

2015-01-24 Thread Andrew Miller
Everything was working great until two days ago, I can no longer read any
of my saved files in doc format.
It opens into garbled text like this:

 Íòmë
#3jÄe_M?7kÒcŨWQyS#Cl¹jíŸ#ó�DÚ`WŽ{Œ#ñ·ÍÁ%×v#JÙ»HdÈ#\”†‡#|#îƒK«#�Mˆkûò¿¦Òi-##’´#ðáo¹#iû8ðª˜s!ô(Vò$¨eJD€PC9¥µWIv‰3…GÚÈ#ß

ys—…+1�×#Ý###Ùqâæ#u#Jô:4ŽWKÈ×_B›Û-0mç
ˆï,I^úyõ,ˆZ6´a�Q28š#–#ô#—¾X#©¸î;Ÿ ö
'9\¸+:�±â8³#š#Îò;èçV,‰Â°T#ÁDÿxÆÁÉ–�áÙ6”ƒ


Documents that were created in the past week open up with no issues,
just my previously saved documents converted from word are the issue.

Any help is appreciated

-- 
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] Re: Installing 2 versions of LO on Mac OS X 10.10.1 Yosemite

2015-01-24 Thread Spencer Graves

 On Jan 24, 2015, at 9:34 PM, V Stuart Foote vstuart.fo...@utsa.edu wrote:
 
 Spencer, *
 
 Just so you understand, installed that way--i.e. with each version of
 LibreOffice using the default UserInstallation= variable of
 $SYSUSERCONFIG--all the installations will be sharing a single user profile.
 It will be located in  /Users/username/Library/Application
 Support/LibreOffice/4  configurations and features will bleed over between
 the installs.
 
 If you want to isolate each of the installations (which is the norm for
 working with multiple installs) rather than using the $SYSUSERCONFIG 
 variable, instead using  the $ORIGIN variable places the user profile
 relative to its supported application package. The install and user profile
 are combined, and isolated from the other installs.  Important if you are
 testing features and different configurations or extensions.
 
 Stuart


  Thanks for the clarification.  I guessed there might be a problem 
like that.  


  Unfortunately, I still do not understand how to produce the isolation 
you recommend.  


  Spencer 

 
 --
 View this message in context: 
 http://nabble.documentfoundation.org/Installing-2-versions-of-LO-on-Mac-OS-X-10-10-1-Yosemite-tp4136563p4137352.html
 Sent from the Users mailing list archive at Nabble.com.
 
 -- 
 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



Re: [libreoffice-users] Installing 2 versions of LO on Mac OS X 10.10.1 Yosemite

2015-01-24 Thread Spencer Graves
Hi, Tom et al.:  


  The previously cited published instructions confused me.  However, I 
was able to install 4 different versions of LibreOffice in parallel under OS X 
10.10.1 by renaming the most recent version in Finder: Applications to “LO” 
with its version number before installing the next version.  Now I have under 
Applications LO4341, LO4352, LO4361 and LibreOffice (LO 4.4.0.2).  If I close 
one and open another, I get the expected version number with “About 
LibreOffice”.  


  Beyond this, users can customize what to share between versions via 
LO:  Preferences:  (LibreOffice: Paths).  


  Best Wishes, 
  Spencer 


p.s.  Regarding “amazing things”, I started writing Fortran in 1963.  Computers 
have been part of my life for over half a century.  My basic engineering 
training discussed both tubes and transistors.  Around 1964 or 1965 I was 
impressed with the availability of 2 transistors in a single package.  I’m over 
the hill but not yet under it ;-)   


 On Jan 22, 2015, at 8:55 AM, Tom Davies tomc...@gmail.com wrote:
 
 Hi :)
 I think you finding something easy is no real indication of whether it
 is really easy or actually quite complicated.  You have done many
 amazing things and seem to have a lot of experience doing exactly this
 in another OS so you have a good foundation that probably most of us
 don't have.
 
 Actually your email seem to simplify the instructions rather well! :)
 I sometimes find that even just explaining something any different way
 around is a good way to get people unstuck.  So, many thanks for that
 :)
 
 @ Spencer.  Did that help make more sense of the instructions?  If not
 please let us know and don't worry about questions seeming stupid to
 you.  Clearly only a few people here understand how to do it so we are
 learning here too.
 
 Regards from
 Tom :)
 
 
 On 22 January 2015 at 04:05, V Stuart Foote vstuart.fo...@utsa.edu wrote:
 Just inherited a 2007 iMac and loaded Yosemite‎ (OS X 10.10.1)
 
 First thing I loaded LO 4.4.0.2, and then 4.3.6.2 and the current
 (2015-01-21)  4.5.0 master.
 
 Steps couldn't be simpler. In fact parallel install is done almost the same
 as with the Windows .msi packages
 
 Put which ever of the installs into /Applications just like any package
 install. Drag and drop there once the .dmg is downloaded and mounted.
 Launch by double clicking the folder in /Applications.
 
 For the additional installs, they could go into /Applications as well  just
 with different names.
 
 But they can go anywhere. For example onto user's Desktop, Documents,
 Downloads etc... just mount the downloaded .dmg package and drag the
 LibreOffice or LibreOfficeDev .app directory object to where you want it to
 reside. It does not need to go into /Applications.
 
 Then use Spotlight to find the bootstraprc file and edit it in TextEdit.
 Just as with Windows or Linux builds, edit the
 UserInstallation=$SYSUSERCONFIG/LibreOffice/4 to be
 UserInstallation=$ORIGIN/../Data/settings
 
 The $ORIGIN variable is parsed internally by LibreOffice and then creates
 the entire user profile within the app package, in the example
 Data/settings but the directory names for the user profile can actually be
 anything you like.  They are fully structured profiles and are portable.
 
 When ready to launch the build, open the .app folder with Finder and locate
 the soffice executable and Control Open it.   You can create an app launcher
 for it if you don't want to dig down into the folder every time.
 
 Easy as pie...  I had all three flavors running simultaneously and could do
 side-by-side comparisons of the UI.
 
 
 
 
 --
 View this message in context: 
 http://nabble.documentfoundation.org/Installing-2-versions-of-LO-on-Mac-OS-X-10-10-1-Yosemite-tp4136563p4136999.html
 Sent from the Users mailing list archive at Nabble.com.
 
 --
 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


-- 
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] Shouldn't it be more secure to by default disable macro support in LibreOffice?

2015-01-24 Thread Andrew Douglas Pitonyak
Although yes, not allowing macros of any sort to run would be more 
secure, the default installation is to only allow macros from trusted 
sources and unsigned macros are disabled. So, macros signed by a trusted 
source are allowed and nothing else. This includes macros included with 
LO that may be part of things such as certain Wizards; at least there 
used to be wizards for things like document migration included.


I think that disabling all macros would be confusing if you attempted to 
use a Wizard and it failed to run. I could be mistaken, I did not bother 
to test (lazy I guess).


I don't consider LO usable until I have lowered the setting one level, 
which requires that I say yes / no for every document that I load that 
runs macros. I never set it to just run any macro.


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


--
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: Installing 2 versions of LO on Mac OS X 10.10.1 Yosemite

2015-01-24 Thread V Stuart Foote
Spencer, *

Just so you understand, installed that way--i.e. with each version of
LibreOffice using the default UserInstallation= variable of
$SYSUSERCONFIG--all the installations will be sharing a single user profile.
It will be located in  /Users/username/Library/Application
Support/LibreOffice/4  configurations and features will bleed over between
the installs.

If you want to isolate each of the installations (which is the norm for
working with multiple installs) rather than using the $SYSUSERCONFIG 
variable, instead using  the $ORIGIN variable places the user profile
relative to its supported application package. The install and user profile
are combined, and isolated from the other installs.  Important if you are
testing features and different configurations or extensions.

Stuart





--
View this message in context: 
http://nabble.documentfoundation.org/Installing-2-versions-of-LO-on-Mac-OS-X-10-10-1-Yosemite-tp4136563p4137352.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] Shouldn't it be more secure to by default disable macro support in LibreOffice?

2015-01-24 Thread jonathon
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 24/01/15 14:04, Thisis theone wrote:

 We think macros and other rarely used, but high risk features should be 
 DISABLED BY DEFAULT in LibreOffice.

Since I don't do windows ^1, I can't confirm the statement in the
original article that MSO ships with Macros disabled by default.

If that is the case, then changing the defaults in LibO/AOo/EO/NO/etc
won't make a difference, because the user will enable the macro to run,
if only for the specific document.

Tom Davis wrote:

So we tend to find the LO and AOO simply don't have as many
vulnerabilities and problems.

Because LibO, AOo,  EO run on various platforms, I suspect that, as a
malware vector, they are less vulnerable than MSO on Windows.

By way of example, I can't use JabBib on my laptop, because the version
in the official distro repository is incompatible with the specific
setup of my laptop. There are two or three other programs I'd like to
install, but have similar issues. If I had the drive space, I could
install the tool chain required to compile the programs from source code.

The apparent increase is insecurity that support for the number of macro
languages that LibO  AOo brings, is nullified by the macro writer not
knowing what components of that language are available on the target
machine.

 It's difficult for anyone to find any flaws that can be exploited by
writing some nasty macro.

At least one proof of concept nasty macro was publicly released for
OOo. I've seen a couple of posts, and articles, that imply that there
are some OOo/LibO/AOo ^2 specific macros in the wild, but nothing that
can be confirmed.

###

^1: The last time I used MSO on Windows, it took 90 seconds from
starting MSO to seeing the Blue Screen of Death. That was with the then
current version of MSO on Windows 7.

^2 I don't recall any mention of EuroOffice, NeoOffice, or Android
OpenOffice in those articles:
* NeoOffice, running exclusively on Mac OS X, can easily accommodate
malware that relies on the standard Mac OS X configuration;
* Android OpenOffice can easily accommodate malware that targets the
Android Operating System;


jonathon
-BEGIN PGP SIGNATURE-
Version: GnuPG v1

iQIcBAEBAgAGBQJUxDFCAAoJEKG7hs8nSMR7+T4QAJB9yBIOl+SWUXey7dwRuIoZ
CBdMJXqyB6Uyo1drRTp4sPFBTqOmu+KQYUAQUqLBGBGChCNjTe6tgGzRfd4MBGJQ
IVyUrdDDbF46M06Clmn0CQB7CMI0wlDXhFdVnXA2ke7DLSFw51qTD7Bpt9PNm6rT
mzIgiRGB58SHrdi4unYWFdrj72VlRpxtNJxo0bRFo7yNG5JkPIsHoNllR9H8+fgb
HsAQPXQPKcR7YPQv/gp/iZqe8/aIlMPi+dR7SWl2itRC0h8PHmGMhDKgzlMUs5ph
BPGcy3soKCqOxlP4w4q8LfsxHqBXkdN2T/mjSOYxNEx97s7KxtHRR5HrYj/Lyh+s
YhhGVB61xCkFYYJnrs5aPu81FIiF5P5t1bkeU7krjbzVhHe4SjH095/WBGgpgpHJ
yP8XTI2nACoXRduabWoxOIxTXDAZ9CeqSACs6Fz7aTY2qkgjQU9a473Zf/tQRM1f
/p6nxIp4f5KfEJUY/lPva7sStmnng2BdfFVZXFFrTyfIYNp6V3XibT/WG+CXdjz4
BNxVtvQgP3dqJaBeQKk8JVt9bKfnwhzWIi4h3u2Elezdcnx9itvrKNLFQJgJdh6J
geukPsIEcSGfYXa8/F9R7kl64fOLuHll8h+NiNG480orFR/IdlKGfFsJDEpQnxnT
vi5Hl0n7beJ2CXB3Dne1
=hclh
-END PGP SIGNATURE-

-- 
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] I cannot unsubscribe...please help!!!

2015-01-24 Thread James Roberts
I have tried over, and ove,r again to remove myself from this mailing list.  I 
send the requisit email to unsubscribe, then I get the usual response to 
confirm it, which I do---and then I keep getting this response back:

Hi, this is the Mlmmj program managing the users@global.libreoffice.org 
mailing list.
The message from j...@jsroberts.com with subject unsubscribe was unable to 
be delivered to the list
(The denied message is below.)

Would someone please help me get off this email list.

James Roberts

-- 
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] installing and removing extensions?

2015-01-24 Thread Spencer B Graves
  How can I install and remove extensions for LibreOffice?  


REMOVE:  https://help.libreoffice.org/Common/Extension_Manager 
https://help.libreoffice.org/Common/Extension_Manager” claims I can Remove or 
Disable an installed extension by clicking the Remove or Disable button under 
Tools:  Extension Manager.  I can find Tools:  Extension Manager.  However, I 
cannot find the advertised Remove and Disable buttons.  


INSTALL:  https://apps.ubuntu.com/cat/applications/libreoffice-nlpsolver/ 
https://apps.ubuntu.com/cat/applications/libreoffice-nlpsolver/“ describes a 
'Solver for Nonlinear Programming extension for LibreOffice’.  However, when 
I try to install it under Ubuntu 14.04 LTS, I can’t find a way do download it.  


  Thanks, 
  Spencer Graves
-- 
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: installing and removing extensions?

2015-01-24 Thread V Stuart Foote
Spencer, *,

Some of the extensions are bundled with LibreOffice core. Spelling and
Gramer, Wiki publisher, NLP Solver

They are optional installations during installation.

The Extension manager dialog (Tools -- Extension Manager) will show a
listing of installed extensions, filtered by the check boxes (bundled with
LibreOffice, Installed for all users, Installed for current user). 
Selecting and highlighitng an extension will expose an Options button for
the extension.  Clicking that button will open a Dialog for configuring the
extensions--including the Remove or Disable buttons if applicable--but those
buttons won't be present for the bundled extensions.

Solver for NonLinear Programing is now a bundled Java JAR build--nlpsolver-- 
(requiring a functional JRE to run) and is available during installation
depending on the build.  But I am not sure how the Ubuntu PPA is bundled--so
it may be there as an option during custom install -- Optional Components
-- Extensions.  Or you may need it as an external extension, 
installed/configured from the Extension manager Add button.  

Any Ubuntu users up on the PPA packaging for the nlpsolver extension that
can help Spencer?

Stuart



--
View this message in context: 
http://nabble.documentfoundation.org/installing-and-removing-extensions-tp4137355p4137357.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] [LibreOffice Bugzilla Migration] We're done! Please visit the new site to reset your password!

2015-01-24 Thread Robinson Tryon
Hi everyone!

The migration was a great success. All of our bugs are now happily living at

  https://bugs.documentfoundation.org/

Bugs should be referenced using the shorthand tdf#, such as tdf#12345.
On the wiki, you can write {{tdf|12345}} to link to a bug report.

Before you can log-in and start working on bugs, you'll need to reset
your password. Read more here:
https://wiki.documentfoundation.org/QA/Bugzilla/TDF_Bugzilla_Proposal/Migration_Userguide#After_the_Migration

If you have any questions or encounter any problems, please stop by
the QA IRC channel or drop us a note on the mailing list:
https://wiki.documentfoundation.org/QA/IRC
https://wiki.documentfoundation.org/QA/Mailing_List

A huge thanks to everyone who helped make this migration go quickly
and smoothly! Let's go tackle some open bugs!

Cheers,
--R

P.S. You'll start to see some updates and changes in Bugzilla over the
coming weeks. The QA Team is excited to work on improving, updating,
and polishing our bugtracker. We're always happen to have more people
join us!

-- 
Robinson Tryon
QA Engineer - The Document Foundation
LibreOffice Community Outreach Herald
qu...@libreoffice.org

-- 
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] Need Help with calc

2015-01-24 Thread Brian Barker

At 01:12 24/01/2015 +0300, Nobody Noname wrote:
Need Help with calc. I often use links to other cells. That is, for 
example, copying what a cell, and then for example in another 
worksheet using the menu insert as and insert a link. But if I 
cell is empty, then insert as a link on an empty cell is not 
working. You can of course use a formula such as: = A1, but it is 
not convenient.


At 02:12 24/01/2015 +0300, Nobody Noname wrote:
Excuse Me! In the first letter, I'm not exactly written. If you are 
copying what a single cell, and then for example in another 
worksheet using the menu insert as insert and communication - in 
this case the link is inserted properly. But if you select multiple 
cells and mouse do insert as elsewhere sheet or in another sheet, 
references to empty cells for some reason do not have communication with them.


I don't see a menu item insert as, but I recognise that you are 
probably translating from the Russian, where menu items may have a 
slightly different meaning. But I now see what you mean, I think. If 
you copy a cell or range of cells and then use Edit | Paste 
Special... (or right-click | Paste Special..., or Ctrl+Shift+V) and 
select the Link option in the Paste Special dialogue to paste 
elsewhere in the sheet or in another sheet of the same spreadsheet, 
links are apparently not created for any empty cells in the source 
range. The same problem occurs if you use the alternative technique 
of dragging a cell range and holding down Ctrl+Shift as you release 
the mouse. If you paste similarly into a different spreadsheet 
document, the expected links *are* created, it seems.


Yes: I too find that surprising.

Possible workarounds:

o For a range of cells, copy one suitable (occupied) cell and paste 
it as a link.
o With the target cell still selected, edit the formula in the Input 
Line to remove $ signs as necessary (depending on the relevant range).

o Fill from the target cell as necessary.
Note that in this case, you may see the target cells linked to any 
empty cells as having zero value, not empty.


o Put temporary values in any empty cells before copying and pasting 
- and remove them afterwards. (This is simpler than it sounds.)


o Put explicit blanks into any empty cells (and possible amend any 
formulae that depend on these cells to allow for these).


(This idea is probably best.)
o Give the source range a name (Insert | Names  | Define...) - say Name.
o In the upper left cell of the target, enter =Name (no quotes) - 
but press Ctrl+Shift+Enter to complete the formula instead of 
ordinary Enter. The formula will appear in the Input Line as {=Name}, 
but note that you cannot achieve the desired effect by typing these 
braces yourself. This creates an array formula which populates other 
cells in the target range - including those for any empty cells in 
the source range.


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



Re: [libreoffice-users] Re: Printing from Linux, Kubuntu/Ubuntu

2015-01-24 Thread Pertti Rönnberg

Good afternoon,
My PC's OS is windows 7prof.-64bit (where LO 4.3.4.1)
My intention is to (again try to) convert to Linux and shall now install 
Ubuntu (vers. 14.04.1 ready on a DVD)
in a virtualbox and use that for creating database applications with 
SQLite(3) ( Apache  PHP) and expect

having LO/Base as a front end.

Am I to understand from this thread that I am getting printing problems 
with

Linux in such an installation?

If so, what version of Ubuntu is then safe and reliable?
My printer is a KonicaMinolta magicolor 1600w.
Grateful for any advice
Pertti Rönnberg


On 23.1.2015 11:33, Tom Davies wrote:

Hi :)
I almost always have at least 4 partitions;  1 for swap, 1 for /home
or just to put my data on and 2 to have different distros or different
versions of the same distro on.  On some machines i multi-boot between
half a dozen different versions of Ubuntu (but always intend to clean
it up down to just 2 or 3).
Regards from
Tom :)


On 22 January 2015 at 17:40, Tim---Kracked_P_P---webmaster
webmas...@krackedpress.com wrote:

Yes, I agree with you, BUT. . .
When I upgrade to a newer version of Ubuntu via the Update Manager system, I
get a message about CUPS being depreciated and no longer used.  So it is
Removed from the upgraded system.  That is when I have to reinstall it,
along with my CUPS-PDF package.  Of course that package gives the
depreciated message as well, but I know of no other PDF file printer for
Ubuntu either.






On 01/22/2015 09:20 AM, CVAlkan wrote:

Tom:

CUPS still seems to be alive and well; in fact, I'm not sure how we could
get along without it.

It is listed in the Ubuntu repository, although has always been installed
by
default on any installation I've done (admittedly, not a whole lot
though).
If you use the Software Center, make sure to check any other additions you
might require (I have everything but OpenPrinting installed).

If you need to install it separately, you can download it from
http://www.cups.org/software.php.

I hope this helps ...

Frank



--
View this message in context:
http://nabble.documentfoundation.org/Printing-from-Linux-Kubuntu-Ubuntu-tp4136908p4137067.html
Sent from the Users mailing list archive at Nabble.com.



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


[libreoffice-users] Need Help with calc !!!

2015-01-24 Thread pkp_svs
Excuse Me! In the first letter, I'm not exactly written. If you are
copying what a single cell, and then for example in another worksheet
using the menu insert as insert and communication - in this case the
link is inserted properly. But if you select multiple cells and mouse do
insert as elsewhere sheet or in another sheet, references to empty cells
for some reason do not have communication with them.






Извините! В первом письме я не точно написал. Если копирую какую нибудь
одну ячейку, а затем например в другом листе использую меню вставить как
и вставляю связь - в этом случае ссылка нормально вставляется. Но если
выделить мышкой несколько ячеек и сделать вставить как в другом месте
листа или в другом листе, то ссылки на пустые ячейки почему,то не имеют с
ними связи.
-- 
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: Printing from Linux, Kubuntu/Ubuntu

2015-01-24 Thread CVAlkan
Pertti:

If you are running Ubuntu (or anything else as far as I know) in a Virtual
Box, you don't have access to any hardware unless it is recognized by the
host system. But if your printer functions properly on the host system (and
you set up virtualbox carefully), it should work fine on Ubuntu.

The issues I encounter all seem to be related to LOWriter, so if you have no
issues with that on your host, it seems to me fairly likely that you should
be ok. In any case, if it doesn't work you haven't lost anything.

Just as a matter of curiosity, are you looking to a linux distro just to use
SQLite and Apache? Or was there some other consideration driving that
choice?

Frank



--
View this message in context: 
http://nabble.documentfoundation.org/Printing-from-Linux-Kubuntu-Ubuntu-tp4136908p4137269.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] Re: Printing from Linux, Kubuntu/Ubuntu

2015-01-24 Thread Pertti Rönnberg


Frank,
Thank you very much for your soon reply  -- I was just working on the 
installations.
The printer seems to be working on the Windows so let us hope it will 
work OK with the VirtualBoxUbuntu too.


Earlier 10-15years ago I used WindowsUbuntu parallell but then I had to 
rebuild my PC completely and for some reason
never installed the Ubuntu again - perhaps too complicated -- but I 
never gave up the idea skipping windows.
Now I re-installed systemprograms again and decided to start working 
with Ubuntu again.
Next step is to learn using ApacheSQLite for my need of databases. I 
used to work with MSAccess but am not interested in
spending money on purchasing and was told that SQLite is easier and not 
so heavy as MySQL. Do not know yet.
Anyway I find this interesting and think it is a healthy exercise for an 
old brain too (75y)


So any guides and ideas how I shall proceed to get SQLite(3) to run in 
Ubuntu are welcome.

Kind regards
Pertti Rönnberg


On 24.1.2015 14:22, CVAlkan wrote:

Pertti:

If you are running Ubuntu (or anything else as far as I know) in a Virtual
Box, you don't have access to any hardware unless it is recognized by the
host system. But if your printer functions properly on the host system (and
you set up virtualbox carefully), it should work fine on Ubuntu.

The issues I encounter all seem to be related to LOWriter, so if you have no
issues with that on your host, it seems to me fairly likely that you should
be ok. In any case, if it doesn't work you haven't lost anything.

Just as a matter of curiosity, are you looking to a linux distro just to use
SQLite and Apache? Or was there some other consideration driving that
choice?

Frank



--
View this message in context: 
http://nabble.documentfoundation.org/Printing-from-Linux-Kubuntu-Ubuntu-tp4136908p4137269.html
Sent from the Users mailing list archive at Nabble.com.




--
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] Shouldn't it be more secure to by default disable macro support in LibreOffice?

2015-01-24 Thread Thisis theone
Hello list,

https://threatpost.com/microsoft-reports-massive-increase-in-macros-enabled-threats/110204

http://blogs.technet.com/b/mmpc/archive/2015/01/02/before-you-enable-those-macros.aspx

We think macros and other rarely used, but high risk features should be
DISABLED BY DEFAULT in LibreOffice.

What do you think? Is it worth it?

Thanks..

Have a wiser and safer day!

-- 
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] Shouldn't it be more secure to by default disable macro support in LibreOffice?

2015-01-24 Thread Tom Davies
Hi :)
I think the LibreOffice macros system is more secure by design.

I think it's fair to assume that if LO/AOO have a certain percentage
of market-share then we could expect roughly that percentage of
exploits.  That doesn't seem to be happening though.

Ok, so you could say that it might be better for malware writers to
only aim at the most used office suite and ignore the rest even if
they have a sizeable percentage of market-share.  However, once a
macro is written surely it's not immensely difficult to edit it to
work in a different program?

That doesn't often work either though because the malware written for
MS Office relies on specialist knowledge of the flaws in MS Office.
LO/AOO simply don't have the same flaws and vulnerabilities.

The top priority of LO/AOO is (are?) radically different from the top
priority of MS Office.  Microsoft's primary goal, as a profit-making
company, is to generate profits.  They have shareholders who are
concerned about the profitability of the company and on the yield
returned on the value of their shares.  LO and AOO have none of that.

Also the way of working is entirely different.  With MS each dev is
shielded from knowing too much about the bigger picture and from
knowing too much code around the specific area they are working on.
Industrial espionage is a major concern.  Also once code is written
very few people are going to see it.  The emphasis is on the code
doing the job and on being written fast enough.  Devs toil in
obscurity and they can't show a portfolio of their work or hold up
examples to a future employer to show off how good they are.

With LO and AOO any elegant code is much admired and wins respect and
starts to attract a fan-base.  The other way around is that kludgy
code is an embarrassment to the dev and is likely to be seen by lots
of peers.  In LO and AOO the devs are like Gods of Rock or celebrities
and can show off their work.

Also MS has teams of people whose sole job is to take a list of
problems that other people have found and then decide which are worth
fixing and which they think MS can get away with not fixing.  By
contrast in LO and AOO tons of people gripe about the tiniest thing
and wont let it go until it's been fixed.

So we tend to find the LO and AOO simply don't have as many
vulnerabilities and problems.  It's difficult for anyone to find any
flaws that can be exploited by writing some nasty macro.

Regards from
Tom :)






On 24 January 2015 at 14:04, Thisis theone thisistheone8...@gmail.com wrote:
 Hello list,

 https://threatpost.com/microsoft-reports-massive-increase-in-macros-enabled-threats/110204

 http://blogs.technet.com/b/mmpc/archive/2015/01/02/before-you-enable-those-macros.aspx

 We think macros and other rarely used, but high risk features should be
 DISABLED BY DEFAULT in LibreOffice.

 What do you think? Is it worth it?

 Thanks..

 Have a wiser and safer day!

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