Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Activity for pnuts
| Type | On... | Excerpt | Status | Date |
|---|---|---|---|---|
| Edit | Post #278569 | Initial revision | — | about 4 years ago |
| Question | — |
Iterative references in LibreOffice Calc An as yet unanswered Q from Stack Overflow [SO] enquired: >how to stop looping this formula where the formulae were: in B9 =16,50 in B10 =B9-B11 in B11 =B10/2 >without changing text in cell. (The above after changing `` to `/` based on a comment. It can also be deduced ... (more) |
— | about 4 years ago |
| Edit | Post #278567 |
Post edited: |
— | about 4 years ago |
| Edit | Post #278567 | Initial revision | — | about 4 years ago |
| Question | — |
Loss of precision when concatenating an exchange rate with a string In response to a Q on Web Applications [WA] the asker self-answered with: =CONCATENATE("@ £/€ rate: ",text(J21,"0.00000")) The issue was that, with "in a cell J21 I have a set value 1.10000":. =CONCATENATE("@ £/€ rate: ",(J21)) was returning `@ £/€ rate: 1.1` rather than `@ £/€ ra... (more) |
— | about 4 years ago |
| Edit | Post #278565 | Initial revision | — | about 4 years ago |
| Question | — |
A Conditional Formatting formula rule expected to apply to all cells is only affecting some A very recently asked Q on Web Applications has no answer yet (and, in my opinion, is so badly written may not receive an answer at all promptly). However it does seem (in my interpretation) to raise a very common issue with Conditional Formatting [CF] – with a very simple solution. The asker chose ... (more) |
— | about 4 years ago |
| Edit | Post #278532 | Initial revision | — | about 4 years ago |
| Answer | — |
A: In a column, set populated cells to 1 and empty cells to 0 An easy way (in LibreOffice Calc 5.4.3.2) is not to attempt directly to overwrite what is already present but to create the desired results with a formula in a different column, then replace the contents of the original column with the values (not formulae) from the added column. Assuming the data... (more) |
— | about 4 years ago |
| Edit | Post #278531 | Initial revision | — | about 4 years ago |
| Question | — |
In a column, set populated cells to 1 and empty cells to 0 In an as yet unanswered Q from early this year a user of Stack Overflow asked: >how to fill all non-empty cells of a column by 1 and the empty cells by 0. It's an xlsx file open with LibreOffice Calc. Is this possible with a formula? (more) |
— | about 4 years ago |
| Edit | Post #278527 | Initial revision | — | about 4 years ago |
| Question | — |
Highlight the maximum value per row across multiple columns An as yet unanswered OpenOffice Calc - Highlighting the higest value in multiple columns posted by Rui on Super User from early this year asked whether a condition was possible to: >fill with a color in the highest value between multiple columns The context was OpenOffice Calc and a data sample... (more) |
— | about 4 years ago |
| Edit | Post #278525 | Initial revision | — | about 4 years ago |
| Question | — |
Summing values formatted for a different locale A couple of year ago a user of Super User reported difficulties with summing values purporting to be Euros imported to LibreOffice Calc in CSV format. In the Q the user does not mention the locale settings, but did write "I've used the LEFT function to get just the number part, though that still l... (more) |
— | about 4 years ago |
| Edit | Post #278523 |
Post edited: |
— | about 4 years ago |
| Edit | Post #278523 | Initial revision | — | about 4 years ago |
| Question | — |
TRUE/FALSE flags for alternating colouring by group For use in connection with conditional formatting with alternating coloured fills in OpenOffice Calc, several years ago a user of Super User was applying this Ruby script: f = File.readlines("shading.txt") #<-- I just copy and paste a column from spreadsheet to here $i = 0 $sw... (more) |
— | about 4 years ago |
| Edit | Post #278366 |
Post edited: |
— | about 4 years ago |
| Edit | Post #278366 |
Post edited: |
— | about 4 years ago |
| Edit | Post #278367 |
Post edited: |
— | about 4 years ago |
| Edit | Post #278367 | Initial revision | — | about 4 years ago |
| Answer | — |
A: Combine the first character of a cell with another cell Regarding length, the correct answer used 43 characters, but one was a space serving no purpose, so say 42 for: =CONCATENATE(LOWER(MID(A1,1,1)),LOWER(B1)) Most obviously, the concatenating function is a great deal less compact than an `&`: =LOWER(MID(A1,1,1))&LOWER(B1) Then apply... (more) |
— | about 4 years ago |
| Edit | Post #278366 | Initial revision | — | about 4 years ago |
| Question | — |
Combine the first character of a cell with another cell A Q on Stack Exchange from a very long time ago included: >I have first names in one column and second names in another, I want to create a third column that contains the first character from the first name and add it to the surname creating first initial + surname. The user asked "How can I do... (more) |
— | about 4 years ago |
| Edit | Post #278361 |
Post edited: |
— | about 4 years ago |
| Edit | Post #278361 |
Post edited: |
— | about 4 years ago |
| Edit | Post #278361 |
Post edited: |
— | about 4 years ago |
| Edit | Post #278361 |
Post edited: |
— | about 4 years ago |
| Edit | Post #278361 | Initial revision | — | about 4 years ago |
| Answer | — |
A: How to add to the value of one cell an amount that depends upon the range of a different cell? One way is to create a lookup table (sorted ascending) and take advantage of VLOOKUP's `issorted` parameter to opt for "the nearest match (less than or equal to the search key)". Say a table like so: 0 0 5 1 10 2 15 3 20 4 25 5 with the Named Range `Table`. Then a formula such as: ... (more) |
— | about 4 years ago |
| Edit | Post #278360 |
Post edited: |
— | about 4 years ago |
| Edit | Post #278360 | Initial revision | — | about 4 years ago |
| Question | — |
How to add to the value of one cell an amount that depends upon the range of a different cell? A user of Web Applications asked how to: > - +1 when the value is >=5, > - +2 when the value is >=10, > - +3 when the value is >=15, > - +4 when the value is >=20, > - +5 when the value is >=25 and had tried: =IF(F7>=5,H7+1,IF(F7>=10,H7+2,IF(F7>=15,H7+3,IF(F7>=20,H7+4,H... (more) |
— | about 4 years ago |
| Edit | Post #278333 |
Post edited: |
— | about 4 years ago |
| Edit | Post #278334 |
Post edited: |
— | about 4 years ago |
| Edit | Post #278334 | Initial revision | — | about 4 years ago |
| Answer | — |
A: Conditionally format a pair of columns First, such formatting is conditional, so there is no need for the IF functions here (nor, normally, in general for Conditional Formatting [CF]). Formatting is triggered when the response to a formula is TRUE (or equivalent). So, for red fill: =$K4>5 is sufficient, as is: =$K4>=2 ... (more) |
— | about 4 years ago |
| Edit | Post #278333 | Initial revision | — | about 4 years ago |
| Question | — |
Conditionally format a pair of columns A user of Web Applications asked "How should I fix the formula?" with reference to: =IF($K4<2,$K4) applied as a Conditional Formatting [CF] formula to J4:J8, where the desired (green fill) format was to apply to values under `2` in K4:K8. I have modified the requirement to extend the format... (more) |
— | about 4 years ago |
| Edit | Post #278324 |
Post edited: |
— | about 4 years ago |
| Edit | Post #278325 |
Post edited: |
— | about 4 years ago |
| Edit | Post #278324 |
Post edited: |
— | about 4 years ago |
| Edit | Post #278322 |
Post edited: |
— | about 4 years ago |
| Edit | Post #278325 | Initial revision | — | about 4 years ago |
| Answer | — |
A: How to convert an RFC822 timestamp to a date index number? Yes, only the sixth to eleventh characters are required and these may be extracted with the MID function. MID is a string function that returns Text but a double unary operator should trigger Sheets' automatic date detection and display as `44105` when in default format: =--mid(A1,6,11) The... (more) |
— | about 4 years ago |
| Edit | Post #278324 | Initial revision | — | about 4 years ago |
| Question | — |
How to convert an RFC822 timestamp to a date index number? A self-answered question - How to get DATEVALUE to recognize RSS 2 pubDate (RFC822)? - written by spcsLrg on Web Applications Stack Exchange offers this formula: =DATEVALUE(TRIM(REGEXREPLACE(A1,"^(Sun|Mon|Tue|Wed|Thu|Fri|Sat)\,(.)\s+\+?[0-9]{4}.$","$2"))) as a way to convert `Thu, 01 Oct 20... (more) |
— | about 4 years ago |
| Edit | Post #278322 | Initial revision | — | about 4 years ago |
| Question | — |
Data validation applied to tickboxes Given ColumnA contains a Text header (A1), an allowed maximum number (A2), fifty tickboxes (A3:A62) and a formula in A63 of: =countif(A3:A62,TRUE) how can I block application of more than the allowed maximum number of ticks, or at least warn that the limit has been exceeded? There is a Q... (more) |
— | about 4 years ago |
- ← Previous
- 1
- 2
- 3
- Next →