Re: [libreoffice-users] Help with libre

On Thu, Jan 9, 2014 at 4:58 PM, Mark Bourne libreoffice-ml.mbou...@spamgourmet.com wrote: Some how when I was doing a lot of work on libre office, I landed up with some solid lines running across my page, which I cannot delete or remove? Why? How can I remove them? That sounds like

Re: [libreoffice-users] Query

On Sun, Jan 19, 2014 at 6:15 AM, Ernest Dale ernest.dal...@gmail.comwrote: ... I appear to have succeeded but the result is what looks like a spreadsheet and I cannot find a way to display one record at a time. As already suggested filtering can limit the number of rows that are displayed.

Re: [libreoffice-users] Calc question

On Thu, Jan 23, 2014 at 9:28 PM, Pikov Andropov piko...@gmail.com wrote: Next to each buyer will be a price. How do I total the amount of a buyer's purchase on the fly, so-to-speak? Have labels at the top of each column such as Buyer and Price. Once you're ready to get your totals by buyer

Re: Re: [libreoffice-users] Calc question

On Fri, Jan 24, 2014 at 7:51 AM, Carl Paulsen carlpaul...@comcast.netwrote: Dang, I hate the new list behavior of replying to the sender instead of the list. C +1 there. I spammed Carl trying to reply and ask for feedback on alternatives suggested to OP Now from computer instead of phone

Re: [libreoffice-users] Additional KSSS for an Auction Question

On Fri, Jan 24, 2014 at 12:46 PM, Pikov Andropov piko...@gmail.com wrote: We would like the Kingsoft Spreadsheet (KSSS) to have the following columns: A. Name B. Amount of winning bid C. Code for item purchased D. Description of item purchased E. Starting bid We realize that D and E can

Re: [libreoffice-users] Writer record changes feature

Thanks for the thought. It's not quite as KISS as I'd like though. I haven't used MS Word for a while, when I did, this was available. It was possible to see a document in it's original form, with all edits displayed, or as if all edits are accepted. That function, or a close approximation, is

Re: [libreoffice-users] Writer record changes feature

On Thu, Feb 13, 2014 at 9:57 PM, Dale Rebgetz dale.rebg...@setec.com.auwrote: The way it works for me is if show changes is de-selected (after the changes have been made), then what I see is what you are asking for - the CHANGED document, not the original. Dale. Made me look Dale, you're

Re: [libreoffice-users] Writer record changes feature

The way it works for me is if show changes is de-selected (after the changes have been made), then what I see is what you are asking for - the CHANGED document, not the original. Dale. ...and p.s. sorry to get folks off on the wrong track. I was hurrying through an unfamiliar document and

Re: [libreoffice-users] Writer record changes feature

On Thu, Feb 13, 2014 at 10:54 PM, Brian Barker b.m.bar...@btinternet.comwrote: The option that is indeed present in (recent versions of?) Microsoft Word but missing in LibreOffice is the display of the original, unedited version of the document. But you kept a separate copy of that, didn't

Re: [libreoffice-users] Document Recovery window appears

On Tue, Feb 18, 2014 at 4:46 PM, Muriel Parker rspn...@gmail.com wrote: The Document Recovery window comes up every time I open LO. When I Start Recovery Recovery failed comes up. Closing out window I can continue with LO. I have uninstalled and reinstalled LO, but it is still happening.

Re: [libreoffice-users] Document Recovery window appears

On Feb 19, 2014 9:18 AM, Tom Davies tomc...@gmail.com wrote: Hi :) I thought he just meant the Escape key on the keyboard. It does about the same as the Cancel button within the dialogue-box itself I did mean the Esc key. And, at least on my system, it did make the always appearing Document

Re: [libreoffice-users] Calc - sort in to columns

On Wed, Feb 19, 2014 at 7:04 PM, IGraham gra...@lovatt.co.uk wrote: How do I sort out from a mixed list of membership types the email addressers into separate columns without gaps or 'false' or '0' appearing http://nabble.documentfoundation.org/file/n4098035/test2.ods I'm guessing from your

Re: [libreoffice-users] Application of Speadsheet

On Fri, Feb 21, 2014 at 3:05 PM, Pikov Andropov piko...@gmail.com wrote: Third phase is checkout. I was thinking of copying the spreadsheet as it existed after phase 2 to a second laptop so that people could checkout with last-names-A-through-M going to laptop 1 and N-Z, to laptop 2. The

Re: [libreoffice-users] Application of Speadsheet

Not sure you've gotten answers to your questions and whether the auction has come and gone and any answer is moot. If you still wish answers here are some suggestions I hope you might find helpful. On Fri, Feb 21, 2014 at 3:05 PM, Pikov Andropov piko...@gmail.com wrote: Attendees' names and

Re: [libreoffice-users] HOW CAN I CONVERT A NUMBER IN LibreOffice CALC TO TEXT IN LibreOffice CALC?

Dennis, It looks to me that you're asking how to convert a number to the words that are spoken to say that number. You've asked how to convert a number ... to text. People familiar with programming/macros and data types will read that and think of something different than creating the words to

Re: [libreoffice-users] HOW CAN I CONVERT A NUMBER IN LibreOffice CALC TO TEXT IN LibreOffice CALC?

On Tue, Feb 25, 2014 at 1:45 PM, Paul D. Mirowsky p_mirow...@bentaxna.comwrote: Please download and install http://extensions.libreoffice.org/extension-center/numbertext-1 Very nice. I've installed it. If I could change the extension (maybe I will try) I would make optional or remove the

Re: [libreoffice-users] HOW CAN I CONVERT A NUMBER IN LibreOffice CALC TO TEXT IN LibreOffice CALC?

On Tue, Feb 25, 2014 at 8:09 PM, James E Lang jim+...@lang.hm wrote: I believe the traditional way to write this on a check is, Thirty-five and 50/100 dollars Good point. That's certainly the way I've done it. And the word dollars is preprinted on the checks I've used so the program output

Re: [libreoffice-users] same calc sheet in 2 windows?

On Thu, Mar 6, 2014 at 4:20 PM, John R. Sowden jsow...@americansentry.netwrote: I have a calc sheet about 600 lines long with data at the top that I would like to see while I an using the data at, say line 400. Is it possible to open a second window showing the data at the top while editing

Re: [libreoffice-users] Calc worksheet stalls when opening

On Tue, Mar 11, 2014 at 9:21 PM, William Drago wdr...@suffolk.lib.ny.uswrote: I have a spreadsheet that stalls when I try to open it and when I try to save it. It does eventually open after a very long time. I Just looking for confirmation the issue is with only one particular spreadsheet?

Re: [libreoffice-users] Getting back to the Start screen

On Thu, Apr 10, 2014 at 2:25 PM, dollyp da...@lochnevis.com wrote: Is it possible to have a button on my toolbar that will bring back to start screen? If by start screen you mean you mean all program windows minimized so the desktop is shown just as it appears after logging on to the computer

Re: [libreoffice-users] Re: Getting back to the Start screen

On Fri, Apr 11, 2014 at 11:29 AM, dollyp da...@lochnevis.com wrote: What I am talking about is the start screen that appears when I start LO, the one with a graphic representation of recently opened files and access to templates and creating new documents etc. I tend to use a few files This

Re: [libreoffice-users] Re: [Sclug] (no subject)

On Sat, May 3, 2014 at 2:38 AM, David Lang da...@lang.hm wrote: googling for grub2 windows parition finds several pages that look promising http://askubuntu.com/questions/110698/add-windows-to-my-boot-menu suggests running update-grub and it should detect the windows partition. On Fri,

Re: [libreoffice-users] Can't get leading zeros in Calc

On Sat, May 31, 2014 at 7:34 PM, Oogie McGuire oog...@desertweyr.com wrote: I'm tearing my hair out here. I have a spreadsheet and the data was originally entered as 4 digits. I need to pass it to a database system that requires 6 digits. I've tried formatting with 2 leading zeros but I

Re: [libreoffice-users] How to ensure all new text entered into a document is different font, without changing the old font settings of the document?

On Sat, Jun 7, 2014 at 9:54 AM, quickbooks office quickbooks.off...@gmail.com wrote: How to ensure all new text entered into a document is different font, without changing the old font settings of the document? That is the document has questions in it, with lets say Times New Roman. When I

Re: [libreoffice-users]

On Wed, Jul 30, 2014 at 10:34 PM, Wanda Moore justme...@gmail.com wrote: I have tried to email questions, but they have never been responded to. I have been getting everyone else's emails, which is in the hundreds. I don't know why I haven't gotten through about my questions . . . . Please

Re: [libreoffice-users] MySQL native connector for LibreOffice 4.2 and 4.3 (Linux versions)

On Wed, Oct 1, 2014 at 10:22 PM, Dan Lewis elderdanle...@gmail.com wrote: I understand your problem. Accidentally, both links were to the same 32 bit connector because I became confused by the naming Nabble used for the two files. (I uploaded teh same file twice.) Here is the 32

Re: [libreoffice-users] LO Writer, how to insert horizontal line

On Sat, Nov 15, 2014 at 10:57 AM, William Drago wdr...@suffolk.lib.ny.us wrote: I'm trying to insert a horizontal line into my LO document. The help says: 1. Click in the document where you want to insert the line. 2. Choose *Insert - Horizontal Rule* Well, there's no Horizontal Rule under

Re: [libreoffice-users] LO Writer, how to insert horizontal line

On Sat, Nov 15, 2014 at 12:11 PM, Brian Barker b.m.bar...@btinternet.com wrote: At 11:45 15/11/2014 -0500, Alan Bonly wrote: Method 2 [Select Format|Paragraph, then the Borders tab, pick a top or bottom border, ...] suffers the same disadvantage if the border is specified as a bottom border.

Re: [libreoffice-users] Base Help Anyone

On Tue, Nov 18, 2014 at 6:35 AM, Alan Pedder alanped...@hotmail.co.uk wrote: I have been using Base to provide a database for my paintings via a simple form. I recorded 200 records and then added the facility to include a photograph .jpg file and this is when the gremlins started to

Re: [libreoffice-users] Base Help Anyone

On Tue, Nov 18, 2014 at 8:19 AM, Alan Pedder alanped...@hotmail.co.uk wrote: *Really appreciate your reply but unfortunately a lot of what you wrote is a bit over my level of knowledge and whilst I understand the terminology it did raise several questions i.e.1. Storing binaries refers

Re: [libreoffice-users] Re: And while I'm here, data extraction

On Wed, Feb 4, 2015 at 6:20 PM, Andreas Säger saege...@t-online.de wrote: Am 04.02.2015 um 01:26 schrieb Alan B: select * into text newfile' from Sheet1; Well, it's obvious. Isn't it? :-) when you put it that way. Gave me hope for a moment it was my error. Unfortunately I must have made

Re: [libreoffice-users] Re: And while I'm here, data extraction

On Thu, Feb 5, 2015 at 1:40 AM, CA Säger saege...@t-online.de wrote: Download this artbitrary database document with an embedded HSQLDB: https://forum.openoffice.org/en/forum/download/file.php?id=22304 Run this: SELECT * INTO TEXT exportTable1 FROM Table1 which creates exportTable1.csv

Re: [libreoffice-users] And while I'm here, data extraction

On Tue, Feb 3, 2015 at 6:55 AM, Mark Stanton m...@vowleyfarm.co.uk wrote: Having said all of that, is it ideal that the only way to get a data output from Base is C'n'P? No it isn't, not at all. Having used dBase, FoxPro, Paradox and Access and others I can attest that all had multiple result

Re: [libreoffice-users] Support options

On Wed, Jan 14, 2015 at 4:49 PM, dave boland dbola...@fastmail.fm wrote: I'm more than a little frustrated/angry at the support options for LO. Can't we find a way to offer support that is easy and convenient? I get Dave, I think easy and convenient is pretty much in the eye of the

Re: [libreoffice-users] Support options

On Thu, Jan 15, 2015 at 1:07 PM, dave boland dbola...@fastmail.fm wrote: What is easy and convenient? I thought I answered that. Quick to do, no reistration, no passwords, able to see the appends in a thred like Yes, you did say that before. I'm not familiar with a forum like that (esp the

Re: Re: [libreoffice-users] first step forward

On Wed, Mar 4, 2015 at 5:49 AM, anddos an...@neostrada.pl wrote: I work for medicine, to be precise, as an engineer active in the human ecosystem personal care. It makes me very satisfied, but I have to deal with quite a range of technological problems. That, explains maybe that I'd rather

Re: [libreoffice-users] first step forward

On Tue, Mar 3, 2015 at 8:24 AM, an...@neostrada.pl wrote: Thank you, Allan for the prompt reply, ... The sample is simply enough, I belive, so the point is how to proceed it to get output in several seperate SS or database tables, preserving the sequention in row position. Unfortunately I

Re: [libreoffice-users] database2spreadsheet

On Wed, Mar 4, 2015 at 4:59 AM, hw h...@gartencenter-vaehning.de wrote: how would I create a spreadsheet from a table in a database? I know I can copy and paste, and I want to avoid that. Basically, users should be able to click an icon in LO (or on their desktop) and be presented with a

Re: [libreoffice-users] Can the most up-to-date LO import and print pdfs?

On Thu, Feb 26, 2015 at 7:24 AM, Tom Davies tomc...@gmail.com wrote: Hi :) +1 I agree that dedicated programs that do 1 single task tend to be better for that task. I seldom have a problem with LO's rendering of Pdfs but that could easily just be luck. Perhaps not so much on luck as on

Re: [libreoffice-users] Can the most up-to-date LO import and print pdfs?

On Wed, Feb 25, 2015 at 10:42 AM, Lisi Reisz lisi.re...@gmail.com wrote: Can the most up-to-date LO import and print pdfs? Lisi - as suggested by V Stuart Foote using LO to print PDF may not provide the most accurate rendering. You don't say if you need to edit the documents. If editing is

Re: [libreoffice-users] Sortting ranges with merged cells

On Wed, Feb 25, 2015 at 10:47 AM, Lera Goncharuk lera.goncha...@gmail.com wrote: «Ranges containing merged cells can only be sorted without formats». This message implies that such ranges can be sorted without splitting cells. Lera - I believe this is a poorly worded information message. I

Re: [libreoffice-users] Sorting ranges with merged cells

On Thu, Feb 26, 2015 at 1:27 AM, Brian Barker b.m.bar...@btinternet.com wrote: At 18:45 25/02/2015 -0500, Alan Bonly wrote: On Wed, Feb 25, 2015 at 10:47 AM, Lera Goncharuk wrote: «Ranges containing merged cells can only be sorted without formats». This message implies that such ranges can

Re: [libreoffice-users] Large Database

On Thu, Feb 26, 2015 at 9:06 AM, Patrick pkh5...@comcast.net wrote: ok i am hours new to Libreoffice so hopefully i dont sound too off here.so i use a large database in access that has several tables that have 80-100k lines in them. iam looking for a way to have access to this database while

Re: [libreoffice-users] Unzipped opendoc files

On Tue, May 12, 2015 at 5:43 AM, Michel Kapel mkir...@gmail.com wrote: I seem to remember ... a long long time ago. It was possible to use an unzipped open-doc file (a directory) as a zipped one. So it was somehow possible to start-up open/libreoffice using as starting point one of the files

Re: [libreoffice-users] Show full content of a cell when selected [Calc]

On Fri, May 15, 2015 at 11:07 AM, Alichino smar...@yahoo.co.uk wrote: I have a cell with a large amount of text in it. I don't want to Wrap text automatically because that will expand the cell. Instead I'd like to keep the cell small, and only expand when it is clicked I don't know of a way

Re: [libreoffice-users] Sorting Calc Sheet in Alphabet orde on names in one Column

On Sun, Oct 25, 2015 at 4:48 PM, ajebay wrote: > I have a calc spreadsheet with many lines of data which include one column > with names for the line. > I want to sort the names from A to Z, top to bottom, and have all the > corresponding data in each line move with the

Re: [libreoffice-users] Digital signatures

On Sun, Oct 11, 2015 at 10:14 PM, Евгений wrote: > No one here used signatures? > No one can help or give some advices to resolve problem? > Sorry Евгений, I have only used self signed and only a few times. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org

Re: [libreoffice-users] Envelopes print in wrong orientation

On Mon, Dec 14, 2015 at 7:53 AM, Philip Jackson wrote: > When I dropped Windows for linux about 18 months' ago, I moved to > LibreOffice 4.2.8.2 and saw that LO Writer had inherited the same bug > from OO. > > My case involved a standard size European envelope to suit

Re: [libreoffice-users] Envelopes print in wrong orientation

On Sun, Dec 13, 2015 at 7:17 PM, wrote: > Im try to print 6x8 envelopes. The text prints perpendicular > to the > long edge instead of paralleled to it no matter what format I select in > the Insert Envelope wizard. I cant figure out what Im doing > wrong. >

Re: [libreoffice-users] how do i Link to External Data?

On Fri, Mar 11, 2016 at 12:07 PM, Beau Thompson wrote: > Hi All, > I like to use calc to pull data from a web page using Link to External > Data all videos are old > thanks for any help Hi Beau. "Insert > Link to External Data..." works for me. Select this menu option then

Re: [libreoffice-users] Calc as a Flat File Database

On Tue, Mar 8, 2016 at 8:02 AM, Ian Whitfield wrote: > So I was wondering if there is and Add-On or Extension available to give > you a "Form" to overlay the Spreadsheet so that you can view the data one > row at a time?? > Hello Ian - I don't know the particulars but

Re: [libreoffice-users] Re: Database help please

On Fri, Mar 4, 2016 at 3:13 PM, John Montgomery wrote: > Thank you to everyone who replied to my query, A01, A02 etc works, I am > very thankful for that. Now the problem to prevent duplication, I have > tried several ways but obviously what I am doing is incorrect as it

Re: [libreoffice-users] Help with extra space at bottom of pages.

Hello Leam, I suggest try the following... Open your document then... Ctrl+A This will select *everything* in the document Then right-click to bring up the context menu Click on the "Paragraph..." option In the dialog box that appears click the "Text Flow" tab At the bottom of this tab in

[libreoffice-users] How to display AutoFilter filter criteria?

When I set up a spreadsheet with AutoFilter I often insert a row at the top to show how many rows are displayed by the current filter, e.g. ="Rows displayed - " & SUBTOTAL(103,A3:A2) Now I'm trying to find a way to display the criteria used by the AutoFilter. e.g. "Rows displayed - " &

Re: [libreoffice-users] Can imported images keep the aspect ratio?

You haven't indicated which app you're using. If using Write, maintaining scale while resizing an image is the default when dragging the handles to resize. At least in version 5.4.5.1 it is. On Sat, Mar 10, 2018 at 8:38 AM, Anne Wilson wrote: > My 200+ entries can now

Re: [libreoffice-users] Inserting a Trademark Symbol in Label

The following won't help you see/find the symbol. It will however let you type it directly. Put your cursor where you want the symbol to appear then If using Windows (tested with Windows 10 and LibreOffice 6.2.2.2) - Type 2122 then Alt+X If using Linux - Ctrl+Shift+U and release, then 2122,

[libreoffice-users] Display criteria currently used in AutoFilter

When I use AutoFilter on a worksheet I often put a row above the filter to show how many rows are displayed or some other formula that updates dynamically as the filter is changed. It would be helpful at times to display additional information such as the current filter criteria. Is there a way

Re: [libreoffice-users] record durations, not time of day

If entered just as you've typed, it seems all the formats presume hrs, minutes, and seconds. Applying the time formats don't cause the display you wish because the "3" is presumed hours and the "5", minutes. Enter instead 0:3:5 Then this custom format should do: MM:SS displays 03:05 Available

Re: [libreoffice-users] Can't open LO Base file

Howard - I'm thinking you're finding the file and double-clicking it to open it in Base? If so the fact that the file name starts with file:///... and the message is the file can't be loaded, NOT it can't be found, has me thinking the file association is changed. If the file association has

Re: [libreoffice-users] Can't open LO Base file

> > Thanks for your help. > > Problem solved. > > Howard > > On Sat, 23 Nov 2019 at 10:11, Alan B wrote: > >> Howard - >> >> I'm thinking you're finding the file and double-clicking it to open it in >> Base? If so the fact that the file name st

Re: [libreoffice-users] LibreOffice Calc - Date - increase number times...

David, A follow up to my first reply. I wanted to investigate a bit more to see if I could produce a macro that actually incremented values in column B based on the corresponding cell in column D being changed. This works for me incrementing the value in col B by +1 when the value in column D on

Re: [libreoffice-users] LibreOffice Calc - Date - increase number times...

Hi David, As I understand it you have values in column B and dates in column D. When a new date is entered in a cell in column D or an existing date is changed you want the cell on the corresponding row in column B to increase by 1. e.g. B1 = 5, D1 = May 5, 2019 change D1 and B1 becomes 6. - or

Re: [libreoffice-users] Using Libre Writer - with hardware questions

More information please. What issues are you experiencing? What make and model laptop? On Fri, Jan 24, 2020 at 3:11 PM charles meyer wrote: > I like using Libre Writer but have been confounded with a hardware issue > with my laptop. > > Would anyone please suggest a knowledgeable forum where I

Re: [libreoffice-users] filter bank transactions and then sum

Meant this to go to the list as well (accidentally sent only to Jame on first reply)... Expanding on Regina's answer... I routinely use subtotal as she suggests. I insert a row above the rows of interest then put the subtotal formula above the column that I want to count or sum. Set the formula

Re: [libreoffice-users] full date string to date

James, The only way I could get the text sample you provided to be accepted as a date was to leave the day name off. Typing Wed, Jan 2, 2020 into a cell resulted in a cell that contained text. Typing Jan 2, 2020 into a cell resulted in a cell that contained a date in the default date format,

Re: [libreoffice-users] Problem with print dialogue

I'm not sure if there is any fix for size of the dialog. Other respondents have already indicated there is a bug report for the issue. The minimum recommended screen resolution is 1024x768. If your screen resolution is below this, resolution may be the problem.

Re: [libreoffice-users] cannot find and replace paragraph break in writer

Try using $ as your search term with the regular expression box checked. When I use \n to search it finds the ends of lines created with Shift+Enter. When I use $ to search it finds the ends of lines created with Enter. LibreOffice 6.3.5.2 on Ubuntu 19.04 On Thu, Mar 26, 2020 at 2:03 PM

Re: [libreoffice-users] Printing Many Columns

Charles, Calc or Excel will handle that. If all columns are not printed there are a number of possible reasons. Two I can think of: * the print range does not include all columns * the print range does include all columns BUT is not scaled to fit all columns on a single sheet AND additional

Re: [libreoffice-users] use calc 7 IF command to change some column values?

Dave, Not sure I'm following your intention but... This formula: {=IF(A1:A13>28,0,A1:A13)} puts the A column value in the corresponding row in column B if that value is less than 28, otherwise it puts 0 in the column B row. Note the curly braces surrounding the formula. These cannot be typed

Re: [libreoffice-users] use calc 7 IF command to change some column values?

, otherwise it puts 0 in the column B row. or, to state it the way the formula is written puts 0 in the corresponding row in column B if the value in column A is greater than 28, otherwise it puts the A row value in the corresponding B row. On Tue, Oct 20, 2020 at 7:03 AM Alan B wrote: > D

Re: [libreoffice-users] Calc: how do I?

Hello Dan, As far as I know, each table needs to be opened separately. That will open a separate Calc window with a tab for the table that was opened. The tabs can then be moved into a single spreadsheet by right-click the tab in one of the spreadsheets and selecting the "Move or Copy Sheet..."

Re: [libreoffice-users] version control of sorts: it is gone?

Hello Uwe, I'm using LibreOffice version 6.0.7.3. "Version..." is the ninth item on the "File" menu. I've done no menu customizations. On Wed, Jul 22, 2020 at 3:27 AM Uwe Brauer wrote: > > > Hi > > I swear I have seen a version control of sorts[1], maybe back in the old > days of

Re: [libreoffice-users] Printing 18 labels per sheet on Avery A4 sheet L7161

Hello John, re: [2] same label for all labels on page with other than the default formatting applied to all labels #1 File > New > Labels #2 Labels dialog, Labels tab -- -- Label text field : enter desired label text -- Brand: Avery A4, Type: L7161 Address #3 Click "New Document" button,

Re: [libreoffice-users] Copying data from Calc to Base...

Hello Zed, I haven't used 6.4 much yet except with already existing databases. With 6.0 (on Ubuntu) it was required that there be an auto incrementing index field or the import would fail with messages like you describe. If your ID field is not set to auto increment modify the field property so

Re: [libreoffice-users] Question on value comand and Err:502

Haven't found documentation to confirm but I believe your first example =value(1+1) is recognized as a formula, the formula is processed and the result converted to a value. It works for me if I enter =value(sum(1,1)) the cell displays 2 and =CELL("type",), pointed at that cell, displays v If I

[libreoffice-users] Re: Fit last column in spreadsheet to print

; I can’t even see how many pages this spread sheet is on as unlike Libre > Writer or Word there is no page indicator in either Calc or Excel. > > > > Thank you. > > > > Charles. > > > > From: Alan B > Date: Tue, Dec 22, 2020 at 3:40 PM > Subject: Re: [libreof

[libreoffice-users] Calc how to display Autofilter values? Not answered, maybe insight from Excel elicits answer

Many moons ago I was using some Calc sheets with AutoFilter routinely. The filter value would be changed, the sheet closed and sometime later opened again. To understand the displayed rows the filter values needed to be known. And that involved opening each filter and checking the value. So I

Re: [libreoffice-users] Calc how to display Autofilter values?

Not at all what I'm trying to do. Distinct values have their uses. But I already knew how to do that. I'm trying to display the AutoFilter values being applied to a table so they can be read without opening up each filter at the top of each column to see what the settings are. For example, three

Re: [libreoffice-users] Write Closed but Windows 10 won't provide safe to remove flash drive

When Windows displays that programs need to be closed, does it display any of the program name(s)? If yes, what is the name or what are some names? (If Paul's response fixed it, never mind.) On Sat, Mar 6, 2021 at 4:38 PM charles meyer wrote: > This is both a Writer question and a Windows 10

Re: [libreoffice-users] Scrolling too fast

Mouse scroll settings are controlled by one or both of the mouse program, e.g. Logitech programs for their mouse, and the operating system's settings. Libreoffice's mouse settings control mouse position and the effect of clicking the middle button, if present. They don't affect scroll speed. On

Re: [libreoffice-users] Lost files

Nick, LibreOffice would not have deleted any document, spreadsheet, etc files that you created. There aren't even options on the menus to perform those actions. Same for the LibreOffice installer, if a new version was recently installed. I have read recently of some Microsoft Windows updates

Re: [libreoffice-users] Reducing extra space in a jpg scanned in Writer

Your call, "quick/easy" Open Draw Drag image onto page Click the image From menu Format > Image > Crop Drag crop handles to desired position Press Enter to complete crop Right-click image, select Save... Click Yes Provide file name Change format (defaults to PNG) to JPEG if wish to keep same

Re: [libreoffice-users] How to print a section of a SS

I hasn't been mentioned if the OP is printing to PDF, and my bad for never reporting the bug, but using LibreOffice File>Export as PDF or the Export Directly as PDF icon causes EVERYTHING on all tabs to print to the PDF no matter what print range might be specified, no matter if the print ranges

Re: [libreoffice-users] extracting cell values

Hello Miss K. The result, 16.7, may be pasted into another cell using "Paste value". This will not paste the formula. If your result cell is displaying the formula and not the result then there is a Calc setting to change. Even if you are seeing the formula, using "Paste value" will paste the

Re: [libreoffice-users] Question

Default in LO 7.1.5.2 Security level High - Only signed macros from trusted sources allowed to run. Plus not 100% compatible with Excel. Excel VBA not likely to run in Calc. (Formulas are a different story. Much better cross product support.) On Wed, Oct 6, 2021, 7:36 AM sleepy wrote: > Does

Re: [libreoffice-users] Toolbar name in Libre Draw

View > Toolbars > Stardard displays the toolbar containing the Pilcrow on my LO 6.4.7.2 installation. I infer the name is "Standard" since if that toolbar is not checked the toolbar with Pilcrow is not present. Tools > Customize > Toolbars appears to be the way to identify the features set for

[libreoffice-users] where to submit enhancement requests?

I should know this but don't. How and where do enhancement requests get submitted? I recently came across UI features in Calc that are inconvenient and usability would be improved if they are changed. To illustrate the differences.

Re: [libreoffice-users] CalcGuide auto sum

Not sure if you've gotten the answer you're looking for. Others have mentioned enabling/disabling the automatic updating of formulas. If that's what you needed this isn't the answer you're looking for. Chapter 1 pg 20 of the 7.2 Calc Guide identifies the sum function as part of the formula bar

Re: [libreoffice-users] calc formula are displayed as ###

I see the same effect when the column is too narrow to display the formula. Display is If the column width is increased so the entire formula can be displayed, then the formula will be displayed. The fact that the formula does not display over adjacent empty cells, like text does, I would

Re: [libreoffice-users] Importing a row from a spreadsheet

Ian, if you reply, please reply to users@global.libreoffice.org, not my email. Thank you. I created a twelve (12) column spreadsheet, A to L, with two rows in Calc, then selected A1:L2, then copied and pasted it into Write. That had the same result as you described, columns disappearing off the

Re: [libreoffice-users] Help please with multipage document.

With the link, thank you, I see that opening the document always shows me a full screen view with thumbnails of all seven pages. If that is what you mean by "it opens to show 7 pages all at once and showing in the same window" then... Use the "View > Zoom" menu and select a page view that works

Re: [libreoffice-users] Help please with multipage document.

Which website? There are visitbritain . com and . org And what file name or document title? With the above info, others can attempt to open it and solve the problem. I've tried opening several .docx downloaded from the . org site. All opened with no issue in LO 6.4.x On Thu, Jul 6, 2023 at

Re: [libreoffice-users] text fields to time fields

wise it is used without adding hours. So finally if $2 is " p.m." calculate the time as TIMEVALUE(REGEX(A1,"(.*)( p.m.| a.m.)","$1"))+0.5 Otherwise calculate the time as TIMEVALUE(REGEX(A1,"(.*)( p.m.| a.m.)","$1")) Then format the cell with t

Re: [libreoffice-users] text fields to time fields

Select the text fields, hopefully they are in a column or columns. After selecting the fields select "Data > Text to Columns..." from the menu In the Text to Columns dialog box select the following options: For "Separator Options" tick "Separated by". The only separator option that should be

Re: [libreoffice-users] Writer- find and replace a number

Regular expressions (regex) are a challenge to get your mind around. Your need seems to be straight forward so there's not a lot to absorb to use regex for this case. Open the "Find & Replace" dialog. In the "Find:" field enter "[:digit:]" without the quotes. In the "Replace:" field put

Re: [libreoffice-users] Writer- find and replace a number

ered each individual digit is replaced by what is in the "Replace:" field. That is not because of [0-9] vs [:digit:] but because of the "+". Pick whichever meets your needs best. On Fri, Jun 30, 2023 at 6:04 PM Alan B wrote: > Regular expressions (regex) are a challenge

Re: [libreoffice-users] Adding hotkey

The hot keys mentioned are default operating system hot keys on Windows, since at least Windows 95, and on Ubuntu linux, since I don't know when. On Ubuntu the keyboard shortcuts can be found in Settings>Keyboard. The default settings can be changed there. In Windows, not sure where. Do the

Re: [libreoffice-users] Tab Settings

... sent original reply to OP only. My error ... To modify default tab stops in LO 7.6.x - Select Tool>Options - Open the "LibreOffice Writer" branch - Select the "General" option - In the Settings option - accept or select the measurement unit - then set the tab stop

Re: [libreoffice-users] LO 7.6 and Win7pro

Per the LibreOffice docs, https://www.libreoffice.org/get-help/system-requirements/, the current version runs on Windows 7. However Microsoft's KB3063858 update must be installed for it to work. On Sun, Nov 19, 2023 at 5:51 AM DaveB wrote: > > Original Message > From: Pat

Re: [libreoffice-users] Help - how to get rid of 'administrator'

Emily, The following presumes you use Windows. This is a test to attempt to isolate the problem... * Use a thumb drive (USB drive) , * create and save a file to the thumb drive (use Write, Calc, or whichever program you use most) * close the program used to create the file * eject the thumb

  1   2   >