Ask Your Question

Michael Fontaine's profile - activity

2018-05-18 03:47:44 +0100 received badge  Teacher (source)
2018-05-18 03:47:44 +0100 received badge  Self-Learner (source)
2015-08-17 07:24:21 +0100 commented answer Text link to a paragraph

When I insert the hyperlink, it changes my highlight text to the name of the bookmark. How do I preserve the original text?

2015-05-18 14:23:29 +0100 received badge  Famous Question (source)
2015-05-16 01:11:10 +0100 received badge  Notable Question (source)
2015-05-15 23:34:48 +0100 received badge  Famous Question (source)
2015-05-15 23:34:21 +0100 answered a question How do I determine what color a Calc cell is?

Although it won't tell you what the actual color is, the easiest solution appears to be to copy a cell that has the desired color, then select the cells you want to give that color, and then do Edit > Paste Special > "Formats", making sure no other checkboxes are selected (normally this requires de-selecting a few of them). Unfortunately, if there is any other formatting such as number formatting or borders that will have to be re-done, but in my case I merely needed to set the number format correct again, and everything was back to a uniform color.

2015-05-15 23:31:53 +0100 commented answer How do I determine what color a Calc cell is?

so... requires some knowledge of macros and can't be done directly through the UI then?

2015-05-02 14:47:41 +0100 received badge  Popular Question (source)
2015-05-01 18:23:17 +0100 asked a question How do I determine what color a Calc cell is?

I created a spreadsheet and am trying to continue the color scheme I was using, but I can't figure out what color I was using for a particular cell. If I look at the cell properties it shows me the actual color, but doesn't tell me what it's name is or otherwise indicate what the color is. I can't seem to find this color in the palette provided when I try to set the background color of a cell, and it isn't showing it in previously used colors (not sure it was created on the same machine or version of LibreOffice.)

How can I determine the color I used so I can re-use it in other places?

2015-04-09 07:04:17 +0100 received badge  Scholar (source)
2015-04-09 07:02:56 +0100 received badge  Notable Question (source)
2015-04-08 19:43:34 +0100 asked a question Can't sign in using Google or upvote/accept/comment

I can't find a "meta" version of this site like StackExchange has, so hopefully it's okay to post this question here.

Today I find that I am no longer able to log in through Google like I previously could. When I go to the sign-in page and click on the Google icon, nothing appears to happen. Closer examination reveals that the page actually reloads producing an identical look.

In the javascript console I see a LOT of errors:

Uncaught SyntaxError: Unexpected token !
(index):289 Uncaught ReferenceError: $ is not defined
(index):344 Uncaught ReferenceError: $ is not defined
jquery.validate.min.js?v=20:16 Uncaught ReferenceError: jQuery is not defined
jquery.openid.js?v=20:9 Uncaught ReferenceError: $ is not defined
(index):446 Uncaught ReferenceError: $ is not defined
(index):453 Uncaught ReferenceError: cleanUrl is not defined

So the site is broken? I had to "recover" my account to be able to log in, as I don't have any other login methods other than through Google.

A bit further poking around when logged in via the "recover" option - I don't seem to be able to upvote helpful answers, or accept, or comment on them.

2015-04-08 14:08:46 +0100 received badge  Popular Question (source)
2015-04-08 08:25:18 +0100 answered a question Calc messing up formulas

First, set up all the formulas the way you want them. For instance, for a running balance column, create the first formula, then copy and paste it down the column as far as needed.

Select all the cells with formulas to fix, and navigate the menus to Edit:Find and Replace.

Search For: \$?([A-Z])\$?([0-9]+)

Replace With: \$$1\$$2

Other Options:

Check "Current selection only"

Check "Regular Expressions"

Search in: "Formulas"

Now click the "Replace All" button.

What this does: all cell references get prefixed with "$" which prevents the reference from being changed. The "\$?" before the column and row sub-regex ensure that if the dollar already exists it won't get duplicated. For instance, "B156" gets changed to "$B$156", but "$B156" also gets changed to the same thing.

2015-04-08 07:42:05 +0100 asked a question Calc messing up formulas

How do I prevent Calc from changing formulas when I move, insert or delete cells or rows?

Example:

  1. Open/Create a new sheet.
  2. In B2, enter value of 1.
  3. In B3, enter value of 2
  4. In A1, enter formula =B2+B3
  5. Cut B2 and paste in B1.

Suddenly, Calc updates the formula in A1 to =B1+B3!

A similar thing happens if I insert a row: Calc adjusts every since formula that references the old row in order to prevent the calculated value from changing.

Similar to this question, except that deals only with formulas changing when sorting occurs. That is not what I am concerned about.

Here's why this is a big problem: I use Calc to balance various account balances, with accounts running columns and dates of the months running down rows. I initially have transactions I expect to occur, but whenever an unexpected transaction occurs, I need to insert a new row. But unless I go through and verify every individual formula in each balance column, inevitably the formula gets all messed up. Obviously this is a big balance if I rely on the projected future balance to make sure I don't overdraw my account due to the formula being wrong because Calc changed it and I failed to catch it. (Copying and pasting a known good formula is the most reliable, but isn't foolproof because I have different formatting and monthly value resets which prevents me from doing a blanket copy/paste down the whole column.)

Update:

The problem is a bit trickier than simply preventing Calc from changing a formula. This can be accomplished as follows:

First, set up all the formulas the way you want them. For instance, for a running balance column, create the first formula, then copy and paste it down the column as far as needed.

Select all the cells with formulas to fix, and navigate the menus to Edit:Find and Replace.

Search For: \$?([A-Z])\$?([0-9]+)

Replace With: INDIRECT("$1$2")

Other Options:

Check "Current selection only"

Check "Regular Expressions"

Search in: "Formulas"

Now click the "Replace All" button.

But this only protects against the formula from changing if a cell it references moves. If a row is inserted, not changing the formula is incorrect as well. For instance, suppose I have a running balance, where column A contains the balance, and column B contains the transaction amount. Suppose that the formula for B147 is "B146+C147". If I insert a row between row 146 and 147, shifting 147 to 148, then "B146+C147" (an unchanged formula) is wrong because it no longer gives the correct balance in the correct spot. But if the formula isn't protected, Calc changes the formula for B148 (formerly B147) to "B146+C148". THIS IS WRONG TOO! It totally ignores the new row 147: the formula needs to change to "B147+C148", and the new B147 needs to get "B146+C147" which is the original formula for B147. Trying to keep ... (more)

2015-03-18 04:33:25 +0100 commented answer How to move columns/rows in Calc?

Under OS X, I can't seem to find any modifier keys that results in the original column being removed. It either copies to the new column, or else it creates a new column with the data and leaves behind an empty column.

2015-02-02 20:20:38 +0100 received badge  Supporter (source)
2014-03-20 12:01:02 +0100 received badge  Famous Question (source)
2014-01-05 18:25:15 +0100 received badge  Notable Question (source)
2014-01-05 18:25:15 +0100 received badge  Popular Question (source)
2013-11-19 22:13:24 +0100 received badge  Student (source)
2013-11-19 21:11:03 +0100 received badge  Editor (source)
2013-11-19 20:55:48 +0100 asked a question How do I Import a pdf to a presentation?

When I import the PDF, it imports it into a 43 page Draw document. The import is a bit wonky, for instance, lines of text consist of a single vertical text element spanning the nearly entire page height for each character, but at least it is editable. However, I want to make a presentation out of this, and I have not been able to find any way to do this. The only suggestion I have found is to "copy" to Impress, but I'm not sure how this would work for 43 pages of mixed text and images.

edit: Ok, it appears that it really is as simple as copy and pasting, which really isn't that simple for a large document, as it is necessary to copy the page, switch to the other document, paste, move the selection to tell it whether or not to adapt the objects (whatever that means), hit enter to do it, switch back to the other document, and repeat, for every single page in the document. Is there any easier way than this?