On Fri, Jan 24, 2014 at 12:46 PM, Pikov Andropov <[email protected]> wrote:
> 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? > > If I understand, it seems the end goal is to have a spreadsheet after the 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. -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
