Frage stellen

TJ Meneses's Profil - Aktivität

2017-07-13 11:30:42 +0100 Als beste Antwort markiert Can I make custom categories for my captions?

The caption function in Writer is amazingly useful, and combined with indices such as Index of Tables and Table of Illustrations increased my productivity infinity-fold (previously had to do all that manually; not an activity to do if you like to sleep during thesis terms).

However, I was wondering if there was any way to make your own, the same way you can make custom Styles. I want to have a category for Figures instead of Illustrations, and I have to trade off productivity and proper formatting (in some courses in college, the label of such things like "Figure" is strictly applied).

2016-11-13 07:00:22 +0100 verliehene Abzeichen  Sehr gute Frage (Quelle)
2016-03-03 18:39:07 +0100 Als beste Antwort markiert How do I change the page count in Writer?

I'd like to use a Title Page style for my first page. I would also like to put a "page # of #[total]" in the footer. So far, it seems the two use cases are mutually exclusive.

If I go for the Title Page style, my page count includes the 2 additional pages it inserts into my document (Title + hidden blank page for printing), inflating the count. If I want to add other pre-body content like a Table of contents, it inflates further.

On the other hand, If I want an accurate page count, I must sacrifice having any pre-body content. Title page would have to be separate, as well as Table of contents, which I don't want 90% of the time.

Is there a simple solution to modifying or offsetting the page count in Writer?

EDIT: Tried using sections to see if it would somehow change the page numbering as per a proposed workaround, but no luck. Attached the files used to test this.

test1.odt - test2.odt - test3.odt

2016-02-28 20:27:43 +0100 Als beste Antwort markiert How do I insert named ranges in charts?

I've been working on a series of spreadsheets with the same type of data (they're outputs of benchmarking data for my videocard), and have been experimenting on how to streamline my workflow.

I've recently attempted to make named database ranges for each of my 10,000's-of-rows data columns in lieu of manually selecting them for the data selection part of the chart wizard. Alas, it seems it's not as intuitive as I first thought.

How can I make use of the named ranges I made to easily plug into a new chart? Is it even possible?

2015-11-25 13:48:02 +0100 Als beste Antwort markiert Can I access a list of recent documents longer than 10 entries?

Just a simple yes or no question, really, but it's something that piqued my interest. Bonus points if there's a counterpart to web browsers' History page for LO, which you can edit and clear out and have all that other functionality. Otherwise, perhaps a log exists which LO makes to keep track of documents history.

2015-11-02 00:27:25 +0100 Als beste Antwort markiert Does the UI support high DPI?

Just curious if Libreoffice supports UI scaling for high-DPI monitors. Does it, and is there an option to adjust it manually?

2015-10-26 22:20:31 +0100 Als beste Antwort markiert How do I enable the global menubar in LO 3.6.3?

From what I understand, 3.6.3 has the notable feature of implementing built-in global menu support for Ubuntu. Currently, I'm using 12.04 LTS and have manually installed the DEB files (since neither the official repositories nor the PPA has it yet). After installing, the menu bar is still in the window instead of showing up as a global menu. Restarting does nothing, either.

Did I misread the release notes? Is built-in global menubar support not currently possible with the LTS release of Ubuntu? If it is possible, what specific steps must I do to get it working (without upgrading to 12.10)?

2015-10-22 16:03:21 +0100 verliehene Abzeichen  populäre Frage (Quelle)
2015-10-22 16:03:21 +0100 verliehene Abzeichen  Elementare Frage (Quelle)
2015-10-22 16:03:21 +0100 verliehene Abzeichen  Bemerkenswerte Frage (Quelle)
2015-10-15 06:03:17 +0100 verliehene Abzeichen  populäre Frage (Quelle)
2015-10-15 06:03:17 +0100 verliehene Abzeichen  Bemerkenswerte Frage (Quelle)
2015-10-15 06:03:17 +0100 verliehene Abzeichen  Elementare Frage (Quelle)
2015-04-17 10:09:14 +0100 verliehene Abzeichen  populäre Frage (Quelle)
2015-04-17 10:09:14 +0100 verliehene Abzeichen  Bemerkenswerte Frage (Quelle)
2015-04-17 10:09:14 +0100 verliehene Abzeichen  Elementare Frage (Quelle)
2014-12-23 12:21:25 +0100 verliehene Abzeichen  Fragen (Quelle)
2014-12-23 12:21:17 +0100 Als beste Antwort markiert What does the updater do?

I understand that LO 3.5 implements (or re-implements) an updating mechanism. It sounds like a cool concept, but I haven't seen anything that details just how it works or what it's supposed to do. Does it just pull the latest binaries/installers from TDF servers? Does it download patches that can be applied to the current installed build to bring it up to date (which would be an excellent use of the feature)?

If ever there is full documentation for how the feature works, can someone please tell me?

2014-04-21 15:32:04 +0100 verliehene Abzeichen  Bemerkenswerte Frage (Quelle)
2014-04-21 15:32:04 +0100 verliehene Abzeichen  populäre Frage (Quelle)
2014-04-21 15:32:04 +0100 verliehene Abzeichen  Elementare Frage (Quelle)
2014-02-10 20:36:09 +0100 verliehene Abzeichen  Sehr gute Frage (Quelle)
2014-01-18 06:33:27 +0100 verliehene Abzeichen  Elementare Frage (Quelle)
2014-01-03 13:24:26 +0100 verliehene Abzeichen  Bemerkenswerte Frage (Quelle)
2014-01-03 13:24:26 +0100 verliehene Abzeichen  Elementare Frage (Quelle)
2014-01-03 13:24:26 +0100 verliehene Abzeichen  populäre Frage (Quelle)
2014-01-02 20:55:18 +0100 verliehene Abzeichen  populäre Frage (Quelle)
2014-01-02 20:55:18 +0100 verliehene Abzeichen  Bemerkenswerte Frage (Quelle)
2014-01-02 20:55:18 +0100 verliehene Abzeichen  Elementare Frage (Quelle)
2013-10-27 22:12:28 +0100 verliehene Abzeichen  Elementare Frage (Quelle)
2013-10-18 00:36:11 +0100 Als beste Antwort markiert How do I set a keyboard shortcut to saving a version?

Simple question. I'd like to do something like Ctrl+Alt+S (or really, just using Ctrl+S itself) to save a version, so that I don't have to a) manually use the dialog box every time or b) Close->Save using the "automatic" versioning feature in LO (can you hear the sarcasm dripping from my quotes?).

Pointing me in the right direction would be great; gimme step-by-step instructions, and I'll mark you as the correct answer.

2013-10-18 00:35:27 +0100 Als beste Antwort markiert How can the Title Page be configured so as not to insert a blank page?

How do I get rid of the hidden blank page in Writer when I convert/insert a Title Page style in my document? I find it absolutely annoying. Not only does it make me waste a page when printing, which I could live with, but it distorts my page numbering and makes me work around it by resetting it in the first line of the first non-title page.

2013-10-18 00:32:14 +0100 Als beste Antwort markiert Which MS Office file formats have better compatibility with LibreOffice?

Wish all I can that ODF was the ubiquitous document format used in my university, it's not. MS Office dominates all office and student work. What I'd like to know is this; which format should I use when exporting my LO-created files to ensure the highest compatibility with, say MS Office 2007, and vice versa?

This is a catch-all kind of question. I expect that the answers might differ between applications e.g. Writer works best with 2007, but not Calc. The more comprehensive your answer to my question is, the more I'd appreciate it.

EDIT: Although I've selected an answer, I'd still like to know if there are certain cases (or certain features) where saving to the newer "open" OOXML formats provide better compatibility than .doc/.xls/.ppt.

2013-10-18 00:30:12 +0100 Als beste Antwort markiert How does the "always save version when closing" under File -> Versions work?

I just discovered the versioning feature of LibreOffice, and it sounds amazing. I love the idea of persistent (and trackable) document versions, which is one of the few advantages I see in Google Docs that LO doesn't have.

What I'd like to know is how the auto-versioning option under the Versions dialog box works. The Help page it sends me to when I click on the "Help" button gave me an answer, but when I made changes to my Writer document and closed without saving like it recommends, a new version was not created.

2013-10-18 00:27:39 +0100 Als beste Antwort markiert Where is Draw's fullscreen mode?

I just tried using the keyboard shortcut for fullscreen (which works in Writer and Calc) while editing a Draw drawing, and discovered that it doesn't do anything. I checked the View menu, and there isn't any "full screen" entry anywhere.

What shortcut do I need to press in order to make the LO Draw window fullscreen? Does it even have this feature, and if not, why not?

2013-10-18 00:24:56 +0100 Als beste Antwort markiert How do I make captions show on top?

Pretty much what the title asks. All captions with the exception of Table have a greyed out and locked display setting, namely to show on the bottom of a figure. However, all of my courses tell me that the correct orientation of such labels must be on top.

Is there any way for me to "unlock" the option to put captions on top?

2013-10-18 00:24:04 +0100 Als beste Antwort markiert Is anyone working on better Windows 7 taskbar integration?

I'm sure it's not just me, but one of the things that really frustrate me is how badly LibreOffice windows are being represented on the Windows 7 taskbar. Whatever the initial LO document is opened, that icon will be used to represent (and group) all other open documents, regardless of their filetype.

I'd just like to know: is there anyone just as frustrated at me with it, and has much more programming knowledge to actually work on it? Does anyone else even care about it, or am I an outlier?

2013-10-18 00:23:47 +0100 Als beste Antwort markiert Does Calc have a summation function?

I apologize if this question is pretty straightforward and possibly common knowledge, but I've been trying to google it in as many permutations of the question as my brain can allow, and I have not seen a single straightforward answer to this. The only real reference of LibreOffice even having an actual summation (not sum) feature is in Math, which is strictly notation.

Let me kindly clarify my question: I am not asking whether there is a SUM function (that is definitely common knowledge); I am asking whether or not there is a SUMMATION function (i.e. sum [expression] from i=a to b) in Calc.

If there is, kindly refer me to the correct formula/documentation of the function. If not, well... bummer. I'm having trouble finding this function in Excel as well, but a colleague mentioned it did have this, which is called through ADDSUM() or something. I wouldn't know; I'm a faithful user of Calc.

Edit: I suppose my question is still a little vague, or at least the details of what I'm trying to look for, so I'll make an example with a hypothetical function I'll call SUMM(). This function would receive 4 arguments, which is the same number of terms you need to input in the summation formula in Math.

Regarding the arguments. First, there would be the expression to be used, for example "5+6*i", where i is the variable you'll use to define your range. Second would be the letter you used in your expression, in this case "i". The third and fourth arguments would receive the lower and upper bounds of the range of values of i, respectively.

The format of the hypothetical function would look something like SUMM(expression,variable,lower_bound,upper_bound). It could link to other cells for certain values or references of the expression, but can also calculate a value without any references, given you supplied it with the proper information.

I hope I made my question clearer.

2013-10-18 00:23:47 +0100 Als beste Antwort markiert How is the highlight color of a text style edited in Writer?

I just recently had a problem with my Text Body style in one document. It unfortunately appears to have been modified without my knowing, and now when I use it for text within that document, it becomes italicized, the font turns light gray, and the highlight color is green (instead of the default invisible).

By editing the style, I could return the font color back to black and remove the italics, but there's one thing option I couldn't find in the dialogue box: highlight color. Sure, there's background color, but it's completely different (not that I didn't try to change the highlighting using that option).

Where's the option to change highlight color?

2013-10-18 00:20:20 +0100 Als beste Antwort markiert Why is a file uneditable while saving?

This has always kind of bugged me, but how come LibreOffice locks down whenever a save cycle happens? It doesn't really matter when saving takes a blink of an eye, which is usually the case for smaller documents, but it becomes very inconvenient when saving much larger files, regardless of the application used (although I've had the most experience with Writer).

What is it that happens during a save, and how necessary is it to lock the user out while it's being performed? Is there anyone else concerned with this, or is any work being planned towards alleviating it? I'd like to again point to Google Docs as a really good example of how saving can be done; you can work and save in parallel, without any loss of functionality or performance.

2013-10-18 00:11:55 +0100 Als beste Antwort markiert Is there an automatic sort function in Calc?

I've been wondering about this for quite some time, because some of my uses of Calc requires me to input data and then sort it right after. I've been looking around the internet and various other boards for a good answer, but the lack of a straightforward solution implies that the ultimate answer is "no".

Still, if anyone knows of a specific function I could apply to a list of data that will keep it autosorted after I've typed my data, I'd really like to know. Two possible use cases of an automatic sort function would be: a) the list I'm typing into is the one being automatically sorted, and b) the data in the list is copied into another list, perhaps into another sheet, and autosorted there.