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 #278762 | Post deleted | — | over 3 years ago |
| Edit | Post #278622 | Post deleted | — | over 3 years ago |
| Edit | Post #278578 | Post deleted | — | over 3 years ago |
| Edit | Post #278572 | Post deleted | — | over 3 years ago |
| Edit | Post #278570 | Post deleted | — | over 3 years ago |
| Edit | Post #278532 | Post deleted | — | over 3 years ago |
| Edit | Post #278367 | Post deleted | — | over 3 years ago |
| Edit | Post #278325 | Post deleted | — | over 3 years ago |
| Edit | Post #277262 | Post deleted | — | over 3 years ago |
| Edit | Post #277933 | Post deleted | — | almost 4 years ago |
| Edit | Post #277455 |
Post edited: [software-practices] as a tag here is just useless noise. [Ref](https://software.codidact.com/questions/277891#comment-3960)) |
— | almost 4 years ago |
| Edit | Post #278674 |
Post edited: |
— | almost 4 years ago |
| Edit | Post #278333 | Post deleted | — | almost 4 years ago |
| Edit | Post #278360 | Post deleted | — | almost 4 years ago |
| Edit | Post #277930 | Post deleted | — | almost 4 years ago |
| Edit | Post #278361 | Post deleted | — | almost 4 years ago |
| Edit | Post #278334 | Post deleted | — | almost 4 years ago |
| Edit | Post #277931 | Post deleted | — | almost 4 years ago |
| Edit | Post #278576 | Post deleted | — | almost 4 years ago |
| Comment | Post #278322 |
@Alexei Sure. I think Sheets favours 'tickboxes' but I can't tell them apart and there would be NO point in having both. (more) |
— | almost 4 years ago |
| Edit | Post #278762 | Initial revision | — | about 4 years ago |
| Answer | — |
A: Automatic adjustment when copying of column reference within INDIRECT function When in ColumnC `B` can be returned with `=char(Column()+63)` and since not inside double quotes this will automatically adjust to `C` in ColumnD. This way a string acceptable to INDIRECT can be constructed in C16 that should produce the same result as the current formula in C16 and also, unlike t... (more) |
— | about 4 years ago |
| Edit | Post #278761 | Initial revision | — | about 4 years ago |
| Question | — |
Automatic adjustment when copying of column reference within INDIRECT function An as yet unanswered question on Web Applications, INDIRECT cell reference - Can't copy cell as reference cell pattern remains same, from @Daniel Klose is: > I have an Overview Sheet where I want to display a sum of values from another sheet. I'm using the indirect function to grab the sheet ... (more) |
— | about 4 years ago |
| Edit | Post #278674 | Initial revision | — | about 4 years ago |
| Question | — |
Delete specific cells with shift cells up Answers to Excel - Get only values from column that are not Zero “0” asked by @CiscoNewb includes ones applying AGGREGATE: =IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW(A$2:A$12)/(A$2:A$12>0),ROW(A1))),"") from @bosco-yip and FILTER from @Harun24HR (Excel 365): =FILTER(A2:A12,A2:A12>0) This sample... (more) |
— | about 4 years ago |
| Edit | Post #278622 | Initial revision | — | about 4 years ago |
| Answer | — |
A: How to pivot text? Perhaps (if a process of several relatively familiar steps is easy to remember) but additional formulae may be appropriate, a little extension to the source data required and some formatting. However, the offered solution only works for at most three states (here `YES`, `NO`, and `X`). First, add ... (more) |
— | about 4 years ago |
| Edit | Post #278621 | Initial revision | — | about 4 years ago |
| Question | — |
How to pivot text? In this Q a user asked for a simple way to represent this data: ``` - PERSON 1 | PERSON 2 | YES - PERSON 1 | PERSON 3 | YES - PERSON 2 | PERSON 1 | YES - PERSON 2 | PERSON 3 | YES - PERSON 3 | PERSON 1 | NO - PERSON 3 | PERSON 2 | NO ``` in this format: ``` - | PERSON 1 | PERSON 2 | PE... (more) |
— | about 4 years ago |
| Edit | Post #278576 |
Post edited: |
— | about 4 years ago |
| Edit | Post #278594 | Initial revision | — | about 4 years ago |
| Question | — |
Merge a pair of columns where in each row one is blank, without a formula A Q on Stack Overflow asks how to merge two columns where each row has only one populated cell. The example was from (on the left) to (on the right): a|b a 0| 0 |1 1 |5 5 9| ... (more) |
— | about 4 years ago |
| Edit | Post #278584 | Initial revision | — | about 4 years ago |
| Question | — |
Copy a sparse matrix with removal of blanks A user of Web Applications gave the following as an example: Array example https://docs.google.com/spreadsheets/d/1nPTBFXaIgpruPgNoWFSBUL2yKaibjeNJNExhnHVr8LE/edit#gid=0 and asked: >How do I read a long row of cells only some of which have scores in them, and print those scores out? ... (more) |
— | about 4 years ago |
| Edit | Post #278577 |
Post edited: |
— | about 4 years ago |
| Edit | Post #278577 |
Post edited: |
— | about 4 years ago |
| Edit | Post #278578 |
Post edited: |
— | about 4 years ago |
| Edit | Post #278578 | Initial revision | — | about 4 years ago |
| Answer | — |
A: Trigger Conditional Formatting by Check Box Assuming Check Box Form Controls in ColumnD, yes in OpenOffice Calc 4.1.4, though for some the process may be too tedious and entering say an `x` instead may be preferred. Unlike in Google Sheets for example, where a Tick box has a FALSE/TRUE value associated with it automatically, in Calc the ass... (more) |
— | about 4 years ago |
| Edit | Post #278577 | Initial revision | — | about 4 years ago |
| Question | — |
Trigger Conditional Formatting by Check Box One part of an as yet unanswered Q on Super User asks whether conditional formatting in OpenOffice Calc can be used to highlight an entire row based on whether a checkmark in the row has been selected. This example was provided: Data sample Can it be? (more) |
— | about 4 years ago |
| Edit | Post #278576 | Initial revision | — | about 4 years ago |
| Answer | — |
A: Controlling format when importing CSV This is happening because of assumptions made by the software. "E notation" is a standard convention popular with scientists, mathematicians and engineers as a convenient way to represent and process very large or very small numbers. Such scientific notation is so popular that without context the cha... (more) |
— | about 4 years ago |
| Edit | Post #278572 | Initial revision | — | about 4 years ago |
| Answer | — |
A: A function to round negative numbers towards 0 Yes, several. Example outcomes from various inputs and functions are shown in the table below, with those compliant with the current requirement highlighted: Rounding examples CEILING CEILING.MATH CEILING.PRECISE (more) |
— | about 4 years ago |
| Edit | Post #278571 | Initial revision | — | about 4 years ago |
| Question | — |
A function to round negative numbers towards 0 Some while ago a user of Web Applications asked after a function to avoid "an if/else just to handle negative numbers properly". Clarification provided was: >Presently it round based on absolute value, meaning that -1.5 rounds to -2.0, which is wrong. I want it to round to -1.0 An answer was... (more) |
— | about 4 years ago |
| Edit | Post #278570 | Initial revision | — | about 4 years ago |
| Answer | — |
A: Iterative references in LibreOffice Calc Since the formulae have circular references (Err:522) the spreadsheet setting needs to be changed to enable iteration (Tools > Options… > LibreOffice Calc > Calculation, tick Iterations and choose a sensible combination of `Steps:` and `Minimum change:`, OK). For current purposes I suggest `100` for ... (more) |
— | about 4 years ago |