Project

General

Profile

Actions

Design #257

closed

A few tweaks to the lookup table utility

Added by Joseph Potvin 9 months ago. Updated about 1 month ago.

Status:
Closed
Priority:
Urgent
Assignee:
Category:
Refine
Start date:
07/27/2024
Due date:
% Done:

0%

Estimated time:
Issue closed :
03/22/2025

Description

It's excellent, just a few minor tweaks to do:

For some reason my spreadsheet did not work properly with " as the string delimiter, so I swapped it for a pipe |. I also had to insert a comma at the end of the string to generate a new column:

Thus to be able to Copy-Paste directly from a text editor to a spreadsheet I had to do the follow search-replace operations:

Search ":
Replace with :|,

Search ,"
Replace with ,|

If you prefer a different string delimiter, that's fine. I'm not sure " is optimal, since user-entered data will sometimes have " in it.


Second, Please adjust the first row to have:

ROW INDEX as first column header and DATA as second column header, and then the column index numbers, so that #1 starts on the third column.

This will now change the numbering that occurs in the Sparse Cartesian Product Coordinates (SCPC).


One other thing: It seems to me that the blue button at top left "Add a Header Value" should be "Add a Column". Do yo agree?


Files

spreadsheet_SCRC.png View spreadsheet_SCRC.png 129 KB Joseph Potvin, 07/27/2024 12:07 AM
Actions #1

Updated by Huda Hussain about 1 month ago

  • Assignee changed from Huda Hussain to Joseph Potvin

As per our discussion, I will be leaving this one since you said you were going to seperate the tasks, and ensure this is the functionality you want :)

Actions #2

Updated by Joseph Potvin about 1 month ago

  • Status changed from New to Closed
Actions

Also available in: Atom PDF