SoftMaker.com

When I create a spreadsheet with numerical digits in a cell (no formula, default settings) such as 12345678987654321, when I select the cell to copy, the digits are preceded by an apostrophe (ex: '12345678987654321). This only occurs when the cell is selected and seems to happen ONLY with a longer sequence of digits. For example, a sequence of only 6 digits would display normally.

Hello,

I tested it with PlanMaker 2008 (rev 484) and there where no apostrophe before the digits when I copy the cell content. I formated teh cells as "Number" with 15 decimal places. Even with the default formatting in PlanMaker there is no apostrophe when I type in longer strings of digits.
Please note, that a digit should not have more than 15 decimal places, because of the calculation accuracy of Windows.

_________________
Sven Leßmann
SoftMaker Software GmbH

Sven,

Please try double clicking the cell and see if that brings up the apostrophe.

Hello,

i did but there is not apostrophe at all. No matter how long the sequence of digits is.

So I tried different formattings of the cell (scientific, number, date, currency, percentage, fraction) and double clicked the cell after every change of the format but no apostrophe.

Can you please attach a example file so I can check the formattings of the file? Thank you!

_________________
Sven Leßmann
SoftMaker Software GmbH

I enter into cells through the match, for example "2-1" (no quotes) ... but displayed 02.01 (date format) ... I do presets formatting of cells that were displaying the correct?

... constantly introduce an apostrophe tiresome:)

I tried everything imaginable to solve the apostrophe problem but no joy. I had hoped to stay with SoftMaker due it's small footprint and ability to run on a flash drive but I kept running into little glitches (especially pertaining to spreadsheets and docs that were originally produced in MS Office). Reluctantly I ended up going back to Office 2003

Hello,

this behavior is correct. PlanMaker tries to see what the user wants to enter.
If you want to force a calculation, you should enter =2-1 instead of 2-1.
If you want to have a string, use '2-1 (Excel does it similar).

We have already a feature request regarding your problem, that there is no way in PlanMaker to set the default format to text, so that you doesn't have to type in the apostrophe.

Concerning the first problem with the large numbers: When you enter such a large number, PlanMaker displays it as 1.23457E+16. So if the the cell content is not displayed in such a way, it is already stored as string. A sample document would really be helpful.

_________________
Sven Leßmann
SoftMaker Software GmbH