Re: [libreoffice-users] how to put only two options in a dropdown

At 11:53 28/02/2016 -0600, Beau Thompson wrote: I have a project that needs a dropdown box on the data sheet E1 I like the data from B1 and B16 with this i get all $data.$B$1:$B$16 Easy: you need to define an intermediate cell range for your drop-down list. Enter =B1 and =B16 in two

Re: [libreoffice-users] Encrypted Calc file got corrupted

Mark, Many thanks indeed for your advice, these are all very valid points. I think I have been entering the password correctly, but I will double-check for sure. Does anyone have an idea how the file could be repaired? I am happy to forward the file if someone has a tool to examine it, or

Re: [libreoffice-users] Encrypted Calc file got corrupted

2016-02-29 12:20 GMT+01:00 Adam Bujdoso : > Does anyone have an idea how the file could be repaired? I am happy to > forward the file if someone has a tool to examine it, or perhaps to recover > it. > ​Unfortunately, I can't do it myself because I lack the time to do so,

Re: [libreoffice-users] I'm Having Trouble with Contents Lists

On Monday 29 February 2016 14:16:38 Terry Coles wrote: > > Insert the illustration, then select it and use Insert > Caption. Make > > sure the category is set to Illustration. That inserts a reference which > > is recognised by the Table of Illustrations. > > > > > 3. I get a similar problem

Re: [libreoffice-users] Thunderbird potential as the official/default email-client for LO?

On 02/29/16 16:00, Tanstaafl wrote: But, sure, if you ACCEPT the mail, then if you fall under certain laws, you may have to archive it for a given amount of time. But, again, in what world does anyone receive (ACCEPT) 2+GB of mail PER HOUR? Sorry, but that is just silly. Besides, you could

[libreoffice-users] Re: Easy rotate in draw.

Sorry, it was not clear that you were not interested in object/image rotation onto cardinal points. Cley's method of selecting the object and toggling to rotation mode provides the incremental rotation. Note though that some of the objects placed on the Draw canvas will not have resize/rotate

Re: [libreoffice-users] Easy rotate in draw.

Thanks, this works easily. Steve On 2016-02-29 17:25, Cley Faye wrote: An alternative solution you might find useful is simply clicking twice on an object. The "resize" handles will turn into "rotate" handles. From that point you can rotate an object by clicking one of the corner handles, and

Re: [libreoffice-users] Re: Easy rotate in draw.

Thanks. Unfortunately the rotation is not from relative position. First down cursor rotates the object and sets the angle at 0.00 and subsequent cursor steps are at 45 degrees. If the object angle is 23.45 then this will not rotate it 90 degrees to 113.45 steve On 2016-02-29 17:16, V Stuart

Re: [libreoffice-users] Encrypted Calc file got corrupted

Cley, thanks a lot, that indeed sounds like a good suggestion as these corruptions do happen every once in a while. Is there perhaps any other way to repair/analyse the file? Many thanks again to everyone. Best, Adam On Mon, Feb 29, 2016 at 11:49 AM, Cley Faye wrote: >

Re: [libreoffice-users] Thunderbird potential as the official/default email-client for LO? Re: [board-discuss] BoD decision from 2015-10-05

On 2/27/2016 5:38 PM, Tanstaafl wrote: On 2/27/2016 2:10 PM, Paul D. Mirowsky wrote: One of the things I miss about Lotus SmartSuite is its' TeamMail function. A quick google suggests this is nothing more than Shared Mailbox functionality. That is Server

Re: [libreoffice-users] Thunderbird potential as the official/default email-client for LO? Re: [board-discuss] BoD decision from 2015-10-05

On 2/29/2016 11:04 AM, Paul D. Mirowsky wrote: > On 2/27/2016 5:38 PM, Tanstaafl wrote: >> Lotus SmartSuite was am integrated mail server/groupware solution. >> >> You're comparing apples and oranges. > You are correct again. But the question is, how can we put the

Re: [libreoffice-users] Re: Thunderbird potential as the official/default email-client for LO? Re: [board-discuss] BoD decision from 2015-10-05

On 2/29/2016 11:18 AM, Paul D. Mirowsky wrote: > The unique possibility to SyncPOP instead of IMAP is an interesting > proposal. No, it isn't... assuming that by 'SyncPOP' you mean the broken POP feature where you can 'leave messages on the server'. If that isn't what

Re: [libreoffice-users] Re: Thunderbird potential as the official/default email-client for LO? Re: [board-discuss] BoD decision from 2015-10-05

On 2/28/2016 11:36 AM, James Knott wrote: On 02/28/2016 11:21 AM, Tim---Kracked_P_P---webmaster wrote: The only thing about Thunderbird, for me right now, was the "chore" it was to to switch systems when the one it was on, since 2010, is now down for repairs. It was not geared for syncing

Re: [libreoffice-users] I'm Having Trouble with Contents Lists

On Sunday 28 February 2016 19:21:32 libreoffice-ml.mbou...@spamgourmet.com wrote: > From Insert > Indexes and Table > Indexes and Tables, set up the > "Index/Table" tab as desired. > > On the "Entries" tab, for each level you're using: > - Select the level in the left-hand list > - Click in the

Re: [libreoffice-users] Thunderbird potential as the official/default email-client for LO?

On 2/29/2016 4:31 AM, toki wrote: > On 27/02/2016 19:06, Tanstaafl wrote: >> Not sure what kind of real world scenario that falls into > That real world scenario is adhering to a lawyer's recommendation that > even de facto spam has to be retrieved and archived to comply

Re: [libreoffice-users] Thunderbird potential as the official/default email-client for LO? Re: [board-discuss] BoD decision from 2015-10-05

On 2/29/2016 11:33 AM, Tanstaafl wrote: On 2/29/2016 11:04 AM, Paul D. Mirowsky wrote: On 2/27/2016 5:38 PM, Tanstaafl wrote: Lotus SmartSuite was am integrated mail server/groupware solution. You're comparing apples and oranges. You are correct again. But the

Re: [libreoffice-users] Re: Easy rotate in draw.

Hi. That would be ok if the object started at a cardinal point. When you group some objects the angle of the group seems to become the angle of the last object in the group. Rotating a group with cursor is painfully slow for larger groups as it calculates the new rotation every step of the way.

Re: [libreoffice-users] Thunderbird potential as the official/default email-client for LO? Re: [board-discuss] BoD decision from 2015-10-05

On 2/29/2016 12:57 PM, Paul D. Mirowsky wrote: > While I do plead ignorance about mail servers, software resident on the > users machine can do what it wants. To a point, yes... > Since PGP already exists in Thunderbird, a server is not required for > updating. What

Re: [libreoffice-users] line numbering

On 29/02/2016 18:05, Daniel wrote: > I noticed that the line numbering starts from the title and adds the one > line space between the title and the first line. Consequently the first > line becomes number 3. Any solution? Play with the settings in the "Outline and Numbering" section of the

Re: [libreoffice-users] Thunderbird potential as the official/default email-client for LO? Re: [board-discuss] BoD decision from 2015-10-05

Each e-mail address has its own "STATUS" file. "STATUS" file e-mails are not deletable from the POP mail server unless specifically commanded to delete them within Thunderbird via a separate command or when all "STATUS" files are duplicated based on time stamp. "STATUS" files are

[libreoffice-users] line numbering

I noticed that the line numbering starts from the title and adds the one line space between the title and the first line. Consequently the first line becomes number 3. Any solution? Daniel -- -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

[libreoffice-users] calc filter?

HI all, im working on a calc sheet where i have a list of 16 names 1 to 16 B2 TO B17 I lie to filter the list in this order 1 16 8 9 4 13 5 12 2 15 7 10 3 14 6 11 thanks beau -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] Re: Thunderbird potential as the official/default email-client for LO? Re: [board-discuss] BoD decision from 2015-10-05

On 02/29/2016 11:18 AM, Paul D. Mirowsky wrote: > The unique possibility to SyncPOP instead of IMAP is an interesting > proposal. > I would feel far more secure if Thunderbird directly re-aligned itself > on different machines I use then have it floating out on the web. > If LibreOffice where to

Re: [libreoffice-users] Thunderbird potential as the official/default email-client for LO?

On 27/02/2016 19:06, Tanstaafl wrote: > Not sure what kind of real world scenario that falls into That real world scenario is adhering to a lawyer's recommendation that even de facto spam has to be retrieved and archived to comply with assorted federal, state and local data retention laws,

Re: [libreoffice-users] calc filter?

Hi, My understanding is you want to re-display the list in the order you provided. If you can calculate the odd indices (the even numbered ones are always equal to the number of elements minus the odd index plus 1 in your list), replace the number in the sequence by that calculation. Otherwise,

Re: [libreoffice-users] Thunderbird potential as the official/default email-client for LO? Re: [board-discuss] BoD decision from 2015-10-05

Oh - not to mention that it doesn't even accomplish the goal. What about all of the email prior to adding 'Thunderbird 3' to the mix? Or your new phone? As I said, IMAP is the only sane, rational solution. On 2/29/2016 10:23 PM, Tanstaafl wrote: > Possible? Sure,

Re: [libreoffice-users] line numbering

At 19:05 29/02/2016 +0100, Daniel Noname wrote: I noticed that the line numbering starts from the title and adds the one line space between the title and the first line. Consequently the first line becomes number 3. Any solution? You need a solution only when you have a problem. Line

[libreoffice-users] Libre Office und IE, Webseiten

Gesendet von Mail für Windows 10 Hallo Ich habe meinen Acer Aspire 5742G auf win 10 umgestellt. Seit diesen Tag gibt es Probleme mit dem IE, beim suchen im Internet las ich das, das ´ich nicht der einzige bin und dies auch mit anderen Browsern ist. Folgendes ist bei mir, ich kann Webseiten

Re: [libreoffice-users] Thunderbird potential as the official/default email-client for LO? Re: [board-discuss] BoD decision from 2015-10-05

Possible? Sure, anything is possible, but this is way too breakable to even give serious consideration to. On 2/29/2016 3:10 PM, Paul D. Mirowsky wrote: > Each e-mail address has its own "STATUS" file. > "STATUS" file e-mails are not deletable from the POP mail server

Re: [libreoffice-users] calc filter?

At 15:01 29/02/2016 -0600, Beau Thompson wrote: im working on a calc sheet where i have a list of 16 names 1 to 16 B2 TO B17 I like to filter the list in this order 1 16 8 9 4 13 5 12 2 15 7 10 3 14 6 11 Filtering in a spreadsheet arranges that only some rows are displayed and possibly that