Ask Your Question

Lew Merrick's profile - activity

2020-03-15 06:49:19 +0200 received badge  Famous Question (source)
2019-07-26 22:14:18 +0200 answered a question "match" (in CALC Version: 6.2.2.2 (x64)) is not working right...

Yes -- I aman idiot! I left off the Exact Match 0 from my Match call. What mind???

2019-07-26 19:17:57 +0200 asked a question "match" (in CALC Version: 6.2.2.2 (x64)) is not working right...

"match" (in CALC Version: 6.2.2.2 (x64)) is not working right... I am building a rather large and complex "design projec

2018-06-01 12:56:55 +0200 received badge  Self-Learner (source)
2018-06-01 12:56:55 +0200 received badge  Teacher (source)
2018-06-01 12:55:52 +0200 received badge  Popular Question (source)
2018-05-26 15:07:52 +0200 edited answer Why cannot Calc 5.4.6.2 SaveAs Excel when "Validity" commands are involved?

OK, after more effort than I had imagined, it turns out that using Cell Ranges rather than Range Names solved my problem

2018-05-26 15:06:40 +0200 answered a question Why cannot Calc 5.4.6.2 SaveAs Excel when "Validity" commands are involved?

OK, after more effort than I had imagined, it turns out that using Cell nRanges rather than Range Names solved my proble

2018-05-10 18:38:03 +0200 asked a question Why cannot Calc 5.4.6.2 SaveAs Excel when "Validity" commands are involved?

Why cannot Calc 5.4.6.2 SaveAs Excel when "Validity" commands are involved? I use "Validity" extensively. When "Validit

2018-05-04 20:32:47 +0200 received badge  Popular Question (source)
2018-05-03 20:40:05 +0200 asked a question Cacl Version 6.0.3.2 Is there a "fix" for SaveAs xlsx or xls?

Cacl Version 6.0.3.2 Is there a "fix" for SaveAs xlsx or xls? I updated Libre Office to V 6.0.3.2 a week oir so ago. Wh

2018-03-11 20:29:00 +0200 answered a question create drop down list in forms

I am not sure I can answer this as clearly as you might like, but the process is called Validity. You essentially creat

2018-02-16 22:36:27 +0200 asked a question I am running "Calc V5.6.3.2" and want to use "left offset 6 Pts" and it fail (to a 15 pt offset). What am I doing wrong?

I am running "Calc V5.6.3.2" and want to use "left offset 6 Pts" and it fail (to a 15 pt offset). What am I doing wrong

2017-12-13 23:53:45 +0200 received badge  Famous Question (source)
2017-12-10 22:29:50 +0200 answered a question Distance, Time = Kilometres per hour

But, how about Furlongs/Fortnight?

2017-11-01 21:15:37 +0200 received badge  Notable Question (source)
2017-10-20 08:02:53 +0200 received badge  Notable Question (source)
2017-10-19 21:32:09 +0200 answered a question Has the (Calc) Hyperlink been changed recently?

OK, as nearly as I can tell, the "issue" is that I had the TEXT in the target cells ROTATED 90°. Changing that to a ROT

2017-10-18 10:29:30 +0200 received badge  Popular Question (source)
2017-10-18 00:25:38 +0200 asked a question Has the (Calc) Hyperlink been changed recently?

Has the (Calc) Hyperlink been changed recently? I use the Hyperlink function re4gularly. I am currently "fighting" one

2017-10-07 18:57:37 +0200 received badge  Popular Question (source)
2017-10-07 18:51:54 +0200 edited question I just updated to V5.4.2.2 Calc is giving me "strange behavior. [Solved]

I just updated to V5.4.2.2 Calc is giving me "strange behavior. I just added (3) text entries to a Calc spreadsheet I am

2017-10-07 18:51:18 +0200 marked best answer I just updated to V5.4.2.2 Calc is giving me "strange behavior. [Solved]

I just added (3) text entries to a Calc spreadsheet I am developing. All three "cells" are surrounded by red "outline borders" even though I added no "borders." How do I get rid of this? [My daughter had to tell me about this as I am colorblind to red.]

2017-10-07 18:51:18 +0200 received badge  Scholar (source)
2017-10-07 06:22:49 +0200 asked a question I just updated to V5.4.2.2 Calc is giving me "strange behavior. [Solved]

I just updated to V5.4.2.2 Calc is giving me "strange behavior. I just added (3) text entries to a Calc spreadsheet I am

2017-08-15 07:51:34 +0200 received badge  Popular Question (source)
2017-08-14 17:06:38 +0200 asked a question I am using SWRITER 5.3.4.2 (X64) and "images" are NOT staying "linked" in my document. Any suggestions?

I am using SWRITER 5.3.4.2 (X64) and "images" are NOT staying "linked" in my document. Any suggestions? I am embedding

2017-07-27 15:05:30 +0200 received badge  Famous Question (source)
2017-05-30 04:46:33 +0200 received badge  Popular Question (source)
2017-05-30 00:21:40 +0200 commented answer How do I "split" a Calc spreadsheet such that a "block" of cells stays at the "top" of the screen?

Thank you! I have hit "that age..."

2017-05-29 23:13:37 +0200 asked a question How do I "split" a Calc spreadsheet such that a "block" of cells stays at the "top" of the screen?

How do I "split" a Calc spreadsheet such that a "block" of cells stays at the "top" of the screen? I did this all the ti

2017-04-07 22:04:23 +0200 received badge  Famous Question (source)
2017-03-22 23:29:35 +0200 received badge  Notable Question (source)
2017-03-22 22:29:43 +0200 answered a question When saving in XSLX format, I am losing "cell format"

I am running Calc Version 5.2.5.1 under Windows-7 Ultimate (64-bit). (1) Updated to Version 5.3.1.2 and the "problem" went away. (2) It turned out (last night, just before updating) that changing from Times New Roman font to Arial font made the "problem" go away.

2017-03-21 03:11:38 +0200 commented question When saving in XSLX format, I am losing "cell format"

In the XLSX format, the numbers are identified as having 2 decimal places and NO "comma separators" whereas in the ODS format, they have 0 decimal places and "comma separators."

2017-03-20 23:34:02 +0200 commented question When saving in XSLX format, I am losing "cell format"

I realize that "###" normally says that the "cell is too narrow." But making is wider has no effect. The "base width" is more than sufficient for the "ODS" format. Making it 30% "wider" ("taller," in this instance) has no effect whatsoever.

2017-03-20 02:36:13 +0200 commented question When saving in XSLX format, I am losing "cell format"

The numeric values all turn into "###" and refuse to display (I have screen shots that demonstrate this) and the "conditional formatting" (that changes the background and font colors) has disappeared.

2017-03-20 01:23:03 +0200 received badge  Popular Question (source)
2017-03-19 18:54:07 +0200 commented question When saving in XSLX format, I am losing "cell format"

The spreadsheet leads one through the SAE/DoD procedure to create a round wire straight coil compression spring with a number of "cross-checks." It then modifies a "base model" and saves it to a "project directory" under a "formally correct" designation (file name). What I would really like is an "Iron Python" library that would allow me to stay in ODS format!

2017-03-19 18:50:14 +0200 commented question When saving in XSLX format, I am losing "cell format"

if you e-mail me, I can provide "screen shots" that show the problem. They are values expressing the torsional stress in the spring's wire and deflection values that are "centered and rotated" values in a table that defined stress/deflection values in the spring. Please note that I can either send you the (JPG) screen shots themselves of a "link" for you to download them.

2017-03-19 03:20:21 +0200 commented question When saving in XSLX format, I am losing "cell format"

Calc Version 5.2.5.1 under Windows 7 Ultimate (64-bit).

2017-03-18 21:04:49 +0200 received badge  Editor (source)
2017-03-18 20:59:52 +0200 asked a question When saving in XSLX format, I am losing "cell format"

I am writing a coil compression spring design program. It has to be saved in "XLSX format" to be compatible with my CAD program. When I do so, I am losing (numeric display) "cell format." What am I doing wrong?

I am unable to "attach" a link to my screenshot images. E-mail me at tangent@olympus.net and I will send them (or a "link") to you.

2017-01-24 01:30:15 +0200 received badge  Notable Question (source)
2017-01-23 13:48:23 +0200 received badge  Popular Question (source)
2017-01-01 16:55:10 +0200 commented question Can "Conditional Formatting" be made to work in xlsx format?

I am running LO B5.1.6.2 and when I Save As xlsx format, my "defined condition" disappears. I do not have Excel and have no clue what version of that would be used. I prefer Libre Office in all things -- but I have to live in the MS Office universe...

2016-12-30 19:36:18 +0200 asked a question Can "Conditional Formatting" be made to work in xlsx format?

I am creating a spreadsheet that, because of the "interface" to other software, must operate in xlsx format. It appears that none of the "Styles and Formatting" that I create for my "Conditional Formats" are accessible when saved in xlsx format. Am I missing something?

Irrational minds want to know...

2016-12-28 02:37:22 +0200 received badge  Famous Question (source)