Re: [libreoffice-users] Draw

If you really only want a light/fast PDF *reader* than for Linux try Evince and for Windows try Sumatra. If you want some basic PDF tools (not a full PDF editor) than for Linux try PDFshuffler and for Windows try PDFTK Builder for which you can find a link on this page:

Re: [libreoffice-users] Re: How to change dialog box font size?

Edwar, I have only used the LO Scaling feature to increase (on high resolution monitors) or decrease (on low resolution monitors) the font size for the menus. I then use the View > Zoom feature for the main worksheet or text document. Otherwise the existing defaults were always readable. On

Re: [libreoffice-users] Re: Draw

Robert, Thanks for that comment on Evince for Windows. It's "lighter" as in less cluttered than Sumatra and includes a useful Annotations feature. On Mon, Jun 6, 2016 at 7:45 PM, Robert Funnell wrote: > David - > > Evince, mentioned by Bruce, also works under Windows.

Re: [libreoffice-users] sumifs() with wildcard question

In this particular case I want to sumifs() with the * wildcard for compatibility with Excel. Regexp are not supported by Excel. On Fri, Jun 17, 2016 at 9:13 AM, Brian Barker <b.m.bar...@btinternet.com> wrote: > At 07:37 17/06/2016 -0400, Bruce Hohl wrote: > >> A B >> 1 a

Re: [libreoffice-users] Re: sumifs() with wildcard question

Thanks for that link Miguel. Looking forward to that feature. On Fri, Jun 17, 2016 at 5:47 PM, m.a.riosv wrote: > You need to wait a couple of months for the next release 5.2, it implements > the option to use regular expressions or wildcard. > > >

Re: [libreoffice-users] LO 5.1.4.2 calc consistently crashing on row deletion

Tom, I just updated to LO 5.1.4.2 from the Ubuntu PPA's on Ubuntu 14.04 (really LXLE Posh). I checked deleting rows from a few worksheets and encountered no errors. If you are using Ubuntu or an Ubuntu based OS you might try getting LO from the PPAs per the links below as these are packaged for

[libreoffice-users] sumifs() with wildcard question

A B 1 aa 1 2 ab 2 3 bb 10 4 bc 10 5 a* 0 Formula in cell B5 =SUMIFS(B1:B4,A1:A4,A5) should return 3 not 0. Tool > Options > LibreOffice Calc > Calculate Enable regular expression in formulas is *off* (I don't want regexp for this worksheet). I though there was a setting that controls how the *

[libreoffice-users] 'Sheet' menu for DEB version of LO 5.1 Calc

Can someone comment on the status of the [missing] 'Sheet' menu for DEB version of LO 5.1 Calc? -- 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:

Re: [libreoffice-users] Re: shrinking an LO window

Find your program on the task bar, right click and select "Resize". This will position the pointer on the bottom right corner of the window so you can easily resize. On Wed, Mar 16, 2016 at 4:46 PM, John R. Sowden wrote: > sorry xubuntu gnome (not unity) > > > On

Re: [libreoffice-users] Save/Store files

Perhaps because in the status bar at bottom there is an icon (rectangle outline with check mark) which indicates if the document has been modified, and is also a 'Save' button. On Wed, Mar 16, 2016 at 5:29 AM, Heinrich Stoellinger wrote: > Hello, > I am using LO 5.1.1

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

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

Re: [libreoffice-users] Re: Calc method to change whole column cell content

Method 1 - Using Value() Use value() function to convert a text string into a number or date. Copy the result; paste special as number or date. --- Method 2 - Search & Replace Select (highlight) a cell range then: Using Search & Replace (Ctrl+H): Search for = .* Replace = & Under Other Options: Y

Re: [libreoffice-users] Re: Importing CSV file into Calc with records determined by the number of field separators instead of Line Feeds

Another useful tool for this type of clean-up is SED. It can take some trial & error and web searching if you're not familiar with sed or awk but it's good knowledge to have. On Mon, Apr 11, 2016 at 2:02 PM, Paul D. Mirowsky wrote: > This is more specific. > > I

Re: [libreoffice-users] Re: date display in Calc Linux/Windows

What format is used to save the file: ods, xlsx, xls? Sometimes the filters used to save in formats other than ods fail to retain all formatting. On Thu, Mar 24, 2016 at 6:45 AM, Thomas Blasejewicz wrote: > On 2016/03/07 0:10, Pedro wrote: > >> Thomas Blasejewicz-3 wrote >>

[libreoffice-users] OwnCloud link on LO site

From the home page menu on the LO site: Community > OwnCloud opens https://owncloud.documentfoundation.org/ which requires a user & password. Is this a LO OwnCloud demo? If so, does anyone know how I can get credentials to check it out? -- To unsubscribe e-mail to:

Fwd: [libreoffice-users] In 5.1.0.3, where is the "Add Ons" menu?

And, use Tools > Extension Manager shows the Add-on's install. -- Forwarded message -- From: Bruce Hohl <bruceh...@gmail.com> Date: Sun, Mar 27, 2016 at 8:31 PM Subject: Re: [libreoffice-users] In 5.1.0.3, where is the "Add Ons" menu? To: Joshua Kramer <j

Re: Disabling recent-doc list [was Re: [libreoffice-users] Re-activating the Recent Documents Function in LibreOffice 5]

There is an Add-on call History Master that gives additional control over recent documents. On Tue, Mar 22, 2016 at 1:35 AM, Robert Funnell wrote: > A simple Google search for 'libreoffice recent documents disable' found > the following, among others: > >

Re: [libreoffice-users] update

For Linux Mint your LO install may receive patches (but not version updates) when you run updates to Linux Mint. Linux Mint can be updated via an icon in the task bar or the 'Update Manager'. If you are happy with that version of LO and LM 17.2 then simply keep LM 17.2 updated. If you move to

Re: [libreoffice-users] Number comparisons in conditional text

t get a lot of attention. > > > On 27/04/16 03:32 PM, Bruce Hohl wrote: > >> Can you give more details of your set-up. What is in the Writer, Calc >> and / or Base components of LO. >> >> On Wed, Apr 27, 2016 at 11:44 AM, Gary Dale <garyd...@torfree.net >

Re: [libreoffice-users] Ubuntu 16.04 and LibreOffice

At some point during the life of 16.04 you may want to move to a newer version of LO. See this link for information on how to accomplish that. https://launchpad.net/~libreoffice/+archive/ubuntu/ppa On Tue, Apr 26, 2016 at 7:34 PM, Tim Lloyd wrote: > Running Fedora with Gnome

Re: [libreoffice-users] function sumif question

See attached example for a few ways to solve this problem. On Thu, Apr 21, 2016 at 5:47 PM, John R. Sowden wrote: > I have an accounting ledger in calc, with two columns in question. > > col 1 is credit (amount charged to account) and col 2 is the account > number

Re: [libreoffice-users] HP Officejet Pro 8630 overprinting lines in LO on Win 10

You cite LO as the culprit yet the problem occurred after changing to Win10. I suggest you verify if the HP driver is at the correct version for Win10. Maybe use the 'DriverTalent' program to check all your drivers. http://download.cnet.com/Driver-Talent/3000-2094_4-76219521.html On Tue, May

Re: [libreoffice-users] Number comparisons in conditional text

categories, etc., it's not much good. > > I suppose I can use a brute force technique and create a table row for > every possible age (for example) but that seems like a ludicrous kludge > when the basic problem is that Writer's form letter functions can't compare > numbers. > &

Re: [libreoffice-users] Number comparisons in conditional text

does work when I use "results"."age" = > "Categories"."low", leading to my complaint that BETWEEN doesn't work. > > Your use of a CASE statement with just the one table looks like it will do > the trick, even if the code will be ugly. I'll need 2 di

Re: [libreoffice-users] Simple sum in column getting zero in libreoffice calc 5.

Check cell formats and contents in B2:B8. SUM() will not add numbers within cells formatted as text or numbers preceded by a half quote. Per below the sum() result is 4 as such items are not summed. 4 '=SUM(B2:B8) 2 Cell number format with '2 (note the half quote) 3 Cell number format with '3

Re: [libreoffice-users] HP Officejet Pro 8630 overprinting lines in LO on Win 10

As a work-around perhaps you could print to PDF then print the PDF on the HP8630. On Tue, May 17, 2016 at 7:05 AM, Rogier F. van Vlissingen < vlisc...@gmail.com> wrote: > Since switching to Windows 10, I've had to abandon LibreOffice, since my > printer inexplicably overprints lines in LO. This

Re: free text editor (was: [libreoffice-users] delete hidden formated text in odt)

en your content.xml with Emacs and record a macro to find and > remove the hidden text? (I'm not sure that qualifies as simple.) > > - Robert > > On Tue, 3 May 2016, Walther Koehler wrote: > > Hallo, >> Am Dienstag, 3. Mai 2016 schrieb Bruce Hohl: >> >>> > D

Re: [libreoffice-users] Calc HH:MM:SS to decimal

Try this in cell A2 "=VALUE(A1)*24" On Thu, May 5, 2016 at 12:44 PM, Russell wrote: > does anyone know if there is a formula for a cell that will transform the > HH:mm:ss from another cell into a decimal equivalent? > > example: > > Cell A1 has 10:45:20 > > Cell A2 would

Re: [libreoffice-users] Re: a question about libreoffice and my recent documents:

Or use the Expert config option described here: http://superuser.com/questions/726467/libreoffice-4-2-1-1-do-not-display-list-of-recent-documents On Sun, May 1, 2016 at 1:06 AM, Pedro wrote: > https://ask.libreoffice.org/en/question/2298/suppress-recent-document-list/ > >

Re: free text editor (was: [libreoffice-users] delete hidden formated text in odt)

> Do you have some advice how to remove the hidden (hard-)formatted text in a > simple way? File > Save :: Save as type = Text (.txt) OR Text - Choose Encoding (.txt) Thus, LO can be used to read, create and edit unformatted text files. On Tue, May 3, 2016 at 12:37 PM, anne-ology

Re: [libreoffice-users] Calc HH:MM:SS to decimal

.me...@gmail.com> wrote: > This actually worked incredibly well for my problem. > > > > On 5/5/2016 10:52 AM, Bruce Hohl wrote: > >> Try this in cell A2 "=VALUE(A1)*24" >> >> On Thu, May 5, 2016 at 12:44 PM, Russell <ka4...@frontier.com> wrot

Re: [libreoffice-users] If value is not present, count it.

Perhaps one of these depending the content of Column E: =COUNTIFS(E2:E160,"<>PO", B2:B160,"Red", D2:D160,"M") =COUNTIFS(E2:E160,"", B2:B160,"Red", D2:D160,"M") On Thu, Jul 14, 2016 at 8:36 PM, Wade Smart wrote: > This does not work but this is what Im thinking about. >

Re: [libreoffice-users] Keyboard shortcuts

You can also use: Tools > Customize, Keyboard tab to set keyboard shortcuts. I use this to assign 'easy' shortcuts to features often used or features in 'inconvenient' menu locations. You can also save these settings to a file - see buttons for Save and Load. On Tue, Jul 26, 2016 at 3:12 AM,

Re: [libreoffice-users] LO Base

> I have recently read that Open Office no longer uses HSQL. Is that also true of LO? If a new Base is created in LO 5.1.x it will be default is "HSQLDB Embedded" to store the data. > is it really necessary to have another database product to do database work in LO Base? Not necessarily, but this

Re: [libreoffice-users] Date field in a spreadsheet

File > Print Preview, Click 'Format Page', In the Header or Footer tab click 'Edit'. You can add the sheet name to the Left, Center or Right by clicking the 'Sheet Name' icon near the bottom. On Wed, Jul 27, 2016 at 7:23 AM, william drescher wrote: > I have version

Re: [libreoffice-users] Re: Compatibility of LO Base with Access databases

Base and some of its limitations (including enbedded HSQLDB) are well described here: https://wiki.openoffice.org/wiki/FAQ_(Base) The last two times I needed a multi user database accessible over the web I went with a LAMP approach. The *upfront* set up and learning curve was higher but *less*

Re: [libreoffice-users] Calc formula tool tips - possible to turn off?

know of any way to turn the formula tool tips off. I even had > a look at the advanced settings (Tools... Options... LibreOffice... > Advanced... Advanced Settings) and I could not find anything. > > Rgds, > > Rémy Gauthier. > > Le samedi 13 août 2016 à 15:42 -0400, Br

Re: [libreoffice-users] Calc formula tool tips - possible to turn off?

t; I like your second suggested option Bruce, i.e. None : Standard : Extended. > > It would be a good option for all tooltips. > > Gordon. > > > > On 15/08/16 13:04, Bruce Hohl wrote: > >> My search for a way to control the formula tips also was unsuccessful so I &

[libreoffice-users] Calc formula tool tips - possible to turn off?

Does anyone know if it is possible to turn off the formula tool tips in Calc? -- 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:

Re: [libreoffice-users] Line spacing on Writer

Go to "View > Non-Printer Characters". This will show the paragraph breaks, etc. Position the cursor within a paragraph or select (highlight) desired paragraphs. Open "Format > Paragraph" and go to the "Indents & Spacing Tab". You can view and change spacing setting here. On Sat, Aug 6, 2016 at

Re: [libreoffice-users] change user interface

"... current user interface look like old office 2003.I need to change the look like office 2007 or higher." Firstly, quite a few people do *not* prefer the 'Ribbon' menu system introduced with MSO 2007. Google Docs features tool bars of icons but I doubt anyone thinks it seems "old" and

Re: [libreoffice-users] Re: LO Base - Dropdown boxes

I have never done this but since it seems your data might fit within a spreadsheet perhaps you can use the features in View > Tool bars > Form Controls, Design, Navigation to create an input sheet / form. Then another sheet(s) for "output" via Data > Filters or Pivot Tables. You might also be

Re: [libreoffice-users] Libre Office clc file not opening in MSO Excel 2007

From LO to which file format (ods, xls, xlsx) do you save the spreadsheet? What is "clc file"? Do the files open if no password is used? On Sat, Jul 2, 2016 at 6:41 AM, jinesh wrote: > Hi, > > > > > > I'm using Libre office 5.1, when i was send or share password protected or

[libreoffice-users] Alt Key

On Linux pressing and holding the Alt key "activates" text menu (File, Edit, View, etc). On Windows pressing then releasing the Alt key "actives" the text menu. Does anyone know how to get Linux to behave like Windows for the Alt key or vice versa? -- To unsubscribe e-mail to:

Re: [libreoffice-users] Re: Alt Key

uart Foote <vstuart.fo...@utsa.edu> wrote: > @Bruce, * > > > Bruce Hohl wrote > > On Linux pressing and holding the Alt key "activates" text menu (File, > > Edit, View, etc). On Windows pressing then releasing the Alt key > "actives" > > th

Re: [libreoffice-users] How to learn Base & an external database program

You could review this: https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Handbook If you think an external database is appropriate each will likely have it's own documentation like this: http://www.postgresqltutorial.com/ Access is unique. On the plus side the

Re: [libreoffice-users] Help with applying filters please.

Another way to keep unwanted columns or rows from printing is to Group those columns or rows (Data > Group and Outline > Group) . Before printing use the "Minus" icon to collapse. After printing use the "Plus" sign to expand. This method provides a fast clickable control which is also a

Re: [libreoffice-users] Calc ABORTS

Does that result occur just for that particular worksheet or any worksheet on your computer? Which delete option are you using: Shift cells up, Etc? What is the file format and origin of the worksheet? On Mon, Feb 6, 2017 at 6:30 AM, Jay Ridgley wrote: > Good Morning, >

Re: [libreoffice-users] Question on wildcards

For more compactness, maybe you could create a maxifs() pointed to each sheet then a maxifs() against those maxifs() results. I agree with Brian on the point of keeping all data in one sheet if practical. With that approach it's still possible to have separate tabs for each year for the analysis

Re: [libreoffice-users] Re: Problem with LO 5.3

With respect to the problem you found with 5.3 you can file a bug report here: https://bugs.documentfoundation.org/ On Wed, Feb 8, 2017 at 5:54 PM, Paolo Debortoli wrote: > I downgraded to LO5.2, but the calc file had lost links to intwernet pages > (LO 5.3 hasn't

Re: [libreoffice-users] Verified fatal error

This is not really an answer but ... sometimes I have a problem with my Windows PC at work, and the IT person confirms the problem, but trouble shooting the problem will take longer than reinstalling ... so by analogy I suggest you rebuild the spreadsheet starting with File > New > Spreadsheet.

Re: [libreoffice-users] Calc ABORTS

ash specific to that operation in that particular file or occurs with any file.) On Mon, Feb 6, 2017 at 1:49 PM, Jay Ridgley <jridgl...@austin.rr.com> wrote: > Thanks Bruce, > > On 02/06/2017 06:43 AM, Bruce Hohl wrote: > >> Does that result occur just for that particular worksheet

Re: [libreoffice-users] LibreOffice Help in version 5.3.0.3

Did you install the separate help package for 5.3.0.3? http://www.libreoffice.org/download/download/?type=deb-x86_64=5.3.0=pick On Sat, Feb 4, 2017 at 12:47 PM, M Henri Day wrote: > ​After upgrading recently to (the Swedish version of) LibreOffice 5.3.0.3, > I find that I

[libreoffice-users] Calc Selection Count in v5302 Win

Hello All, I installed version 5.3.0.2 / Win64 this morning but found that in Calc the Selection Count option in the status bar did not work (nothing displayed). If anyone has this version installed please check this and reply. If confirmed, I will add a bug report. I use selection count

[libreoffice-users] Re: Calc Selection Count in v5302 Win

Well ... Calc's Count Selection feature also does not work in version 5.3.0.2 on Linux. I will file a bug report. On Tue, Jan 24, 2017 at 12:47 PM, Bruce Hohl <bruceh...@gmail.com> wrote: > Hello All, > I installed version 5.3.0.2 / Win64 this morning but found that in Calc >

Re: [libreoffice-users] Default font in LO calc

on't want or need a Template I just want the Font and size that I > selected to be the Default for all new Spreadsheets!! > > IanW > Pretoria RSA > > > > On 02/20/2017 03:22 PM, Bruce Hohl wrote: > >> View > Sidebar >> Use top right icon to switch to "

Re: [libreoffice-users] Default font in LO calc

View > Sidebar Use top right icon to switch to "Styles and Formatting Right click "Default" and select "Modify" Under the Font tab select your desired font. You might want to save this as a template and use as your default template. On Mon, Feb 20, 2017 at 7:52 AM, Ian Whitfield

Re: [libreoffice-users] Default font in LO calc

I can always open a new spreadsheet equipped with Arial by selecting File > New > Templates > spreadsheet tab > My Templates > select the template > click Open. That is a lot of clicks and so in practice, it is easier just to do File > New > Spreadsheet and then change the font from Liberation to

Re: [libreoffice-users] Start Center

You can simply open only the component you want (Writer, Calc, etc.) from the menu, a desktop icon or a desktop tray icon. Or, if the list of previously open files in start center is unwanted those can turned off here: Tools > Options > LO > Advanced :: Expert Configuration | Set PickListSize to

Re: [libreoffice-users] Re: Problem with LO 5.3

<paolo_debort...@yahoo.com > wrote: > Hi. Thank you for testing. I uploaded a working file (copia 1) on the bug > report, you can use that for test. Paolo > > > > > On Friday, February 10, 2017 1:49 PM, Bruce Hohl <bruceh...@gmail.com> > wrote: > I s

Re: [libreoffice-users] Re: Problem with LO 5.3

<paolo_debort...@yahoo.com> wrote: > Thanks. It's done: Bug 105907. Paolo > > > > > > On Thursday, February 9, 2017 1:18 AM, Bruce Hohl <bruceh...@gmail.com> > wrote: > With respect to the problem you found with 5.3 you can file a bug report > here: https

[libreoffice-users] Need someone to check a 5.2.x regression

Hi All, I installed 5.2.x on a Windows 7 and Linux from ppa:libreoffice/libreoffice-5-2. In both cases the Format > Cells > Background > 'No Fill' did not work correctly per this bug report: https://bugs.documentfoundation.org/show_bug.cgi?id=101588 However, another tester did not find the problem

Re: [libreoffice-users] Re: Need someone to check a 5.2.x regression

On Sat, Aug 20, 2016 at 5:06 AM, Pedro <pedl...@gmail.com> wrote: > Bruce Hohl wrote > > In both cases the Format > Cells > Background > 'No Fill' did not work > > correctly per this bug report: > > https://bugs.documentfoundation.org/show_bug.cgi?id=101

[libreoffice-users] Calc row height: Fixed versus Optimal

Hello List, Is there a way to see from *within* Calc if a spreadsheet row is set to Fixed versus Optimal (That is, see the setting of style:use-optimal-row-height = false | true.) -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] Fwd: Looking for expert help

I totally agree with Joe's comment. LO including Calc has an excellent PDF export feature with many options (review the various tabs at File > Export to PDF). Also, print ranges can be set by Tab/Sheet, cells set as non-printable and Headers & Footers can be used to identify content, page

Re: [libreoffice-users] Get number of items in a calc's sheet filtered list

Make sure "View > Status Bar" is checked. That information is displayed in the second part of the status bar at the bottom of Calc but only when the focus is within the range of data being filtered. At the bottom you will then see something like: | Sheet 3 of 4 | 55 of 1425 records found | etc.

Re: [libreoffice-users] Re: How to fill in "Read filter criteria from"

> Is there some other way to get a check range? Yes, to 'AND' setup your Advanced filter range like this: date | check no | check no | | >=1000 | <=1100 | If you install the LO help there is good explanation and example of using Advanced Filters. On Mon, Sep 26, 2016 at 8:53 AM, Larry Evans

Re: [libreoffice-users] COUNTIFs with cells of yyyy-mm-dd

Or, for example, for the year 2015 try this: =COUNTIFS(A1:A50,">="(2015,1,1), A1:A50,"<="(2015,12,31)) On Wed, Oct 5, 2016 at 9:55 PM, Brian Barker wrote: > At 17:30 05/10/2016 -0600, F H Data wrote: > >> I have -mm-dd as my date format in Calc (libreoffice

Re: [libreoffice-users] Re: COUNTIFS with cells of yyyy-mm-dd

And, for 2 criteria like this: =SUMPRODUCT((YEAR(A1:A50)=2011)*(B1:B50="ZZZ")) On Sat, Oct 8, 2016 at 9:38 PM, m.a.riosv wrote: > Or > > =SUMPRODUCT(YEAR(A1:A50)=2011) > > Miguel Ángel. > > > > -- > View this message in context:

Re: [libreoffice-users] trouble installing fonts to use with Libre Office

You may be able to find (and install) desired fonts from the Synaptic Package Manager. After opening the Synaptic Package Manager, on the left panel there are entries for Fonts, Fonts (multi-verse) and Fonts (universe). Or enter "font" in the Quick Filter search box. On Sat, Sep 17, 2016 at

Re: [libreoffice-users] Time Calculations in LOBase

What type of database is used - HSQLDB embedded, HSQLDB, MySQL, PostgreSQL, etc? On Thu, Aug 25, 2016 at 11:54 AM, Don Parris wrote: > Hi all, > > I need to do some time calculations in LO Base queries - seems fairly > straightfoward, but I can't seem to find any good info

Re: [libreoffice-users] libreoffice base: building query, need help with input parameter development

> What would I need to write as a criteria so that when the QUERY is run, it prompts the user to select from a listbox You must create a form to use the List Box control. If you really only need a query you can add the choices to the query parameter name. For example: SELECT "F1", "F2" FROM

Re: [libreoffice-users] dsum

There is an example in the installable help at: Help > LibreOffice Help Contents tab > Spreadsheets > Functions Types and Operators > Database Functions I just checked and that example works. On Fri, Aug 26, 2016 at 2:25 AM, Istvan Toth wrote: > Guten Morgen, > ich kann

Re: [libreoffice-users] libreoffice base: building query, need help with input parameter development

On form Form_Filter, is it possible to define the List Box using General - List Entries and Data - ValuelList (without using the separate table Filter and query Query_Filter)? The Base Handbook has brief comments on the List Entries & ValueList but only defining those items does not produce a

Re: [libreoffice-users] LibreOffice on a Chromebook?

Suggest you read the following: http://www.pcworld.com/article/2984834/chromebooks/installing-linux-on-a-chromebook-what-you-need-to-know.html http://www.androidauthority.com/crouton-turn-your-chromebook-into-far-more-than-a-glorified-web-browser-663044/ https://github.com/dnschneid/crouton So

Re: [libreoffice-users] Re: Time Calculations in LOBase

I can confirm as follows. With this in table1: ID time1 time2 1 01/01/16 11:30 PM 01/02/16 04:00 AM 2 01/02/16 01:30 AM 01/02/16 05:30 AM This query: SELECT "time1", "time2", DATEDIFF( 'minute', "time1", "time2" ) AS "diff_minutes", DATEDIFF( 'minute', "time1", "time2" ) / 60.00 AS "diff_hours"

Re: [libreoffice-users] Help Please with Printing Ranges

What is included at Format > Print Ranges > Edit for (1) Print Range, (2) Rows to Repeat, and (3) Columns to Repeat? On Wed, Oct 26, 2016 at 10:50 AM, ajebay wrote: > I am trying to print only selected columns which I have defined using > Format>Print Range>Define and

Re: [libreoffice-users] Help Please with Printing Ranges

e Edit, just defione and >> add. Will now try Edit option and report back. >> >> On 26/10/2016 16:22, Bruce Hohl wrote: >> >>> What is included at Format > Print Ranges > Edit for >>> (1) Print Range, (2) Rows to Repeat, and (3) Columns to Repeat?

Re: [libreoffice-users] Calc - Page number and printing page range

Have you tried: View > Page Break or File > Print Preview On Thu, Oct 27, 2016 at 5:35 PM, charles meyer wrote: > Hi All, > > Is there a way to detect how many pages there are in a Calc file? > > I just see columns, row, etc but not pages? > > Once I can establish

Re: [libreoffice-users] Help with LOCalc formula

I think VLOOKUP might work. In cell X1 try this: =VLOOKUP(B1,B$20:C$22,2,0) Copy down as needed; Adjust 2nd parameter (B$20:C$22) as needed. On Mon, Nov 7, 2016 at 10:58 AM, Pertti Rönnberg wrote: > Best Spreadsheet Experts, > May I ask for help having a more elegant formula

Re: [libreoffice-users] Observations on LO v5.2.1.2

> the icons in the menu bars are terrible! Way too large Tools > Options; Left panel: LibreOffice > View; Right panel: Set Icon Size = Small If desired, install and select an alternate icon style as well. > as is the bar at the bottom with the "Find" window, which I can't find a way to get rid

Re: [libreoffice-users] Re: How do I install the current Linux version

Those PPA's work fine with Mint. You can also select another version, for example 5-2. This method will replace your current version. Updates to your selected version (5.1.x or 5.2.x, etc) are provided through the package system. This is more convenient versus manually downloading and

Re: [libreoffice-users] Help Please with Printing Ranges

> I found that hiding the unwanted columns (which I tried first) did not solve the problem either. For that approach to work you must hide (or group) the unwanted columns AND clear the multiple print ranges. On Thu, Oct 27, 2016 at 1:07 PM, Budge wrote: > Hi, Regina, > On

Re: [libreoffice-users] Strange pdf printout in Calc vs. Excel

@Valter There is actually an enhancement request related to PDF export in Calc: https://bugs.documentfoundation.org/show_bug.cgi?id=54052 I agree the default of printing the entire workbook is generally unwelcome. On Thu, Oct 13, 2016 at 4:02 PM, Robert Großkopf

Re: [libreoffice-users] Downloads impossible and latest version of Firefox not recognized by captcha, connclusion: service level zero

I just downloaded LO 5.2.2.2 for Windows from LibreOffice.org using Firefox and installed on my Windows 7 (64 bit) notebook without problem. The program opens and appears to work correctly. On Sun, Oct 9, 2016 at 12:23 PM, Jurriaan Nijkerk wrote: > Hi there, > > I'd like

Re: [libreoffice-users] Strange pdf printout in Calc vs. Excel

> You recognized Valter himself wrote this enhancement request four years ago? Actually, I did not notice that. I recently added myself to the CC list for that bug as I agree that more control over PDF output from Calc would be nice. > ... Printing button is right beside this. Here you could

Re: [libreoffice-users] Re: Libra Office and MS Word compatibility query

"with no glitches" I think this can only be achieved if everyone can agree to only use a specified file format (.doc, .docx, .rtf) and only [basic] features known to work the same in both programs. Perhaps one of the many online [basic] word processors would be a better fit this situation. On

Re: [libreoffice-users] i of the most disturbing things about 5.0 libreoffice

fudmer, The copy and paste results you experienced are likely due to the formula "anchoring" feature which can be set under "Sheet > Relative/Absolute References" or pressing the F4 key. Try "un-anchoring" or setting cells to "Relative References" (no "$" in the formulas) before copy & paste.

Re: [libreoffice-users] i of the most disturbing things about 5.0 libreoffice

ample > > got to standard training module 9ll that explains what to do or how > to and that training modules always works with the standard > content spread sheet.. > > > > > > > On Sun, 12/11/16, Bruce Hohl <b

Re: [libreoffice-users] Speed up RTF to PDF (headless) conversions

If the QuickStarter is available for Mac, perhaps that would make a difference. On Tue, Nov 29, 2016 at 9:14 AM, Paquin, Brian wrote: > > > On Nov 28, 2016, at 11:24 AM, Cley Faye wrote: > > > > 2016-11-28 16:55 GMT+01:00 Paquin, Brian

Re: [libreoffice-users] Column width not shown when resizing column

Version: 5.2.3.2, Build ID: 1:5.2.3~rc2-0ubuntu1~xenial1, which I currently have installed does show column width when resizing. You might check/test the Graphics Output setting under Tools > Options > LibreOffice > View. On Thu, Dec 1, 2016 at 11:31 AM, dave boland wrote:

Re: [libreoffice-users] Formula calculation differences between LO 5.3 and Excel

This is not really an answer but you might search bugzilla to get an idea of what types of differences exist and if any such differences are relevant to your use. https://bugs.documentfoundation.org/ On Wed, Mar 22, 2017 at 1:44 PM, bunk3m wrote: > When I open most Excel

Re: [libreoffice-users] no access to styles in calc

Format > Styles > Styles and Formatting (or F11 by default as mentioned) If you do not want spreadsheet headers & footers by default you can create a template without headers & footers and set that as your default template. On Thu, Mar 16, 2017 at 4:21 PM, Steve Edmonds

[libreoffice-users] Wanted: KB shortcut to Calc Name Box

In Calc I would like to set F3 as a KB shortcut which moves the focus to the "Name Box" (1st control on formula bar). This would provide navigation equivalent to a 'go to cell' command which would be useful for my very large spreadsheets (without having to reach for the mouse). I don't see an

Re: [libreoffice-users] Re: Wanted: KB shortcut to Calc Name Box

Regina & Stuart, Many thanks. I did not expect the name of this function to be "Sheet Area Input Field". The ease and flexibility of creating LO Keyboard shortcuts is an outstanding feature that enhances my productivity. BH On Fri, Mar 17, 2017 at 10:19 AM, V Stuart Foote

Re: [libreoffice-users] Linux User Groups

Lots of good stuff here: https://ubuntuforums.org/ On Fri, Mar 3, 2017 at 4:13 PM, MR ZenWiz wrote: > I can't speak for Knoppix, but Ubuntu has a users' group and email > list at "Ubuntu user technical support, not for general discussions" > .

Re: [libreoffice-users] regular expression for calc

If the code you are looking for only occurs once per cell you could use find() or search() against each cells to determine if the code is present then countif() the results where greater than zero. On Sun, Mar 12, 2017 at 1:50 PM, Regina Henschel wrote: > Hi Gary, > >

Re: [libreoffice-users] Printing selected text to PDF

In 5.2.x File > Export as PDF then click the "Selection" radio button. This will print selected cells or selected sheets. For 5.3.x the wording might be slightly different and this might become the default. See: https://bugs.documentfoundation.org/show_bug.cgi?id=90436

Re: [libreoffice-users] Pasting data from LO Calc to BricsCAD

You might try this: Tools > Options > Calc > View then Under "Display" set X = Formulas Now perform the copy and paste. Or you can save the Calc sheet as a CSV with formulas. File > Save As (select Text CSV) and set X = Edit filter settings In the next pop-up set X = Save cell formulas instead of

Re: [libreoffice-users] Fwd: + session of Calc: everything scares frightfully.

Just a few general comments: LibreOffice is a relative large desktop application so if you have a low resource computer (old or very low cost) performance will be slower with more open worksheets. Performance is affected by the "size" of each worksheet. "Size" somewhat difficult to measure but

  1   2   >