Search found 20 matches

by robert006
Thu Apr 03, 2025 1:01 pm
Forum: PlanMaker NX and 2024 for Windows
Topic: Bug report - please fix - re: paste unformatted
Replies: 5
Views: 12513

Re: Bug report - please fix - re: paste unformatted

Thank you very much! The paste now works for me.
My software is offline, so if this issue was addressed earlier, my apologies.
I prefer to use Planmaker over others for its file compatibility, speed and ease of use.
Thanks again for your help!
by robert006
Wed Apr 02, 2025 5:27 pm
Forum: PlanMaker NX and 2024 for Windows
Topic: Bug report - please fix - re: paste unformatted
Replies: 5
Views: 12513

Bug report - please fix - re: paste unformatted

Hi, This problem was reported in a previous post re: copying and pasting as unformatted text into a new sheet, using the attached file. Please open the attached file and try these steps: 1 select all of the data 2 Edit>Copy 3 open a new sheet 4 Edit>Paste Special>Paste as: Unformatted text, uncheck ...
by robert006
Thu Mar 27, 2025 12:17 pm
Forum: PlanMaker NX and 2024 for Windows
Topic: Paste as text does not include all decimals
Replies: 5
Views: 22589

Re: Paste as text does not include all decimals

Hi, Thank you for this - I will make a note of it. Perhaps greying out the paste formatting check boxes, when paste as unformatted text is selected, would be less confusing for users like me. If the selection is not done correctly, the pasted results will be incorrect, and not necessarily noticed, w...
by robert006
Wed Mar 26, 2025 3:52 pm
Forum: PlanMaker NX and 2024 for Windows
Topic: selecting data in sheet
Replies: 5
Views: 8566

Re: selecting data in sheet

Please see my previous post regarding pasting of decimals - I added some information on how to reproduce the problem.
Thanks
by robert006
Wed Mar 26, 2025 3:49 pm
Forum: PlanMaker NX and 2024 for Windows
Topic: selecting data in sheet
Replies: 5
Views: 8566

Re: selecting data in sheet

Hi, Unfortunately, I cannot remember the situation which caused my enquiry. Today, when I try the selection in Planmaker and in other spreadsheets, the behaviour seems to be the same in all of them. My apologies for not being more helpful - if I encounter the situation again I will add it to this th...
by robert006
Wed Mar 26, 2025 1:00 am
Forum: PlanMaker NX and 2024 for Windows
Topic: Paste as text does not include all decimals
Replies: 5
Views: 22589

Re: Paste as text does not include all decimals

Hi, Please try these steps: 1 select all of the data 2 Edit>Copy 3 open a new sheet 4 Edit>Paste Special>Paste as: Unformatted text, uncheck All under Paste formatting 5 review numbers in column F, and note that cell F7 pasted as 32970 and not 329.70, cell F11 pasted as 17220 and not 172.20 etc. In ...
by robert006
Wed Mar 26, 2025 12:50 am
Forum: PlanMaker NX and 2024 for Windows
Topic: selecting data in sheet
Replies: 5
Views: 8566

Re: selecting data in sheet

Hi,
If you are at cell A1, the rectangle is to the left of the A in column A and above the 1 in row 1.
Thanks
by robert006
Tue Mar 18, 2025 11:46 am
Forum: PlanMaker NX and 2024 for Windows
Topic: Paste as text does not include all decimals
Replies: 5
Views: 22589

Re: Paste as text does not include all decimals

Pasting into other spreadsheets has mixed results - some include all decimals and others don't.
When looking at the clipboard data, all decimals are shown.
by robert006
Mon Mar 17, 2025 8:16 pm
Forum: PlanMaker NX and 2024 for Windows
Topic: Paste as text does not include all decimals
Replies: 5
Views: 22589

Paste as text does not include all decimals

Hi, In the attached file, I copied the cells, then opened another instance of Planmaker and pasted the clipboard data as Unformatted text with no formatting. In the pasted sheet, cells which had only one digit after the decimal place pasted as a number without the decimal place. This does not happen...
by robert006
Mon Mar 17, 2025 8:07 pm
Forum: PlanMaker NX and 2024 for Windows
Topic: selecting data in sheet
Replies: 5
Views: 8566

selecting data in sheet

Hi, In another popular spreadsheet, you can easily select all cells containing data by clicking on the rectangle at the top left of the cells. That will select only cells which contain data. However, in Planmaker this will action select all cells in the sheet (over a million rows). Could it be chang...
by robert006
Thu Sep 19, 2024 5:08 pm
Forum: BasicMaker NX and 2024 for Windows
Topic: getting last row in spreadsheet
Replies: 1
Views: 6122

Re: getting last row in spreadsheet

OK - it looks like the EOF function will accomplish this.
Thanks
by robert006
Mon Sep 16, 2024 9:11 pm
Forum: BasicMaker NX and 2024 for Windows
Topic: getting last row in spreadsheet
Replies: 1
Views: 6122

getting last row in spreadsheet

Hi,
It would be nice to get the last populated row as a Planmaker range property. It could then be used as the upper bound in loops.
Thanks
by robert006
Tue Sep 10, 2024 8:43 pm
Forum: PlanMaker NX and 2024 for Windows
Topic: no decimals in csv export
Replies: 3
Views: 9854

Re: no decimals in csv export

Thank you for your help. The problem must have been with the file that I was exporting to csv. When I create numbers manually and export as csv it works fine.
by robert006
Thu Sep 05, 2024 10:20 pm
Forum: PlanMaker NX and 2024 for Windows
Topic: no decimals in csv export
Replies: 3
Views: 9854

Re: no decimals in csv export

The decimals are exported when exporting with the default additional options csv export, but not when just .csv export is chosen.

Go to advanced search