Additional "KSSS for an Auction" Question

users
#1

We would like the Kingsoft Spreadsheet (KSSS) to have the following columns:

A. Name
B. Amount of winning bid
C. Code for item purchased
D. Description of item purchased
E. Starting bid

We realize that D and E can be entered (somewhere -- "lower down" in the
spreadsheet. in another sheet, ???) as soon as the auction catalog is
prepared, but is there any way to get KSSS to automatically enter the
description and starting bid when the purchase is logged at the auction?

IOW, before the auction begins, the cashier would have a blank
spreadsheet with 5 columns. As each buyer comes to cash out, he would
enter that person's name, the amount and the item code.

Then the other fields would be filled in by the program. It's probably
acceptable if those fields were entered a day or two later, maybe by
some kind of merge operation, but I have no idea how that would be done.

Any suggestions? I'm obviously a very unsophisticated spreadsheet user. :slight_smile:

#2

Hello,

This is the LibreOffice support mailing list (www.libreoffice.org) .
We do not provide support for the KingSoft Office suite nor any other
office suite aside LibreOffice.

Thank you,

#3

Charles-H. Schulz has written on 1/24/2014 1:02 PM:

Hello,

This is the LibreOffice support mailing list (www.libreoffice.org) .
We do not provide support for the KingSoft Office suite nor any other
office suite aside LibreOffice.

Thank you,

I'm blushing and admitting to a "senior moment"!

Please change references from KSSS to LO Calc.

#4

Charles-H. Schulz has written on 1/24/2014 1:02 PM:

Hello,

This is the LibreOffice support mailing list (www.libreoffice.org) .
We do not provide support for the KingSoft Office suite nor any other
office suite aside LibreOffice.

Thank you,

I'm blushing and admitting to a "senior moment"!

Please change references from KSSS to LO Calc.

#5

Hi :slight_smile:
This mailing list is for questions about LibreOffice NOT Kingsoft!!! lqtm

However if you were doing this in Calc (our spreadsheet) then i'd
suggest thinking about using a database program instead. If you use a
spreadsheet then it's likely that each person will see the list of all
other names as they type their own in.

With a database you might be able to set-up a form that shows no-one
else's details.
Regards from
Tom :slight_smile:

#6

No worries :slight_smile:

#7

auction with rows where columns A, B, C, D, and E are completed. And items
that don't sell would have no entry in column A or B on their row.

If C, D, and E are known before the auction begins why not work directly in
the spreadsheet when buyers come to cash out? When the buyer is cashed out
search the column of item codes and put the buyer's name and winning bid
amount right in the correct row during the cash out transaction.

If E is actual starting bid vs something like minimum starting bid, then
enter A, B, and E when the buyer comes to cash out.

Seems to me this would work and produce the final output desired as part of
the cash out process. Not post production steps. If the cashiers couldn't
do the lookup and data entry then more thinking is needed.