The Linux Page

type

Add or subtract to a Time field in LibreOffice

Today I was working on a spreadsheet where I added a time for a calendar type of sheet.

What I wanted to do is have a column where time increases without having to type each time manually.

So I needed to add 15 or 30 minutes to the first time.

Say my first time is 7am, it appears as 07:00:00 AM.

In the next row (B4), I wanted to do something like:

=B3+"15 minutes"

The fact is that LibreOffice saves time and date as a double number where 1.0 represents 1 day.

So to add just 15 minutes, you need to divide your number by the number of minutes in a day:

=B3+15/60/24

Or if ...

Polylang messes up my canonical link on my website

UPDATE:

I reported this problem to the author who took a bit of time but ended up fixing the problem. If you still have a problem, you probably need to upgrade to the newest version.


I just created a new website and added a few plugins, one of which is Polylang. It generally works okay. Not what I really would like to have, but close enough for a Wordpress website.

Only, it has a horrible side effect:

I destroys the canonical URL which instead of appearing as expected appears with a "%pagename%" variable in it. This is because the module caches the results of a previous call ...

Display a line number in a table (i.e. subform of records)

I was ask by a customer to add line numbers to each entry in a table shown in an invoice.

The concept is pretty simple, but really, how do you do that properly in MS-Access?

Microsoft actually has a solution (see link below) and it comes down to writing a function that counts the number of items from that item's current position to the beginning of the table (i.e. going backward). It works, it is just really bad if you have very large invoices since it will tend to slow down as you start getting many items.

There is the function, we can see the counting in the do until near the end ...

Multi-level lists in MS-Word... The new way!?

Okay, it has been a little while now, but each time I just have to search forever to find out how to create a multi-level numbering list.

By default, a list will appear as this:

1. Chapter

    1. Section

        1. Sub-Section

Which may work for you, but in many cases you want to have all the list numbers appearing in your section and sub-sections as in:

1. Chapter

    1.1 Section

        1.1.1 Sub-Section

Okay, so that in itself it actually very easy, but it used to be that you could ...

Compile Qt 4.7.x with Visual Studio 10 (VC++ 2010)

Try to recompile Qt with Pavel's instructrions...

I did not encounter much problems, although the examples failed. It looks like jom would be the problem as some people reported not having problems following the same steps, but using nmake instead of jom.

The instructions go like this: [Update: the links below all stopped working.]

  1. Visual C++ 2010 contains all necessary SDKs for Qt compilation. However if you plan to use Qt with Phonon you need to install additional software from Qt for Windows Requirements list.
     
  2. Download and extract Qt 4.7.4 Sources. (Or Qt ...

OpenSSL commands working with certificates

The following are some commands I use to read certificate and otherwise work with OpenSSL which I otherwise find somewhat difficult to use.

To read a certificate, you use the -text and -noout to get the result in stdout. Use the -in to specify the

openssl x509 -text -noout -in server.pem

The first parameter is the type of of key. I'm not sure where you should use what, but in general you can use x509 (csr file) and rsa (rsa files). I'm not too sure why they cannot just detect what's what...

Getting rid of the new Overlay Scrollbars (Invisible Scrollbar feature)

As I upgraded from Ubuntu 10.04 to 11.04, I got a bit of a surprise... many system windows started using a new type of scrollbar that is pretty much unusable (at least it slows down my production time on my desktop.)

Yes, these invisible scrollbars (which they call Overlay Scrollbar) are... invisible. Now you have to hover the mouse at the right place to get arrows that you can grab and move up and down. Oh! Did I say that you have to however in one place and these arrows, on purpose, appear AWAY from your mouse? This means you need to then move the mouse over those arrows before you can

C printf(3) for int, long and long long that works every time

Of Note: This only applies to C99, not C++.

I learned something quite interesting today and wanted to keep a note of it.

Whenever I use a printf() with a format such as %ld and try to compile my code on "many" different platforms, I often get warnings on another one.

The fact is that an int, a long, a long long, an int32_t, int64_t all use a different combination depending on your platform and whether you're running in 32 or 64 bit.

So, the answer to this problem are the #define found in the inttypes.h header file:

PRId8
PRId16
PRId32
PRId64

These entries are used after

The Expression On Load you entered as the event property setting produced the following error: User-defined type not defined

Problem

A few days ago, I made many updates in one of the MS-Access forms I'm working on.

Then, when I tried to open the form I'd get this error...

The Expression On Load you entered as the event property setting produced the following error: User-defined type not defined

This doesn't mean anything to me since I did not define any type... Removing the Form_Load function (commenting it out) made that very error go away, however, since that's the sub-form of another form, it still generates errors when the main form is trying to initialize the sub-form.

Note that it ...

Apache misconfiguration: AddType versus AddEncoding

I've been using Drupal for a while and only now started to notice a problem with the cache of JavaScript code. In general, I don't cache the JS since they are not dynamic files. But we do that with Snap!.

The Apache mime module offers two options: AddType and AddEncoding

Both options are used in a similar way meaning that both react on file extensions. When a match is found, the corresponding MIME type or content encoding is attached to the content being sent.

If you install the MIME module, it will attempt encode data properly for the most general case, but not all cases. That is, it does

Syndicate content Syndicate content

SMS From Me Logo

SMS From Me

To automatically start one on one conversations with your online leads.

     

   

Terms of Site Index

Find the page/content you are looking for with our index.

  • Bill Gates
    The person who created Microsoft with a few friends. Multi-billionaire, he lives in Richmont Washington and has been the CEO of Microsoft for a very long time. He's now just a Chairman.
  • router
  • rsync
  • space
  • top