51.
    发明专利
    未知

    公开(公告)号:AT410740T

    公开(公告)日:2008-10-15

    申请号:AT00480056

    申请日:2000-06-28

    Applicant: IBM

    Abstract: A named range defined by a cell address range in a spreadsheet comprises a plurality of cells identified in each dimension by an address, each dimension comprising two directions. An open named range is specifyed to the named range in at least one open direction. A hidden named range with the cell address range of the open named range is expanded by one address in every direction specified as open. In response to user action, at least one direction is selected, the cell address range of the hidden named range is increased by inserting between two consecutive cell addresses, a new address in selected directions, the open named range is updated with the cell address range of the hidden named range shortened by one address in every direction specified as open.

    METHOD AND SYSTEM IN AN ELECTRONIC SPREADSHEET FOR PERSISTENTLY COPY-PASTING A SOURCE OF RANGE OF CELLS ONTO ONE OR MULTIPLE DESTINATIONRANGES OF CELLS

    公开(公告)号:CA2357638C

    公开(公告)日:2008-05-13

    申请号:CA2357638

    申请日:2001-09-24

    Applicant: IBM

    Inventor: BAUCHOT FREDERIC

    Abstract: The present invention discloses a system and method for persistently copying and pasting a source range of cells onto one or multiple destination ranges of cells, in a multi dimensional spreadsheet comprising a plurality of cells identified by a cell address alo ng each dimension, a range of cells comprising one or a plurality of cells. The method comprises the steps of: .cndot. performing a persistent copy operation, said operation comprising th e steps of: .cndot. selecting a source range of cells; .cndot. copying the source reference range of cells onto a buffer; .cndot. performing a persistent paste operation, said operation comprising t he steps of: .cndot. selecting one or a plurality of cells a destination range of cells; for each selected destination range of cells: .cndot. copying the content of said buffer onto the selected destination ran ge of cells; .cndot. associating the source range of cells with the destination range of cells; .cndot. automatically performing a copy operation each time the source range of cells is updated, said operation comprising the steps of: .cndot. determining whether the source range of cells is associated with one or a plurality of destination range of cells; If the source range of cells is associated with one or a plurality of destination rangeof cells: .cndot. copying the source range of cells onto the one or plurality of associated destination range of cells.

    Method and systems using radio frequency identifier tags for comparing and authenticating items

    公开(公告)号:AU2006326213A1

    公开(公告)日:2007-06-21

    申请号:AU2006326213

    申请日:2006-10-16

    Applicant: IBM

    Abstract: A method and system for identifying an authentication status of a first item. An RFID reader transmits zero and a random number to a first RFID tag associated with the first item. The first RFID tag uses a hashing function to compute a hash (H1) of a concatenation of an identifier (Id1) of the first RFID tag, the random number, and a first secret key and sends the hash H1 to the RFID reader which then transmits the identifier Id1 and the random number to a second RFID tag. The second RFID tag uses the hashing function to compute a hash (H2) of a concatenation of the identifier Id1, the random number, and a second secret key and sends the hash H2 to the RFID reader. The authentication status of authentic or counterfeit is determined for the first item based on whether or not H1 is equal to H2.

    METHOD AND SYSTEM IN AN ELECTRONIC SPREADSHEET FOR INTRODUCING NEW ELEMENTS IN A CELL NAMED RANGE ACCORDING TO DIFFERENT MODES

    公开(公告)号:CA2305968C

    公开(公告)日:2007-05-08

    申请号:CA2305968

    申请日:2000-04-19

    Applicant: IBM

    Abstract: The present invention discloses a system and method of processing a named range defined by a cell address range in a spreadsheet comprising a plurality of cells identified in each dimension by an address, each dimension comprising two directions. The method comprises the steps of defining an open named range by specifying to the named range at least one open directio n; defining a hidden named range with the cell address range of the open named range expanded by one address in every direction specified as open. In response to an user action, the method comprises the further steps of selecting at least one direction; increasing the cell address range of th e hidden named range by inserting between two consecutive cell addresses, a new address in selected directions; updating the open named range with the cell address range of the hidden named range shortened by one address in every direction specified as open.

    55.
    发明专利
    未知

    公开(公告)号:DE602004003140D1

    公开(公告)日:2006-12-21

    申请号:DE602004003140

    申请日:2004-02-27

    Applicant: IBM

    Abstract: A method and system for managing deletion operations in a recursive scalable template instance (RSTI) of an electronic data table having dimensions D1 and D2. The RSTI includes contiguous recursive element instances (REIs) ordered and aligned along D1. The REIs include scalable template instances (STIs). Contiguous elements are deleted, upon satisfying consistency condition(s), in a first STI. The RSTI is structured according to an associated recursive scalable template (RST) that includes a recursive element (RE) including at least one scalable template (ST). Each STI is structured according to an associated ST. The contiguous elements are structured according to a first ST associated with the first STI. A size of the first REI along dimension D1 is adjusted according to a size of a largest STI in the first REI. All REIs of the RSTI remain contiguous after the deleting and adjusting.

    56.
    发明专利
    未知

    公开(公告)号:AT292302T

    公开(公告)日:2005-04-15

    申请号:AT02751061

    申请日:2002-05-23

    Applicant: IBM FRANCE

    Abstract: System and program product are provided for facilitating on-line help information in an office application which includes one or more objects. The on-line help information is dependent on content of a selected object of the office application. A user of the office application is provided with help information setting forth an example directly derived from content of the currently selected object or cell. Content of a user entry field within the object is parsed to determine whether a predefined keyword is present, and if so, at least one parameter associated with the keyword and at least one format or rule related to the at least one parameter are identified. The at least one format and rule specified in the help information are employed in correcting content of the user entry field, for example, for display to the user.

    57.
    发明专利
    未知

    公开(公告)号:FR2811788B1

    公开(公告)日:2003-10-31

    申请号:FR0105483

    申请日:2001-04-24

    Abstract: The present invention relates to the field of information processing by digital computers, and more particularly to a method and system, in an electronic spreadsheet, of applying one or a plurality of user-defined options within one or a plurality of cells. The method comprises the steps of: defining for each option a boolean variable with a first value and a second value, preferably a "true" or "false" value; for each of said one or plurality of cells: referencing one or a plurality of boolean variables; associating a logical or mathematical operation with each boolean variable; for each of said one or plurality of referenced boolean variables in each of said one or plurality of cells: specifying a default value, said default value being defined as the value of the cell when the referenced boolean variable is set to the first value, preferably when the boolean variable is set to the "false" value; specifying a delta value by applying to the specified cell default value, the operation associated with the referenced boolean variable when the boolean variable is set to the second value, preferably when the boolean variable is set to the "true" value; setting each boolean variable to the first value or to the second value; for each of said one or plurality of cells: computing said one or plurality of delta values.

    METHOD AND SYSTEM IN AN ELECTRONIC SPREADSHEET FOR PERSISTENTLY SELF-REPLICATING MULTIPLE RANGES OF CELLS THROUGH A COPY-PASTE OPERATION

    公开(公告)号:CA2357653A1

    公开(公告)日:2002-04-24

    申请号:CA2357653

    申请日:2001-09-24

    Applicant: IBM

    Inventor: BAUCHOT FREDERIC

    Abstract: The present invention relates to the field of information processing by digital computers, and more particularly to a method and system for persistently self replicating multiple ranges of cells through a copy-paste operation, in a multi dimensional spreadsheet comprisin g a plurality of cells identified by a cell address along each dimension, a range of cells comprising one or a plurality of cells The method comprises the steps of: ~ defining a set of ranges of cells, each range of cells having the same siz e; ~ each time the content of a range of cells belonging to this set is changed , automatically performing a self-replication operation, the self-replication operation comprising the steps of: ~ copying the changed range of cells onto a buffer; ~ determining the set of ranges of cells to which the changed range of cells belongs to; ~ identifying the ranges of cells belonging to the set; ~ pasting the content of the buffer in each of identified range of cells belonging to the set.

    Variable air cooling system for data centers

    公开(公告)号:GB2522269A

    公开(公告)日:2015-07-22

    申请号:GB201400979

    申请日:2014-01-21

    Applicant: IBM

    Abstract: The system includes a room or an enclosure in the form of parallel rows of rack servers separated by aisles to be cooled that is suitable for housing hardware components. The cooling system includes a first air input for controllably allowing input of outside air from outside the enclosure, a second air input for controllably allowing input of recycled air from the enclosure, a cooling mechanism, and an air output for allowing output of air into the enclosure. A control system includes a first temperature monitor for monitoring an outside air temperature, a second temperature monitor for monitoring a blowing air temperature of air at the air output, and a control mechanism for controlling an operation of the first air input, the second air input, the air cooling system in dependence on the monitored temperatures. Hygrometry control can be optimised and an override mechanism is provided in response to exceptional conditions outside of the enclosure. An elongate duct may be provided along and above the hardware racks (Figure 5b).

Patent Agency Ranking