We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

kasloman's profile - activity

2021-02-10 13:44:42 +0200 marked best answer BASE REPORT WRITER How to add the Total of a column in footer

I am basing a report on a number of fields, some of which I want totals on. Is there any way to add a sum(field) to the footer of the report. Like adding a calculated field.

image description

It seems to me it takes two queries to do this, but how do you base a report on two queries?

Thanks for help, R

2020-12-11 19:16:27 +0200 received badge  Famous Question (source)
2020-11-24 13:54:27 +0200 received badge  Famous Question (source)
2020-11-23 11:09:33 +0200 received badge  Notable Question (source)
2020-11-23 00:22:02 +0200 received badge  Popular Question (source)
2020-11-22 23:25:39 +0200 received badge  Famous Question (source)
2020-11-22 20:33:54 +0200 asked a question How do you edit .PHP files

How do you edit .PHP files I tried to edit a .php file in "Writer" and it ran the code. How do you edit these files? R

2020-10-25 19:07:05 +0200 received badge  Famous Question (source)
2020-10-25 19:07:05 +0200 received badge  Notable Question (source)
2020-10-25 19:07:05 +0200 received badge  Popular Question (source)
2020-10-01 15:36:45 +0200 received badge  Famous Question (source)
2020-09-27 08:43:59 +0200 received badge  Notable Question (source)
2020-09-27 02:54:03 +0200 commented answer How to increase font size in LibreOffice 6.4 Menu

I don't know what created the above mess. strong textIt looked good when I wrote it!!!!

2020-09-27 02:51:02 +0200 commented answer How to increase font size in LibreOffice 6.4 Menu

I use Ubuntu 18.04.6 with MATE desktop Try to increase the view ratio in the operating system. How do you do this??? H

2020-09-25 01:48:09 +0200 commented question How to increase font size in LibreOffice 6.4 Menu

Sorry, I use Ubuntu 18.04.6. Still haven't figured this out!!!!

2020-09-21 10:25:30 +0200 received badge  Popular Question (source)
2020-09-20 20:49:12 +0200 asked a question How to increase font size in LibreOffice 6.4 Menu

How to increase font size in LibreOffice 6.4 I just installed LO 6.4 on a Dell LatitudeE6510 laptop. If I open LibreOf

2020-09-07 13:38:38 +0200 received badge  Famous Question (source)
2020-08-04 08:49:14 +0200 received badge  Notable Question (source)
2020-08-03 21:10:37 +0200 received badge  Popular Question (source)
2020-08-03 20:46:41 +0200 commented question How to fill blank cells in range with NULL

I am trying to produce a csv file suitable for MySql to import. As an example to follow I exported a tables data from My

2020-08-03 20:46:41 +0200 received badge  Commentator
2020-08-03 19:16:00 +0200 asked a question How to fill blank cells in range with NULL

How to fill blank cells in range with NULL I have a csv file with 30 fields and 500 rows with many blank cells. I create

2020-07-20 11:35:47 +0200 received badge  Notable Question (source)
2020-07-20 04:22:18 +0200 received badge  Popular Question (source)
2020-07-20 00:53:04 +0200 commented answer How do I properly import CSV data into a SQLite DB ...

I don't think that will work if you have blank fields in the midst of full ones. How does one update a PHP program to ig

2020-07-19 18:54:30 +0200 edited question How do I properly import CSV data into a SQLite DB ...

How do I properly import CSV data into a SQLite DB ... I am writing a program in PHP which reads a CSV file produced by

2020-07-19 18:50:09 +0200 asked a question How do I properly import CSV data into a SQLite DB ...

How do I properly import CSV data into a SQLite DB ... I am writing a program in PHP which reads a CSV file produced by

2020-07-19 16:46:59 +0200 received badge  Popular Question (source)
2020-07-18 21:54:35 +0200 asked a question how do you get ALL fields in csv to be double quoted - even blank flields - like "". SQLite will not import ,, must be ,"",

how do you get ALL fields in csv to be double quoted - even blank flields - like "". SQLite will not import ,, must be ,

2020-07-16 03:15:15 +0200 commented question How to Convert "John;Smith" to "Smith;John"

Where do you get the information on REGEX to do this REGEX(A1;"([^;]);(.)";"$2;$1";"g") or Find: & replace. The help

2020-07-15 13:32:48 +0200 received badge  Notable Question (source)
2020-07-15 10:03:45 +0200 received badge  Popular Question (source)
2020-07-15 05:58:56 +0200 asked a question How to Convert "John;Smith" to "Smith;John"

How to Convert "John;Smith" to "Smith;John" The Text functions don't seem to have the oomph to do this. I looked up spl

2020-03-11 09:56:01 +0200 received badge  Notable Question (source)
2020-03-11 05:48:00 +0200 received badge  Popular Question (source)
2020-03-11 01:57:57 +0200 marked best answer Convert this '45.87' text to number

Using TYPE(), this '45.87' is text (2) in cell G3.

VALUE(G3) returns a blank.

The cell was created by LibreOffice Calc loading a phpmyadmin Excel style .csv file and converting all the double quotes to single quotes ( " to ' ). I need to convert all these ' Amount ' cells to numbers.

Thanks R

2020-03-10 23:40:54 +0200 received badge  Notable Question (source)
2020-02-08 01:21:37 +0200 received badge  Notable Question (source)
2020-02-08 01:21:37 +0200 received badge  Famous Question (source)
2019-12-12 10:08:26 +0200 received badge  Notable Question (source)
2019-12-06 02:24:44 +0200 marked best answer Trouble merging cells - all end up in one line

Hi,

C:\fakepath\mergeCells.png

As shown above I am trying to merge cells so that the results are : same number of rows with the * attached to the left side of the field in each row.

As shown below what I get is the last row containing all fields merged properly but in one long string.

C:\fakepath\mergeCellsResult.png

To get what I want I would have to merge each row of two columns. Is there a setting I don't know about??